Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/old/lib/internal/Customweb/Database/ |
<?php
class Customweb_Database_Util {
private function __construct() {
}
public static function createPdo($inputHost, $inputDatabase, $inputUser, $inputPassword, $inputType = 'mysql') {
return new PDO($inputType . ':' . self::generateDns($inputHost, $inputDatabase), $inputUser, $inputPassword);
}
public static function generateDns($inputHost, $inputDatabase) {
$parameters = array();
if(stripos($inputHost, ':') !== false) {
list($host, $port) = explode(':', $inputHost);
if (empty($port)) {
$parameters['host'] = $host;
} elseif (preg_match('/^[0-9]+$/', $port)) {
$parameters['host'] = $host;
$parameters['port'] = $port;
} else {
$parameters['unix_socket'] = $port;
}
} else {
$parameters['host'] = $inputHost;
}
$parameters['dbname'] = $inputDatabase;
$assignments = array();
foreach ($parameters as $key => $value) {
$assignments[] = $key . '=' . $value;
}
return implode(';', $assignments);
}
/**
* Returns a where clause based on the given parameters.
*
* @param unknown $whereClause
* @return string
*/
public static function getWhereClause($whereClause) {
if (is_string($whereClause)) {
return ' WHERE ' . $whereClause;
}
else {
return ' WHERE ' . implode(' AND ', self::getDataPairs($whereClause));
}
}
public static function getDataPairs($data) {
$items = array();
foreach ($data as $key => $value) {
$prefix = substr($key, 0, 1);
if ($prefix == '>' || $prefix == ':' || $prefix == '!' || $prefix == '?') {
$fieldName = substr($key, 1);
$items[] = ' ' . $fieldName . ' = ' . $key . ' ';
}
else {
if (is_float($value)) {
$items[] = sprintf(' ' . $key . ' = %F ', $value);
} else {
$items[] = ' ' . $key . ' = ' . $value . ' ';
}
}
}
return $items;
}
}