Zend Database Expression for Mysql PASSWORD()
$db = Zend_Db_Table::getDefaultAdapter(); new Zend_Db_Expr($db->quoteInto(‘PASSWORD(?)’, $data[‘password’]))
Uncategorized
Zend Framework 1.12
Disable Layout and View Zend Framework
Disable Layout and View Zend Often when actions are used in controllers that do some work but do not actually […]
Uncategorized
Check if running 32 or 64 bit linux
Tutorial on how to check if you are running 64 bit or 32 bit on Linux: uname –m i686 means […]
Microsoft
Export an excel spreadsheet to a quoted CSV
Tutorial on how to Export to a Quoted CSV This guide is tailored towards Microsoft Office 2007, but with a […]
SQL
MySQL: How to Copy tables into seperate Schemas
To Copy a single table in a Schema into another existing Schema CREATE TABLE myschema.mytbl LIKE myschema2.mytbl; INSERT INTO myschema.mytbl […]
football
Top 12 Scariest Stadiums in World Football List
A list of the 12 scariest stadiums in world football. The main factors: loudness of fans violence of fans flare […]
Web Development, Zend Framework 1.12
Zend Framework Tips and Tricks
To Redirect: /controllers/yourcontroller::youAction() $this->_redirect(‘/path/to/place’); To Show Profiler in a layout /layouts/yourlayout.phtml $this->addScriptpath(APPLICATION_PATH . ‘/profiler/views/scripts’); echo $this->render(‘util/profiler.phtml’); /application/profiler/views/scripts/util/profiler.phtml Database Profiling Report […]
Server
Debian 7 (WheezY) Cheat Sheet
Check php version (command line): php -i unzip a .tar: tar -xvf file.tar unzip a .tar.gz: tar -xzvf file.tar.gz Virtual […]
Database, SQL
Create a New MySQL User that only has access to a Particular Schema and Table
Create New MySQl User with Privileges GRANT ALL PRIVILEGES ON dbTest.* To ‘user’@’hostname’ IDENTIFIED BY ‘password’; So for example: Log […]