PHP – MySQL Connectivity

Welocome Guys !!

It is Saturday , after a long week of hard work , we are having weekend. I am also going to have fun.
Anyway before that i am going to write an article about the the problem which the any new PHP developer often face when he go for a database application.

Any PHP developer often  come across situation to connect to a database to make its  application more interactive.

PHP – MySQL Connectivity

Interacting with MySQL makes PHP a far more powerful tool. In this tutorial we will go through some of the most common ways PHP interacts with MySQL. To follow along with what we are doing, you will need to create a database table by executing this command:

 CREATE TABLE friends (name VARCHAR(30), fav_color VARCHAR(30), fav_food VARCHAR(30), pet VARCHAR(30)); 
 INSERT INTO friends VALUES ( "Rose", "Pink", "Tacos", "Cat" ), ( "Bradley", "Blue", "Potatoes", "Frog" ), ( "Marie", "Black", "Popcorn", "Dog" ), ( "Ann", "Orange", "Soup", "Cat" ) 

This will create a table for us to work with, that has friends’ names, favorite colors, favorite foods, and pets.

The first thing we need to do in our PHP file is connect to the database. We do that using this code:

 <?php 
 // Connects to your Database 
 mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error()); 
 mysql_select_db("Database_Name") or die(mysql_error()); 
 ?> 

Of course you will replace server, username, password, and Database_Name with the information relevant to your site. If you are unsure what these values are, contact your hosting provider.

Enjoy Coding !!

Have a nice week end !! :) :)

Email-me at : ajayjaiswalhi@gmail.com