Error Save [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 '' at line 1]
งงมากเลยครับผมก็ว่า ทำตามหมดทุกอย่างแล้วนะครับ เพราะแก้แค่ ตัวแปรเฉยๆแต่ทำใมมันถึงขึ้นแบบนี้อะครับ<html>
<head>
<title>MyRoMance</title>
</head>
<body>
<?
$objConnect = mysql_connect("localhost","mamacpe_mama01","9543688") or die("Error Connect to Database");
$objDB = mysql_select_db("mamacpe_01");
//*** Add Condition ***//
if($_POST["hdnCmd"] == "Add")
{
$strSQL = "INSERT INTO Carin ";
$strSQL .="(Id,Name,Number,City,Color) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtAddId"]."','".$_POST["txtAddName"]."' ";
$strSQL .=",'".$_POST["txtAddNumber"]."' ";
$strSQL .=",'".$_POST["txtAddCity"]."','".$_POST["txtAddColor"]."' ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Save [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
//*** Update Condition ***//
if($_POST["hdnCmd"] == "Update")
{
$strSQL = "UPDATE Carin SET ";
$strSQL .="Id = '".$_POST["txtEditId"]."' ";
$strSQL .=",Name = '".$_POST["txtEditName"]."' ";
$strSQL .=",Number= '".$_POST["txtEditNumber"]."' ";
$strSQL .=",City= '".$_POST["txtEditCity"]."' ";
$strSQL .=",Color = '".$_POST["txtEditColor"]."' ";
$strSQL .="WHERE Id = '".$_POST["hdnEditId"]."' ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Update [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
//*** Delete Condition ***//
if($_GET["Action"] == "Del")
{
$strSQL = "DELETE FROM Carin ";
$strSQL .="WHERE Id = '".$_GET["ID"]."' ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Delete [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM Carin";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<form name="frmMain" method="post" action="<?=$_SERVER["PHP_SELF"];?>">
<input type="hidden" name="hdnCmd" value="">
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">Id </div></th>
<th width="98"> <div align="center">Name </div></th>
<th width="198"> <div align="center">Number </div></th>
<th width="97"> <div align="center">City</div></th>
<th width="59"> <div align="center">Color</div></th>
<th width="30"> <div align="center">Edit </div></th>
<th width="30"> <div align="center">Delete </div></th>
</tr>
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<?
if($objResult["Id"] == $_GET["ID"] and $_GET["Action"] == "Edit")
{
?>
<tr>
<td><div align="center">
<input type="text" name="txtEditId" size="5" value="<?=$objResult["Id"];?>">
<input type="hidden" name="hdnEditId" size="5" value="<?=$objResult["Id"];?>">
</div></td>
<td><input type="text" name="txtEditName" size="20" value="<?=$objResult["Name"];?>"></td>
<td><input type="text" name="txtEditNumber" size="20" value="<?=$objResult["Number"];?>"></td>
<td><div align="center"><input type="text" name="txtEditCity" size="2" value="<?=$objResult["City"];?>"></div></td>
<td align="right"><input type="text" name="txtEditColor" size="5" value="<?=$objResult["Color"];?>"></td>
<td align="right"><input type="text" name="txtEditUsed" size="5" value="<?=$objResult["Used"];?>"></td>
<td colspan="2" align="right"><div align="center">
<input name="btnAdd" type="button" id="btnUpdate" value="Update" OnClick="frmMain.hdnCmd.value='Update';frmMain.submit();">
<input name="btnAdd" type="button" id="btnCancel" value="Cancel" OnClick="window.location='<?=$_SERVER["PHP_SELF"];?>';">
</div></td>
</tr>
<?
}
else
{
?>
<tr>
<td><div align="center"><?=$objResult["Id"];?></div></td>
<td><?=$objResult["Name"];?></td>
<td><?=$objResult["Number"];?></td>
<td><div align="center"><?=$objResult["City"];?></div></td>
<td align="right"><?=$objResult["Color"];?></td>
<td align="right"><?=$objResult["Used"];?></td>
<td align="center"><a href="<?=$_SERVER["PHP_SELF"];?>?Action=Edit&CusID=<?=$objResult["Id"];?>">Edit</a></td>
<td align="center"><a href="JavaScript:if(confirm('Confirm Delete?')==true){window.location='<?=$_SERVER["PHP_SELF"];?>?Action=Del&CusID=<?=$objResult["Id"];?>';}">Delete</a></td>
</tr>
<?
}
?>
<?
}
?>
<tr>
<td><div align="center"><input type="text" name="txtAddId" size="5"></div></td>
<td><input type="text" name="txtAddName" size="20"></td>
<td><input type="text" name="txtAddNumber" size="20"></td>
<td><div align="center"><input type="text" name="txtAddCity" size="2"></div></td>
<td align="right"><input type="text" name="txtAddColor" size="5"></td>
<td colspan="2" align="right"><div align="center">
<input name="btnAdd" type="button" id="btnAdd" value="Add" OnClick="frmMain.hdnCmd.value='Add';frmMain.submit();">
</div></td>
</tr>
</table>
</form>
<?
mysql_close($objConnect);
?>
</body>
</html> Tag PHP, MySQL
Date :
2011-09-01 04:03:21By :
mamaView :
7886Reply :
4
Code (PHP) $strSQL = "INSERT INTO Carin ";
$strSQL .="(Id,Name,Number,City,Color) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtAddId"]."','".$_POST["txtAddName"]."' ";
$strSQL .=",'".$_POST["txtAddNumber"]."' ";
$strSQL .=",'".$_POST["txtAddCity"]."','".$_POST["txtAddColor"]."' ";
$objQuery = mysql_query($strSQL);
Date :
2011-09-01 06:14:42By :
webmaster
ขอบคุณมากครับ ตอนนี้ ที่ถามไปแก้ได้เรียบร้อยแล้วครับ แต่ตอนนี้ติดปัญหาอื่นอยู่ ยังใงเดี้ยวผมจะลอง หาดูก่อนนะครับว่าเป็นเพราะอะไร ยังใง ถ้าติด เดี้ยวจอ ขอมาถามอีกทีนะครับ
Date :
2011-09-01 12:47:21By :
ขอบคุณคร้าบ
<?
Date :
2012-07-01 19:48:35By :
Beeoi
Error Save [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 '('trutyift','','','','2012-07-01 20:41:44')' at line 1]
Date :
2012-07-01 19:50:59By :
Beeoi
Server 02
Load balance : Server 02
