More Useful .HTACCESS tips and Tricks

Hello Friends !!

I am back with .htaccess tips and tricks. Today i found one document whick contains lots of .htaccess tips and tricks.

This document in about 12 to 13 pages. So today i cant write all these tricks in my post.

But i will give you that document. You have to download that document from this site.

But one thing you have to do for this. Please give me comments and please share this post and my all posts.

Here you can DOWNLOAD this document.

Please..Please..Please comment on this post.

Thanks to all of you….

Block IP Address using PHP Script

Hello Friends !

Do you want to block those peoples who are doing spaming ?

Once we have determined that a particular IP address is worthy of banishment, we generally invoke the

magical powers of htaccess to lock the gates. When htaccess is not available, we may summon the versatile

functionality of PHP to get the job done.

Simply edit, copy and paste the following code example into the top of any PHP for which you wish to block access:
Continue reading »

Upload Large files using .htaccess in PHP

Hello Friends !!

In PHP, on server somekind of error occures when you upload large files.

If you work on localhost then you can change four parameters in php.ini file.
Continue reading »

Export data from MS EXCEL sheet to MySQL table – PHP Script

Export data from MS EXCEL sheet to MySQL table – PHP Script

Hello Friends !!

Today i write post on Export records from EXCEL sheet to MySQL table.I have PHP script for that. I already use that script and it’s working.

I will give you whole source code and explain you how to use this script.First of all you have to download excelreader file. Here this is a zip file and you have to extract it into your project directory.

After this make one PHP file called “excel_upload.php“. Copy this code and paste in this PHP file. You have to set the fields as your table.
Continue reading »

URL rewriting Tips and Tricks in .htaccess – PHP

Hello friends !!

Today i want to give you some more .htaccess tips and tricks for url rewriting in PHP.

In my last post, i was show you basick url rewriting. In this post i will write some more .htaccess tricks for you.

Control Access

Being able to control access to certain areas of your server can be very useful. The following example demonstrates how to only allow access from those connecting from a 192.168.0 LAN IP pool. This could be easily modified to only allow access from a single remote IP address or addresses.

Shorter URLs

Shorter URLs are beneficial, as visitors that persist in typing full URLs won’t have to type as much, and they’re more memorable. Do they benefit SEO, even though the full URL contains the same keywords? I don’t know, maybe someone can tell me.

This example will rewrite a page requested as http://xyz.com/files/code/apache.zip to http://xyz.com/download.php?type=code&file=apache.

Continue reading »