X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fdbm.php;h=bda62f34c2c1d6539bb2c757c7344deec16bfa87;hb=390e34d587ef5bd09759ce63e7e64518398b2018;hp=62ebb1af082526b8d12ea6eb4154688ffbedba86;hpb=2c71d307c8a4dfc22dce295a84ff92e9dae7c5ad;p=friendica.git diff --git a/include/dbm.php b/include/dbm.php index 62ebb1af08..bda62f34c2 100644 --- a/include/dbm.php +++ b/include/dbm.php @@ -2,6 +2,7 @@ /** * @brief This class contain functions for the database management * + * This class contains functions that doesn't need to know if pdo, mysqli or whatever is used. */ class dbm { /** @@ -47,6 +48,11 @@ class dbm { if (is_bool($array)) { return $array; } + + if (is_object($array)) { + return true; + } + return (is_array($array) && count($array) > 0); } @@ -70,7 +76,7 @@ class dbm { if (is_bool($value)) { $value = ($value ? 'true' : 'false'); - } elseif (is_float($value) OR is_integer($value)) { + } elseif (is_float($value) || is_integer($value)) { $value = (string)$value; } else { $value = "'".dbesc($value)."'"; @@ -86,5 +92,21 @@ class dbm { public static function esc_array(&$arr, $add_quotation = false) { array_walk($arr, 'self::esc_array_callback', $add_quotation); } + + /** + * Checks Converts any date string into a SQL compatible date string + * + * @param string $date a date string in any format + * @return string SQL style date string + */ + public static function date($date = 'now') { + $timestamp = strtotime($date); + + // Don't allow lower date strings as '0001-01-01 00:00:00' + if ($timestamp < -62135596800) { + $timestamp = -62135596800; + } + + return date('Y-m-d H:i:s', $timestamp); + } } -?>