sql.php 794 B

1234567891011121314151617181920212223242526272829303132
  1. <?php
  2. if (! defined("CONFIG")) die("Not defined");
  3. if (! defined("SQL")) { die("Not defined"); }
  4. function new_connection ($db_host, $db_user, $db_password, $db_name)
  5. {
  6. mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
  7. $result = mysqli_connect($db_host,$db_user,$db_password,$db_name);
  8. if (! $result) {
  9. echo "Error connect to MYSQL " . PHP_EOL;
  10. echo "Errno: " . mysqli_connect_errno() . PHP_EOL;
  11. echo "Error message: " . mysqli_connect_error() . PHP_EOL;
  12. exit();
  13. }
  14. /* enable utf8 */
  15. if (!mysqli_set_charset($result,'utf8mb4')) {
  16. printf("Error loading utf8: %s\n", mysqli_error($result));
  17. exit();
  18. }
  19. //mysqli_options($result, MYSQLI_OPT_INT_AND_FLOAT_NATIVE, 1);
  20. return $result;
  21. }
  22. $db_link = new_connection(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  23. ?>