How to get useful error messages in mysql query in php? [duplicate]

by

In the else-block you can see, how you can catch up MySQL-errors and display them in an alert.

if(isset($_POST['btnSubmit'])) {
    $name = mysqli_real_escape_string($conn,$_POST["name"]);
    $sql = "INSERT INTO isodetail(title) VALUES ('{$name}')";
    $run = mysqli_query($conn, $sql);

    if($run) {
        echo "<script>alert('Certi Added Successfully');window.open('isocerti.php','_self');</script>";
    } else {
        $error = addslashes(mysqli_error($conn));
        echo "<script>alert('An Error occur: {$error}');</script>";
    }
}

References:
MySQLi-Error: http://php.net/manual/en/mysqli.error.php
Escape special characters: http://php.net/manual/en/function.addslashes.php (it does the job for this example)

More Related Contents:

  1. Reference — What does this symbol mean in PHP?
  2. Call php function from JavaScript
  3. Export to CSV via PHP
  4. How can I echo HTML in PHP?
  5. Nginx serves .php files as downloads, instead of executing them
  6. Global or Singleton for database connection?
  7. Checking if form has been submitted – PHP
  8. What’s the best way to get the last element of an array without deleting it?
  9. Listing all the folders subfolders and files in a directory using php
  10. PHPMailer GoDaddy Server SMTP Connection Refused
  11. Search for a key in an array, recursively
  12. Export MySQL data to Excel in PHP
  13. MySQL – ignore insert error: duplicate entry
  14. SF2 form : error Neither the property … nor one of the methods “get
  15. Looping Through All a Server’s Sessions in PHP
  16. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  17. Creating a config file in PHP
  18. Understanding nested PHP ternary operator [duplicate]
  19. PDO + MySQL and broken UTF-8 encoding
  20. How do I open a file from line X to line Y in PHP?
  21. permission denied – php unlink
  22. Show Curl POST Request Headers? Is there a way to do this?
  23. header(“Content-type: text/css”); is working in Firefox and Chrome, but in Internet Explorer 9 it shows up as ‘text/html’
  24. How do you convert an image to black and white in PHP
  25. Set character set using MySQLi
  26. Send FCM messages from server side to android device
  27. how to execute mysql command DELIMITER
  28. Skip Checkout in Magento for a downloadable product
  29. jQuery Mobile: Sending data from one page to the another
  30. Unit Test Laravel’s FormRequest

Leave a Comment