Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('./config.php');
- /*==========================
- Execute Query Function
- =========================*/
- function sql_query($query_code) {
- $db_config_server = DB_HOST;
- $db_config_user = DB_USERNAME;
- $db_config_password = DB_PASSWORD;
- $db_config_db_name = DB_NAME;
- $mysqli = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
- $result = $mysqli->query($query_code);
- //Return Query Result
- return $result;
- //Need to close conection
- $mysqli->close();
- }
- /*=========================================
- Execute Query Function and Return Connection
- ================================================*/
- function sql_conn($query_code){
- $db_config_server = DB_HOST;
- $db_config_user = DB_USERNAME;
- $db_config_password = DB_PASSWORD;
- $db_config_db_name = DB_NAME;
- $mysqli = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
- $mysqli->query($query_code);
- return $mysqli;
- //Need to close conection
- $mysqli->close();
- }
- /*==========================
- Execute Query Function
- =========================*/
- 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){
- $db_config_server = DB_HOST;
- $db_config_user = DB_USERNAME;
- $db_config_password = DB_PASSWORD;
- $db_config_db_name = DB_NAME;
- $conn = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- // prepare and bind
- $stmt = $conn->prepare($query_code);
- Switch($parameters_num){
- Case 1:
- $stmt->bind_param($parameters_type,$parameter1);
- break;
- Case 2:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2);
- break;
- Case 3:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3);
- break;
- Case 4:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4);
- break;
- Case 5:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5);
- break;
- Case 6:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6);
- break;
- Case 7:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7);
- break;
- Case 8:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8);
- break;
- Case 9:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8,$parameter9);
- break;
- }
- $stmt->execute();
- $result = $stmt->get_result();
- return $result;
- $stmt->close();
- $conn->close();
- }
- /*=========================================
- Execute Safe Query Function and Return Connection
- ================================================*/
- 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){
- $db_config_server = DB_HOST;
- $db_config_user = DB_USERNAME;
- $db_config_password = DB_PASSWORD;
- $db_config_db_name = DB_NAME;
- $conn = new mysqli($db_config_server, $db_config_user, $db_config_password, $db_config_db_name);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- // prepare and bind
- $stmt = $conn->prepare($query_code);
- Switch($parameters_num){
- Case 1:
- $stmt->bind_param($parameters_type,$parameter1);
- break;
- Case 2:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2);
- break;
- Case 3:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3);
- break;
- Case 4:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4);
- break;
- Case 5:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5);
- break;
- Case 6:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6);
- break;
- Case 7:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7);
- break;
- Case 8:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8);
- break;
- Case 9:
- $stmt->bind_param($parameters_type,$parameter1,$parameter2,$parameter3,$parameter4,$parameter5,$parameter6,$parameter7,$parameter8,$parameter9);
- break;
- }
- $stmt->execute();
- return $stmt;
- $stmt->close();
- $conn->close();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement