98 lines
3.1 KiB
PHP
98 lines
3.1 KiB
PHP
|
|
|
|
<?php
|
|
// DB 연결
|
|
// $conn = new mysqli('localhost', 'db_user', 'db_pass', 'db_name');
|
|
// if ($conn->connect_error) {
|
|
// die('DB 연결 실패: ' . $conn->connect_error);
|
|
// }
|
|
|
|
// // GET 파라미터 수신
|
|
// $product_name = $_GET['PRODUCT_NAME'] ?? '';
|
|
// $login_id = $_GET['LOGIN_ID'] ?? '';
|
|
// $login_version = $_GET['LOGIN_VERSION'] ?? '';
|
|
// $login_ip = $_GET['LOGIN_IP'] ?? '';
|
|
// $user_company = $_GET['USER_COMPANY'] ?? '';
|
|
// $user_position = $_GET['USER_POSITION'] ?? '';
|
|
// $user_last_login = $_GET['USER_LAST_LOGIN'] ?? '';
|
|
|
|
// // SQL 인젝션 방지를 위한 prepared statement 사용
|
|
// $sql = "INSERT INTO user_program_info (
|
|
// product_name, login_id, login_version, login_ip,
|
|
// user_company, user_position, user_last_login
|
|
// ) VALUES (?, ?, ?, ?, ?, ?, ?)";
|
|
|
|
// $stmt = $conn->prepare($sql);
|
|
// $stmt->bind_param("sssssss",
|
|
// $product_name, $login_id, $login_version, $login_ip,
|
|
// $user_company, $user_position, $user_last_login
|
|
// );
|
|
|
|
// $stmt->execute();
|
|
// $stmt->close();
|
|
// $conn->close();
|
|
|
|
// // 응답
|
|
// header('Content-Type: text/plain; charset=UTF-8');
|
|
// echo "OK";
|
|
?>
|
|
<?php
|
|
// 에러 표시 켜기 (개발용)
|
|
ini_set('display_errors', 1);
|
|
error_reporting(E_ALL);
|
|
|
|
// 테스트 메시지
|
|
echo "시작 OK<br>";
|
|
|
|
// DB 연결
|
|
$conn = new mysqli('localhost', 'egbim', 'baron3840!!', 'egbim'); // 실제 정보로 변경
|
|
|
|
if ($conn->connect_error) {
|
|
die("DB 연결 실패: " . $conn->connect_error);
|
|
}
|
|
|
|
echo "DB 연결 OK<br>";
|
|
|
|
function clean($value) {
|
|
// 일반 따옴표 + 스마트 따옴표 제거
|
|
return str_replace(['"', '“', '”'], '', $value);
|
|
}
|
|
|
|
$product_name = clean($_GET['PRODUCT_NAME'] ?? '');
|
|
$login_id = clean($_GET['LOGIN_ID'] ?? '');
|
|
$login_version = clean($_GET['LOGIN_VERSION'] ?? '');
|
|
$login_public_ip = clean($_GET['LOGIN_PUBLIC_IP'] ?? '');
|
|
$login_local_ip = clean($_GET['LOGIN_LOCAL_IP'] ?? '');
|
|
$user_company = clean($_GET['USER_COMPANY'] ?? '');
|
|
$user_position = clean($_GET['USER_POSITION'] ?? '');
|
|
$user_department = clean($_GET['USER_DEPARTMENT'] ?? '');
|
|
$user_login_time = clean($_GET['USER_LOGIN_TIME'] ?? '');
|
|
$user_family_flag = clean($_GET['USER_FAMILY_FLAG'] ?? '');
|
|
$user_employee_id = clean($_GET['USER_EMPLOYEE_ID'] ?? '');
|
|
|
|
echo "파라미터 수신 OK<br>";
|
|
|
|
// DB 저장
|
|
$sql = "INSERT INTO user_program_info (
|
|
product_name, login_id, login_version, login_public_ip, login_local_ip,
|
|
user_company, user_department, user_position, user_login_time, user_family_flag, user_employee_id
|
|
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
|
|
$stmt = $conn->prepare($sql);
|
|
$stmt->bind_param("sssssssssss",
|
|
$product_name, $login_id, $login_version, $login_public_ip, $login_local_ip,
|
|
$user_company, $user_department, $user_position, $user_login_time, $user_family_flag, $user_employee_id
|
|
);
|
|
|
|
$stmt->execute();
|
|
$stmt->close();
|
|
$conn->close();
|
|
|
|
echo "DB 저장 OK<br>";
|
|
|
|
// 최종 응답
|
|
echo "DONE";
|
|
|
|
echo "<pre>";
|
|
print_r($_GET);
|
|
echo "</pre>";
|