Monday, September 14, 2015

Project Synopsis - “MATERNITY CENTRE”

How to make a Project Synopsis?

Important points for Project Synopsis

  1. Title of Project
  2. Objective of the Project
  3. Input of Project
  4. Output of Project
  5. Process Logic
  6. Limitation of Project
  7. Description of  Hardware and Software for Project Development
  8. Are you doing this project for any Industry/Client?
  9. Scope of future application

             


Title of the project


Objective of the Project


The main objectives comes after the computerization of “MATERNITY CENTRE”.

Ø Improved processing speed in nursing home
Ø Enhance capacity to process a greater amount of activity
Ø Providing ability in conducting complex search
Ø Faster retrieval of information
Ø Greater accuracy and consistency
Ø Reducing paper Work
Ø Reducing cost than using computing capability to process data at a lower cost than possible with other methods, while maintaining accuracy and performance levels.
Ø Improved arrangement for patients
Ø Reduces involvement of manpower




Input to the project


Once we know about our goal, we can easily determine what the input should be. Sometimes it may happen that the required information may not be readily available in the proper form. This may be because of the existing forms are not properly designed. If the information is vital to the system we should make all possible effort to make it available. In this project the main input are



Patient infomation

Field Name
Patient Name
Patient Id
Husband_name
Address
Blood_group
Lmp






Treatment condition


Field Name

p_id
vdrl
abo grouping
pv examination
pulse
blood pressure
twin pregnence




After the input of all these information computer process all the entered information and take the decision about the delivery. It also takes the input for billing module. And on the basis of that my system will generate the bill.


    Out of the project


      Before developing a system we must have to determine our objective or goals. As we know only a well defined and objective highlights the need for plan. What do we intended to achieve, what is the purpose of our work. Defining aim is very vital in system work. In the other words if we do not know where we want to go and we should not know when we have to reach there.

I also have some aim, objective goal before developing the software. The main output of my system is patient list form, patient report form, and billing details.


     Process Logic




As I wrote above that my project is related to “MATERNITY MANAGEMENT SYSTEM”. In my project I fed some condition of about the pregnancy such as the position of child, blood pressure, child kicking, trasverse lie, pulse etc and after processing it is produces that how child will be issued either by operation and normal condition. After that it will calculate bill. To clear my process logic I am describing here some diagrams such as Data Flow Diagram.




Limitation of the project

Ø This project doesn’t cover all schemes that are issued by Nursing Home
Ø This project has not any connection with Medical Treatment of Nursing Home
Ø It does not make support Network.
Ø It does not make any type of back up file.
Ø Not any sorting technique used for fast access.
Ø It supports sequential searching techniques only.
Ø Only keyword used as input device.
Ø Although there may be many sections in Nursing Home but this project deserves only billing section.
Ø Some Terms which are used in project is assumed.






Tools/ Platforms, Language to be used


Ø HARDWARE CONFIGURATION
§ Microprocessor – Pentium IV
§ Motherboard – 933 E
§ Hard Disk – 40 GB
§ RAM – 128MB
§ Cache Memory – 256k
§ Multimedia keyboard with 108 keys
§ Mouse – Logitech Scroll Mouse
§ Color Monitor with 17”
§ Floppy disk drive
§ CD ROM drive 52X
§ UPS 500VA
§ Scanner N64 OP
§ Printer – Laser






Ø SOFTWARE REQUIRMENTS


§ OPERATING SYSTEM : WINDOWS XP2
§ PROGRAMMING LANGUAGE : OOPS IN C++
§ COMPILER : TURBO C++ IDE 3.O
§ DOCUMENTATION IN MS-WORD 2000






Are you doing this project for any Industry/Client?

YES,
Dr. XXXXXX
XXX XX Nursing home
XXXXXX city
XXXXXX -110011

-------------------------------------------------End-------------------------------------------------------

  1. Project Documentation -  Index 
  2. Project Documentation - Introduction
  3. Project Documentation - Acknowledgement 
  4. Project Documentation - Objective
  5. Project Documentation - Advantages of New Computerized System
  6. Project Documentation - Drawback with the existing System
  7. Project Documentation - Tools / Platforms, Languages to be used
  8. Project Documentation - Reason Behind choosing C++ 

Wednesday, August 26, 2015

PROJECT FOR BCA/MCA/B.TECH/MBA(IT)

STUDENT INFORMATION SYSTEM

Project---Student Information System

  • Make a folder and folder name is "student"
  • Make a folder in "student" folder and folder name is "admin"
  • Make a folder in "admin" folder and folder name is "image"
  • Now start make files for project 
  • All folders and files must be according instructions


insert.php(admin folder)

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
      <p align="center">&nbsp;</p>
      <form id="form1" name="form1" method="get" action="insert2.php">
        <table align="center" width="291" border="0">
          <tr>
            <td width="129"><strong>Name of Student:</strong></td>
            <td width="152"><label>
              <input type="text" name="name" id="textfield" />
            </label></td>
          </tr>
          <tr>
            <td><strong>Roll #:</strong></td>
            <td><input type="text" name="rollno" id="textfield2" /></td>
          </tr>
          <tr>
            <td><strong>Registration #:</strong></td>
            <td><input type="text" name="reg" id="textfield3" /></td>
          </tr>
          <tr>
            <td><strong>Department Name</strong>:</td>
            <td><input type="text" name="dept" id="textfield4" /></td>
          </tr>
        </table>
        <p align="center">
          <label>
            <input type="submit" name="button" id="button" value="Submit" />
          </label>
        </p>
        <p align="center"><a href="./"><img border="0" src="images/cooltext457951462.png" alt="Go Back" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /></a></p>
      </form>
<p align="center"></p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>

insert2.php(admin folder)

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
  <p align="center">
    <?php
$sname=$_REQUEST['name'];
$roll=$_REQUEST['rollno'];
$reg=$_REQUEST['reg'];
$dept=$_REQUEST['dept'];

$link=mysql_connect("localhost","root","") or die("Cannot Connect to the database!");

mysql_select_db("department",$link) or die ("Cannot select the database!");
$query="INSERT INTO students (sname, rollno, regno, dname) values('".$sname."', '".$roll."', '".$reg."', '".$dept."')";

 if(!mysql_query($query,$link))
 {die ("An unexpected error occured while saving the record, Please try again!");}
 else
{
 echo "New record saved successfully!";}
?>

      </p>
      <p align="center"><img onclick="javascript: history.go(-1)" src="images/cooltext457951462.png" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /><a href="../"><img border="0" src="images/cooltext457951615.png" onmouseover="this.src='images/cooltext457951615MouseOver.png';" onmouseout="this.src='images/cooltext457951615.png';" /></a></p>
      <p align="left">&nbsp;</p>
    <p align="left">&nbsp;</p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>

image folder


delete.php(admin folder)

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
  <p align="center">
    <?php
$link=mysql_connect("localhost","root","") or die("Cannot Connect to the database!");

mysql_select_db("department",$link) or die ("Cannot select the database!");
$query="SELECT * FROM students";

 $resource=mysql_query($query,$link);
 echo "
<table align=\"center\" border=\"0\" width=\"70%\">
<tr>
<td><b>Name</b></td> <td><b>Roll No.</b></td><td><b>Reg No.</b></td><td><b>Deparment</b></td><td><b>Action</b></td></tr> ";
while($result=mysql_fetch_array($resource))
{
echo "<tr><td>".$result[1]."</td><td>".$result[2]."</td><td>".$result[3]."</td><td>".$result[4]."</td><td>
<a href=\"delete2.php?id=".$result[0]."\"><img border=\"0\" src=\"images/cooltext457952800.png\" onmouseover=\"this.src='images/cooltext457952800MouseOver.png';\" onmouseout=\"this.src='images/cooltext457952800.png';\" /></a>
</td></tr>";
} echo "</table>";
?>

      </p>
  <p align="center">&nbsp;</p>
      <p align="center"><a href="./"><img border="0" src="images/cooltext457951462.png" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /></a><a href="../"><img border="0" src="images/cooltext457951615.png" onmouseover="this.src='images/cooltext457951615MouseOver.png';" onmouseout="this.src='images/cooltext457951615.png';" /></a></p>
      <p align="center"></p>
    <p align="left">&nbsp;</p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>

delete2.php(admin folder)

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
  <p align="center">
    <?php 
$id=$_REQUEST['id']; 
 
$link=mysql_connect("localhost","root","") or die("Cannot Connect to the database!");

mysql_select_db("department",$link) or die ("Cannot select the database!");
$query="DELETE FROM students WHERE id='".$id."'";

 if(!mysql_query($query,$link))
 {die ("An unexpected error occured while <b>deleting</b> the record, Please try again!");}
 else
{
 echo "Record ".$id." removed successfully!";}
?>

      </p>
      <p align="center"><a href="delete.php"><img border="0" src="images/cooltext457951462.png" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /><a href="../"></a><a href="./"><img border="0" src="images/cooltext457951615.png" onmouseover="this.src='images/cooltext457951615MouseOver.png';" onmouseout="this.src='images/cooltext457951615.png';" /></a></p>
      <p align="left">&nbsp;</p>
    <p align="left">&nbsp;</p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>

modify.php(admin folder)

7. Make a file "modify.php" and put in "admin" folder.

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
  <p align="center">
    <?php
$link=mysql_connect("localhost","root","") or die("Cannot Connect to the database!");

mysql_select_db("department",$link) or die ("Cannot select the database!");
$query="SELECT * FROM students";

 $resource=mysql_query($query,$link);
 echo "
<table align=\"center\" border=\"0\" width=\"70%\">
<tr>
<td><b>Name</b></td> <td><b>Roll No.</b></td><td><b>Reg No.</b></td><td><b>Deparment</b></td><td><b>Action</b></td></tr> ";
while($result=mysql_fetch_array($resource))
{
echo "<tr><td>".$result[1]."</td><td>".$result[2]."</td><td>".$result[3]."</td><td>".$result[4]."</td><td>
<a href=\"modify2.php?id=".$result[0]."\"><img border=\"0\" src=\"images/cooltext457953689.png\"/></a>
</td></tr>";
} echo "</table>";
?>

      </p>
  <p align="center">&nbsp;</p>
      <p align="center"><a href="./"><img border="0" src="images/cooltext457951462.png" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /></a><a href="./"><img border="0" src="images/cooltext457951615.png" onmouseover="this.src='images/cooltext457951615MouseOver.png';" onmouseout="this.src='images/cooltext457951615.png';" /></a></p>
    <p align="center"></p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>

modify2.php(admin folder)

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
  <p align="center">
    <?php
$id=$_REQUEST['id'];

$link=mysql_connect("localhost","root","") or die("Cannot Connect to the database!");

mysql_select_db("department",$link) or die ("Cannot select the database!");
$query="SELECT * FROM students WHERE id='".$id."'";

$resource=mysql_query($query,$link) or die ("An unexpected error occured while <b>deleting</b> the record, Please try again!");
 $result=mysql_fetch_array($resource);

?>
     <form id="form1" name="form1" method="get" action="modify3.php">
        <table align="center" width="291" border="0">
          <tr>
            <td width="129"><strong>Name of Student:</strong></td>
            <td width="152">
            <input type="hidden" name="id" value="<?php echo $result[0] ?>"  />
            <label>
              <input name="name" type="text" id="textfield" value="<?php echo $result[1] ?>" />
            </label></td>
          </tr>
          <tr>
            <td><strong>Roll #:</strong></td>
            <td><input name="rollno" type="text" id="textfield2" value="<?php echo $result[2] ?>" /></td>
          </tr>
          <tr>
            <td><strong>Registration #:</strong></td>
            <td><input type="text" name="reg" id="textfield3" value="<?php echo $result[3] ?>" /></td>
          </tr>
          <tr>
            <td><strong>Department Name</strong>:</td>
            <td><input type="text" name="dept" id="textfield4" value="<?php echo $result[4] ?>" /></td>
          </tr>
        </table>
        <p align="center">
          <label>
            <input type="submit" name="button" id="button" value="Modify" />
          </label>
        </p>
        <p align="center"><img onClick="javascript: history.go(-1)" border="0" src="images/cooltext457951462.png" alt="Go Back" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /></p>
        <p align="center"><a href="./"><img border="0" src="images/cooltext457951615.png" onmouseover="this.src='images/cooltext457951615MouseOver.png';" onmouseout="this.src='images/cooltext457951615.png';" /></a></p>
      </form>

      </p>
      <p align="center"><a href="delete.php"><a href="../"></a></p>
      <p align="left">&nbsp;</p>
    <p align="left">&nbsp;</p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>

modify3.php(admin folder)

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
  <p align="center">
    <?php
$id=$_REQUEST['id'];
$sname=$_REQUEST['name'];
$roll=$_REQUEST['rollno'];
$reg=$_REQUEST['reg'];
$dept=$_REQUEST['dept'];

$link=mysql_connect("localhost","root","") or die("Cannot Connect to the database!");

mysql_select_db("department",$link) or die ("Cannot select the database!");
$query="UPDATE students SET sname='".$sname."', rollno='".$roll."', regno='".$reg."', dname='".$dept."' WHERE id='".$id."'";

 if(!mysql_query($query,$link))
 {die ("An unexpected error occured while saving the record, Please try again!");}
 else
{
 echo "Record updated successfully!";}
?>

      </p>
      <p align="center"><a href="./"><img border="0" src="images/cooltext457951462.png" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /></a><a href="../"><img border="0" src="images/cooltext457951615.png" onmouseover="this.src='images/cooltext457951615MouseOver.png';" onmouseout="this.src='images/cooltext457951615.png';" /></a></p>
      <p align="left">&nbsp;</p>
    <p align="left">&nbsp;</p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>

index.php(admin folder)

2. Make a file "index.php" and put in "admin" folder(Don't Confuse this is different index file and it is in admin folder.).


Code Of "index.php"

<!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=utf-8" />
<title>Control Panel :: Student Information Panel</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="images/cooltext457948700.png" width="747" height="58" alt="Welcome to Admin Panel" /></h1>
      <p align="center">&nbsp;</p>
      <table width="638" border="0" align="center">
        <tr>
          <td width="107"><a href="insert.php"><img border="0" name="test
     " src="images/cooltext457947887.png" onmouseover="this.src='images/cooltext457947887MouseOver.png';" onmouseout="this.src='images/cooltext457947887.png';" /></a></td>
          <td width="515" class="options">to enter a new student record...</td>
        </tr>
        <tr>
          <td><a href="delete.php"><img border="0" src="images/cooltext457947999.png" onmouseover="this.src='images/cooltext457947999MouseOver.png';" onmouseout="this.src='images/cooltext457947999.png';" /></a></td>
          <td class="options">to delete a student record..</td>
        </tr>
        <tr>
          <td><a href="modify.php"><img border="0" src="images/cooltext457948094.png" onmouseover="this.src='images/cooltext457948094MouseOver.png';" onmouseout="this.src='images/cooltext457948094.png';" /></a></td>
          <td class="options">to modify a student record...</td>
        </tr>
      </table>
      <p align="center"><a href="../"><img border="0" src="images/cooltext457951462.png" alt="Go Back" onmouseover="this.src='images/cooltext457951462MouseOver.png';" onmouseout="this.src='images/cooltext457951462.png';" /></a></p>
    <p align="center"></p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>



index.php(student folder)

1. Make a file "index.php" and put in "student" folder.


Code Of "index.php"


<!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=utf-8" />
<title>Welcome</title>
<style type="text/css">
<!--
.heading {
color: #F90;
font-family: "Comic Sans MS", cursive;
}
.options {
font-family: "Comic Sans MS", cursive;
font-size: 16px;
font-style: oblique;
color: #F93;
}
-->
</style>
</head>

<body background="admin/images/1019286_abstract_orange_tiles_background_.jpg">

<br />
<br />
<br />
<table align="center" cellpadding="0" bgcolor="#FFFFFF" width="800" border="0">
  <tr>
    <td><h1 align="center" class="heading"><img src="admin/images/computer.jpg" width="304" height="42" /></h1>
      <h1 align="center" class="heading"><img src="admin/images/cooltext457954659.png" width="830" height="51" alt="Welcome to Site" /></h1>
      <p align="center">
        <?php
   $link=mysql_connect("localhost","root","") or die("Cannot Connect to the database!");

 mysql_select_db("department",$link) or die ("Cannot select the database!");
 $query="SELECT * FROM students";

  $resource=mysql_query($query,$link);
  echo "
<table align=\"center\" border=\"0\" width=\"70%\">
<tr>
<td><b>Name</b></td> <td><b>Roll No.</b></td><td><b>Reg No.</b></td><td><b>Deparment</b></td></tr> ";
while($result=mysql_fetch_array($resource))
{
echo "<tr><td>".$result[1]."</td><td>".$result[2]."</td><td>".$result[3]."</td><td>".$result[4]."</td></tr>";
} echo "</table>";
 ?>
   
      </p>
  <p align="center">&nbsp;</p>
      <p align="center"><a href="admin/index.php"><img border="0" src="admin/images/cooltext457954941.png" onmouseover="this.src='admin/images/cooltext457954941MouseOver.png';" onmouseout="this.src='admin/images/cooltext457954941.png';" /></a></p>
      <center>
   
      </center>
    <p align="left">&nbsp;</p></td>
  </tr>
</table>
<h1 align="center" class="heading">&nbsp;</h1>
</body>
</html>