Report on Industrial Training at Indian Ordnance Factory

Six week Industrial Training Report in PHP

1. MINISTRY OF DEFENCE
ORDANANCE CLOTHING FACTORY
SHAHJAHANPUR


COMPUTER SCIENCE & ENGINEERING
PERIOD OF TRAINING
10
th
June 2013 to 20
th
July 2013
Submitted By:
AKASH SHANKAR BISARIYA
B.TECH 3
rd
year
Computer Science & Engineering
Future Institute of Engineering & Technology
Bareilly (U.P)
Ordnance Clothing Factory, Shahjahanpur 1

2. TABLE OF CONTENT

1)ACKNOWLEDGEMENT
2)SUPERVISORS’ NOTE
3)INTRODUCTION
3.1) HISTORICAL BACKGROUND OF O.C.F
3.2) PRINCIPAL PRODUCTS
3.3) WELFARE ACTIVITIES
3.4) RECREATIONAL& OTHER FACILITIES
3.5) FACTORIES & THEIR LOCATION
3.6) OFB LOCATION MAP
3.7) SECTIONS /OFFICES OF ORDNANCE CLOTHING FACTORY,
SHAHJAHANPUR
3.8) ADMINISTRATIVE HIERARCHY OF OCFS
4)POLICIES
5)5-S SYSTEM
6)H.R.D. AND TRAINING SECTION
7)IN FORMATION TECHNOLOGY CENTER
7.1) P.P.C. PACKAGE
7.2) E –ADMIN
7.3) E.A.R.S
7.4) COMNET
7.5) VISITOR MANAGEMENT SYSTEM
8) DATA FLOW DIAGRAMS
9) E-R DIAGRAMS
10) EMPLOYEE QUALIFICATION MODULE
8.1) HOME PAGE
8.2) CODE MASTER ADD.PHP
8.3) CODE MASTER EDIT.PHP
8.4) CODE MASTER DELETE.PHP
Ordnance Clothing Factory, Shahjahanpur 2

3. 8.5) EMPLOYEE QUALIFICATION ADD.PHP
8.6) EMPLOYEE QUALIFICATION EDIT.PHP
8.7) EMPLOYEE QUALIFICATION DELETE.PHP
8.8) CODE MASTER REPORT.PHP
8.9) EMOLOYEE QUALIFICATION REPORT.PHP
8.10) EMPLOYEE WISE REPORT.PHP
11) BIBLIOGRAPHY
1.ACKNOWLEDGEMENT
I express my sincere thanks & regards to ORDNANCE CLOTHING FACTORY,
SHAHJAHANPUR for giving me the opportunity to study on the topic“ PIS (Personal Information
System) Module in Php ”.
First & foremost I express my heartily thanks to MR. D.R. SHARMA (JWM), MR.
AASHEESH SAXENA (JWM) and MR. L.P. GROVER (JWM) for their kind guidance. I also
express my sincere thanks to all other employees of concerned sections of I.T.C. for their kind
cooperation in this project work.
And lastly, I would like to thank all my group members for their kind cooperation to complete
this project work successfully.

AKASH SHANKAR BISARIYA
Ordnance Clothing Factory, Shahjahanpur 3

4. Ordnance Clothing Factory, Shahjahanpur 4

5. 2. SUPERVISOR’S NOTE
It is certified that AKASH SHANKAR BISARIYA S/O Mr. SUBODH SHANKAR BISARIYA
student of B.TECH - C.S. & E (3
rd
year) from FUTURE INSTITUTE OF ENGINEERING &
TECHNOLOGY has undergone six weeks Industrial training on “ PIS(Personal Information System)
Module in Php ” from 10
th
June 2013 to 20
th
July 2013 under my supervision and guidance.
MR. SHIV KUMAR
Jt. GENERAL MANAGER-MDO
MR. MANISH MUKHERJEE
AWM/ITC
MR. AASHEESH SAXENA
JWM-ITC
MR. V. K. SHUKLA
JWM/HRD & APP. TRG
MR. SHUK DEV
CHARGEMAN/HRD
Ordnance Clothing Factory, Shahjahanpur 5

6. 3. INTRODUCTION
Ordnance Clothing Factory, Shahjahanpur established in 1914 and this comes under group of
Ordnance Equipment Factories, the group head quarter of these factories at Kanpur and head office
is situated at Kolkata and is known as Ordnance Factory Board.
The Ordnance Clothing Factory, Shahjahanpur deals with specially making the army garments.
3.1 HISTORICAL BACKGROUND
Ordnance Clothing Factory, Shahjahanpur has a very old historical background. In the year
1879, Sir ASHLEY EDEN, Lt. Governor of Bengal founded 3 clothing Factories in Bombay, Alipur
and Madras for stitching of garments. In the year 1914, a part of the Alipur factory was shifted to
Shahjahanpur on experimental basis for 1 year and named as Army Clothing Factory, Shahjahanpur.
This is the largest clothing factory in ASIA.
In the year 1925 the entire Alipur Factory was closed and work was permanently transferred to
Shahjahanpur. Shahjahanpur is about 180 K.M. from Lucknow and 330 K.M. from New Delhi. The
nearby places of interests are Nainital and Dudhawa National Park. Ordnance Clothing Factory
Shahjahanpur is engaged in the production of textile and clothing items for army, navy, air force,
DGBR, MHA and other civil authorities. The factory is spread in an area 20.02 Hectare and the estate is
spread in an area of 125.1 Hectare.
*********
Ordnance Clothing Factory, Shahjahanpur 6

7. 3.2 FACTORIES & THEIR LOCATIONS
There are forty factories under the Ordnance Factory Board. Ordnance Clothing Factory is one of
them. The forty-one factories are as: -
1) Ammunition Factory Khadki (A.F.K.).
2) Cordite Factory, Aruvankadu (C.F.A.).
3) Engine Factory, Avadi (E.F.A.).
4) Field Gun Factory, Kanpur (F.G.K.).
5) Gun Carriage Factory (G.C.F.).
6) Grey Iron Foundry (G.I.F.).
7) Gun and Shell Factory (G.S.F.).
8) Heavy Alloy Penetrator Project (H.A.P.P.).
9) High Explosive Factory (H.E.F.).
10) Heavy Vehicle Factory (H.V.F.).
11) Machine Tool Prototype Factory (M.P.F.).
12) Metal and Steel Factory (M.S.F.).
13) Ordnance Clothing Factory, Avadi (O.C.F.A.V.).
14) Ordnance Cable Factory, Chandigarh (O.C.F.C.).
15) Ordnance Clothing Factory, Shahjahanpur (O.C.F.S.).
16) Ordnance Equipment Factory, Kanpur (O.E.F.C.).
17) Ordnance Equipment Factory, Hazratpur (O.E.F.H.Z.).
18) Ordnance Factory, Ambernath (O.F.A.).
19) Ordnance Factory, Ambajhari (O.F.A.J.).
20) Ordnance Factory, Bhandara (O.F.B.A.).
21) Ordnance Factory, Bhusawal (O.F.B.H.).
22) Ordnance Factory, Bolangir (O.F.B.O.L.).
23) Ordnance Factory, Kanpur (O.F.C.).
24) Ordnance Factory, Chandrapur (O.F.C.H.).
Ordnance Clothing Factory, Shahjahanpur 7

8. 25) Ordnance Factory, Dumdum (O.F.D.C.).
26) Ordnance Factory, Dehu Road (O.F.D.R.).
27) Ordnance Factory, Dehradun (O.F.D.U.N.).
28) Ordnance Factory, Itarsi (O.F.I.).
29) Ordnance Factory, Khamaria (O.F.K.).
30) Ordnance Factory, Katni (O.F.K.A.T.).
31) Ordnance Factory, Muradnagar (O.F.M.).
32) Ordnance Factory Project, Nalanda (O.F.N.).
33) Ordnance Factory Project, Medak (O.F.P.M.).
34) Ordnance Factory, Tiruchirapalli (O.F.T.).
35) Ordnance Factory, Varangaon (O.F.V.).
36) Opto Electronics Factory (O.L.F.).
37) Ordnance Parachute Factory (O.P.F.).
38) Rifle Factory, Isadora (R.F.I.).
39) Small Arms Factory (S.A.F.).
40) Vehicle Factory, Jabalpur (V.F.J.).
41) Ordnance Factory Project Korba (O.F.P.K.R)
3.3 OFB LOCATION MAP: -
This Location map is not to scale. It indicates the location of Ordnance Factories.
Ordnance Clothing Factory, Shahjahanpur 8

9. Ordnance Clothing Factory, Shahjahanpur 9

10. 4. POLICIES
There are three policies in OCFS:
1.Quality Policy
2.Safety Policy
3.IT Policy

QUALITY POLICY
“Ordnance Clothing Factory Shahjahanpur is committed to supply quality product as per requirement to
customer and to strive for customer satisfaction through continual improvement of quality management
system.”
SAFETY POLICY
“To ensure employee while at work is safe and without risk to health by maintaining safe working
condition and environment and by providing protection against industrial hazards.”

IT POLICY
“The information technology Center of OCFS has committed itself to provide and maintain all types of
Information Technology Services, ensuring confidentiality and integrity of information to the
satisfaction of all users. The information technology centers shall endeavor to provide improved services
to all Users to achieve optimum utilization of all available information technology resources.”
Ordnance Clothing Factory, Shahjahanpur 10

11. 5. (5-S System)
5-S system is taken from the Japanese works culture. This system is useful in industrial sector as well as to
develop good working habits in society also. All the factory employees should follow 5-S systems to create
good industrial working environment.
The meaning of all five “S” is as under:-
1. S Sieri → Sort out necessary items in the workplace and discard others.
2. S Seoton → Arrange necessary items in good picked for use. All the things have its own place.
3. S Seiso → Clear your work place thoroughly so that there is no dust in the room or on the
machines and equipments.
4. S Seiketsu → Maintain high standard of house keeping at workplace all time.
5. S Shitsuke → Train the people to follow good house keeping and work in discipline.
*******
Ordnance Clothing Factory, Shahjahanpur 11

12. 6. HRD & TRAINING SECTION
HRD SECTION
HRD stands for Human Recourse and Development. It mainly concern with the effective utilization
of the human recourses. Development concern with the increasing / updating the of knowledge and skill
of the employees which help in increasing production and productivity. This is achieved by providing
adequate training to the concerned employee. It is also helpful in the improvement of behaviour and
personality of the employees.
TRAINING SECTION
Ordnance Factory Board has started a training section with approval of Ministry of Defense
under 1961 apprentice Act. This section provide training to student in various trades such as mechanical,
electrical, tailoring, fitter etc. but in OCFS presently training on tailoring is being given. The main goal
of this section is generate workmen for the future by giving training in a particular stream.
The Training Section is also managing periodical (summer/winter vocations) training to wards of
the factory employees who are studying in different technical / professional courses. This section is
providing every possible guidance / assistance to trainee students by which trainees are able to gain
knowledge about this organization / concern department and to improve their skills & personality to
shine like sun in the sky among others.
*******
Ordnance Clothing Factory, Shahjahanpur 12

13. 7. ITC (INFORMATION TECHNOLOGY CENTER)
I have completed my six weeks training in ITC department; this section is one of the sections of engineering
group of this factory. This is one of the vital department s of O.C.F, Shahjahanpur. Processing of all types of
information is handled by ITC. Many computerized work is being performed here which concerned with the
different processes / activities required to run the factory.
The work of ITC is divided into four main parts:
7.1 P.P.C Package (Production and Planning Control)
7.2 E-Admin (Administration)
7.3 EARS (Electronic Attendance Recording System)
7.4 COMNET (Communication Network)
7.5 Visitor Management System
These four parts contain different modules to handle all the processing of the factory. The description of all
the four parts is given below:
7.1PPC Package:
The P.P.C package is the combination of 11 different modules. These are as follows:
i.INVENTORY MAINTENANCE & ANALYSIS
ii.PURCHASE ORDER PLANNING & CONTROL
iii.VENDOR ANALYSIS
iv.MATERIAL REQUIREMENT & PLANNING
v.PAYMENT ANALYSIS
vi.FORECASTING
vii.SHOP ORDER RELEASE
viii.WORK IN PROCESS
ix.COSTING MODULE
x.QUALITY CONTROL
xi.MAINTENANCE MANAGEMENT
Ordnance Clothing Factory, Shahjahanpur 13

14. S No. Name of Module Reports
I INVENTORY
MAINTENANCE &
ANALYSIS
1.Slow Moving/Non Moving Report
2.Task Force Report
3.Surplus/Waste Item Report
4.Flag Stock Maintenance Report
5.Critical (Folder) Item Report
6.Outstanding Dues against an Item
7.Daily Receipt Report
8.List of Pending Requisition/SIS
9.‘A’ category Item Report
10.Stock Availability Report
IiPURCHASE ORDER
PLANNING & CONTROL
1.Pending supply order on date
2.CST Generation through On-Line
3.Ranking Statement Generation
4.Direct PO on pre-printed format
5.List of pending TE, CP
IiiVENDOR ANALYSIS 1.Vendor rating for a given party code
2.Vendor rating for an item for all suppliers.
3.Likely suppliers for an item
4.Supply Position for a vendor
IvMATERIAL REQUIREMENT
& PLANNING
1.Direct SHIS generation with plan, dues, stock,
WIP & deficiency
V PAYMENT ANALYSIS 1.Bills Pending with LAO
2.Budget & Pending Bills summary
3.Liaison Meeting Report on bills
Vi FORECASTING 1.Section Wise MR Requirement
2.Forecasting of indirect items
ViiSHOP ORDER RELEASE 1.Outstanding Warrant Position
2.Pending Material/Labour on Warrant
3.Warrants closed in a given period
ViiiWORK IN PROCESS 1.End Product wise daily Report
2.Cut-Component Balance Position
3.Inspection Notes pending as on date
4.Made-up Garment Report
5.Trade garments pending with firm
6.Garments pending for dispatch
7.Shop Semi (WIP) Report for whole factory.
IxCOSTING MODULE 1.Cost card (in detail)
2.Brief of Cost Card
X QUALITY CONTROL 1.Pending I/Note Report for fy & trade
2.RFR Percentage Report
Xi MAINTENANCE
MANAGEMENT
1.Machine efficiency Report
2.Daily Breakdown Report
Ordnance Clothing Factory, Shahjahanpur 14

15. E-ADMIN(Administration):
The E-ADMIN part is consisting of 17 different modules. These are as follows:
i.PIS (PERSONAL INFORMATION SYSTEM)
ii.GPF (GENERAL PROVIDENT FUND)
iii.FACTORY ORDERS
iv.QUARTERS MAINTENANCE
v.ESTATE SHOPS
vi.LEAVE MAINTENANCE
vii.TA/DA (TRAVELLING AND DAILY ALLOWANCE)
viii.CENTRAL REGISTRY
ix.CASH OFFICE TRANSACTION MENU
x.MED/TUTION FEE
xi.ADMIN STATISTICAL REPORT MENU
xii.HRD TRAINING SECTION
xiii.PAYROLL MANAGEMENT
xiv.L. FEE (LICENCE FEE)
7.2 EARS:
“Electronic Attendance Recording System” is used in factory for the attendance calculations of
the employees. Every employee has an identity card on to which a unique personal number and
other details like name, category is printed which recognize a particular employee. Actually this
card acts as a punching machine in the whole factory, placed at different locations.
Data is transferred through punching machines received through a HUB to a computer, where
software entitled “TIME OFFICE SYSTEM (TOS)” is used for the attendance calculation.
Ordnance Clothing Factory, Shahjahanpur 15

16. 7.3COMNET:

It is communication network used to connect the entire ordnance factories, training institute and head
quarters. The main feature of COMNET is to voice and data transfer. The data is transferred through e-
mails and voice is transferred through IP phones.
The main work of ITC is to provide support to every section in there work and solve the problems
related to programming.
All the information is handled through computers. Whole factory can use an internet environment.
Approximately 94 terminals and are located at different places in the factory attached to LAN servers.
There are also 75 PC out of which 45 computers are also in LAN connections, are used in the factory.
Peer to peer networking is used by the factory. The programming used is visual basic.
7.4VISITOR MANAGEMENT SYSTEM:
In the visitor system record the detail of the person who enter in the factory through gate pass, and
the visitors are managed by the gate pass management system with her /his identification (voter id)
In this also include the:
1.Photo
2.Address
3.Name
4.In time
5.Out time
*******
Ordnance Clothing Factory, Shahjahanpur 16

17. 8.DATA FLOW DIAGRAM
LEVEL -0 DATA FLOW DIAGRAM
Ordnance Clothing Factory, Shahjahanpur 17

18. LEVEL -1 DATA FLOW DIAGRAM


LEVEL – 2 DATA FLOW DIAGRAM
Ordnance Clothing Factory, Shahjahanpur 18

19. 9. ER DIAGRAMS
Ordnance Clothing Factory, Shahjahanpur 19

20. 10.PROJECT TITLE:
EMPLOYEE QUALIFICATION MODULE
IN PHP
10.1 Home page-
Ordnance Clothing Factory, Shahjahanpur 20

21. <html>
<head>
</head>
<body>
<frameset rows="15%,90%">
<frame src="ssas1.html" />
<frameset cols="25%,60%" noresize="noresize">
<frame src="ssas4.html" />
<frame src="ssas9.html" id="three" frameborder=0 />
</frameset>
</frameset>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 21

22. 10.2 Code Master Add.php-
Ordnance Clothing Factory, Shahjahanpur 22

23. <html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-
8859-1" />
<title>Untitled Document</title>
</head>
<body bgcolor="#eee">
<?
$qry= "select max(qcm_code) from qual_code_mstr group by qcm_code
";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
$recset=odbc_exec($congpass,$qry);
if (!$recset) {exit("Error in SQL"); }
while(odbc_fetch_row($recset))
{
$qcode = odbc_result ($recset,1);
}
$qc=($qcode+1);
echo($qc);
?>
<form name="f_leavesubmit" id="f_leavesubmit" method="get"
action="bp_add.php" >
<table bgcolor="#eee" align="centre" cellspacing="2" border="1"
cellpadding="2" border="5" bordercolor="blue">
<tr >
<td colspan="2"><h2> Enter The Following Details<h2></td>
</tr>
<tr id="r_gpid">
<td class="tdh">Code Value &nbsp;</td>
<td>
<input name="pn" value="<? echo $qc; ?>" type="text"
readonly="true"/>
&nbsp;
</td>
Ordnance Clothing Factory, Shahjahanpur 23

24. </tr>
<tr>
<td class="tdh">Code Type &nbsp;*</td>
<td>
<input name="bp" value="" type="text" />
&nbsp;
</td>
</tr>
<tr id="r_uniqidtype">
<td class="tdh">code desc *</td>
<td>
<input name="bpdt" size="30" maxlength="50" value="" type="text"
onBlur="change_case();"/> </td>
</tr>
<tr>
<td colspan="2">
<input type="Submit" value="Generate" name="B3" >
</td>
</tr>
</table>
</form>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 24

25. 10.3 Code Master Edit.php-
Ordnance Clothing Factory, Shahjahanpur 25

26. <html>
<head>
<?php
$pno=$_POST['t1'];
print($pno);
?>
</head>
<body bgcolor="#eee">
<form method="post" action="testing2.php">
<?php
$qry= "select qcm_code_desc,qcm_code from qual_code_mstr where
qcm_code='$pno'";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
$recset=odbc_exec($congpass,$qry);
if (!$recset) {exit("Error in SQL"); }
while(odbc_fetch_row($recset))
{
$pmtname = odbc_result ($recset,1);
$pmt = odbc_result ($recset,2);
?>
<table bgcolor="#eee" cellspacing="2"border="1" cellpadding="2"
border="5" bordercolor="blue">
<tr><td> Code Value:</td><td>
<input type="text" value="<? echo $pmt; ?>"name="txty"></td>
</tr><tr>
<td> Qualification Description:</td>
<td>
<input type="text" value="<? echo $pmtname; ?>" name="txt"></td>
</tr><tr>
<td colspan="2"> <input type="submit"> </td> </tr>
<?
}
?>
</form>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 26

27. 10.4 Code Master Delete.php-
Ordnance Clothing Factory, Shahjahanpur 27

28. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-
8859-1" />
<title>Untitled Document</title>
</head>
<body bgcolor=#eee>
<?php
$txt=$_POST['codev'];
$qry = "delete from qual_code_mstr where qcm_code='$txt'";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
$result=odbc_exec($congpass,$qry);

if($qry) {
?>
<script language="javascript"> alert ('Successfully Deleted !!')
</script>
<?
}
?>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 28

29. 10.5 Employee Qualification Add.php-
Ordnance Clothing Factory, Shahjahanpur 29

30. <html>
<body bgcolor="#eee">
<?php
$pno=$_POST['t1'];
$qry= "select pmt_name,pmt_dob,pmt_curr_desgn from pis_mstr_table
where pmt_per_no='$pno'";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
$recset=odbc_exec($congpass,$qry);
if (!$recset) {exit("Error in SQL"); }
while(odbc_fetch_row($recset))
{
$pmtname = odbc_result ($recset,1);
$pmtdob = odbc_result ($recset,2);
$pmtcurr = odbc_result ($recset,3);
?>
<form method="post" action="inserting.php">
<table>
<tr>
<td>Personal No: <input type="text" value="<? echo $pno; ?>"
name="pers"></td></tr>
<tr>
<td> Name: <? echo $pmtname; ?> </td>
</tr>
<tr>
<td> Dob: <? echo $pmtdob; ?> </td>
<tr>
<td> Current Designation : <? echo $pmtcurr; ?> </td>
</tr>
<?
}
?>
<?
$query="select qcm_code,qcm_code_desc from qual_code_mstr order by
qcm_code";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
Ordnance Clothing Factory, Shahjahanpur 30

31. $recset=odbc_exec($congpass,$query);
echo "<td >";
?>
<select name="qual_cd" id ="sl">
<option value=''>Select Qual Code</option>
<?php

while(odbc_fetch_row($recset))
{
$qcode=odbc_result($recset,1);
$qdesc=odbc_result($recset,2);
echo "<option value='$qcode'>$qcode : $qdesc";
}
?>
</select>
<br>
Enter Starting Date:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text"
name="d1"><br>
Enter Ending Date:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input
type="text" name="d2">
<br><input type="submit" value="Submit" >
</form>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 31

32. 10.6 Employee Qualification Delete.php-
Ordnance Clothing Factory, Shahjahanpur 32

33. <html>
<body bgcolor=#eee>
<?php
$select=$_POST['qual_cd'];
$pers=$_POST['pers'];
echo $select,$pers;
$qry = "delete from pis_qual_dtl where pqd_per_no='$pers' and
pqd_qual_cd='$select'";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
$result=odbc_exec($congpass,$qry);

if($qry) {
?>
<script language="javascript"> alert ('Successfully Deleted !!')
</script>
<?
}
?>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 33

34. 10.7 Code Master Report.php-
Ordnance Clothing Factory, Shahjahanpur 34

35. <html>
<head>
<title>textvalue</title>
</head>
<body bgcolor=#eee>
<?php
$qry= "select qcm_code,qcm_code_desc,qcm_code_type from
qual_code_mstr order by qcm_code ";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
echo "<table border=1>";
echo "<tr><td> --Code Value--</td><td>------------------ Qualification
Descriptions-------------------</td></tr>";
$recset=odbc_exec($congpass,$qry);
if (!$recset) {exit("Error in SQL"); }
while(odbc_fetch_row($recset))
{
$pqdperno = odbc_result ($recset,1);
$pqdqualcd = odbc_result ($recset,2);
$pqdqualdt = odbc_result ($recset,3);
?>
<tr>
<td> <? echo $pqdperno; ?> </td>
<td> <? echo $pqdqualcd; ?> </td>
</tr>
<?
}
?>
</table>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 35

36. 10.8 Employee Qualification Report.php-
Ordnance Clothing Factory, Shahjahanpur 36

37. <html>
<head>
<title>textvalue</title>
</head>
<body bgcolor=#eee>
<?php
$qry= "select pqd_per_no,pqd_qual_cd,pqd_qual_dt,pqd_qual_entdt
from pis_qual_dtl order by pqd_per_no ";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
echo "<table border=1>";
echo "<tr><td> Personal No </td><td>Qualification Code</td><td>--
Starting Date-- </td><td> --Ending Date-- </td></tr>";
$recset=odbc_exec($congpass,$qry);
if (!$recset) {exit("Error in SQL"); }
while(odbc_fetch_row($recset))
{
$pqdperno = odbc_result ($recset,1);
$pqdqualcd = odbc_result ($recset,2);
$pqdqualdt = odbc_result ($recset,3);
$pqdqualentdt = odbc_result ($recset,4);
?>
<tr>
<td> <? echo $pqdperno; ?> </td>
<td> <? echo $pqdqualcd; ?> </td>
<td> <? echo $pqdqualdt; ?> </td>
<td> <? echo $pqdqualentdt ?>
</td>
</tr>
<?
}
?>
</table>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 37

38. 10.9 Employee Wise Report.php-
Ordnance Clothing Factory, Shahjahanpur 38

39. <html>
<head>
<title>textvalue</title>
</head>
<body bgcolor=#eee>
<?php
$pers=$_POST['t1'];
$qry= "select
pqd_per_no,pqd_qual_cd,pqd_qual_dt,pqd_qual_entdt,qcm_code_desc
from pis_qual_dtl,qual_code_mstr where pqd_per_no='$pers' and
pqd_qual_cd=qcm_code ";
$congpass=odbc_connect("eadmin","informix","uniline") or die("could
not connect m");
echo "<table border=1>";
echo "<tr><td> Per No </td><td>Qualification code</td><td>Qual
Description</td><td>Start Date </td><td> End Date </td></tr>";
$recset=odbc_exec($congpass,$qry);
if (!$recset) {exit("Error in SQL"); }
while(odbc_fetch_row($recset))
{
$pqdperno = odbc_result ($recset,1);
$pqdqualcd = odbc_result ($recset,2);
$pqdqualdt = odbc_result ($recset,3);
$pqdqualentdt = odbc_result ($recset,4);
$pqdqualdesc = odbc_result ($recset,5);
?>
<tr><td><?echo $pqdperno; ?> </td>
<td><? echo $pqdqualcd; ?> </td>
<td><? echo $pqdqualdesc; ?> </td>
<td><? echo $pqdqualdt; ?> </td>
<td><? echo $pqdqualentdt ?></td>
</tr>
<?
}
?>
</table>
</body>
</html>
Ordnance Clothing Factory, Shahjahanpur 39

40. 11. BIBLIOGRAPHY
Beginning PHP5 by WROX.
www.ofbindia.nic.in
www.wikipedia.com
Head First PHP & MySQL by Lynn Beighley and Michael Morrison(O’Reilly)
Ordnance Clothing Factory, Shahjahanpur 40