4,251
社区成员
发帖
与我相关
我的任务
分享
<?php
include 'sql_build_query.php';
include 'pdo_query.php';
$db = new pdo_db;
$sql = $db->pdo_query('show databases ');
var_dump( $sql, $db->dbVersion() );
exit;
$sql = $db->select( 'i.kd k, io.id dk, iil.ii ds' )->from( 'test t' )
->leftjoin( 'post p', 't.id = ?', array( 2 ) )
->order( 'name DESC, id ASC' )
->where( array( 'xin = ? AND do > ?' => array( 1,3 )))
->having( array('xin' => 'dkls' ))
->group( 'id' )
->limit( 3,4 )
->queryAll();
exit;
//var_dump( $sql );
$sql = $db->from( 'test')
->insert( array( 'kd' => '233', 'dkwe' => 323 ));
$sql = $db->from( 'test' )
->where( array( '( dk = ? and kd > ?) or ( dk = ? and ddd = ?)' => array( 2,3,5,4 )))
->limit( 2 , 4 )
->update( array( 'dkddl' => 'd', 'kdls' => 'dkdl' ));
$sql = $db->from( 'test,test' )
->select( 'test,test' )
->where( array( 'id' => array( 3,3,4,2,3) ))
->limit( '3', 3)
->delete();
http://php.xlxz.org/2013/11/370/$database->select("account", "user_id", [
"GROUP" => "type",
// "ORDER" => "age DESC"
"ORDER" => "age",
// Must have to use it with ORDER together
"HAVING" => [
"user_id[>]" => 500
],
// LIMIT => 20
"LIMIT" => [20, 100]
]);
// SELECT user_id FROM account
// GROUP BY type
// ORDER BY age
// HAVING user_id > 500
// LIMIT 20,100