Skip to main content

Select query in cakephp 3.x

Select query with multiple where conditions in cakephp 3.x




First include these classes into your controller to use objects of these classes
use Cake\ORM\Query;
use Cake\ORM\Table;
use App\Model\Entity\Role;
use Cake\ORM\TableRegistry;

Simple Select query in cakephp 3.x

 $tableRegObj = TableRegistry::get('OurTableName');  //database Table name = our_table_name
 $getAllResults = $tableRegObj->find('all');

 $getAllResults will return results object . if you want to count records then you can use count function of this
 example =>

 echo $getAllResults->count();

 If you want fetch data as an array then you can use toArray();
 example =>

 $getAllResults = $tableRegObj->find('all')->toArray();

 If you want to fetch only first row of result data then you can use first()
 example=>

 $getFirstRow = $getAllResults->first();

 2.Fetch Data with conditions

      In cakephp 3.x you can use multiple conditions with fetch data from database .

  example=>  Query with conditions
   $tableRegObj = TableRegistry::get('OurTableName');
   $getAllResults = $tableRegObj
    ->find()
    ->select(['field1','field2','field3','total'=>'SUM(field)'])
    ->where(['category' => 'buy','status'=>'pending'])
    ->group(['getAllResults.price'])
    ->order(['price' => 'DESC'])->toArray();  


 3. Fetch Data by column  name in cakephp 3.x

         You can also get results by passing your field with query for example if you want to fetch results fron db where username="abc" and email="abc@gmail.com" then your query will be :-
     
    $tableRegObj = TableRegistry::get('Users');
    $getuserdetails = $tableRegObj->findAllByUsernameAndEmail("abc", "abc@gmail.com"); //return object
    $getCurquerySingle = $getuserdetails->first();   //this will select first record of object

     first() function will return first row from object that is return by query.


  
   so these are the all queries to get data from database in cakephp 3.x with conditions .

4. Cakephp select only single column from table query


$yourresult = $tableRegObj->find()->select(['quantity'])->where(['category' => 'sell'])->order(['price' => 'ASC']);

   Related Posts-


   How to get data from database in Cakephp 3.x

    Cakephp 3.x Select Query

   Cakephp 3.x Get data with multiple conditions  

  Get First Data in cakephp 3.x

Comments

Popular posts from this blog

Run and compile sass scss file to css using node

  Today we learn how to use scss and generate css using node  or Run and compile sass scss file to css using node   So please follow simple  steps :-   Today we will create a project that can read scss file and generates css with it  Note: Make sure you have installed node in your system. If you want to help to install node js based on your system then check our other tutorial or check node js official website. Now create a blank folder and open  terminal(linux) or cmd(windows) and navigate to your current project folder by using cd command Now run below command npm init after enter it will ask you some package info that you can fill according to you or just keep enter until it finished. The above command will generate package.json file Now  we will install npm module that will convert our scss to css Run below command: npm install node-sass So we have installed node-sass package . Now open package.json file in your...

How to retrieve Facebook Likes, share , comment Counts

function facebook_count($url){     // Query in FQL     $fql  = "SELECT share_count, like_count, comment_count ";     $fql .= " FROM link_stat WHERE url = '$url'";     $fqlURL = "https://api.facebook.com/method/fql.query?format=json&query=" . urlencode($fql);     // Facebook Response is in JSON     $response = file_get_contents($fqlURL);     return json_decode($response); } $fb = facebook_count('https://www.facebook.com/BahutHoGyiPadhai'); // facebook share count echo $fb[0]->share_count;  echo "like"; // facebook like count echo $fb[0]->like_count ; echo "comment"; // facebook comment count echo $fb[0]->comment_count;  ?>

Solution-windows 'expo' is not recognized as an internal or external command

Solution for expo is not recognized as an internal or external command,operable program or batch file in Windows 10 Sometimes expo will not work globally mostly in windows 10, If you are facing same issue then follow the below Steps 1) Click on windows button and search for  " Environment variables"  and click on "Edit the system environment variables" 2) Now you will see a popup like below screen. Then you need to click on Environment Variables. (Please see highlight part in below image)     3)Then click on new button that i have highlighted in below image 4. Then a popup will open and you need to fill details like below mentioned Variable Name :Path Variable Value: %USERPROFILE%\AppData\Roaming\npm Here we are creating a new path variable and passing location of npm.   Now Click on OK and close all the terminal windows and open new CMD or terminal and type Expo . Great now you can access expo from any...