Advertisement
bidsalvaterra

SQL easy query

Jun 10th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 5.16 KB | None | 0 0
  1. <?php
  2. require_once('./config.php');
  3. /*==========================
  4. Execute Query Function
  5. =========================*/
  6.  
  7.  
  8. function sql_query($query_code) {
  9. $db_config_server = DB_HOST;
  10. $db_config_user = DB_USERNAME;
  11. $db_config_password = DB_PASSWORD;
  12. $db_config_db_name = DB_NAME;
  13.  
  14. $mysqli = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
  15.  
  16.  
  17. $result = $mysqli->query($query_code);
  18. //Return Query Result
  19. return $result;
  20. //Need to close conection
  21. $mysqli->close();
  22.     }
  23.    
  24.     /*=========================================
  25. Execute Query Function and Return Connection
  26. ================================================*/
  27.    
  28.     function sql_conn($query_code){
  29. $db_config_server = DB_HOST;
  30. $db_config_user = DB_USERNAME;
  31. $db_config_password = DB_PASSWORD;
  32. $db_config_db_name = DB_NAME;
  33. $mysqli = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
  34.  
  35. $mysqli->query($query_code);
  36. return $mysqli;
  37. //Need to close conection
  38. $mysqli->close();
  39.     }
  40.    
  41.    
  42. /*==========================
  43. Execute Query Function
  44. =========================*/
  45.  
  46.  
  47.    
  48.     function sql_sf_query($query_code,$parameters_num, $parameters_type=null , $parameter1=null,$parameter2=null,$parameter3=null,$parameter4=null,$parameter5=null,$parameter6=null,$parameter7=null,$parameter8=null,$parameter9=null){
  49.    
  50.         $db_config_server = DB_HOST;
  51. $db_config_user = DB_USERNAME;
  52. $db_config_password = DB_PASSWORD;
  53. $db_config_db_name = DB_NAME;
  54. $conn = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
  55.  
  56. // Check connection
  57. if ($conn->connect_error) {
  58.     die("Connection failed: " . $conn->connect_error);
  59. }
  60.  
  61. // prepare and bind
  62. $stmt = $conn->prepare($query_code);
  63. Switch($parameters_num){
  64.    
  65.     Case 1:
  66.     $stmt->bind_param($parameters_type,$parameter1);
  67.     break;
  68.         Case 2:
  69.     $stmt->bind_param($parameters_type,$parameter1,$parameter2);
  70.     break;
  71.         Case 3:
  72.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3);
  73.     break;
  74.         Case 4:
  75.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4);
  76.     break;
  77.         Case 5:
  78.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5);
  79.     break;
  80.     Case 6:
  81.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6);
  82.     break;
  83.         Case 7:
  84.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7);
  85.     break;
  86.         Case 8:
  87.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8);
  88.     break;
  89.         Case 9:
  90.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8,$parameter9);
  91.     break;
  92. }
  93.  
  94.  
  95. $stmt->execute();
  96. $result = $stmt->get_result();
  97. return $result;
  98.  
  99. $stmt->close();
  100. $conn->close();
  101.  
  102.     }
  103.    
  104.             /*=========================================
  105. Execute Safe Query Function and Return Connection
  106. ================================================*/
  107.  
  108.  
  109.    
  110.     function sql_conn_sf_query($query_code,$parameters_num, $parameters_type=null , $parameter1=null,$parameter2=null,$parameter3=null,$parameter4=null,$parameter5=null,$parameter6=null,$parameter7=null,$parameter8=null,$parameter9=null){
  111.    
  112.         $db_config_server = DB_HOST;
  113. $db_config_user = DB_USERNAME;
  114. $db_config_password = DB_PASSWORD;
  115. $db_config_db_name = DB_NAME;
  116. $conn = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
  117.  
  118. // Check connection
  119. if ($conn->connect_error) {
  120.     die("Connection failed: " . $conn->connect_error);
  121. }
  122.  
  123. // prepare and bind
  124. $stmt = $conn->prepare($query_code);
  125. Switch($parameters_num){
  126.    
  127.     Case 1:
  128.     $stmt->bind_param($parameters_type,$parameter1);
  129.     break;
  130.         Case 2:
  131.     $stmt->bind_param($parameters_type,$parameter1,$parameter2);
  132.     break;
  133.         Case 3:
  134.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3);
  135.     break;
  136.         Case 4:
  137.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4);
  138.     break;
  139.         Case 5:
  140.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5);
  141.     break;
  142.     Case 6:
  143.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6);
  144.     break;
  145.         Case 7:
  146.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7);
  147.     break;
  148.         Case 8:
  149.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8);
  150.     break;
  151.         Case 9:
  152.     $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8,$parameter9);
  153.     break;
  154. }
  155.  
  156.  
  157. $stmt->execute();
  158.  
  159. return $stmt;
  160.  
  161. $stmt->close();
  162. $conn->close();
  163.  
  164.     }
  165.    
  166.    
  167.     ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement