Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory : /home/u107206879/domains/escort46.de/public_html/en/ |
<?php
function query($query)
{
//echo $query;
global $connection;
return mysqli_query($connection, $query);
}
function getAll($query)
{
$result = query($query);
return getArray($result);
}
function update($table = null, $data, $where = '1')
{
global $connection;
if ($table === null or empty($data) or !is_array($data)) {
return "Invalid array for table: <b>" . $table . "</b>.";
return false;
}
$q = "UPDATE `" . $table . "` SET ";
foreach ($data as $key => $val) {
//$val = escape($val); // filter input value
$q .= "`$key`='" . $val . "', ";
}
$q = rtrim($q, ', ') . ' WHERE ' . $where . ';';
//print_r($q);die;
$res = query($q); // Run mysqli query
if (!$res)
return mysqli_error($connection);
return mysqli_affected_rows($connection);
}
function delete($table, $where = '')
{
global $connection;
$query = !$where ? 'DELETE FROM ' . $table : 'DELETE FROM ' . $table . ' WHERE ' . $where;
return query($query); // Run mysqli query
}
function insertMulti($table, $column = array(), $valueArray = array())
{
foreach( $valueArray as $row )
{
$sql[] = '("'.$row['adservices_id'].'", "'.$row['search_id'].'")';
}
$queryInsTag = 'INSERT INTO '.$table.' ('.implode(', ',$column).') VALUES '.implode(',', $sql);
return query($queryInsTag);
//return $queryInsTag;
}
function real_escape_str($string)
{
global $connection;
return mysqli_real_escape_string($connection, $string);
}
function insert($table = null, $data)
{
global $connection;
$query = "INSERT INTO `" . $table . "` ";
$v = '';
$k = '';
foreach ($data as $key => $val) {
//$val = escape($val); // filter input value
$k .= "`$key`, ";
$v .= "'" . $val . "', ";
}
$query .= "(" . rtrim($k, ', ') . ") VALUES (" . rtrim($v, ', ') . ");";
//print_r($res);die;
$res = query($query); // Run mysqli query
if (!$res)
echo mysqli_error($connection);
return mysqli_insert_id($connection);
}
function getArray($resultQuery = '')
{
$returnData = array();
if($resultQuery)
{
//$returnData = mysqli_fetch_all($resultQuery, MYSQLI_ASSOC);
while ($row = $resultQuery->fetch_assoc()) {
// do what you need.
$returnData[] = $row;
}
}
return $returnData;
}
function countdata($result)
{
if(mysqli_num_rows($result) > 0)
{
return 1;
}
else
{
return 0;
}
}
function pre($array = array())
{
echo "<pre>";
print_r($array);
echo "</pre>";
}
function repss($key, $value, $content)
{
return str_replace($key, $value, $content);
}
function stxt($a){
$a = str_replace('"', '\"', $a);
// $a = stripslashes($a);
return str_replace("'", "stripslashes_single", $a);
}
function rtxt($a){
$a = str_replace('"', '\"', $a);
// $a = stripslashes($a);
return str_replace("stripslashes_single", "'", $a);
}
?>