使用phpmyadmin和一列插入的数据不断重复我尝试的第一个测试用例的值 - Inserted data using phpmyadmin and one column keeps repeating the value of the first test case that i tried

Inserted data using phpmyadmin and one column keeps repeating the value of the first test case that i tried

我的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}'
      )";