[edit] Last updated: Fri, 17 May 2013

La classe mysqli_sql_exception

(PHP 5)

Introduction

La classe de gestion des exception de mysqli.

Synopsis de la classe

mysqli_sql_exception extends RuntimeException {

/* Propriétés */

protected $code ;

protected $sqlstate ;

}

Propriétés

message: Le message d'erreur.
fichier: Le fichier contenant l'erreur.
ligne: La ligne de l'erreur.
code: Le code causant l'erreur.
sqlstate: Le statut SQL associé à l'erreur.

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

down

dronebraindeveloper at gmail dot com ¶

4 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