$value) { $user_data = mysqli_real_escape_string($conn,$value); //print_r($user_data); $WH_DATA .= " `$field` = '$user_data' and "; } $WH_DATA = trim($WH_DATA," and "); $SQL_STRING = "SELECT $fetch_fields FROM $table WHERE $WH_DATA "; //echo $SQL_STRING; $result = mysqli_query($conn, $SQL_STRING); return mysqli_fetch_array($result,MYSQLI_ASSOC); } } function gSelect2($table,$where = NULL,$fetch_fields = "*") { $conn = self::init_db(); if($where) { $WH_DATA = ''; foreach($where as $field=>$value) { $user_data = mysqli_real_escape_string($conn,$value); //print_r($user_data); $WH_DATA .= " `$field` = '$user_data' and "; } $WH_DATA = trim($WH_DATA," and "); $SQL_STRING = "SELECT $fetch_fields FROM $table WHERE $WH_DATA "; //echo $SQL_STRING; $result = mysqli_query($conn, $SQL_STRING); return mysqli_fetch_array($result,MYSQLI_ASSOC); } } function gUpdate($table,$where = NULL,$data = NULL) { $conn = self::init_db(); if($where && $data) { // CREATE WHARE STRING $WH_DATA = ''; foreach($where as $field=>$value) { $user_data = mysqli_real_escape_string($conn,$value); $WH_DATA .= " `$field` = '$user_data' and "; } $WH_DATA = trim($WH_DATA," and "); // CREATE UPDATE STRING $UP_DATA = ''; foreach($data as $field=>$value) { $user_data = mysqli_real_escape_string($conn,$value); $UP_DATA .= " `$field` = '$user_data' , "; } $UP_DATA = trim($UP_DATA," , "); $SQL_STRING = "UPDATE $table SET $UP_DATA WHERE $WH_DATA "; mysqli_query($conn, $SQL_STRING); return mysqli_affected_rows($conn); } } function gDelete($table,$where = NULL) { $conn = self::init_db(); if($where) { $WH_DATA = ''; foreach($where as $field=>$value) { $user_data = mysqli_real_escape_string($conn,$value); $WH_DATA .= " `$field` = '$user_data' and "; } $WH_DATA = trim($WH_DATA," and "); $SQL_STRING = "DELETE FROM $table WHERE $WH_DATA"; $result = mysqli_query($conn, $SQL_STRING); return mysqli_fetch_array($result,MYSQLI_ASSOC); } } function gInsert($table,$data = NULL) { $conn = self::init_db(); if($data) { $FD_DATA = ''; $DD_DATA = ''; foreach($data as $field=>$value) { $user_data = mysqli_real_escape_string($conn,$value); $FD_DATA .= " `$field` , "; $DD_DATA .= " '$value' , "; } $FD_DATA = trim($FD_DATA," , "); $DD_DATA = trim($DD_DATA," , "); //INSERT INTO sg_purches_history (`userID` , `purTime` , `details` , `amount` , `type`) VALUES ('90853' , '1593705898' , ' Instant Payment [User: b ] [Amount: 25 ] ' , '25' , '9') $SQL_STRING = "INSERT INTO $table ($FD_DATA) VALUES ($DD_DATA)"; $mysqli = mysqli_query($conn, $SQL_STRING); return mysqli_insert_id($conn); } } function query($Q) { $conn = self::init_db(); mysqli_real_escape_string($conn,$Q); if($Q) { // echo $Q; $result = mysqli_query($conn, $Q); return mysqli_fetch_array($result,MYSQLI_ASSOC); } } function query1($Q) { $conn = self::init_db(); mysqli_real_escape_string($conn,$Q); if($Q) { //echo $Q; $result = mysqli_query($conn, $Q); $rows = array(); while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) { $rows[] = $row; } return $rows; } } function query_db($Q) { $conn = self::init_db(); mysqli_real_escape_string($conn,$Q); if($Q) { // echo $Q; $result = mysqli_query($conn, $Q); return mysqli_fetch_assoc($result); } } function query_update($Q) { $conn = self::init_db(); if($Q) { mysqli_query($conn, $Q); return mysqli_affected_rows($conn); } } function uservalid($username) { $conn = self::init_db(); if($table) { $Q="select * from sg_users where binary username like '$username'"; $result = mysqli_query($conn, $Q); while($row = $result->fetch_array()) {$rows[] = $row;} return $rows; } } function gSelectStar($table) { $conn = self::init_db(); if($table) { $Q='select * from '.$table; $result = mysqli_query($conn, $Q); //return $followingdata = mysqli_fetch_array($result,MYSQLI_BOTH); while($row = $result->fetch_array()) {$rows[] = $row;} return $rows; } } function gSelectWhere($table,$where = NULL) { $conn = self::init_db(); if($where) { $WH_DATA = ''; foreach($where as $field=>$value) { $user_data = mysqli_real_escape_string($conn,$value); $WH_DATA .= " `$field` = '$user_data' and "; } $WH_DATA = trim($WH_DATA," and "); $SQL_STRING = "SELECT * FROM $table WHERE $WH_DATA "; $result = mysqli_query($conn, $SQL_STRING); // return mysqli_fetch_array($result,MYSQLI_ASSOC); $rowcount=mysqli_num_rows($result); if($rowcount>0){ while($row = $result->fetch_assoc()) { $rows[] = $row;} return $rows; }else{ return 0;} } } function gSelectNumRows($table,$where = NULL) { $conn = self::init_db(); if($where) { $WH_DATA = ''; foreach($where as $field=>$value) { $user_data = mysqli_real_escape_string($conn,$value); $WH_DATA .= " `$field` = '$user_data' and "; } $WH_DATA = trim($WH_DATA," and "); $SQL_STRING = "SELECT * FROM $table WHERE $WH_DATA "; $result = mysqli_query($conn, $SQL_STRING); // return mysqli_fetch_array($result,MYSQLI_ASSOC); return $rowcount=mysqli_num_rows($result); } } function gSelectNumRowsAll($table) { $conn = self::init_db(); if($table) { $SQL_STRING = "SELECT * FROM $table"; $result = mysqli_query($conn, $SQL_STRING); // return mysqli_fetch_array($result,MYSQLI_ASSOC); return $rowcount=mysqli_num_rows($result); } } function queryResults($Q) { $conn = self::init_db(); mysqli_real_escape_string($conn,$Q); if($Q) { // echo $Q; exit; $result = mysqli_query($conn, $Q); $rowcount=mysqli_num_rows($result); if($rowcount>0){ while($row = $result->fetch_array()) {$rows[] = $row;} return $rows; }else{ return 0;} } } function query_n($Q) { $conn = self::init_db(); mysqli_real_escape_string($conn,$Q); if($Q) { // echo $Q; $result = mysqli_query($conn, $Q); return mysqli_fetch_array($result,MYSQLI_ASSOC); } } }
Fatal error: Uncaught Error: Class "db" not found in /home/infigwik/changethenarrative.foundation/inc/ginc.php:17 Stack trace: #0 /home/infigwik/changethenarrative.foundation/gallary.php(5): db_obj() #1 {main} thrown in /home/infigwik/changethenarrative.foundation/inc/ginc.php on line 17