conn.php - This is the connection file
<?php
$db_name="yourdatabasename";
$connection=mysql_connect("hostname","username","password") or die("I Couldn't connect");
$db=mysql_select_db($db_name,$connection) or die("I Couldn't select your database");
?>
==========================================
viewemp.php - The main file
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Employee Details</title>
<!-- Developed By Suraj Thapaliya http://www.surajthapaliya.com.np -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td> </td>
</tr>
<tr>
<td> <table width="775" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form method="post" action="">
<table width="775" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td width="357"> </td>
<td width="245" align="right"> </td>
<td width="163" align="center">Current Page No:
<?
$x=$_GET["x"];
$pageno=$x/15 +1;
echo "<b>".$pageno."</b>";
?></td>
</tr>
<tr>
<td colspan="3"><table width="750" border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#666666" class="allborder">
<tr bgcolor="#CFCFE7">
<td height="20"><strong>Id</strong></td>
<td><strong>Full Name</strong></td>
<td><strong>Department</strong></td>
<td><strong>Gender</strong></td>
<td><strong>Contact</strong></td>
<td><strong>Email</strong></td>
</tr>
<?
$x=$_GET["x"];
if(!isset($x)) $x=0;
include("conn.php");
$tsql="select * from empdetail";
$tresult=mysql_query($tsql,$connection) or die(mysql_error());
$num=mysql_num_rows($tresult);
$sql="select sn,empid,fname,lname,mname,department,branchid,sub_branchid,email from empdetail limit $x,15";
$result=mysql_query($sql,$connection) or die(mysql_error());
$counter=0;
while($row=mysql_fetch_array($result))
{
if($counter==0) {
$color="#EEEEF7";
$counter++;
} else {
$color="#ffffff";
$counter=0;
}
?>
<tr bgcolor="<? echo $color; ?>">
<td height="20"><? echo $row['empid']; ?></td>
<td><? echo $row['fullname']; ?></td>
<td><? echo $row['department']; ?></td>
<td><? echo $row['gender']; ?></td>
<td><? echo $row['contact']; ?></td>
<td><? echo $row['email']; ?></td>
</tr>
<?
}
?>
<tr bgcolor="#CFCFE7">
<td height="20"><strong>Id</strong></td>
<td><strong>Full Name</strong></td>
<td><strong>Department</strong></td>
<td><strong>Gender</strong></td>
<td><strong>Contact</strong></td>
<td><strong>Email</strong></td>
</tr>
<tr>
<td colspan="6">
<?
$page=1;
$increment=0;
$showpage=$num/15;
echo"<font face=verdana size=2><b>Page:</b> </font> ";
for($j=0;$j<$showpage;$j++)
{
if($page==$pageno) {
$size="3";
} else {
$size="2";
}
echo"<a href='viewemp.php?x=$increment'><font face=verdana size=$size>$page</a></font> ";
$page=$page+1;
$increment=$increment+15;
}
?>
</td>
</tr>
</table></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
Database schema
create table empdetail
(
id int not null primary key,
fullname varchar(50),
department varchar(50),
gender varchar(10),
contact varchar(50),
email varchar(50)
)
insert into empdetail values(1,'Prashant singh','Programmer','Male','00001255454','abc@gmail.com');
insert into empdetail values(2,'Prashant singh','Programmer','Male','00001255454','abc@gmail.com');
insert into empdetail values(3,'Prashant singh','Programmer','Male','00001255454','abc@gmail.com');
insert into empdetail values(4,'Prashant singh','Programmer','Male','00001255454','abc@gmail.com');
insert into empdetail values(5,'Prashant singh','Programmer','Male','00001255454','abc@gmail.com');
insert into empdetail values(6,'Prashant singh','Programmer','Male','00001255454','abc@gmail.com');
Enjoy the code
............................. :)
No comments:
Post a Comment