Files
Testing/include/class_he_database.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

227 lines
5.6 KiB
PHP

<?php
/**
* Database layer for SocialEngine
* @author Hire-Experts
* @version 1.1
*/
if( !class_exists('he_database') ) {
class he_database
{
public static function query($query)
{
global $database;
return $database->database_query($query);
}
function num_rows($resource)
{
global $database;
return $database->database_num_rows($resource);
}
public static function fetch_array($query, $field_as_index = null)
{
global $database;
$rows = array();
$res = he_database::query($query);
if ( $field_as_index === null )
{
while($row = $database->database_fetch_assoc($res))
$rows[] = $row;
}
else
{
while($row = $database->database_fetch_assoc($res))
$rows[$row[$field_as_index]] = $row;
}
return $rows;
}
function fetch_column($query, $first_field_is_index = false)
{
global $database;
$rows = array();
$res = he_database::query($query);
if ( $first_field_is_index )
{
while($row = $database->database_fetch_array($res))
$rows[$row[0]] = $row[1];
}
else
{
while($row = $database->database_fetch_array($res))
$rows[] = $row[0];
}
return $rows;
}
function fetch_row($query)
{
global $database;
return $database->database_fetch_assoc(he_database::query($query));
}
function fetch_row_from_resource($resource)
{
global $database;
return $database->database_fetch_assoc($resource);
}
function fetch_field($query)
{
global $database;
$row = $database->database_fetch_array(he_database::query($query));
return $row ? $row[0] : null;
}
function real_escape($unescaped_string)
{
global $database;
return $database->database_real_escape_string($unescaped_string);
}
function insert_id()
{
global $database;
return $database->database_insert_id();
}
function affected_rows()
{
global $database;
return $database->database_affected_rows();
}
function compile_placeholder($query_tpl)
{
$compiled = array();
$i = 0; // placeholders counter
$p = 0; // current position
$prev_p = 0; // previous position
while ( false !== ($p = strpos($query_tpl, '?', $p)) )
{
$compiled[] = substr($query_tpl, $prev_p, $p-$prev_p);
$type_char = $char = $query_tpl[$p-1];
switch ( $type_char ) {
case '"': case "'": case '`':
$type = $type_char; // string
break;
default:
$type = ''; // integer
break;
}
$next_char = isset($query_tpl[$p+1]) ? $query_tpl[$p+1] : null;
if ( $next_char === '@' ) { // array list
$compiled[] = array($i++, $type, '@');
$prev_p = ($p=$p+2);
}
else {
$compiled[] = array($i++, $type);
$prev_p = ++$p;
}
}
$tail_length = (strlen($query_tpl) - $prev_p);
if ( $tail_length ) {
$compiled[] = substr($query_tpl, -$tail_length);
}
return $compiled;
}
function placeholder()
{
$arguments = func_get_args();
$c_query = array_shift($arguments);
if ( !is_array($c_query) ) {
$c_query = (new he_database())->compile_placeholder($c_query);
}
$query = '';
foreach ( $c_query as $piece )
{
if ( !is_array($piece) ) {
$query .= $piece;
continue;
}
list( $index, $type ) = $piece;
if ( isset($piece[2]) ) // array value
{
$array = $arguments[$index];
switch ( $type ) {
case '"': case "'": case '`':
$query .= implode("$type,$type", array_map(array(__CLASS__, 'real_escape'), $array));
break;
default:
$query .= implode(",", array_map('intval', $array));
break;
}
}
else // scalar value
{
$var = $arguments[$index];
switch ( $type ) {
case '"': case "'": case '`':
$query .= he_database::real_escape($var);
break;
default:
$query .= (int)$var;
break;
}
}
}
return $query;
}
function query_paging_part( $start=0, $limit=0, $sort="", $where="", $group="" )
{
$sql = "";
if ($where != "")
{
$sql .= " WHERE $where";
}
if ($sort != "")
{
$sql .= " ORDER BY $sort";
}
if ($group != "")
{
$sql .= " GROUP BY $group";
}
if ($start != 0 && $limit !=0)
{
$sql .= " LIMIT $start, $limit";
}
elseif ($limit != 0)
{
$sql .= " LIMIT $limit";
}
return $sql;
}
}
}
?>