PHP with MySQL Database Connectivity!

I’m writing this article for those who are not familier with database connection using PHP or other language. One of my best friend Akash has told me to help him with this topic. Its a special matter. Because he is a student of Mechanical Engineering.
Though he is trying to know about the basic of HTML, CSS using Macromedia Dreamwever MX but his cursity about PHP made me surprised.

First you should know the neccessity of database. In present websites there are many kind of use of database. Such as User Login, Comment Box, Voting system, Registration form etc. When a Website is not just for browsing but also for connectivity between user and administrator of that site, then it need database.

For example: One user want to be a member of a site with his information and he will get his data back requesting them again. For this he need to be registered.
First his registration form is inserted into database with is ID. When he requests or get Login , then he can go to his page or some secured page by the verification of his information stored in database. His user ID and Password also stored in database and when he insert his ID & PASS in a login form then neccessary PHP code send this data to database and some code compare that data with stored data. When it is true then some other functions will be executed.

Requriments:
***** I want to imagine that Akash has enough idea About
1.MySQL Query
2.Functions and Logics that he used in C language previous semester
3.Executing codes

4. Database (MySQL or Oracle)
5. Web Server ( Apache or anythig)
6. PHP

(more…)

Published in:  on March 11, 2008 at 10:47 pm Comments (9)