desc books; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | title | varchar(20) | NO | PRI | NULL | | | number | int(11) | YES | | NULL | | | author | varchar(20) | YES | | NULL | | | publisher | varchar(20) | YES | | NULL | | | edition | int(11) | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ */ $user = "test"; $pass = "test"; $host = "localhost"; $db = "test"; if (!isset ($_POST["choice"])) { //display choice form ?>

Insert new book
Search for a book

Title:


Title:
Number:
Author:
Edition:
Publisher:


\n"); mysql_select_db ($db); $query = "select * from books where title='$title'"; $result = mysql_query ($query) or die ("Query error.
\n"); if (mysql_num_rows ($result) == 0) echo "Book not found..
\n"; else { $row = mysql_fetch_assoc ($result); echo "Title: " . $row["title"] . "
\n"; echo "Number: " . $row["number"] . "
\n"; echo "Publisher: " . $row["publisher"] . "
\n";; echo "Edition: " . $row["edition"] . "
\n"; echo "Author: " . $row["author"] . "
\n"; } echo "Click here to continue.
\n"; } break; case "insertsubmit": { //submit the book data $connection = mysql_connect ($host, $user, $pass) or die ("Error in connecting to db
\n"); mysql_select_db ($db); $title = $_POST["title"]; $number = $_POST["number"]; $author = $_POST["author"]; $publisher = $_POST["publisher"]; $edition = $_POST["edition"]; $query = "insert into books values ('$title', '$number', '$author', '$publisher' , '$edition')"; mysql_query ($query) or die ("Insertion failed..
\n"); echo "Insertion successful.
\n"; echo "Click here to continue.
\n"; } break; } ?>