Note: $c = new CDbCriteria(); is a way of writing ActiveRecord, making ActiveRecord more flexible, instead of DAO (PDO) and Query Builder in the manual.
These are some notes and common usage of Yii CDbCriteria:
1. The case of a sql assembly
$criteria = new CDbCriteria; >
->addCondition("id=1"); //Query conditions, i.e. where id = 1
$criteria->addInCondition('id', array(1,2,3,4,5)); //Represents where id IN (1,23,,4,5,);
$criteria->addNotInCondition('id', array(1,2,3,4,5));//Exactly the same as the above, it is NOT IN
$criteria->addCondition('id=1',' OR');//This is the OR condition. When there are multiple conditions, the condition is OR instead of AND.
$criteria->addSearchCondition('name', 'category' );//Search conditions actually represent. . where name like '%category%'
$criteria->addBetweenCondition('id', 1, 4);//between 1 and 4
$criteria
->compare('id', 1); //This method is quite special, it will automatically process it into addCondition or addInCondition according to your parameters, // That is, if the second parameter is the array, the adDInCondition
$criteria
->addCondition("id = :id"); $criteria
->params[':id']=1;
//Attribute method
$criteria
->select = 'id,parentid,name'; //Represents the field to be queried, default select='*'; $criteria
->join = 'xxx'; //join Table $criteria
->with = 'xxx'; //Call relations $criteria
->limit = 10; //Get 1 piece of data, if less than 0, no processing will be done $criteria
->offset = 1; //When the two are combined, it means limit 10 offset 1, or represents . limit 1,10 $criteria
->order = 'xxx DESC,XXX ASC' ;//Sort conditions
$criteria->group = 'group criteria';
$criteria->having = 'having conditions ';
$criteria->distinct = FALSE; //Is it a unique query?
Example:
$criteria = new CDbCriteria();
$criteria->select = 'table_name,model_id,sum(amount) total';
$criteria->group = 'table_name,model_id';
$criteria->addCondition("$nIdcId=4");//Also $ criteria->condition = "$nIdcId=4";
$aResult = accessory_info::model()->findAll($criteria);
$c = new CDbCriteria();
$c->select = 't.id, t.created_at, t.outsource_id, t.user_id, t.operate, t.content' ;
$c->join = 'LEFT JOIN outsource ON outsource.id=t.outsource_id';
$c->condition = 'outsource.idc_id IN(' .implode(',' , $idc_ids) . ')';
if($last_log_id) {
> 🎜>} $c
->limit = 20;
$c->order =
't.id DESC';
$logs = OutsourceProcessLog::model()->findAll($c
);
Annotations: 1. The difference from the DAO method is that each element in the DAO method is still an array. With the CDbCriteria method, the elements in the array are objects. 2. Even if this function is very powerful, there are still some requirements that cannot be met. At this time, sql statements are still needed. For example, select avg(num) amount from ****. 2. The situation of mergeWith
//In ActiveRecord, add conditional restrictions
$this
->getDbCriteria()->mergeWith(array(
'condition'=>"idc_id IN ($ids)",
)); The original text is reproduced from Baidu Space "Yii CDbCriteria Common Methods"
http://www.bkjia.com/PHPjc/780018.html
www.bkjia.com
truehttp: //www.bkjia.com/PHPjc/780018.html
TechArticle
ThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin

You should care about DependencyInjection(DI) because it makes your code clearer and easier to maintain. 1) DI makes it more modular by decoupling classes, 2) improves the convenience of testing and code flexibility, 3) Use DI containers to manage complex dependencies, but pay attention to performance impact and circular dependencies, 4) The best practice is to rely on abstract interfaces to achieve loose coupling.

Yes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching

ThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

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

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Zend Studio 13.0.1
Powerful PHP integrated development environment

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
