Browsing articles from "September, 2009"
Sep
30
2009

Enable Apache mod_rewrite on Windows

In httpd.conf file the following line should be uncommented : LoadModule rewrite_module modules/mod_rewrite.so by removing the # sign before it. Then comes a section which looks like this : The line : AllowOverride None should be made : AllowOverride All Restart Apache. Create a .htaccess file somewhere in htdocs and write some garbage text in it like akjsnajknda and save. Create a index.php along with the .htaccess file. Now open the index.php file in browser [...]

Sep
5
2009

List foreign keys in mysql

One interesting way of listing foreign keys is like this : which is found here and gives an output like this : Another way would be to : which displays the sql query to create the table and has the foreign key constraints too. Apart from this phpmyadmin too shows the foreign keys on the top of a table structure. References : 1. Mysql Docs