Advertisement
Guest User

MySQL Exception Throw

a guest
Dec 19th, 2014
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.67 KB | None | 0 0
  1. mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
  2. $link = mysqli_connect('localhost', 'db_user', 'db_password', 'db_name');
  3.  
  4. if (!$link) {
  5.     printf("Невозможно подключиться к базе данных. Код ошибки: %s\n", mysqli_connect_error());
  6.     exit;
  7. }
  8.  
  9. $id   = rand(1, 5);
  10. $name = "Maxim";
  11.  
  12. function insert($link, $id, $name)
  13. {
  14.     $sql = "INSERT INTO users (id, name) VALUES ('$id', '$name')";
  15.     if (!$result = mysqli_query($link, $sql)) {
  16.         throw new Exception();
  17.     }
  18.     return true;
  19. }
  20.  
  21. try {
  22.     insert($link, $id, $name);
  23. } catch (Exception $e) {
  24.     echo $e->getCode();
  25.     echo $e->getMessage();
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement