[php]Database connexion function

[sasuke]

Hello!!
in this tuto I'm gonna explain how to make connection to your database using PHP

1-connexion script
to start open your text editor
copy and past this code:

Code:

<?

$hostname = "localhost";
$database = "database_name";
$username = "your_username";
$password = "your_password";

// Open a connection to the server
$connection = mysql_connect($hostname, $username, $password) or die ("Unable to connect to the DB Server!");


// Select the database
mysql_select_db($database) or die ("Can't select database!");
?>

the first part of the code
$hostname = "localhost"; --->leave "localhost" or put your local ip 192.168.x.x if you're using your computer as a host
$database = "database_name";--->enter the name of db you are going to use
$username = "your_username";--->enter your username (root is the default username of mysql"
$password = "your_password";--->enter your mysql password (leave it blank if you didn't edit it before)
the second part of the code

Code:

$connection = mysql_connect($hostname, $username, $password) or die ("Unable to connect to the DB Server!");

it's a mysql query wich make the connexion to MYSQL server
the third part

Code:

mysql_select_db($database) or die ("Can't select database!");

it will select the dabatase.

Note!!: you can use this code also for MSSQL server by replacing "mysql" with "mssql"
2-the include form
after pasting the code into your text editor save it as con.php
now if you wanna use this code for a php page,all you have to do is to add this code at the begining of the page

Code:

<?php
include "con.php";

?>

[Papercut]

this might come in-handy someday (for me)^^

[Zubair Ali]

Hi,
Mr. sasuke

Good work keep tech it...

[Sora]

Thank you.

Keep on working!

[evilalex]

thanks for this

[DesperateSoul]

this is great

[Dustyclaws]

i dont get it o.0

[Column]

Life
　　--- By Allan Houston
　　Life can be good,
　　Life can be bad,
　　Life is mostly cheerful,
　　But sometimes sad.
　　Life can be dreams,
　　Life can be great thoughts;
　　Life can mean a person,
　　Sitting in court.
　　Life can be dirty,
　　Life can even be painful;
　　But life is what you make it,
　　So try to make it beautiful.
Dream
　　--- By Allan Houston

　　Hold fast to dreams,
　　For if dreams die
　　life is a broken-winged bird
　　That cannot fly.

　　Hold fast to dreams,
　　For when dreams go
　　life is a barren field
　　Forzen with snow.
Flower Girl DressesEmpire Wedding DressesNew Style Wedding DressesColumn Wedding Dresses