‘MVC’ Archives
configure database using propel
$ ./symfony configure:database --name=propel --class=sfPropelDatabase "mysql:host=localhost;dbname=dbname" username userpassword
Self join criteria in symfony
For Example : SELECT tbl1.id FROM tbl1 a LEFT JOIN tbl1 b ON a.somecolumnname = b.somecolumn ORDER BY a.somecolumn DESC The criteria would be as follow $c=new Criteria(); $c->addAlias('a', 'tbl1'); $c->addAlias('b', [...]
select multiple column from multiple table in cakePHP
$markers = $this->Post->find('all', array( 'joins' => array( array( 'table' => 'cp_user', 'alias' => 'users', 'type' => 'left', 'foreignKey' => false, 'conditions'=> array('Post.postauthor = users.id') ) ), [...]
Latest music . videos and songs
PHP Manual
