MySql Table Structure (newrecords)
Column |
Type |
Null |
Default |
Comments |
ID |
int(11)
|
No |
|
|
Name |
varchar(20)
|
No |
|
|
Class |
varchar(20)
|
No |
|
|
Complete Example
<!DOCTYPE HTML>
<html>
<head>
<title>The Complete Example</title>
</head>
<body>
<p style="font-weight: bold;">Records</p>
<hr>
<form name="form1" action="">
<p>
<label for="Name">Name</label>
<input type="text" name="Name" id="Name">
</p>
<p>
<label for="Class">Class</label>
<input type="text" name="Class1" id="Class1">
</p>
<p>
<input type="submit" name="Submit" id="Submit" value="Submit">
</p>
</form>
<p style="font-weight: bold;"> all entered data </p>
<hr>
<?php
$db_server = mysql_connect("localhost", "username", "password");
if (! $db_server)
die("Unable to connect to MySQL: " . mysql_error());
mysql_select_db("database_Name", $db_server) or
die("Unable to select database: " . mysql_error());
if ((isset($_GET['Name'])) && (! empty($_GET['Name'])) && (! empty($_GET['Class1'])) && (! empty($_GET['Class1'])))
{
$query = "INSERT INTO newrecords(Name,Class) VALUES('" . $_GET['Name'] . "','" . $_GET['Class1'] . "');";
$result = mysql_query($query);
if (! $result)
die("Database access failed: " . mysql_error());
else
echo "record inserted";
}
if ((isset($_GET['delete'])) && (! empty($_GET['delete'])))
{
$query = " DELETE FROM `newrecords` WHERE ID =" . $_GET['delete'];
$result = mysql_query($query);
if (! $result)
die("Database access failed: " . mysql_error());
else
echo "record deleted";
}
$query = "SELECT * FROM newrecords";
$result = mysql_query($query);
if (! $result)
die("Database access failed: " . mysql_error());
$rows = mysql_num_rows($result);
if ($rows > 1)
{
?>
<table width="100%" border="1">
<?php
}
for ($j = 0; $j < $rows; ++ $j) {
$row = mysql_fetch_row($result);
?>
<tr>
<td><?php echo $row[0]?> </td>
<td><?php echo $row[1]?> </td>
<td><?php echo $row[2]?> </td>
<td><a href="index.php?delete=<?php echo $row[0] ?>">delete</a></td>
</td>
</tr>
<?php
}
?>
</table>
</body>
</html>