Display Related Records in PHP

Satyapriya Nayak
13y
9.9k
0
1

Article

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>EMP ID</th>
<th>EMP NAME</th>
<th>SALARY</th>
<th>SHOW ALL</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><?php echo $empid;?></td>
<td><?php echo $empname;?></td>
<td><?php echo $salary;?></td>
<td><a href="showDetails1.php?frm_action=3&cust_id=<?php echo $id;?>" target="_blank">Show
All</a></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>ID</th>
<th>NAME</th>
<th>ADDRESS</th>
<th>DESIGNATION</th>
<th>SALARY</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><?php echo $empid;?></td>
<td><?php echo $empname;?></td>
<td><?php echo $empaddress;?></td>
<td><?php echo $designation;?></td>
<td><?php echo $salary;?></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/

Up Next

Ebook Download

View all

Printing in C# Made Easy

Read by 10.8k people

Download Now!

Learn

View all