[edit] Last updated: Fri, 28 Jun 2013

The mysqli_sql_exception class

(PHP 5)

Introduction

The mysqli exception handling class.

Class synopsis

mysqli_sql_exception extends RuntimeException {

/* Properties */

protected string $sqlstate ;

/* Inherited properties */

protected string $message ;

protected int $code ;

protected string $file ;

protected int $line ;

}

Properties

sqlstate: The sql state with the error.

add a note User Contributed Notes mysqli_sql_exception - [1 notes]

down

dronebraindeveloper at gmail dot com ¶

6 months ago


Quick note on how to setup and use mysqli_sql_exceptions properly





<?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();


}


?>

add a note