prepared语句停止写入mysql表

quhf5bfb  于 2021-10-10  发布在  Java
关注(0)|答案(0)|浏览(355)

该脚本工作了大约6个月,但突然停止了对mysql中3个表之一的写入。我对此束手无策,似乎无法解决这个问题。脚本会写入client_许可证和clients_notes表,但在其生命周期内不会写入clients表。正如我所说的,直到两周前,它都工作得很好。代码没有任何更改,我似乎在db上找不到任何问题。

  1. <?php
  2. session_start();
  3. if (!isset($_SESSION['loggedin'])) {
  4. header('Location: index.html');
  5. exit();
  6. }
  7. if( $_SESSION['access'] != "admin") {
  8. session_destroy();
  9. header("location: index.html");
  10. }
  11. ?>
  12. <?php
  13. $DATABASE_HOST = 'localhost';
  14. $DATABASE_USER = '***';
  15. $DATABASE_PASS = '***';
  16. $DATABASE_NAME = '***';
  17. $con = mysqli_connect($DATABASE_HOST, $DATABASE_USER, $DATABASE_PASS, $DATABASE_NAME);
  18. if (mysqli_connect_errno()) {
  19. die ('Failed to connect to MySQL: ' . mysqli_connect_error());
  20. }
  21. if (!isset($_POST['clients_initials'], $_POST['clients_name'], $_POST['clients_nickname'], $_POST['clients_surname'], $_POST['clients_id_nr'], $_POST['clients_profession'], $_POST['clients_tel'], $_POST['clients_tel_alt'], $_POST['clients_email'], $_POST['clients_address_complex'], $_POST['clients_address'], $_POST['clients_suburb'], $_POST['clients_town'], $_POST['clients_province'], $_POST['client_license_nr'], $_POST['client_license_expiry'], $_POST['client_license_code'])) {
  22. header("Location: statusclient1a_admin.php");
  23. die();
  24. }
  25. if ($stmt = $con->prepare('SELECT * FROM clients WHERE clients_id_nr = ?')) {
  26. $stmt->bind_param('s', $_POST['clients_id_nr']);
  27. $stmt->execute();
  28. $stmt->store_result();
  29. if ($stmt->num_rows > 0) {
  30. header("Location: statusclient2a_admin.php");
  31. die();
  32. } else
  33. {
  34. if ($stmt = $con->prepare('INSERT INTO clients (clients_initials, clients_name, clients_nickname, clients_surname, clients_id_nr, clients_profession, clients_address, clients_suburb, clients_town, clients_province, clients_tel, clients_email, clients_tel_alt, clients_address_complex, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)')) {
  35. $stmt->bind_param('sssssssssssssss',$_POST['clients_initials'], $_POST['clients_name'], $_POST['clients_nickname'], $_POST['clients_surname'], $_POST['clients_id_nr'], $_POST['clients_profession'], $_POST['clients_address'], $_POST['clients_suburb'], $_POST['clients_town'], $_POST['clients_province'], $_POST['clients_tel'], $_POST['clients_email'], $_POST['clients_tel_alt'], $_POST['clients_address_complex'], $_SESSION['user_id']);
  36. $stmt->execute();
  37. $GET_last_ID = mysqli_insert_id($con);
  38. $url = 'addvehicle_admin.php?id=' . $GET_last_ID;
  39. header("Location: $url");
  40. } else {
  41. header("Location: statusclient3a_admin.php");
  42. die();
  43. }
  44. }
  45. if ($stmt1 = $con->prepare('INSERT INTO client_license (clients_id, client_license_nr, client_license_expiry, client_license_code, user_id) VALUES (?, ?, ?, ?, ?)')) {
  46. $stmt1->bind_param('sssss',$GET_last_ID, $_POST['client_license_nr'], $_POST['client_license_expiry'], $_POST['client_license_code'], $_SESSION['user_id']);
  47. $stmt1->execute();
  48. $stmt1->close();
  49. }
  50. if ($stmt2 = $con->prepare('INSERT INTO client_notes (clients_id, client_notes_data, user_id) VALUES (?, ?, ?)')) {
  51. $stmt2->bind_param('sss',$GET_last_ID, $created, $_SESSION['user_id']);
  52. $created = "Client added to database";
  53. $stmt2->execute();
  54. $stmt2->close();
  55. }
  56. } else {
  57. header("Location: statusclient4a_admin.php");
  58. die();
  59. }
  60. $con->close();
  61. ?>

暂无答案!

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

相关问题