表字段正在将VARCHAR记录为0

Question

我有一个表格，其中有6个字段，姓名，电子邮件，电话，性别，行业和教育。前四个字段记录了在mysql数据库中正确输入的值，行业和教育字段仅显示0。我到处找都找不到问题所在，感谢您的帮助。

表格：

​

表结构：

​

表值：

​

    <?php
$username = $_POST['username'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$gender = $_POST['gender'];
$industry = $_POST['industry'];
$education = $_POST['education'];

if (!empty($username) || !empty($email) || !empty($phone) || !empty($gender) || !empty($industry) || !empty($education)) {

    //create connection
    $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);
    if (mysqli_connect_error()) {
     die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
    } else {
     $SELECT = "SELECT email From register Where email = ? Limit 1";
     $INSERT = "INSERT Into register (username, email, phone, gender, industry, education) values(?, ?, ?, ?, ?, ?)";
     //Prepare statement
     $stmt = $conn->prepare($SELECT);
     $stmt->bind_param("s", $email);
     $stmt->execute();
     $stmt->bind_result($email);
     $stmt->store_result();
     $rnum = $stmt->num_rows;
     if ($rnum==0) {
      $stmt->close();
      $stmt = $conn->prepare($INSERT);
      $stmt->bind_param("ssssii", $username, $email, $phone, $gender, $industry, $education);
      $stmt->execute();
      echo "";
     } else {
      echo "Someone already register using this email";
     }
     $stmt->close();
     $conn->close();
    }
} else {
 echo "All field are required";
 die();
}
?>

Answer 1

语法： bind_param ( string $types，mixed &$var1，mixed &$... )

$types包含一个或多个字符的字符串，用于指定相应绑定变量的类型：

类型规范字符

i对应变量的类型为integer

%d对应变量的类型为double

的对应变量的类型为字符串

b对应的变量是一个blob，将以数据包的形式发送

在本例中，所有内容都是字符串，所以使用"ssssss“代替"ssssii”

  $stmt->bind_param("ssssss", $username1, $email, $phone, $gender, $industry, $education);