PHP學習
// $conditions 保存查詢條件
$conditions = 'level_ix > 1';
// $tableOrders 是一個訂單數據表的表數據入口對象
$order = $tableOrders->find($conditions, 'created DESC', 'id, title, body');
$conditions = array('username' => 'dualface');
// $tableUsers 是一個用戶信息數據表的表數據入口對象
$user = $tableUsers->find($conditions);

PHP學習
// 查詢主鍵字段值為1的記錄
$user = $tableUsers->find(1);
// 如果主鍵字段名為"id",則生成的where字句為"WHERE `id` = 1"

PHP學習
$conditions = 'id < 3'
$user = $tableUsers->find($conditions);
//生成的where字句為"WHERE id < 3"

PHP學習
// 查詢id字段值為3的記錄
$conditions = array(
  'id' => '1',
 );
$user = $tableUsers->find($conditions);
//生成的where字句為"WHERE `id` = 1"

PHP學習
$conditions = array('id = 1');
// 生成的where字句為"WHERE `id` = 1"
$user = $tableUsers->find($conditions);

PHP學習
$conditions = array(
  'id < 3',
  'sex' => 'male',
);
$user = $tableUsers->find($conditions);
// 生成的where字句為"id < 3 AND `sex` = 'male'"

PHP學習
// 假如主鍵名為"id",需要查詢id的值為1、2、3其中之一,則可以這樣寫：
$condition = array(
  'in()' => array(1,2,3),
)
$user = $tableUsers->find($conditions);
// 生成的where子句為"WHERE `id` IN (1, 2, 3)"

PHP學習
$condition = array(
  'in()' => array(
          'username' => array('username1','username2')
         )
  )
$user = $tableUsers->find($conditions);
// 生成的where子句為"WHERE `username` IN ('username1', 'username2')"

PHP學習
$fields = array('title', 'created');
//也可以寫成下面的字符串形式,兩種寫法作用相同,區別在于自動生成的字段名兩邊將會添加上"`"符號,以防止出現字段名與SQL關鍵字沖突的情況出現.建議手寫時也加上"`"字符
$fields = 'title, created';
$user = $tableUsers->find('id < 10',NULL,$fields);