제출 양식을 작성했지만 제출을 누르면 다음과 같은 응답이 표시됩니다.

제출 양식을 작성했지만 제출을 누르면 다음과 같은 응답이 표시됩니다.

ERROR: Could not able to execute
INSERT INTO applications (title, surname, maiden_name, first_name, marital_status, gender, country, date_of_birth, address, email, home_numbers, work_numbers, cell_phone, application_results, next_of_kin_name, next_of_kin_relationship, next_of_kin_number, chronic_disease)
VALUES ('Mr', 'McLaren', '', 'Richard', 'Single', 'Male', 'England', '', 'Room 67 14 Tottenham Court Road London England W1T 1JY', 'mclaren.richard@gmail.com', '020 7946 0072', '020 7946 0549', '020 7946 0760', 'Elizabeth', 'Mother', '020 7946 0831', 'No') ).

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB
server version for the right syntax to use near ')' at line 6

php 코드는 다음과 같습니다.

/* Attempt MySQL server connection. Assuming you are running MySQL

server with default setting (user 'root' with no password) */

$link = mysqli_connect("localhost", "root", "", "cas");



// Check connection

if($link === false){

    die("ERROR: Could not connect. " . mysqli_connect_error());

}



// Escape user inputs for security

$title = mysqli_real_escape_string($link, $_REQUEST['title']);

$surname = mysqli_real_escape_string($link, $_REQUEST['surname']);

$maiden_name = mysqli_real_escape_string($link, $_REQUEST['maiden_name']);

$first_name = mysqli_real_escape_string($link, $_REQUEST['first_name']);

$marital_status = mysqli_real_escape_string($link, $_REQUEST['marital_status']);

$gender = mysqli_real_escape_string($link, $_REQUEST['gender']);

$country = mysqli_real_escape_string($link, $_REQUEST['country']);  

$date_of_birth = mysqli_real_escape_string($link, $_REQUEST['date_of_birth']);

$address = mysqli_real_escape_string($link, $_REQUEST['address']);

$email = mysqli_real_escape_string($link, $_REQUEST['email']);

$home_number = mysqli_real_escape_string($link, $_REQUEST['home_number']);

$work_number = mysqli_real_escape_string($link, $_REQUEST['work_number']);

$cell_phone = mysqli_real_escape_string($link, $_REQUEST['cell_phone']);



$next_of_kin_name = mysqli_real_escape_string($link, $_REQUEST['next_of_kin_name']);

$next_of_kin_relationship = mysqli_real_escape_string($link, $_REQUEST['next_of_kin_relationship']);

$next_of_kin_number = mysqli_real_escape_string($link, $_REQUEST['next_of_kin_number']);

$chronic_disease = mysqli_real_escape_string($link, $_REQUEST['chronic_disease']);


// attempt insert query execution

$sql = "INSERT INTO applications (title, surname, maiden_name, first_name, marital_status, 
gender, country, date_of_birth, address, email, home_numbers, work_numbers, cell_phone, 
application_results, next_of_kin_name, next_of_kin_relationship, next_of_kin_number, chronic_disease) 
VALUES ('$title', '$surname', '$maiden_name', '$first_name', '$marital_status', 
'$gender', '$country', '$date_of_birth', '$address', '$email', '$home_number', '$work_number', '$cell_phone', 
'$next_of_kin_name', '$next_of_kin_relationship', '$next_of_kin_number', '$chronic_disease') )";

if(mysqli_query($link, $sql)){

    echo "Records added successfully.";

} else{

    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);

}



// close connection

mysqli_close($link);

?>

INSERT 문에는 문장 끝에 괄호가 하나 더 있습니다.

INSERT INTO ....  '$chronic_disease') >)< ';

INSERT 구문

INSERT INTO table(columns) VALUES(values)

$sql = "INSERT INTO applications (title, surname, maiden_name, first_name, marital_status, 
gender, country, date_of_birth, address, email, home_numbers, work_numbers, cell_phone, 
application_results, next_of_kin_name, next_of_kin_relationship, next_of_kin_number, chronic_disease) 
VALUES ('$title', '$surname', '$maiden_name', '$first_name', '$marital_status', 
'$gender', '$country', '$date_of_birth', '$address', '$email', '$home_number', '$work_number', '$cell_phone', 
'$next_of_kin_name', '$next_of_kin_relationship', '$next_of_kin_number', '$chronic_disease')";

여분이 있었군요)상기 진술의 끝에

언급URL : https://stackoverflow.com/questions/42605467/ive-created-a-submission-form-but-when-i-hit-submit-i-get-the-following-respons