我的php脚本类似于:
$mobnumber = mysqli_real_escape_string($conn, $_POST["mobnumber"]);
$name = mysqli_real_escape_string($conn, $_POST["name"]);
$state = mysqli_real_escape_string($conn, $_POST["state"]);
$role = mysqli_real_escape_string($conn, $_POST["role"]);
$designation = mysqli_real_escape_string($conn, $_POST["designation"]);
$organisation = mysqli_real_escape_string($conn, $_POST["organisation"]);
$mail = mysqli_real_escape_string($conn, $_POST["mail"]);
$addr = mysqli_real_escape_string($conn, $_POST["addr1"].", ".$_POST["addr2"].", ".$_POST["addr3"].", ".$_POST["addr4"].", ".$_POST["addr5"]);
$sql="INSERT INTO admin_reg VALUES (null, '$mobnumber', '$name', '$state', '$role', '$designation', '$organisation', '$mail', '$addr')";
我的mobnumber字段的形式空间是:
<label class="description" for="mobnumber">Contact Number </label>
<div>
<input id="mobnumber" name="mobnumber" class="element text medium" type="text" maxlength="255" value=""/>
</div>
无论我在手机号码字段中输入什么值,我都会将其作为第一个测试用例的随机手机号码。
试试这个:
$sql = "INSERT INTO admin_reg (
-- Enter your table fields name here
) VALUES (
null,
'{$mobnumber}',
'{$name}',
'{$state}',
'{$role}',
'{$designation}',
'{$organisation}',
'{$mail}',
'{$addr}'
)";