Dbconn.php
<?php
session_start();
ob_start();
error_reporting(0);
$serverName = "localhost";
$dbUserName = "root";
$dbPassword ="";
$dbName = "student";
mysql_connect($serverName,$dbUserName,$dbPassword)
or die(mysql_error());
mysql_select_db($dbName);
Index.php
<?php
require('dbconn.php');
?>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<form action="" method="post">
<h1 align="center"><u>Student Database Table</u></h1>
<table align="center">
<tr>
<td>Name</td>
<td> <input type="text" name="t1"/> </td>
</tr>
<tr>
<td>Roll No</td>
<td> <input type="text" name="t2"/> </td>
</tr>
<tr>
<td>Marks</td>
<td> <input type="text" name="t3"/> </td>
</tr>
<tr>
<td></td>
<td> <input type="submit" value="Submit" name="btn"/> </td>
</tr>
</table>
<?php
if(isset($_POST['btn']))
{
$name = $_POST['t1'];
$roll = $_POST['t2'];
$marks = $_POST['t3'];
$sql = "INSERT INTO student VALUES('','$name','$roll','$marks')";
mysql_query($sql) or die(mysql_error());
}
?>
</form>
<br/><br/><h3><a href="data.php">Show Student Database</a></h3>
</body>
</html>
Data.php
<?php
require('dbconn.php');
ob_start();
?>
<html>
<head>
<title>Student Database</title>
<style>
td{
padding: 10px;
}
th{
padding: 10px;
}
</style>
</head>
<body>
<h3 align="right"><a href="index.php">Go to Home Page</a></h3>
<h1 align="center"><u>Student Database</u></h1>
<table align="center" border="1">
<th>Id</th>
<th>Name</th>
<th>Roll</th>
<th>Marks</th>
<?php
$sql = "select * from student";
$result=mysql_query($sql);
while($rws = mysql_fetch_assoc($result)){ ?>
<tr><td><?php echo $rws['Id']."\n"; ?> </td>
<td><?php echo $rws['Name']."\n"; ?> </td>
<td><?php echo $rws['Roll']."\n"; ?> </td>
<td><?php echo $rws['Marks']."\n"; ?> </td>
<?php } ?>
</table>
</body>
</html>
No comments:
Post a Comment