Syntax
mysql_connect(“host”, “username”, “password”)or die(“cannot connect to server”);
Overview
Define your database information, in this example use information of www.phpeasystep.com
* host=”localhost” you don’t have to change it. When it’s on your computer or server it still be localhost
Username = phpeasystep
Password = 1234
Database = test
Test
$host=”localhost”;
$username=”phpeasystep”;
$password=”1234″;
$db_name=”test”;mysql_connect(“$host”, “$username”, “$password”)or die(“cannot connect to server”);
mysql_select_db(“$db_name”)or die(“cannot select db”);or
mysql_connect(“localhost”, “phpeaststep”, “1234″)or die(“cannot connect to server”);
mysql_select_db(“test”)or die(“cannot select db”);
Creating file config.php
$host=”localhost”;
$username=”phpeasystep”;
$password=”1234″;
$db_name=”test”;mysql_connect(“$host”, “$username”, “$password”)or die(“cannot connect to server”);
mysql_select_db(“$db_name”)or die(“cannot select db”);
save this file as “config.php”
when you want to use this code include it to your main php file
example
<?php
include(“config.php”);
$tbl_name=”member”;
$sql=”SELECT * FROM $tbl_name”;
$result=mysql_query($sql);
?>
