Php from command line PHP scripts are usually opened in a web browser. But they can be run from command line or terminal as well. The syntax to run a script from commandline is very much similar to python or perl. php /path/to/script/index.php Inside a script it might be necessary to test if it is… Read More »
Racing car in box2d Box2d is a physics 2d simulation library and is used in game development. Apart from C/C++ it has ports for various languages like python, javascript etc. With the availability of the html5 canvas element and many other html5 apis, it becomes possible to write browser based games in javascript. So in… Read More »
Resizing images Web applications often need to work with images like pictures of users or photos etc. So the need to need to resize images comes up when creating thumbnails for example or compressing images for storage. The default library to handle image operations in php is GD. It can be used to resize images…. Read More »
If using this code gives the error : .htaccess: php_flag not allowed here in /var/log/apache/error.log Then Options should be added to AllowOverride in : /etc/apache2/sites-available/default AllowOverride FileInfo Options like this Last Updated On : 13th June 2011
If you are finding a way to encode urls in ruby then here is a quick tip – Short Answer: You could use the URI class or the CGI class. We have CGI.escape and URI.escape, but they have some slight differences. I have tried to show the differences in IRB as follows – So i… Read More »
There are times when you might be working on a codebase with other people and spot a method which you do not know about. You may want to locate the source of that method to learn and understand more about its functionality. So, Here is a quick tip on how to find where a method… Read More »
System load System load is a measure of how busy the system is running the processes. Higher system load simply means more processes are running and more are waiting to be run. When coding php applications, it sometimes is useful or necessary to find the current load on the server/system. For example if you want… Read More »
information_schema The following query will list out the foreign keys in mysql. It finds it out from the information_schema database. The output is a clean table listing out all foreign keys from all databases +———————–+————-+ | foreign key | references | +———————–+————-+ | orders.client_id | clients.id | | line_items.order_id | orders.id | | line_items.product_id |… Read More »
The innodb storage engine supports foreign keys in Mysql. To create foreign keys in phpmyadmin : 1. Convert both tables into innodb, if they are not already. 2. View the structure of the table which will have a foreign key. Make the referencing field an INDEX. 3. Now come back to structure view and click… Read More »
Views and mysqldump A little back I tried to backup a database from my webhost and restore it on my localhost mysql. It had a few views. The import of the sql file seemed to work fine. But on accessing the views in phpmyadmin mysql gave the error : #1449 – There is no ‘projects’@’localhost’… Read More »