Categories
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 32 bit x86_64 means 64 bit

Categories
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 little intuition it should work on the other distributions. 1. If the developer tab is not shown at the top Click File Options Customize Ribbon Select the Developer checkbox 2. On Developer tab, Code Group, Click […]

Categories
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 SELECT * FROM myschema2.mytbl; To Copy all the tables in a Schema into another existing Schema   In cmd/terminal, dump the database mysqldump -u root -ppass myschema > /path/to/myschema.sql In cmd/terminal, use the new database […]

Categories
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 usage imagery (synchronisation) reputation Picks are subjective and based on Champions League, Europa League games and a few youtube videos. If you have a problem and think there needs to be additions please let me […]

Categories
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 Total queries executed: Total elapsed time: # Query Time () Disable Zend Layout: $this->_helper->layout->disableLayout(); source: Web Development Blog