http://www.binarytides.com/blog Fri, 09 Oct 2009 10:56:28 +0000 http://backend.userland.com/rss092 en FontMatrix is a font manager available for Linux. It can be used to preview fonts installed on the System. To install FontMatrix on Ubuntu 8.04 the deb file can be downloaded from : http://www.getdeb.net/app/Fontmatrix http://www.binarytides.com/blog/install-fontmatrix-on-ubuntu-8-04-hardy-heron/ A little while back I was trying to make a router for my application which I had grouped into classes. So a url could be like this : www.site.com/index.php/class_name/method?id=15 or www.site.com/index.php/controller/action?id=15 in the MVC style or localhost/project/index.php/class_name/method?id=15 PHP MVC frameworks like codeigniter use urls like that. Apache makes available a variable called PATH_INFO to PHP ... http://www.binarytides.com/blog/path_info-orig_path_info-apache-and-php/ 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 : [c] <Directory "C:/Apache2.2/htdocs"> # # Possible values for the Options directive are "None", "All", # or any ... http://www.binarytides.com/blog/enable-apache-mod_rewrite-on-windows/ One interesting way of listing foreign keys is like this : [sql] select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where referenced_table_name is not null; [/sql] which is found here and gives an output like this ... http://www.binarytides.com/blog/list-foreign-keys-in-mysql/ The innodb storage engine supports foreign keys in Mysql. To create foreign keys in phpmyadmin : 1. Convert both tables into innodb. 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 Relation view. In the ... http://www.binarytides.com/blog/create-foreign-key-using-phpmyadmin/ A little back I tried to backup a database from my webhost and restored it on my localhost mysql. It had a few views. On accessing the views in phpmyadmin mysql gave the error : #1449 - There is no 'projects'@'localhost' registered #1449 - There is no 'projects'@'localhost' registered So I opened the ... http://www.binarytides.com/blog/mysql-view-definer-and-sql-security/ Lots of newbies keep asking or search for techniques to hack someones email password like yahoo gmail msn etc. First of all it should be noted that getting someone's password out of a server is something impossible for the very simple reason that in most cases the password is stored no-where. ... http://www.binarytides.com/blog/email-hacking-facts-and-fictions/ Sometime back I was trying to put unicode characters(utf-8) in the title of a blog from wp-admin > settings > general. After saving it became like ?????????. All pages had utf-8 in their meta tags so the issue was somewhere else. A working solution was found : 1. Go to phpmyadmin and ... http://www.binarytides.com/blog/unicode-utf-8-characters-in-wordpress-blog-title/ MDB Viewer is a tool which can be used to open and view mdb files on Linux. On Ubuntu it can be installed from synaptic via the command : sudo apt-get install mdbtools-gmdb http://www.binarytides.com/blog/open-view-ms-access-mdb-files-in-ubuntu-linux/ Googling up for graph plotting solutions in PHP , found these free libraries : 1. PHPLOT - Can create Pie Charts , Bar Graphs , Line Graphs , Point Graphs etc. 2. PostGraph - Can create simple bar graphs. http://www.binarytides.com/blog/drawplot-graphs-with-php/