��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/ezcomponents/Database/src/sqlabstraction/implementations/expression_sqlite.php

��ѧ٧ѧ�
<?php /** * File containing the ezcQueryExpressionSqlite class. * * @package Database * @version 1.4.7 * @copyright Copyright (C) 2005-2010 eZ Systems AS. All rights reserved. * @license http://ez.no/licenses/new_bsd New BSD License / /* * The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite. * * This class reimplements the methods that have a different syntax in * SQLite (substr) and contains PHP implementations of functions that are * registered with SQLite with it's PDO::sqliteRegisterFunction() method. * * @package Database * @version 1.4.7 / class ezcQueryExpressionSqlite extends ezcQueryExpression { /* * Contains an interval map from generic intervals to SQLite native intervals. * * @var array(string=>string) / protected $intervalMap = array( 'SECOND' => 'seconds', 'MINUTE' => 'minutes', 'HOUR' => 'hours', 'DAY' => 'days', 'MONTH' => 'months', 'YEAR' => 'years', ); /* * Returns part of a string. * * Note: Not SQL92, but common functionality. SQLite only supports the 3 * parameter variant of this function, so we are using 2^30-1 as * artificial length in that case. * * @param string $value the target $value the string or the string column. * @param int $from extract from this characeter. * @param int $len extract this amount of characters. * @return string sql that extracts part of a string. / public function subString( $value, $from, $len = null ) { $value = $this->getIdentifier( $value ); if ( $len === null ) { $len = $this->getIdentifier( $len ); return "substr( {$value}, {$from}, 1073741823 )"; } else { return "substr( {$value}, {$from}, {$len} )"; } } /* * Returns the current system date and time in the database internal * format. * * @return string / public function now() { return '"' . date( 'Y-m-d H:i:s' ) . '"'; } /* * Returns the SQL that performs the bitwise XOR on two values. * * @param string $value1 * @param string $value2 * @return string / public function bitXor( $value1, $value2 ) { $value1 = $this->getIdentifier( $value1 ); $value2 = $this->getIdentifier( $value2 ); return "( ( {$value1} \| {$value2} ) - ( {$value1} & {$value2} ) )"; } /* * Returns the SQL that converts a timestamp value to a unix timestamp. * * @param string $column * @return string / public function unixTimestamp( $column ) { if ( $column == 'NOW()' ) { return " strftime( '%s', 'now' ) "; } else { $column = $this->getIdentifier( $column ); return " toUnixTimestamp( {$column} ) "; } } /* * Returns the SQL that subtracts an interval from a timestamp value. * * @param string $column * @param numeric $expr * @param string $type one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR * @return string / public function dateSub( $column, $expr, $type ) { $type = $this->intervalMap[$type]; $column = $this->getIdentifier( $column ); return " datetime( {$column} , '-{$expr} {$type}' ) "; } /* * Returns the SQL that adds an interval to a timestamp value. * * @param string $column * @param numeric $expr * @param string $type one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR * @return string / public function dateAdd( $column, $expr, $type ) { $type = $this->intervalMap[$type]; $column = $this->getIdentifier( $column ); return " datetime( {$column} , '+{$expr} {$type}' ) "; } /* * Returns the SQL that extracts parts from a timestamp value. * * @param string $column * @param string $type one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR * @return string */ public function dateExtract( $column, $type ) { switch ( $type ) { case 'SECOND': $type = '%S'; break; case 'MINUTE': $type = '%M'; break; case 'HOUR': $type = '%H'; break; case 'DAY': $type = '%d'; break; case 'MONTH': $type = '%m'; break; case 'YEAR': $type = '%Y'; break; } if ( $column == 'NOW()' ) { $column = "'now'"; } $column = $this->getIdentifier( $column ); return " strftime( '{$type}', {$column} ) "; } } ?>

| ver. 1.4 | Github | . | PHP 8.2.30 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0 | proxy | phpinfo | ��ѧ��ۧܧ�