string数据转换:使用mysql从spinner插入数据

mfpqipee  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(258)

我试图通过spinner将数据添加到mysql数据库中,spinner有几个选项可供选择。我不知道如何在mysql代码中声明spinner的值。错误发生在第39行,这是使用mysql代码插入数据库的第一行。我期待着尽快收到你的来信。

  1. <?php
  2. include 'db.php';
  3. $user_type = ['user_type'];
  4. $first = $_POST['first'];
  5. $last = $_POST['last'];
  6. $email = $_POST['email'];
  7. $username = $_POST['username'];
  8. $password = $_POST['password'];
  9. $phone = $_POST['phone'];
  10. if(/*$user_type == '' ||*/ $first == '' || $last == '' || $email == '' || $username == '' || $password == '' || $phone == '')
  11. {
  12. echo 'Please, fill all fields';
  13. } else{
  14. $sql = "SELECT * FROM users WHERE user_username='$username'";
  15. $check = mysqli_fetch_array(mysqli_query($conn,$sql));
  16. if(isset($check))
  17. {
  18. echo 'Username already exist. Please, use another one.';
  19. }else{
  20. $hashedPWD = password_hash($password , PASSWORD_DEFAULT); //hash password
  21. $sql = "INSERT INTO users (user_type, user_first, user_last, user_email, user_username, user_pwd, user_phonenumber) VALUES('$user_type','$first','$last','$email','$username','$hashedPWD','$phone')";
  22. if(mysqli_query($conn,$sql))
  23. {
  24. echo 'Successfully registered';
  25. } else{
  26. echo 'Oops! Please try again!';
  27. }
  28. }
  29. mysqli_close($conn);
  30. }

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题