not able to insert data to a database in MYSQL 5.0 wid PHP
Posted: Wed Mar 18, 2009 10:51 am
The following error is shown when code was executed:
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 ''logistics'.'posted_manpower' VALUES('1',1,1,1)' at line 1
I am new to php. I have tried many changes but nothing is helping me out.. pls help . the code is below:
<?php
$Link = Mysql_connect("localhost","root","taralim")
or die(mysql_error());
mysql_select_db("logistics",$Link)
or die(mysql_error());// DELETE SCRIPT
?>
<?php
echo 'masia';
echo $_POST['Offrs']." "."monindra";
if ( array_key_exists ( '_submit_check', $_POST ) )
{
if ( $_POST [ 'Offrs' ] != '' && $_POST [ 'JCOs' ] != ''&& $_POST['ORs']!='' )
{
mysql_select_db ( $database);
$Fmn= mysql_real_escape_string($_POST['FmnName']);
$Offrs= mysql_real_escape_string($_POST['Offrs']);
$JCOs= mysql_real_escape_string($_POST['JCOs']);
$ORs= mysql_real_escape_string($_POST['ORs']);
$query="INSERT INTO 'logistics'.'posted_manpower' VALUES('$FmnName',$Offrs,$JCOs,$ORs)";
/*"INSERT INTO 'posted_manpower'('FMN_NAME',)".*/
if ( @mysql_query ($query,$Link) )
{
$success = 'New Record added';
}
else {
die ( mysql_error () );
}
}
else {
echo 'Enter Data for all !';
}
}
if ( isset ( $success ) ) {
echo $success;
}
else {
//we need this form only if we don't have the success message
?>
<form action="<?echo $_SERVER['PHP_SELF']?>" method=post>
<input type=hidden name="_submit_check" value="1">
<table bgcolor="#353535" width="20%" cellpadding="3" cellspacing="1"
align=center>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold"> Fmn Name</td>
<td bg="#ffffff" align="center">
<input type="text" id="FmnName" name="FmnName" value="<?php if ( isset ( $_POST['FmnName'] ) ){echo $_POST['FmnName'];}?>" title="Enter fmn name">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold">Offrs </td>
<td bg="#ffffff" align="center">
<input type="text" id="Offrs" value="<?php if ( isset ( $_POST['Offrs'] ) ){echo $_POST['Offrs'];}?>" name="Offrs" title="Enter No. of Offrs">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold">JCOs</td>
<td bg="#ffffff" align="center">
<input type="text" name="JCOs" id="JCOs" value="<?php if ( isset ( $_POST['JCOs'] ) ){echo $_POST['JCOs'];}?>"title="Enter No. of JCOs">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold">ORs</td>
<td bg="#ffffff" align="center">
<input type="text" name="ORs" id="ORs" value="<?php if ( isset ( $_POST['ORs'] ) ){echo $_POST['ORs'];}?>" title="Enter No. of ORs">
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#ffffff" align=center>
<input bg="ffffff" type="submit" title="submit your data" name="Save" value="save">
</td>
</tr>
</table>
</form>
<?php
}
?>
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 ''logistics'.'posted_manpower' VALUES('1',1,1,1)' at line 1
I am new to php. I have tried many changes but nothing is helping me out.. pls help . the code is below:
<?php
$Link = Mysql_connect("localhost","root","taralim")
or die(mysql_error());
mysql_select_db("logistics",$Link)
or die(mysql_error());// DELETE SCRIPT
?>
<?php
echo 'masia';
echo $_POST['Offrs']." "."monindra";
if ( array_key_exists ( '_submit_check', $_POST ) )
{
if ( $_POST [ 'Offrs' ] != '' && $_POST [ 'JCOs' ] != ''&& $_POST['ORs']!='' )
{
mysql_select_db ( $database);
$Fmn= mysql_real_escape_string($_POST['FmnName']);
$Offrs= mysql_real_escape_string($_POST['Offrs']);
$JCOs= mysql_real_escape_string($_POST['JCOs']);
$ORs= mysql_real_escape_string($_POST['ORs']);
$query="INSERT INTO 'logistics'.'posted_manpower' VALUES('$FmnName',$Offrs,$JCOs,$ORs)";
/*"INSERT INTO 'posted_manpower'('FMN_NAME',)".*/
if ( @mysql_query ($query,$Link) )
{
$success = 'New Record added';
}
else {
die ( mysql_error () );
}
}
else {
echo 'Enter Data for all !';
}
}
if ( isset ( $success ) ) {
echo $success;
}
else {
//we need this form only if we don't have the success message
?>
<form action="<?echo $_SERVER['PHP_SELF']?>" method=post>
<input type=hidden name="_submit_check" value="1">
<table bgcolor="#353535" width="20%" cellpadding="3" cellspacing="1"
align=center>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold"> Fmn Name</td>
<td bg="#ffffff" align="center">
<input type="text" id="FmnName" name="FmnName" value="<?php if ( isset ( $_POST['FmnName'] ) ){echo $_POST['FmnName'];}?>" title="Enter fmn name">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold">Offrs </td>
<td bg="#ffffff" align="center">
<input type="text" id="Offrs" value="<?php if ( isset ( $_POST['Offrs'] ) ){echo $_POST['Offrs'];}?>" name="Offrs" title="Enter No. of Offrs">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold">JCOs</td>
<td bg="#ffffff" align="center">
<input type="text" name="JCOs" id="JCOs" value="<?php if ( isset ( $_POST['JCOs'] ) ){echo $_POST['JCOs'];}?>"title="Enter No. of JCOs">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFf" align="center" font="bold">ORs</td>
<td bg="#ffffff" align="center">
<input type="text" name="ORs" id="ORs" value="<?php if ( isset ( $_POST['ORs'] ) ){echo $_POST['ORs'];}?>" title="Enter No. of ORs">
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#ffffff" align=center>
<input bg="ffffff" type="submit" title="submit your data" name="Save" value="save">
</td>
</tr>
</table>
</form>
<?php
}
?>