How to prevent php website from sql injection

Hi friends,
In this post, i would like to explain what is sql injection and how to prevent from this attacks to our website.
SQL Injection:
SQL injection is another vulnerability of PHP.  SQL injection refers to the act of anyone can inserting a MySQL statement to be run on our database without our knowledge. Injection usually occurs when you ask a user for input, like their name, and instead of a name they give you a MySQL statement that you will unknowingly run on your database

Complete information at http://www.anil2u.info/2010/04/12/how-to-prevent-php-website-from-sql-injection/

how to configure oscommerce site

Hi friends,
Today I want to discuss how to configure the oscommerce if we are files at subfolder and  run at localhost or site .

http://localhost/oscommerce/shop/

We may get errors at this point, suppose we are run oscommerce shop in a sub folder then we  have to think that how to configure this file to run the site success . Follow below points to configure file to run the shop at your localhost or site.

Complete post at  http://www.anil2u.info/2010/04/08/how-to-configure-oscommerce-site/

How to import and export big database files

Hello friends,
today i want to share some basic concepts but we need to know about import and export databases. If it is small database file, we can directly export or import from the phpmyadmin.
Process to export:
1) Go to phpmyadmin -> click on database -> there we have button called “export”.
2) When we click on that button, we got a screen like in which format do want to export from database ( Like .sql,.txt,.zip,.zar or just open it that browser) 3) When we click on “Go” button, we will get database backup file.
Process to import:
1) We have the database, but we want to import database to that existing database.
2) Click on “import” button and then we have the separate screen click on browse and select the database file and click on “Go” button, it will successfully import the database.

  Complete article at @ http://www.anil2u.info/2010/04/03/how-to-import-and-export-big-database-files/

How to implement google map in smarty?

Hi friends ,
the following script will discuss for how to implement google map in smarty application.
1) Sign up for API key of googlemap
http://code.google.com/apis/maps/signup.html
2) Create a google map class.
3) Create a tpl file

Complete post is available at http://www.anil2u.info/2010/03/28/how-to-implement-google-map-in-smarty/

List of posts using php code

•       File Extenstion Using PHP

•      How to add line breaks in the textarea

•      What is cron job ? How to set the cron job in PHP?

•      PHP Charts with using Google API

•     SEO – URL using php code and .htaccess

•     Generation of SEO URL in php code

•    How to create custom error log files in php?

•    How to get the php data grid?

•    Date Format in the PHP Code?

•    Generating Random Password using PHP code?

•    How to take backup of Database using PHP code?

•    Small urls generated using php code?

•   How to connect to FTP and upload file using php code?

•   How to set the timezone of server using PHP

•   Google maps using php code

•    Current page URL using PHP code?

•    How to external html content to the mail using php?

•   How to get the real IP address using php?

•    Inactive in site then auto logout using php

•   Unzip file using php code

•   Grabbing thumbnail image from youtube using php code

•   Auto post into Blogspot using php code?

•    We get the address by latitude and longitude -using php code

•    How to get links from feed using php

•   Searching for existing domain names?

•   How to remove consecutive whitespaces using php?

•   How to send mail using phpmailer class

•   How to create auto hyperlinks using php code

•   How to clean a string using php code

•   Sending mail using phpmailer and gmail as smtp

•    How to display the mysql table schema using php code?

•   How to create excel file with mysql data using php code

•   Mysql Date functions in php code

Simple keys to be a successful Website

Keys for a successful Website

•  Meta Tags
•  Navigation
•  Search Engine Optimized
•  Google Analytics/Tracking System
•  Contact Us Information
•  Privacy Policy/Disclaimer
•  Copyright Notice
•  Search Box/Site Map
•  Newsletter Sign Up/RSS Feed
•  Social Media Share Button
•  Trust Seals/Testimonials