Category: PHP Frameworks

Suppose we have a table cake_test with a column named modified that contains epoch values. CakePHP code: $options = array ( ‘fields’ => array ( “modified”, “to_timestamp(modified) as New__original”, “to_timestamp(modified) AT TIME ZONE ‘America/Denver’ as New__converted” ) ); $result =

Error: Call to a member function schema() on a non-object File: /home/user/git/!defaultRepo!/Appname/lib/Cake/Model/Datasource/Database/Postgres.php Line: 404 Description: I was trying to execute the following cake query to fetch the records: $records = $this->find ( ‘all’, array ( ‘fields’ => array ( ‘Table2.*’,

Use Heroku cron jobs to run CakePHP code at fixed intervals of time. Cron is a time-based scheduler used to run commands periodically at fixed intervals. Cron means time. It is used for scheduling repetitive tasks. In order to use

First of all, we should know what features are provided by jquery-ui plugin. To know about details, please see link, http://jqueryui.com/demos/ Jquery UI plugin can be downloaded from the link http://jqueryui.com/download/ Now, today, we will discuss about Autocomplete feature of

How to use concatenate, cases, substring in CakePHP 2.* find query. Suppose given records are: Problem: Display user details in one column and the first character of user role in front of the user full name. Also suppose in case

Before uploading any document to Amazon AWS S3 server, make sure that user has to write access on the bucket where files will be saved else it will throw ‘Access denied’ error. Apart from the write permissions, access keys are

Question: Can we add custom functions in quickbook? Answer: Yes, In quickbook.php file we need to add Constants to make custom function and we can add as many as we want. After defining these constant we can map these in

CSRF stands for cross-site request forgery. CSRF token is basically used for security purpose in Laravel forms. To understand how it works read here: https://laravel.com/docs/5.4/csrf How to disable it if required? CSRF protection is enabled by default in all routes

Create and Download CSV of table Records using OUTFILE Sql command and PHP 1. Create temporary CSV file using OUTFILE SQL command: OUTFILE command is used to write your sql command output to the specified location. You can write the output