Jun
6,
2019

CakePHP3: Fetch a particular column from all rows

Say we have the following data in a table called countries:

id country capitol
1 USA Washington DC
2 Japan Tokyo
3 United Kingdom London


And you want to fetch data like this:


['Washington DC', 'Tokyo', 'London']


Then do this:


$capitols = $this->countries

                 ->find()

                 ->extract('capitol')

                 ->toArray();

#cakephp3

People Who Wowed This Post

Jun
4,
2019

CakePHP3: Get the full URL of the current page

Method 1: Use the URL helper



$url = $this->Url->build([

           "controller" => "Posts",

           "action"     => "search",

           "?"          => ["foo" => "bar"] 

           ],true);


Method 2: Use the Router



use Cake\Routing\Router;



$url = Router::url([

           'controller' => 'Posts', 

           'action'     => 'search', 

           '?'          => ['foo' => $bar] 

           ], true);
#cakephp3

People Who Wowed This Post

Jun
1,
2019

CakePHP3: Check if record exists

Here is a handy way to do it:

To check by primary key:



if ($this->Users->exists($id)) {

}


To find by specifying where clause:



if ($this->Users->exists(['email' => $email])) {

}


Much more convenient than using find('count').
#cakephp3

People Who Wowed This Post

May
31,
2019

Bash: working with filenames containing spaces

At times, I'd like to perform an action against all files in a directory like this:



for i in `find . -type f`

do

cp "${i}" "${i}.bak"

done


This fails when filenames contain spaces, as bash uses whitespace, tab and LF as the default delimiter. Solution? Do this:



SAVEIFS=$IFS

IFS=$(echo -en "\n\b")


#bash

People Who Wowed This Post

×
  • If you are a bloguru member, please login.
    Login
  • If you are not a bloguru member, you may request a free account here:
    Request Account