Hello every body I am using a form in which i have 12 fields. But when i click on submit button then i got error :
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 ‘add, add1, mobile, email, checkin, checkout, package, adult, children, hotel, tr’ at line 1
For more information my php code is below :
[code=php]
<?php
$host=”localhost”; // Host name
$username=”root”; // Mysql username
$password=”*******”; // Mysql password
$db_name=”book”; // Database name
$tbl_name=”packbook”; // Table name
// Connect to server and select databse.
$connect = mysql_connect(“$host”, “$username”, “$password”)or die(“cannot connect”);
mysql_select_db(“$db_name”)or die(“cannot select DB”);
?>
<?php
if (isset($_REQUEST[‘Submit’]))
{
$pname = mysql_real_escape_string($_POST[‘pname’]);
$padd = mysql_real_escape_string($_POST[‘padd’]);
$padd1 = mysql_real_escape_string($_POST[‘padd1’]);
$pmob = mysql_real_escape_string($_POST[‘pmobile’]);
$pmail = mysql_real_escape_string($_POST[‘pemail’]);
$date = date(‘Y/m/d’, strtotime( mysql_real_escape_string($_POST[‘pcheckin’])));
$date1 = date(‘Y/m/d’, strtotime( mysql_real_escape_string ($_POST[‘pcheckout’])));
$ppack = mysql_real_escape_string($_POST[‘pack’]);
$padult = mysql_real_escape_string($_POST[‘adult’]);
$pchild = mysql_real_escape_string($_POST[‘child’]);
$photel = mysql_real_escape_string($_POST[‘hotel’]);
$ptrans = mysql_real_escape_string($_POST[‘trans’]);
$query = “INSERT INTO packbook( name, add, add1, mobile, email, checkin, checkout, package, adult, children, hotel, transport) VALUES( ‘$pname’, ‘$padd’, ‘$padd1’, ‘$pmob’, ‘$pmail’, ‘$date’, ‘$date1’, ‘$ppack’, ‘$padult’, ‘$pchild’, ‘$photel’, ‘$ptrans’)”;
if($result = mysql_query($query ,$connect))
{
echo “Thank you, Your information has been entered into our database”;
}
else
{
echo “ERROR: “.mysql_error();
}
}
else
{
?>
And my form is like :
[code=html]
<form action=”” method=”post” >
<input type=”text” name=”pname” size=”27″ style=”width:192px;” value=””>
<input type=”text” name=”padd” size=”27″ style=”width:192px;” value=””>
<input type=”text” name=”padd1″ size=”27″ style=”width:192px;” value=””>
<input type=”text” name=”pmobile” size=”27″ style=”width:192px;” value=””>
<select name=”pack” size=”1″>
<option>Please Select</option>
<option>Delhi-Shimla-Delhi</option>
</select>
<input type=”text” name=”pemail” size=”27″ style=”width:192px;” value=””>
<input type=”text” name=”pcheckin” size=”27″ style=”width:192px;” value=””>
<input type=”text” name=”pcheckout” size=”27″ style=”width:192px;” value=””>
<select name=”adult” size=”1″>
<option>Please Select</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
</select>
<select name=”child” size=”1″>
<option>Please Select</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
</select>
<select name=”hotel” size=”1″>
<option value=””>Please Select</option>
<option value=””>Budget </option>
<option value=””>Luxury</option>
<option value=””>Semi-Luxury</option>
<option value=””>5 Star</option>
<option value=””>3 Star</option>
</select>
<select name=”trans” size=”1″>
<option>Please Select</option>
<option>Normal Car</option>
<option>AC Car</option>
<option>SUV</option>
<option>Tourister</option>
<option>Mini Bus</option>
</select>
[code=php]
<?php
}
?>
[code=html]
<input name=”Submit” type=”submit” value=”Submit” />
</form>
So please help me out.