Preventing SQL Injection Attacks with MySQL and PHP-2

Hello Friends !!

If you remember then in my older post on SQL injection, I was explain you basic of SQL injection and basic code to prevent SQL injection.

Today I will explain how to prevent SQL injection using encryption ?

I think you all use MySQL for database purpose.We add one variable named key . This Key is concatenate with original password.

There is one fieldtype md5. We will use this type to store password.

I list some steps for this method :
Continue reading »

Block Proxy Servers using .htaccess

Hello Friends !!

We all know about spamming.

In my last post we can block IP address using .HTACCESS. But suppose proxy server used for spamming then what will you do ? In using proxy server, every time IP address changed.

Generally hackers are also use proxy servers to hack the site.

Don’t worry about this. I found some code of .HTACCESS which blocks proxy servers to access your site.

How to Block Proxy Servers

This code help you to block proxy servers to access your site.

Continue reading »

Block IP addresses Using .HTACCESS

Hello Friends !!

In my previous post, i was write how to block IP address using PHP script ?

Today i will write that how to block IP address using .HTACCESS ?

There are several ways to block a specific IP range.

The first utilizes a CIDR number to block the specified range (via htaccess):

Continue reading »

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 »

Some Inspirational Thoughts From Some Genious Persons

Hello Friends !!

Today i will show you some Inspirational Thoughts From Some Genious Persons of world.

When your mind have negative thinking, then please revise these thoughts in your mind :

“Man often becomes what he believes himself to be. If I keep on saying to myself that I cannot do a certain thing, it is possible that I may end by really becoming incapable of doing it. On the contrary, if I have the belief that I can do it, I shall surely acquire the capacity to do it even if I may not have it at the beginning.”
- Mahatma Gandhi

“You can never cross the ocean unless you have the courage to lose sight of the shore.”
- Christopher Columbus

“To a brave man, good and bad luck are like his left and right hand. He uses both.”
- St Catherine of Siena

“When one door of happiness closes, another opens, but often we took so long at the closed door that we do not see the one that has been opened up for us”
- Helen Keller

“We don’t see the things the way they are. We see things the way WE are.”
- Talmund

“Formal education will make you a living. Self education will make you a fortune.”
- Jim Rohn

“It isn’t what the book costs. It’s what it will cost you if you don’t read it.”
- Jim Rohn

“You must be the change you want to see in the world.”
- Mahatma Gandhi

“The future has several names. For the weak, it is the impossible. For the fainthearted, it is the unknown. For the thoughtful and valiant, it is the ideal.”
- Victor Hugo

“There is nothing more genuine than breaking away from the chorus to learn the sound of your own voice.”
- Po Bronson

“Do not go where the path may lead, go instead where there is no path and leave a trail.”
- Waldo Emerson

“Use what talents you possess, the woods will be very silent if no birds sang there except those that sang best.”
- Henry van Dyke

“Do not fear to be eccentric in opinion, for every opinion now accepted was once eccentric.”
- Bertrand Russell

Continue reading »

Useful SEO tips for WordPress Blog users – 2

Hello Friends !!

This post contains some more tips for SEO.

1. Permalinks

First of all you have to change your permalinks SEO friendly. Go to Settings -> Permalinks and after that select date and name based. See image displayed :

2. Submit your blog search engines

Do not forget to submit your blog to Google, Yahoo and Microsoft Live search engines. You can use the sitemap created in previous tip (if you already did that) in all submissions.

- Google: go to Webmaster Tools in your Google account and add your blog URL; follow steps to add blog sitemap and verify ownership of blog.

Continue reading »