ช่วยด้วยคะ #1064 - 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 '$strSQL = "INSERT INTO webdata (domainname,title,descrip,tags,languages,address' at line 1
Code Error
Code (PHP) if($_POST["add_submit"]){
if(copy($_FILES["filUpload"]["tmp_name"],"./logo images/".$_FILES["filUpload"]["name"]))
{
//*** Insert Record ***//
$strSQL = "INSERT INTO webdata (domainname,title,descrip,tags,languages,address,contact,logo_pic) VALUES ('".$_POST["txtdomainname"]."','".$_POST["txttitle"]."','".$_POST["txtdescrip"]."','".$_POST["txttags"]."','".$_POST["txtlanguages"]."','".$_POST["txtaddress"]."','".$_POST["txtcontact"]."','".$_FILES["filUpload"]["name"]."')";
$objQuery = mysql_query($strSQL);
}
}
Tag PHP
Date :
2011-07-13 11:02:22By :
PosterView :
2675Reply :
7
INSERT INTO webdata (domainname,title,descrip,tags,languages,address,contact,logo_pic ) ผิดแถวนี้ นะ ลองเช็คดูตรงกับฐานข้อมูลไม มีช่องว่างหรือเปล่า
Date :
2011-07-13 11:08:03By :
ckcr
ขอบคุนมากคะ เช็คตามที่แนะนำแล้วนะคะ แต่ก้อหาไม่เจอยุดี
Date :
2011-07-13 11:31:00By :
Poster
คำสั่งผิดต้องไล่ดู You have an error in your SQL syntax;
Date :
2011-07-13 11:42:47By :
bank1324
Code (PHP) <?
if($_POST["add_submit"]){
if(copy($_FILES["filUpload"]["tmp_name"],"./logo images/".$_FILES["filUpload"]["name"]))
{
$txtdomainname = $_POST["txtdomainname"];
$txttitle = $_POST["txttitle"];
$txtdescrip = $_POST["txtdescrip"];
$txttags = $_POST["txttags"];
$txtlanguages = $_POST["txtlanguages"];
$txtaddress = $_POST["txtaddress"];
$txtcontact = $_POST["txtcontact"];
$filUpload = $_FILES["filUpload"]["name"];
//*** Insert Record ***//
$strSQL = "INSERT INTO webdata (domainname,title,descrip,tags,languages,address,contact,logo_pic) VALUES ('$txtdomainname','$txttitle','$txtdescrip','$txttags','$txtlanguages','$txtaddress','$txtcontact','$filUpload')";
$objQuery = mysql_query($strSQL);
}
}
?>
Date :
2011-07-13 11:46:15By :
avsqlz
echo $strSQL ดู สิCode (PHP) if($_POST["add_submit"]){
if(copy($_FILES["filUpload"]["tmp_name"],"./logo images/".$_FILES["filUpload"]["name"]))
{
//*** Insert Record ***//
$strSQL = "INSERT INTO webdata (domainname,title,descrip,tags,languages,address,contact,logo_pic) VALUES ('".$_POST["txtdomainname"]."','".$_POST["txttitle"]."','".$_POST["txtdescrip"]."','".$_POST["txttags"]."','".$_POST["txtlanguages"]."','".$_POST["txtaddress"]."','".$_POST["txtcontact"]."','".$_FILES["filUpload"]["name"]."')";
$objQuery = mysql_query($strSQL);
echo $strSQL; <<<<<<ลองดู
}
}
Date :
2011-07-13 11:46:23By :
ckcr
ลองตามที่ทุกท่านแนะนำแล้วนะคะ มันก้อไม่ลงฐานยุดีคะdatawebform.php <?
include("./config/config.php");
if($_POST["add_submit"]){
if(copy($_FILES["filUpload"]["tmp_name"],"./logo images/".$_FILES["filUpload"]["name"]))
{
$txtdomainname = $_POST["txtdomainname"];
$txttitle = $_POST["txttitle"];
$txtdescrip = $_POST["txtdescrip"];
$txttags = $_POST["txttags"];
$txtlanguages = $_POST["txtlanguages"];
$txtaddress = $_POST["txtaddress"];
$txtcontact = $_POST["txtcontact"];
$filUpload = $_FILES["filUpload"]["name"];
//*** Insert Record ***//
$strSQL = "INSERT INTO webdata (domainname,title,descrip,tags,languages,address,contact,logo_pic) VALUES ('$txtdomainname','$txttitle','$txtdescrip','$txttags','$txtlanguages','$txtaddress','$txtcontact','$filUpload')";
$objQuery = mysql_query($strSQL);
echo $strSQL;
}
}
?>
<html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css">
</head>
<body>
<div id="stylized" class="adddataform">
<form id="form" name="add" method="post" action="?Action=insert" enctype="multipart/form-data">
<h1>Add Website Data</h1>
<p>We know the web</p>
<label>Domain name<span class="small">Add Domain name</span></label>
<input name="txtdomainname" id="txtdomainname" />
<label>Title<span class="small">Add Title</span></label>
<input name="txttitle" id="txttitle" />
<label>Description<span class="small">Add Description</span></label>
<input name="txtdescrip" id="txtdescrip" />
<label>Key<span class="small">Add Key</span></label>
<input name="txttags" id="txttags" />
<label>Languages<span class="small">Add Languages</span></label>
<input name="txtlanguages" id="txtlanguages" />
<label>Address<span class="small">Add Address</span></label>
<input name="txtaddress" id="txtaddress" />
<label>Contact<span class="small">Add Contact</span></label>
<input name="txtcontact" id="txtcontact" />
<label>Logo<span class="small">Add Logo</span></label>
<input name="filUpload" type="file">
<button type="submit" name="add_submit">Save</button>
<div class="spacer"></div>
</form>
</div>
</body>
</html>
Date :
2011-07-13 12:01:25By :
Poster
ได้ละคะ ขอบคุนทุกๆคนคะ
Date :
2011-07-13 13:55:18By :
Poster
Server 01
Load balance : Server 01
