Hi all. This is my first programming in PHP, but I keep getting syntax error when trying to use INSERT INTO ... VALUES. Here's the code.
<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL | E_STRICT);
/* server info */
$server = 'localhost';
$user = 'root';
$password = '';
$database = 'cart';
/* get variables */
$name_last1 = $_POST['name_last1'];
$name_first1 = $_POST['name_first1'];
$name_mi1 = $_POST['name_mi1'];
$gender1 = $_POST['gender1'];
$birthdate1 = $_POST['birthdate1'];
$ssn1 = $_POST['ssn1'];
$name_last2 = $_POST['name_last2'];
$name_first2 = $_POST['name_first2'];
$name_mi2 = $_POST['name_mi2'];
$gender2 = $_POST['gender2'];
$birthdate2 = $_POST['birthdate2'];
$ssn2 = $_POST['ssn2'];
$name_last3 = $_POST['name_last3'];
$name_first3 = $_POST['name_first3'];
$name_mi3 = $_POST['name_mi3'];
$gender3 = $_POST['gender3'];
$birthdate3 = $_POST['birthdate3'];
$ssn3 = $_POST['ssn3'];
$name_last4 = $_POST['name_last4'];
$name_first4 = $_POST['name_first4'];
$name_mi4 = $_POST['name_mi4'];
$gender4 = $_POST['gender4'];
$birthdate4 = $_POST['birthdate4'];
$ssn4 = $_POST['ssn4'];
$name_last5 = $_POST['name_last5'];
$name_first5 = $_POST['name_first5'];
$name_mi5 = $_POST['name_mi5'];
$gender5 = $_POST['gender5'];
$birthdate5 = $_POST['birthdate5'];
$ssn5 = $_POST['ssn5'];
$name_last6 = $_POST['name_last6'];
$name_first6 = $_POST['name_first6'];
$name_mi6 = $_POST['name_mi6'];
$gender6 = $_POST['gender6'];
$birthdate6 = $_POST['birthdate6'];
$ssn6 = $_POST['ssn6'];
$street = $_POST['street'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$email = $_POST['email'];
$home_phone = $_POST['home_phone'];
$insurance = $_POST['insurance'];
$policy = $_POST['policy'];
$group = $_POST['group'];
/* server and database connection */
$my_connection = mysql_connect($server, $user, $password);
if(!$my_connection) {
die('Could not connect to server:' . mysql_error());
}
echo 'Connected successfully to $server. <br><br>';
mysql_select_db ($database, $my_connection)
or die ( 'Couldn\'t open $database: ' . mysql_error() );
echo 'Connected successfully to $database.';
/* Add to database */
$query = " INSERT INTO applicant ( name_last1, name_first1, name_mi1, gender1, birthdate1, ssn1, name_last2, name_first2, name_mi2, gender2, birthdate2, ssn2, name_last3, name_first3, name_mi3, gender3, birthdate3, ssn3, name_last4, name_first4, name_mi4, gender4, birthdate4, ssn4, name_last5, name_first5, name_mi5, gender5, birthdate5, ssn5, name_last6, name_first6, name_mi6, gender6, birthdate6, ssn6, street, city, state, zip, email, home_phone, insurance, policy, group ) VALUES ( '$name_last1' , '$name_first1', '$name_mi1', '$gender1', '$birthdate1', '$ssn1', '$name_last2', '$name_first2', '$name_mi2', '$gender2', '$birthdate2', '$ssn2', '$name_last3', '$name_first3', '$name_mi3', '$gender3', '$birthdate3', '$ssn3', '$name_last4', '$name_first4', '$name_mi4', '$gender4', '$birthdate4', '$ssn4', '$name_last5', '$name_first5', '$name_mi5', '$gender5', '$birthdate5', '$ssn5', '$name_last6', '$name_first6', '$name_mi6', '$gender6', '$birthdate6', '$ssn6', '$street', '$city', '$state', '$zip', '$email', '$home_phone', '$insurance', '$policy', '$group') " ;
$result = mysql_query ($query) or die ( "Error in query: $query. " . mysql_error() );
echo "<br><br>New record inserted with ID ".mysql_insert_id();
mysql_close ($my_connection);
?>
and the error:
Connected successfully to $server.
Connected successfully to $database.Error in query: INSERT INTO applicant ( name_last1, name_first1, name_mi1, gender1, birthdate1, ssn1, name_last2, name_first2, name_mi2, gender2, birthdate2, ssn2, name_last3, name_first3, name_mi3, gender3, birthdate3, ssn3, name_last4, name_first4, name_mi4, gender4, birthdate4, ssn4, name_last5, name_first5, name_mi5, gender5, birthdate5, ssn5, name_last6, name_first6, name_mi6, gender6, birthdate6, ssn6, street, city, state, zip, email, home_phone, insurance, policy, group ) VALUES ( 'V' , 'T', 'p', 'M', '', '', '', '', 'a', 'F', '', '', '', '', '', ' ', '', '', '', '', '', ' ', '', '', '', '', '', ' ', '', '', '', '', '', 'M', '', '', '', '', '', '', '', '', '', '', '') . You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group ) VALUES ( 'V' , 'T', 'p', 'M', '', '', '' at line 1
Any suggestions?
Thanks!