Author Archives: Silver Moon

About Silver Moon

A Tech Enthusiast, Blogger, Linux Fan and a Software Developer. Writes about Computer hardware, Linux and Open Source software and coding in Python, Php and Javascript. He can be reached at [email protected].

Install php xdebug profiler on ubuntu

By | April 7, 2010

Install Xdebug Install the packages from synaptic package manager sudo apt-get install php5-dev php5-xdebug Configure php to use xdebug extension Locate the path to xdebug.so file [email protected]:/$ find / -name 'xdebug.so' 2> /dev/null /usr/lib/php5/20060613/xdebug.so An alternative command to find the xdebug.so file is using dpkg and grep as follows $ dpkg -L php5-xdebug | grep… Read More »

Cgi bin directory for each user in Apache

By | May 9, 2020

This page http://httpd.apache.org/docs/2.2/howto/cgi.html describes how to give each user his own cg-bin directory. The following lines should be added to the Apache configuration file http.conf : <Directory /home/*/public_html/cgi-bin> Options ExecCGI SetHandler cgi-script </Directory> Along with this there are some more points to be kept in mind. If you .htaccess file has a section like this… Read More »

PATH_INFO, ORIG_PATH_INFO, APACHE and PHP

By | June 2, 2013

AcceptPathInfo Directive The AcceptPathInfo directive is a useful feature of apache. It detects any path information in a url following the actual script name and passes it to php as an environment variable in $_SERVER superglobal. Php mvc based frameworks often use such urls that have additional path information after a script name. This is… Read More »

Install apache mod rewrite on windows

By | September 30, 2009

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 : <Directory "C:/Apache2.2/htdocs"> # # Possible values for the Options directive are "None", "All", # or any combination of: # Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews #… Read More »

List foreign keys in mysql

By | September 5, 2009

information_schema The following query will list out the foreign keys in mysql. It finds it out from the information_schema database. 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; The output is a clean table listing out all foreign keys from all databases +———————–+————-+ |… Read More »

Create foreign key using Phpmyadmin

By | May 9, 2020

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 »

Create AutoIncrement column/field in Apache Derby

By | July 6, 2009

While creating a table a particular column / field can be made autoincrement as : CREATE TABLE students ( id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), name VARCHAR(24) NOT NULL, address VARCHAR(1024), CONSTRAINT primary_key PRIMARY KEY (id) ) ; The value of an autoincrement column increments automatically with… Read More »