Shakeel Shrestha's Page

New Communication and Collaboration System.

In PHP, if we need to use the functions of class file, to load the class file, we usually use include/include_once or require/require_once functions. But the easier way is to use the inbuild function __autoload().

For demonstration define the class files as needed. Example is given below.



class MyClass1{

function myfunction(){
echo "Function inside MyClass1";
}
}
Save the file as MyClass.php


class MyClass2{

function mynextfunction(){
echo "Function inside MyClass2";
}
}
Save the file as… Continue

Some url rewriting that I have used.

First uncomment the line below in apache>conf>httpd.conf file and restart the apache server.

LoadModule rewrite_module modules/mod_rewrite.so

Now add these lines in .htaccess file

#initialize mod rewrite
Options +FollowSymlinks
RewriteEngine on

#this line will disable direct file viewing within any folder
Options -Indexes


#this configuration will disable the access of .htaccess file
<Files .htaccess>

order allow,deny
… Continue

Guidelines to create indexes

The characteristics of data and the usage of the data in the environment in which it is defined ascertains the columns to build the index. The usefulness of the index is directly related to the percentage of rows returned from a query. Low percentage or high selectivity are more efficient. Creating indexes on the frequently searched column is more useful and efficient. Indexes can be best created on the following columns.

• Primary Keys
• Foreign Keys or col… Continue

Limitations of MySQL

General limitations of MySQL

32-bit binaries cannot addess more than 4 GB of memory. This is not a MySQL limitation, this is a technical limitation.

Limits of MySQL 4.1

Limits of Joins

In MySQL 4.1, the maximum number of tables that can be referenced in a single join is 61. This also applies to the number of tables that can be referenced in the definition of a view.

Limits of the MyISAM storage engine

There is a

… Continue