欧美日韩不卡合集视频_精品丝袜国产自在线拍AV_四虎永久在线精品884AA_久久国产偷任你爽任你_日韩精品无码人妻免费视频

我們在對最土程序進(jìn)行二次開發(fā)的過程中。我們常常需要對數(shù)據(jù)庫進(jìn)行操作．最土程序的數(shù)據(jù)庫操作方式還不少。我們將陸續(xù)總結(jié)最土程序的一些常見的數(shù)據(jù)庫操作方式．

1:如何取得最土數(shù)據(jù)庫中一條數(shù)據(jù)。使用LimitQuery()

$res = DB::LimitQuery('subscribe',array('condition'=>array('email'=>$email),'one'=>true));

2:最土程序如何進(jìn)行數(shù)據(jù)庫插入數(shù)據(jù)

$table = new Table('subscribe', array(
'email' => $email,
'city_id' => $city_id,
'secret' => $secret,
));

return $table->insert(array('email', 'city_id', 'secret'));

3:檢索一行內(nèi)容
$field = strpos($email,?'@') ? 'email' : 'username';
$zuituuser = DB::GetTableRow('user', array(
$field => $email,
'password' => $password,
));

4:通過某個值檢索一行數(shù)據(jù)
return Table::Fetch('user', $email, 'email');
5:修改數(shù)據(jù)庫字段某個值

$table = new Table('user', $newuser);
$table->SetPk('id', $user_id);
if ($table->password) {
$plainpass = $table->password;
$table->password = self::GenPassword($table->password);
}
return $table->Update( array_keys($newuser) );

6:如何統(tǒng)計數(shù)據(jù)庫中某些數(shù)據(jù)的條數(shù)

$now_count = Table::Count('order', array(
'user_id' => $login_user_id,
'team_id' => $id,
'state' => 'pay',
), 'quantity');

7:如何修改數(shù)據(jù)庫中某個字段的值

Table::UpdateCache('order',$table->id,array('order_sn'=>get_order_sn()));

8:最土中如何檢索某個字段的值

$cond = array('zone'=>'city');
$info = DB::LimitQuery('category', array(
'condition' => $cond,
'order' => 'ORDER BY id DESC',

));
$citys = Utility::GetColumn($info, 'name');

9:最土如何刪除一條數(shù)據(jù)

Table::Delete('article', $id);