Cyrus_black
یک شنبه 21 اردیبهشت 1393, 18:28 عصر
با سلام
دوستان من کد زیر رو برای ثبت نوشتم ولی ارور : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax رو میده
ممنون میشم دوستان یه چک بکنند ببینند مشکل از کجاست
<?php
$username = "*****";
$password = "******";
$hostname = "localhost";
$connect = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
mysql_query("SET character_set_results=utf8 , character_set_client=utf8 , character_set_connection=utf8 , character_set_database=utf8 , character_set_server=utf8");
$select = mysql_select_db("*****",$connect)
or die("Could not select dbname");
$project = mysql_escape_string($_POST['project']);
$rack = mysql_escape_string($_POST['rack']);
$berand = mysql_escape_string($_POST['berand']);
$tedad = mysql_escape_string($_POST['tedad']);
$tool = mysql_escape_string($_POST['tool']);
$arz = mysql_escape_string($_POST['arz']);
$omgh = mysql_escape_string($_POST['omgh']);
$mohal = mysql_escape_string($_POST['mohal']);
$patch = mysql_escape_string($_POST['patch']);
$modpatch = mysql_escape_string($_POST['modpatch']);
$optic = mysql_escape_string($_POST['optic']);
$modoptic = mysql_escape_string($_POST['modoptic']);
$blank = mysql_escape_string($_POST['blank']);
$modblank = mysql_escape_string($_POST['modblank']);
$light = mysql_escape_string($_POST['light']);
$modlight = mysql_escape_string($_POST['modlight']);
$cable = mysql_escape_string($_POST['cable']);
$modcable = mysql_escape_string($_POST['modcable']);
$media = mysql_escape_string($_POST['media']);
$modmedia = mysql_escape_string($_POST['modmedia']);
$cool = mysql_escape_string($_POST['cool']);
$modcool = mysql_escape_string($_POST['modcool']);
$power = mysql_escape_string($_POST['power']);
$modpower = mysql_escape_string($_POST['modpower']);
$sm1 = mysql_escape_string($_POST['sm1']);
$sm2 = mysql_escape_string($_POST['sm2']);
$sm3 = mysql_escape_string($_POST['sm3']);
$sm4 = mysql_escape_string($_POST['sm4']);
$sm5 = mysql_escape_string($_POST['sm5']);
$st1 = mysql_escape_string($_POST['st1']);
$st2 = mysql_escape_string($_POST['st2']);
$st3 = mysql_escape_string($_POST['st3']);
$st4 = mysql_escape_string($_POST['st4']);
$st5 = mysql_escape_string($_POST['st5']);
$sem1 = mysql_escape_string($_POST['sem1']);
$sem2 = mysql_escape_string($_POST['sem2']);
$sem3 = mysql_escape_string($_POST['sem3']);
$sem4 = mysql_escape_string($_POST['sem4']);
$sem5 = mysql_escape_string($_POST['sem5']);
$set1 = mysql_escape_string($_POST['set1']);
$set2 = mysql_escape_string($_POST['set2']);
$set3 = mysql_escape_string($_POST['set3']);
$set4 = mysql_escape_string($_POST['set4']);
$set5 = mysql_escape_string($_POST['set5']);
$se5m1 = mysql_escape_string($_POST['se5m1']);
$se5m2 = mysql_escape_string($_POST['se5m2']);
$se5m3 = mysql_escape_string($_POST['se5m3']);
$se5m4 = mysql_escape_string($_POST['se5m4']);
$se5m5 = mysql_escape_string($_POST['se5m5']);
$se5t1 = mysql_escape_string($_POST['se5m1']);
$se5t2 = mysql_escape_string($_POST['se5m1']);
$se5t3 = mysql_escape_string($_POST['se5m1']);
$se5t4 = mysql_escape_string($_POST['se5m1']);
$se5t5 = mysql_escape_string($_POST['se5m1']);
$modir = mysql_escape_string($_POST['modir']);
if (isset($_POST['buttonName'])) {
$result = mysql_query("INSERT INTO form1 (id, project, rack, tedad, berand, tool, arz, omgh, mohal, patch, modpatch, optic, modoptic, blank, modblank, light, modlight, cable, modcable, media, modmedia, cool, modcool, power, modpower, sm1, sm2, sm3, sm4, sm5, st1, st2, st3, st4, st5, sem1, sem2, sem3, sem4, sem5, set1, set2, set3, set4, set5, se5m1, se5m2, se5m3, se5m4, se5m5, se5t1, se5t2, se5t3, se5t4, se5t5, modir) VALUES (NULL,`$project`,`$rack`,`$tedad``,`$berand`,`$too l`,`$arz`,`$omgh`,`$mohal`,`$patch`,`$modpatch`,`$ optic`,`$modoptic`,`$blank`,`$modblank`,`$light`,` $modlight`,`$cable`,`$modcable`,`$media`,`$modmedi a`,`$cool`,`$modcool`,`$power`,`$modpower`,`$sm1`, `$sm2`,`$sm3`,`$sm4`,`$sm5`,`$st1`,`$st2`,`$st3`,` $st4`,`$st5`,`$sem1`,`$sem2`,`$sem3`,`$sem4`,`$sem 5`,`$set1`,`$set2`,`$set3`,`$set4`,`$set5`,`$se5m1 `,`$se5m2`,`$se5m3`,`$se5m4`,`$se5m5`,`$se5t1`,`$s e5t2`,`$se5t3`,`$se5t4`,`$se5t5`,`$modir`)") or die(mysql_error());
if ($result){
$out = "مشخصات شما با موفقیت ثبت شد";
}
else
{
echo mysql_error();
$out = "خطا در ثبت مشخصات";
}
}
?>
دوستان من کد زیر رو برای ثبت نوشتم ولی ارور : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax رو میده
ممنون میشم دوستان یه چک بکنند ببینند مشکل از کجاست
<?php
$username = "*****";
$password = "******";
$hostname = "localhost";
$connect = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
mysql_query("SET character_set_results=utf8 , character_set_client=utf8 , character_set_connection=utf8 , character_set_database=utf8 , character_set_server=utf8");
$select = mysql_select_db("*****",$connect)
or die("Could not select dbname");
$project = mysql_escape_string($_POST['project']);
$rack = mysql_escape_string($_POST['rack']);
$berand = mysql_escape_string($_POST['berand']);
$tedad = mysql_escape_string($_POST['tedad']);
$tool = mysql_escape_string($_POST['tool']);
$arz = mysql_escape_string($_POST['arz']);
$omgh = mysql_escape_string($_POST['omgh']);
$mohal = mysql_escape_string($_POST['mohal']);
$patch = mysql_escape_string($_POST['patch']);
$modpatch = mysql_escape_string($_POST['modpatch']);
$optic = mysql_escape_string($_POST['optic']);
$modoptic = mysql_escape_string($_POST['modoptic']);
$blank = mysql_escape_string($_POST['blank']);
$modblank = mysql_escape_string($_POST['modblank']);
$light = mysql_escape_string($_POST['light']);
$modlight = mysql_escape_string($_POST['modlight']);
$cable = mysql_escape_string($_POST['cable']);
$modcable = mysql_escape_string($_POST['modcable']);
$media = mysql_escape_string($_POST['media']);
$modmedia = mysql_escape_string($_POST['modmedia']);
$cool = mysql_escape_string($_POST['cool']);
$modcool = mysql_escape_string($_POST['modcool']);
$power = mysql_escape_string($_POST['power']);
$modpower = mysql_escape_string($_POST['modpower']);
$sm1 = mysql_escape_string($_POST['sm1']);
$sm2 = mysql_escape_string($_POST['sm2']);
$sm3 = mysql_escape_string($_POST['sm3']);
$sm4 = mysql_escape_string($_POST['sm4']);
$sm5 = mysql_escape_string($_POST['sm5']);
$st1 = mysql_escape_string($_POST['st1']);
$st2 = mysql_escape_string($_POST['st2']);
$st3 = mysql_escape_string($_POST['st3']);
$st4 = mysql_escape_string($_POST['st4']);
$st5 = mysql_escape_string($_POST['st5']);
$sem1 = mysql_escape_string($_POST['sem1']);
$sem2 = mysql_escape_string($_POST['sem2']);
$sem3 = mysql_escape_string($_POST['sem3']);
$sem4 = mysql_escape_string($_POST['sem4']);
$sem5 = mysql_escape_string($_POST['sem5']);
$set1 = mysql_escape_string($_POST['set1']);
$set2 = mysql_escape_string($_POST['set2']);
$set3 = mysql_escape_string($_POST['set3']);
$set4 = mysql_escape_string($_POST['set4']);
$set5 = mysql_escape_string($_POST['set5']);
$se5m1 = mysql_escape_string($_POST['se5m1']);
$se5m2 = mysql_escape_string($_POST['se5m2']);
$se5m3 = mysql_escape_string($_POST['se5m3']);
$se5m4 = mysql_escape_string($_POST['se5m4']);
$se5m5 = mysql_escape_string($_POST['se5m5']);
$se5t1 = mysql_escape_string($_POST['se5m1']);
$se5t2 = mysql_escape_string($_POST['se5m1']);
$se5t3 = mysql_escape_string($_POST['se5m1']);
$se5t4 = mysql_escape_string($_POST['se5m1']);
$se5t5 = mysql_escape_string($_POST['se5m1']);
$modir = mysql_escape_string($_POST['modir']);
if (isset($_POST['buttonName'])) {
$result = mysql_query("INSERT INTO form1 (id, project, rack, tedad, berand, tool, arz, omgh, mohal, patch, modpatch, optic, modoptic, blank, modblank, light, modlight, cable, modcable, media, modmedia, cool, modcool, power, modpower, sm1, sm2, sm3, sm4, sm5, st1, st2, st3, st4, st5, sem1, sem2, sem3, sem4, sem5, set1, set2, set3, set4, set5, se5m1, se5m2, se5m3, se5m4, se5m5, se5t1, se5t2, se5t3, se5t4, se5t5, modir) VALUES (NULL,`$project`,`$rack`,`$tedad``,`$berand`,`$too l`,`$arz`,`$omgh`,`$mohal`,`$patch`,`$modpatch`,`$ optic`,`$modoptic`,`$blank`,`$modblank`,`$light`,` $modlight`,`$cable`,`$modcable`,`$media`,`$modmedi a`,`$cool`,`$modcool`,`$power`,`$modpower`,`$sm1`, `$sm2`,`$sm3`,`$sm4`,`$sm5`,`$st1`,`$st2`,`$st3`,` $st4`,`$st5`,`$sem1`,`$sem2`,`$sem3`,`$sem4`,`$sem 5`,`$set1`,`$set2`,`$set3`,`$set4`,`$set5`,`$se5m1 `,`$se5m2`,`$se5m3`,`$se5m4`,`$se5m5`,`$se5t1`,`$s e5t2`,`$se5t3`,`$se5t4`,`$se5t5`,`$modir`)") or die(mysql_error());
if ($result){
$out = "مشخصات شما با موفقیت ثبت شد";
}
else
{
echo mysql_error();
$out = "خطا در ثبت مشخصات";
}
}
?>