How to catch mysql error in PHP?

Subash Chandran 9th November 2021 Leave a Comment

<?php
define("MYSQL_CONN_ERROR", "Unable to connect to database.");

// Ensure reporting is setup correctly
mysqli_report(MYSQLI_REPORT_STRICT);

// Connect function for database access
function connect($usr,$pw,$db,$host) {
   try {
      $mysqli = new mysqli($host,$usr,$pw,$db);
      $connected = true;
   } catch (mysqli_sql_exception $e) {
      throw $e;
   }
}

try {
  connect('username','password','database','host');
  echo 'Connected to database';
} catch (Exception $e) {
  echo $e->errorMessage();
}
?>

Related

See also Python code snippet - How to sort subset of rows in pandas df?

Snippets

catch error mysql php, catch error sql php, catch mysql err php, catch mysql error in php, catch sql error php, catch syntax error php, else mysql error php, error handling mysql php, exception handling php query mysql, get error in mysql php, get mysql error exception php, get mysql error in php, how to catch mysql error in php, how to echo mysql error in php, how to get mysql error in php, how to get mysql errors in php, how to handle mysql error in php, my SQL exception in php, mysql error exception php catch, mysql error handling in php, mysql php catch sql error, mysql php connection try catch, mysql php error handling, mysql php how to catch errors, php catch all mysql errors, php catch database error, php catch mysql errors, php catch mysql response, php catch sql error, php cath mysql error, php mysql connection try catch, php mysql error handling, php mysql exception, php mysql exception catch, php mysql query catch error, php mysql select with error catch, php mysql with error catch, show mysql exception php, sql error handling php, try catch mysql exception php

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.