收到的错误:
错误:您的SQL语法有错误;请检查与您的MySQL服务器版本对应的手册,以获得正确的语法以使用接近“组,事件”值(
当我单击register.php文件的寄存器时。帮助!
Register.php
<form id='register' action='RegisterCode.php' method='post' accept-charset='UTF-8'> <table>
<tr> <td> Name: </td> <td> <input type="text" name="Name" maxlength="50" /> </td> </tr>
<tr> <td> Age: </td> <td> <input type="text" name="Age" maxlength="2" /> </td> </tr>
<tr> <td> Contact: </td> <td> <input type="text" name="Contact" maxlength="8" /> </td> </tr>
<tr> <td> Email: </td> <td> <input type="text" name="Email" maxlength="200" /> </td> </tr>
<tr> <td> Gender: </td> <td> <input type="text" name="Gender" maxlength="2" /> </td> </tr> <tr> <td> Address: </td><td> <input type="text" name="Address" maxlength="100"/></td></tr>
<tr> <td> Which Industry/ Occupational Group: </td> <td>
<select name="Group"> <option value="Student">Student</option> <option value="Employed">Employed</option> <option value="Unemployed">Unemployed</option> <option value="Retired">Retired</option>
</select>
<tr> <td> How did you know about this event: </td> <td>
<select name="Event"> <option value="Online">Online</option> <option value="Newspaper">Newspaper</option> <option value="Friend">Friend</option> </select>
<tr><td></td><td><input class="formstylethree" type="submit"></td></tr> </table></form>RegisterCode.php
<?php require_once("includes/connection.php");?> <?php require_once("includes/functions.php"); ?> <?php $sql="INSERT INTO registration(Name, Age, Contact, Email, Gender, Address, Group, Event) VALUES ('$_POST[Name]','$_POST[Age]','$_POST[Contact]','$_POST[Email]','$_POST[Gender]','$_POST[Address]','$_POST[Group]','$_POST[Event]')";
if (!mysql_query($sql,$connection)) { die('Error: ' . mysql_error()); } else { $location="index.php"; header("Location: {$location}"); echo "1 record added" . $sql; }
mysql_close($connection); ?>登记表
Name varchar (50)
Age int(2)
Contact varchar(8)
Email varchar(200)
Gender varchar(200)
Address varchar(200)
Group varchar(150)
Event varchar(150)发布于 2014-01-31 09:35:22
发布于 2014-01-31 09:40:42
对于保留关键字,请使用`,也可以像下面这样更改查询
$sql="INSERT INTO registration(Name, Age, Contact, Email, Gender, Address, `Group`, `Event`) VALUES ('".$_POST[Name]."','".$_POST[Age]."','".$_POST[Contact]."','".$_POST[Email]."','".$_POST[Gender]."','".$_POST`[Address]."','".$_POST[Group]."','".$_POST[Event]."')";发布于 2014-01-31 09:39:10
尝试连接:
VALUES('".$_POST['Name']."','".$_POST['Age']."',...https://stackoverflow.com/questions/21476601
复制相似问题