when you are going to crate relations with your's database tables plz keep in your mind:

The two tables must have the same engine i.e. ENGINE=InnoDB. (can be others: ENGINE=MyISAM works too)

The two tables must have the same charset.

The PK column(s) in the parent table and the FK column(s) must be the same data type. (if the PRIMARY Key in the Parent table is UNSIGNED, be sure to select UNSIGNED in the Child Table field)

The PK column(s) in the parent table and the FK column(s), if they have a define collation type, must have the same collation type;

If there is data already in the foreign key table, the FK column value(s) must match values in the parent table PK columns.

And the child table cannot be a temporary table.

By .htaccess to redirect all traffic to root or holding page

Add the following to the file and save.

RewriteEngine on
RewriteCond %{REQUEST_URI} !/$
RewriteRule (.*) / [R=301,L]

Now all traffic will redirect to the root. YOu could also do this for a holding page if you like:

RewriteEngine on
RewriteCond %{REQUEST_URI} !/holdingpage.php$
RewriteRule (.*) /holdingpage.php [R=301,L]

Simple and standrad .htaccess file create

Options -Indexes
Options +FollowSymLinks

RewriteEngine On
RewriteBase /{ROOT_FOLDER: (if it's htdocs then no need)}/

#Removes access to the system folder by users.
#Additionally this will allow you to create a System.php controller,

RewriteCond %{REQUEST_URI} ^system.*
RewriteRule ^(.*)$ index.php?/$1 [L]

#When your application folder isn't in the system folder

RewriteCond %{REQUEST_URI} ^application.*
RewriteRule ^(.*)$ /index.php?/$1 [L]

#Checks to see if the user is attempting to access a valid file,
#such as an image or css document, if this isn't true it sends the
#request to index.php

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L]

# If we don't have mod_rewrite installed, all 404's
# can be sent to index.php, and everything works as normal.
# Submitted by: ElliotHaughin   

ErrorDocument 404 /index.php

How to add aptana studio 3 in you eclipse IDE

Add Sencha touch and Ex.js editor feature in your Aptana Studio 3 editor.

1. Into Aptana Studio go to Help -> Install New Software
2. Click "Add" to add a repository
   • Name: Spket IDE
   • Location: http://www.agpad.com/update
3. In "Work with:" list select the item u just added A list will appear wit 3 repositoryes for Spket IDE. (Spket IDE, Spket Text Editor and Xerces for Spket IDE) Install all of them
4. Download http://www.agpad.com/downloads/com.spket.js_1.6.18.jar
5. Replace the existing file located in "C:\Program Files\Appcelerator\Aptana Studio 3\plugins" or where did you installed Aptana (in "plugins" folder) You must install this because Spket only supports format "jsb1" and "jsb2". With this fix it will support "jsb3" (wich Sencha Touch use it).
6. In Aptana Studio go to Windows -> Preferences -> Spket -> Javascript Profiles
   • Click "New" and write "SenchaTouch"
   • Select "SenchaTouch" and click "Add Library" and select "ExtJs" from the list displayed
   • Select "ExtJs" and click "Add File" Locate youre "sencha-touch.jsb3" wich is containted in the zip file downloaded from sencha.com. (make sure all the files from that archive are located in the same folder) ....and click "Open"
   • Select "SenchaTouch" again and click "Default" button
   • Click "OK"

Now open a ".js" script of a sencha touch project and check it out.

Use of .delegate() function in Jquery

when we need to play with html which is already manipulated with jquery we have to use   .delegate() function in Jquery.

suppose you have generated some list item by an ajax call from DB. Now you've to give an event functionality by clicking those list. then .delegate() will help you a lot

$("body ul").delegate("li", "click", function(){

//add some code

alert( $(this).text() );

});

There is an excellent Domain and Hosting service provider management webware PHPCOIN

Early in joining in may second job in my life, I had to work for creating a software to manage clients of my office who ware get domain and hosting from the company.
in order to mange those client I was search a good webware. and I have get something very essantial to use. the name of the webware is PHPCOIN. if you want to visit the demo of this management software plz visit this link:

 http://cpdemo.phpcoin.com

If you wish to track clients, orders, invoices, payments, support requests, email communications, and notes (and domains if you are a web-host), then phpCOIN is the package for you.