database.php 892 B

12345678910111213141516171819202122232425262728293031
  1. <?php
  2. require_once(realpath(dirname(__FILE__)).'/config.php');
  3. $mysqli = new mysqli(get('host'),get('user'),get('password'),get('database'));
  4. if($mysqli && $mysqli->connect_errno){
  5. die("Failed to connect to MySQL: ".$mysqli->connect_error);
  6. }
  7. if(!$mysqli->autocommit(true)){
  8. die("Failed to connect to MySQL: ".$mysqli->connect_error);
  9. }
  10. function query($query,$args=Array()){
  11. global $mysqli;
  12. for ($i=0;$i<count($args);$i++){
  13. if(is_string($args[$i])){
  14. $args[$i] = $mysqli->real_escape_string($args[$i]);
  15. }elseif(!is_numeric($args[$i])){
  16. return false;
  17. }
  18. }
  19. return $mysqli->query(vsprintf($query,$args));
  20. }
  21. function fetch_all($result,$type=MYSQLI_NUM){
  22. if(method_exists('mysqli_result', 'fetch_all')){
  23. $res = $result->fetch_all($type);
  24. }else{
  25. for($res = array(); $tmp = $result->fetch_array($type);){
  26. $res[] = $tmp;
  27. }
  28. }
  29. return $res;
  30. }
  31. ?>