Greeting. I am trying to create a form to store user information in MySQL database. The forms are programed in HTML and PHP. I get the following error message, "Error: 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 '','92820','999-999-9999','000-888-9909')' at line 4"
Below is my code in PHP:
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$sql="INSERT INTO Borrower_info (First_Name, Middle_Initial,Last_Name,Apt_Number,Street_Address,City,State,Zip,Home_Phone_Number,Cell_Phone_Number)
VALUES
('$_POST[First_Name]','$_POST[Middle_Initial]','$_POST[Last_Name]','$_POST[Apt_Number]','$_POST[Street_Address]','$_POST[City]','$_POST[State]')','$_POST[Zip]','$_POST[Home_Phone_Number]','$_POST[Cell_Phone_Number]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>
Also, here is my html code:
<html>
<title> Dream Life Mortgage </title>
<body bgcolor="#FFFF00">
<H1>Dream Life Mortgage</H1>
<H3>New Customer Form</H3>
<form action="insert.php" method="post">
Loan #:<input type="text" name="Loan_Number" />
Firstname: <input type="text" name="First_Name" />
Middle Initial: <input type="text" name="Middle_Initial"/>
Lastname: <input type="text" name="Last_Name" />
Apt #: <input type="text" name="Apt_Number" />
Street Address: <input type="text" name="Street_Address"/>
City: <input type="text" name="City"/>
State: <input type="text" name="State"/>
Zip: <input type="text" name="Zip"/>
Home Phone #: <input type="text" name="Home_Phone_Number"/>
Cell Phone #: <input type="text" name="Cell_Phone_Number"/>
<br>
<br>
<input type="submit" />
</form>
</body>
</html>
Please help. I am a newbie and desiring to do more programming. I am teaching myself.
Below is my code in PHP:
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$sql="INSERT INTO Borrower_info (First_Name, Middle_Initial,Last_Name,Apt_Number,Street_Address,City,State,Zip,Home_Phone_Number,Cell_Phone_Number)
VALUES
('$_POST[First_Name]','$_POST[Middle_Initial]','$_POST[Last_Name]','$_POST[Apt_Number]','$_POST[Street_Address]','$_POST[City]','$_POST[State]')','$_POST[Zip]','$_POST[Home_Phone_Number]','$_POST[Cell_Phone_Number]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>
Also, here is my html code:
<html>
<title> Dream Life Mortgage </title>
<body bgcolor="#FFFF00">
<H1>Dream Life Mortgage</H1>
<H3>New Customer Form</H3>
<form action="insert.php" method="post">
Loan #:<input type="text" name="Loan_Number" />
Firstname: <input type="text" name="First_Name" />
Middle Initial: <input type="text" name="Middle_Initial"/>
Lastname: <input type="text" name="Last_Name" />
Apt #: <input type="text" name="Apt_Number" />
Street Address: <input type="text" name="Street_Address"/>
City: <input type="text" name="City"/>
State: <input type="text" name="State"/>
Zip: <input type="text" name="Zip"/>
Home Phone #: <input type="text" name="Home_Phone_Number"/>
Cell Phone #: <input type="text" name="Cell_Phone_Number"/>
<br>
<br>
<input type="submit" />
</form>
</body>
</html>
Please help. I am a newbie and desiring to do more programming. I am teaching myself.
