17 Mar 2014
Database Connectivity in Php
This blog is going to explain how to connect database with php and display all the records of table.
STEP 1: Create a table and insert some records in it.
create table emp (id int, name varchar(50), salary int, phone varchar(20));
insert into emp values (1,’Albert’,56000,’98587485768′);
insert into emp values (2,’Robart’,58000,’98587485768′);
insert into emp values (3,’Sam’,45000,’98587485768′);
insert into emp values (1,’Albert’,56000,’98587485768′);
insert into emp values (2,’Robart’,58000,’98587485768′);
insert into emp values (3,’Sam’,45000,’98587485768′);
STEP 2: Write a code for database connectivity and display records in Php.
<?php
$server = “localhost”;
$user = “root”;
$password =””;
$database =”test”;
$con = @mysql_connect($server,$user,$password);
mysql_select_db($database,$con);
$query = “select * from emp”;
$data = mysql_query($query);
while($rec = mysql_fetch_array($data)) {
echo “<br/>Name : “.$rec[‘name’];
echo “</br>Salary : “.$rec[‘salary’];
echo “</br>Phone : “.$rec[‘phone’];
echo “<hr>”;
}
?>
$server = “localhost”;
$user = “root”;
$password =””;
$database =”test”;
$con = @mysql_connect($server,$user,$password);
mysql_select_db($database,$con);
$query = “select * from emp”;
$data = mysql_query($query);
while($rec = mysql_fetch_array($data)) {
echo “<br/>Name : “.$rec[‘name’];
echo “</br>Salary : “.$rec[‘salary’];
echo “</br>Phone : “.$rec[‘phone’];
echo “<hr>”;
}
?>
Output :
About Author
bestonetechnologies
I am a software developer.
