1. PDO method of executing native SQL
The code is as follows:
$sql = "";//原生態(tài)sql語句 xx::model()->dbConnection->createCommand($sql)->execute();
2. Active Record Method
(1) New method
The code is as follows:
$post=new Post; $post->title='sample post'; $post->content='post body content'; $post->save();
(Related tutorials recommended: yii framework)
(2) Criteria method
You can also use $condition to specify more complex query conditions. Instead of using a string, we can make $condition an instance of CDbCriteria, which allows us to specify conditions that are not limited to WHERE.
The code is as follows:
$criteria=new CDbCriteria; $criteria->select='title'; // 只選擇 'title' 列 $criteria->condition='postID=:postID'; $criteria->params=array(':postID'=>10); $post=Post::model()->find($criteria);
An alternative to CDbCriteria is to pass an array to the find method. The keys and values ??of the array respectively correspond to the attribute names and values ??of the criterion. The above example can be rewritten as follows:
$post=Post::model()->find(array(
'select'=>'title',
'condition'=>'postID=:postID',
'params'=>array(':postID'=>10),
));When a query condition is about matching several columns by a specified value, we can Use findByAttributes(). We make the $attributes parameter an array of values ??indexed by column names.
In some frameworks, this task can be achieved by calling a method like findByNameAndTitle. Although this approach seems tempting, it often causes confusion, conflicts, and issues such as case-sensitivity of column names.
3. Query Builder method
The code is as follows:
$user = Yii::app()->db->createCommand()
->select('id, username, profile')
->from('tbl_user u')
->join('tbl_profile p', 'u.id=p.user_id')
->where('id=:id', array(':id'=>$id))
->queryRow();If you want to learn more programming related content, please pay attention to php Chinese website Programming Tutorial column!
The above is the detailed content of Three ways to operate the database in yii. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
How to install MySQL 8.0 on Windows/Linux?
Jun 11, 2025 pm 03:25 PM
The key to installing MySQL 8.0 is to follow the steps and pay attention to common problems. It is recommended to use the MSI installation package on Windows. The steps include downloading the installation package, running the installer, selecting the installation type, setting the root password, enabling service startup, and paying attention to port conflicts or manually configuring the ZIP version; Linux (such as Ubuntu) is installed through apt, and the steps are to update the source, installing the server, running security scripts, checking service status, and modifying the root authentication method; no matter which platform, you should modify the default password, create ordinary users, set up firewalls, adjust configuration files to optimize character sets and other parameters to ensure security and normal use.
Yii Developer: Senior vs junior
May 24, 2025 am 12:10 AM
The main difference between senior Yii developers and junior Yii developers is experience, depth of skills and way of thinking. 1. Senior developers pay attention to performance optimization and code reconstruction, and use Yii's cache mechanism to improve application performance. 2. They deeply understand Yii's underlying principles, participate in architectural design and technical decision-making, and use modular design to build flexible applications. 3. Senior developers pay attention to overall project planning and long-term development and play the role of mentor. Junior developers need to gradually improve through learning and practice, and eventually grow into senior developers.
How to view all databases in MongoDB
Jun 04, 2025 pm 10:42 PM
The way to view all databases in MongoDB is to enter the command "showdbs". 1. This command only displays non-empty databases. 2. You can switch the database through the "use" command and insert data to make it display. 3. Pay attention to internal databases such as "local" and "config". 4. When using the driver, you need to use the "listDatabases()" method to obtain detailed information. 5. The "db.stats()" command can view detailed database statistics.
sql database statements summary of common statements for sql database
May 28, 2025 pm 08:12 PM
Common SQL statements include: 1. CREATETABLE creates tables, such as CREATETABLEemployees(idINTPRIMARYKEY, nameVARCHAR(100), salaryDECIMAL(10,2)); 2. CREATEINDEX creates indexes, such as CREATEINDEXidx_nameONemployees(name); 3. INSERTINTO inserts data, such as INSERTINTO employeees(id, name, salary)VALUES(1,'JohnDoe',75000.00); 4. SELECT check
When Should I Use Redis Instead of a Traditional Database?
May 13, 2025 pm 04:01 PM
UseRedisinsteadofatraditionaldatabasewhenyourapplicationrequiresspeedandreal-timedataprocessing,suchasforcaching,sessionmanagement,orreal-timeanalytics.Redisexcelsin:1)Caching,reducingloadonprimarydatabases;2)Sessionmanagement,simplifyingdatahandling
How do I create new records in the database using Eloquent?
Jun 14, 2025 am 12:34 AM
To create new records in the database using Eloquent, there are four main methods: 1. Use the create method to quickly create records by passing in the attribute array, such as User::create(['name'=>'JohnDoe','email'=>'john@example.com']); 2. Use the save method to manually instantiate the model and assign values ??to save one by one, which is suitable for scenarios where conditional assignment or extra logic is required; 3. Use firstOrCreate to find or create records based on search conditions to avoid duplicate data; 4. Use updateOrCreate to find records and update, if not, create them, which is suitable for processing imported data, etc., which may be repetitive.
Yii Developer vs Laravel: What are the differences?
May 17, 2025 am 12:01 AM
Yiiisbetterforhigh-performanceprojectswithasteeperlearningcurve,whileLaravelsuitsrapiddevelopmentwithalargeecosystem.1)ChooseYiiforperformanceandmodularity,idealforexperienceddevelopers.2)OptforLaravelforeaseofuseandextensivetools,suitableforquickerd
MongoDB in Action: Real-World Use Cases
May 11, 2025 am 12:18 AM
MongoDB uses in actual projects include: 1) document storage, 2) complex aggregation operations, 3) performance optimization and best practices. Specifically, MongoDB's document model supports flexible data structures suitable for processing user-generated content; the aggregation framework can be used to analyze user behavior; performance optimization can be achieved through index optimization, sharding and caching, and best practices include document design, data migration and monitoring and maintenance.
