class DB
{
function init_db()
{
include ( __DIR__ . "/../inc/config.php");
$dbhost = $DB_HOST;
$dbuser = $DB_USERNAME;
$dbpass = $DB_PASSWORD;
$database = $DB;
$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $database);
return $conn;
}
function gSelect($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 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