Here we produce two PHP pages, in first (showDetails.php)
it contains some data with a show all link. When the user clicks on that link all
related data of that link will be displayed in the second page (showdetails1.php).
Table creation
Server: localhost Database: home_work
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 17, 2011 at 04:25 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `home_work`
--
-- --------------------------------------------------------
--
-- Table structure for table `employee`
--
CREATE TABLE `employee` (
`id` int(11) NOT NULL auto_increment,
`empid` varchar(255) NOT NULL,
`empname` varchar(255) NOT NULL,
`empaddress` varchar(255) NOT NULL,
`designation` varchar(255) NOT NULL,
`salary` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `employee`
--
INSERT INTO `employee` (`id`, `empid`, `empname`, `empaddress`,
`designation`, `salary`) VALUES
(1, 'E001', 'Raj', 'Delhi', 'Clerk', 10000),
(2, 'E002', 'Harry', 'Mumbai', 'Player', 20000),
(3, 'E003', 'Sunil', 'Noida', 'Producer', 30000),
(4, 'E004', 'Pollock', 'Durban', 'Manager', 40000),
(5, 'E005', 'Jonty', 'Perth', 'Director', 50000),
(6, 'E006', 'Kallis', 'Oslo', 'Dean', 60000),
(7, 'E007', 'Imran', 'Dubai', 'Admin', 70000);
showDetails.php
<?php
$link=mysql_connect("localhost","root","");
mysql_select_db("home_work",$link);
$sql="SELECT * FROM employee ";
$aResult=mysql_query($sql);
?>
<html>
<head>
</head>
<body bgcolor="Yellow">
<form name="frmForm" id="frmForm" >
<table border="1" width="30%" height="30%">
<tr>
<th><font color='Red'>EMP ID</font></th>
<th><font color='Red'>EMP NAME</font></th>
<th><font color='Red'>SALARY</font></th>
<th><font color='Red'>SHOW ALL</font></th>
</tr>
<?php
while($rows = mysql_fetch_array($aResult,MYSQL_ASSOC))
{
$id = $rows['id'];
$empid = $rows['empid'];
$empname = $rows['empname'];
$empaddress = $rows['empaddress'];
$designation = $rows['designation'];
$salary = $rows['salary'];
?>
<tr>
<td><b><font color='#663300'><?php echo $empid;?></font></b></td>
<td><b><font color='#663300'><?php echo $empname;?></font></b></td>
<td><b><font color='#663300'><?php echo $salary;?></font></b></td>
<td><b><font color='#663300'><a href="showDetails1.php?frm_action=3&cust_id=<?php
echo $id;?>" target="_blank">Show
All</a></font></b></td>
</td>
</tr>
<?php } ?>
<?php if($_REQUEST['frm_action'] == 3) { ?>
<tr>
<td colspan="2">
<table style="border:1px solid #003366;" cellspacing="2" cellpadding="2"
width="100%" bgcolor="#003366">
<tr bgcolor="#EFEFEF">
<td>Empid</td>
</tr>
<?php
while($row1= mysql_fetch_array($aCustomer,MYSQL_ASSOC))
{
$empid=$row1['empid'];
?>
<tr bgcolor="#FFFFFF">
<td><?php echo $empid;?></td>
</tr>
<?php } ?>
</table>
</td>
</tr>
<?php } ?>
</table>
</form>
</body>
</html>
showdetails1.php
<?php
$link = mysql_connect("localhost","root","");
mysql_select_db("home_work",$link);
if($_REQUEST['frm_action'] == 3)
{
$id = $_REQUEST['cust_id'];
$sqlCustomer = "SELECT * FROM employee WHERE id='$id'";
$aCustomer = mysql_query($sqlCustomer);
}
?>
<html>
<head>
</head>
<body bgcolor="Yellow">
<form name="frmForm" id="frmForm" >
<table border="1" width="30%" height="30%">
<tr>
<th><font color='Red'>ID</font></th>
<th><font color='Red'>NAME</font></th>
<th><font color='Red'>ADDRESS</font></th>
<th><font color='Red'>DESIGNATION</font></th>
<th><font color='Red'>SALARY</font></th>
</tr>
<?php if($_REQUEST['frm_action'] == 3) { ?>
<?php
while($row1 = mysql_fetch_array($aCustomer,MYSQL_ASSOC))
{
$empid = $row1['empid'];
$empname = $row1['empname'];
$empaddress = $row1['empaddress'];
$designation = $row1['designation'];
$salary = $row1['salary'];
?>
<tr>
<td><b><font color='#663300'><?php echo $empid;?></font></b></td>
<td><b><font color='#663300'><?php echo $empname;?></font></b></td>
<td><b><font color='#663300'><?php echo $empaddress;?></font></b></td>
<td><b><font color='#663300'><?php echo $designation;?></font></b></td>
<td><b><font color='#663300'><?php echo $salary;?></font></b></td>
</tr>
</table>
<?php } ?>
<?php } ?>
</form>
</body>
</html>
Running the application
Run the WampServer then write the below line in the Url
http://localhost/Display Related records/
