Home > Article > Backend Development > Summary of operations related to adding, modifying, and deleting yii database_PHP tutorial
This article summarizes the related operations of adding data, modifying data, and deleting data in yii. I have just learned a lot. Today, I only recorded a few, and will gradually flesh them out later. Friends in need can take a look.
How to add data
(1) save method (object form operation)
$user=new User;
$user->username='phpernote';
$user->password='123456';
if($user->save()>0){
echo 'Added successfully';
}else{
echo 'Add failed';
}
(2) insert method (array form operation)
Yii::app()->dbName->createCommand()->insert('tbl_user',
array(
'username'=>'phpernote',
'password'=>'123456'
)
);
(3) insert method (object form operation)
$user=new User();
$user->username='phpernote';
$user->password='123456';
if($user->insert()){
echo 'Added successfully';
}else{
echo 'Add failed';
}
How to modify data
(1)Post::model()->updateAll($attributes,$condition,$params);
$count=User::model()->updateAll(array('username'=>'phpernote','password'=>'123456'),'id=:id',array(':id' =>$id));
if($count>0){
echo 'Modification successful';
}else{
echo 'Modification failed';
}
(2) Post::model()->updateByPk($pk,$attributes,$condition,$params);
$count=User::model()->updateByPk(1,array('username'=>'admin','password'=>'123456'));
or
$count=User::model()->updateByPk(array(1,2),array('username'=>'admin','password'=>'123456'),'username= :name',array(':name'=>'admin'));
if($count>0){
echo 'Modification successful';
}else{
echo 'Modification failed';
}
$pk represents the primary key, which can be one or a set. $attributes represents the set of fields to be modified. $condition represents the condition. The value passed in by $params
(3) Post::model()->updateCounters($counters,$condition,$params);
$count =User::model()->updateCounters(array('status'=>1),'username=:name',array(':name'=>'admin'));
if($count>0){
echo 'Modification successful';
}else{
echo 'Modification failed';
}
array('status'=>1) represents the admin table in the database. According to the condition username='admin', the status field of all query results will automatically add 1
User::model()->updateCounters(array('count'=>1), 'id='.User::model()->id);//Automatically superimpose 1
User::model()->updateCounters(array('count'=>-1), 'id='.User::model()->id);//Automatically decrement by 1
(4) Yii::app()->dbName->createCommand()->update($attributes,$condition,$params);
Yii::app()->dbName->createCommand()->update('tbl_user',
array(
'username'=>'phpernote'
),
'id=:id',
array(
‘:id’=>3
)
);
How to delete data
(1) Post::model()->deleteAll($condition,$params);
For example:
$count=User::model()->deleteAll('username=:name AND password=:pass',array(':name'=>'phpernote',':pass'=>'123456') );
or:
$count=User::model()->deleteAll('id in("1,2,3")'); //Delete data with these ids
if($count>0){
echo 'Delete successfully';
}else{
echo 'Deletion failed';
}
(2) Post::model()->deleteByPk($pk,$condition,$params);
For example:
$count=User::model()->deleteByPk(1);
or:
$count=User::model()->deleteByPk(array(1,2),'username=:name',array(':name'=>'admin'));
if($count>0){
echo 'Delete successfully';
}else{
echo 'Deletion failed';
}