Summary of operations related to adding, modifying, and deleting yii database_PHP tutorial

Summary of operations related to adding, modifying, and deleting data in yii database

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';
}

Articles you may be interested in

• The reasons why PHP adds backslashes before quotation marks and how to remove backslashes in PHP, three ways to close php magic quotes
• Mysql database cache cache function analysis, debugging and performance summary
• php mysql database operation class
• FckEditor adds right-click menu-picture deletion function
• Summary MySQL database server gradually slows down Reasons and solutions
• Mysql server master-slave database synchronization configuration
• php clears (delete) the files in the specified directory without deleting the directory folder
• php uses array_flip Implement array key-value exchange to remove array duplicate values

http://www.bkjia.com/PHPjc/980975.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/980975.htmlTechArticleYii database addition, modification, deletion related operations summary This article summarizes the addition of data and modification of data in yii. , the related operations of deleting data, I just learned it for a few days...