Submitted by: Submitted by gram0120
Views: 175
Words: 670
Pages: 3
Category: Other Topics
Date Submitted: 10/16/2012 03:46 PM
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"/>
<title>Books</title>
</head>
<body>
<form method = "post">
<table>
<tr>
<td>Title:</td>
<td><input type="text" name="title"/></td>
</tr>
<tr>
<td>Author</td>
<td><input type="text" name="author"/></td>
</tr>
<tr>
<td>Publisher Name</td>
<td><input type="text" name="name"/></td>
</tr>
<tr>
<td>Copyright Year</td>
<td><input type="text" name="copy"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="add"/></td>
</table>
<?php
if (isset($_POST['submit']))
{
include'db.php';
$title=$_POST['title'];
$author=$_POST['author'];
$name=$_POST['name'];
$copy=$_POST['copy'];
mysql_query("INSERT INTO 'books' (Title, Author,PublisherName,CopyrightYear) VALUES ('$title','$author','$name','$copy')");
}
?>
</form>
<table border = "1">
<?php
include("db.php");
$result=mysql_query("SELECT * FROM books");
while ($test=mysql_fetch_array($result))
{
$id=$test['BookID'];
echo "<tr align='center'>";
echo"<td><font color='black'>".$test['BookID']."</font></td>";
echo"<td><font color='black'>".$test['Title']."</font></td>";
echo"<td><font color='black'>".$test['Author']."</font></td>";
echo"<td><font color='black'>".$test['PublisherName']."</font></td>";
echo"<td><font color='black'>".$test['CopyrightYear']."</font></td>";
/**echo "<td><a...