1. ?? ?? ??

???? ?? ??? ????? table() ??? ?? ??? ???? ??? ? ???, find() ??? ??? ???? ??? ??? ???? ?? ?????. MySQL SELECT * FROM table_name WHERE ??_?? = '?' LIMIT 1.

?? ??:

$data = Db::table('user')->where('id', 1)->value('username');
echo $data; // 輸出結果：'張三'

? ????? table() ??? ???? ???? ??? ???? ??? ?? where() ??? ???? ?? ??? ?????. id 1? ???? value() ??? ???? ??? ?? ??? ?? ?????.

2. ?? ??? ??

???? ?? ???? ????? find() ?? select() ???? ??? ? ????. ? ? find() ??? ??? ?? ? ?? ???? ????? ????, select() ??? ??? ?? ?? ???? ????? ???.

?? ??:

$data = Db::table('user')->where('username', '張三')->find();
print_r($data); // 輸出結果：['id' => 1, 'username' => '張三', 'age' => 25]

? ????? ?? table() ??? ???? ???? ??? ???? ??? ?? where() ??? ???? ?? ??? ???? ??? ??? ??? ?? ???? ?????. 'Zhang San', ????? find() ??? ???? ?? ??? ?????.

3. ?? ?? ??

???? ?? ??? ????? field() ??? ???? ??? ??? ??? ? ????.

?? ??:

$data = Db::table('user')->where('id', 1)->field('username, age')->find();
print_r($data); // 輸出結果：['username' => '張三', 'age' => 25]

? ????? field() ??? ???? ??? ??? ??? ??? ??? ???? ID? 1? ???? ??? ?? ????? find() ??? ???? ?? ??.

4. ?? ??? ??

????? ?? ??? ?? ?? ???? ????? select() ??? ?????. find() ???? ???? select() ??? ?? ?? ??? ??? 2?? ??? ????? ????.

?? ??:

$data = Db::table('user')->where('age', '>', 20)->select();
print_r($data); // 輸出結果：[['id' => 1, 'username' => '張三', 'age' => 25], ['id' => 2, 'username' => '李四', 'age' => 28]]

? ????? table() ??? ???? ???? ??? ???? ??? ?? where() ??? ???? ?? ??? ????, age? ???? ? ???? ?????. 20, select() ??? ???? ?? ???? ?????.

5. ?? ??

?? ??? ????? order() ??? ??? ? ????. ??? ????? ????? ?? asc, ????? ?? desc? ? ????.

?? ??:

$data = Db::table('user')->where('age', '>', 20)->order('age desc')->select();
print_r($data); // 輸出結果：[['id' => 2, 'username' => '李四', 'age' => 28], ['id' => 1, 'username' => '張三', 'age' => 25]]

? ????? where() ??? ???? ?? ??? ????, 20? ??? ???? ????, order() ??? ???? ??? ?????? ?????. age? ???? ????? select() ??? ???? ?? ???? ?????.

6. ??? ??

?? ??? ???? ?? ???? Limit() ??? ???? ??? ??? ??? ? ????. ??? ? ?? ????? ???? ?? ??? ???? ? ?? ????? ??? ?????. ??? ??? ????.

?? ??:

$data = Db::table('user')->where('age', '>', 20)->order('age desc')->limit(0, 1)->select();
print_r($data); // 輸出結果：[['id' => 2, 'username' => '李四', 'age' => 28]]

? ????? where() ??? ???? ?? ??? ????, 20? ??? ???? ????, order() ??? ???? ??? ?????? ?????. age? ??? ?? Limit() ??? ???? ???? ?????.

? ??? ThinkPHP?? ??? ???? ???? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!