Untitled

<html>
	<head>
	</head>
	<body>
		<?php
		$search = $_POST('search');

		$dbuser = "hpl";
		$dbpass = "Phong";
		$db = "SSID";
		$connect = oci_connect($dbuser, $dbpass, $db);

		if (!$connect)
		{
			echo "An error occurred connecting to the database";
			exit;
		}

		$query = "SELECT * FROM books WHERE book_title = 'search'";

		$stmt = oci_parse($connect, $query);

		if (!$stmt)
		{
			echo "An error occurred in parsing the sql string.\n";
			exit;
		}

		oci_execute($stmt);
		?>

		<div>
			<div id = "header">
            <span id = "title">BooksRUS</span> <br>
            <span id = "description"> Best Secondhand Book Shop in Geelong</span>
         </div>
         <div id = "mainnav">
            <a href = "ass1.html">
            <span id = "homebutton" class = "nav_button">Homepage</span>
            </a>
            <a href = "bookshelf.html" >
            <span id = "bookshelf" class = "nav_button" >Book shelf</span>
            </a>
            <a href = "bookorder.html">
            <span id = "orderbook" class = "nav_button">Order book</span>
            </a>
            <a href = "faq.html">
            <span id = "faq" class = "nav_button">FAQ/Help</span>
            </a>
            <a href = "contact.html">
            <span id = "contact" class = "nav_button">Contact us</span>
            </a>
         </div>
		 <div id = "content">
			<?php
			$howmany = 0;
			While(oci_fetch_array($stmt))
			{
				$howmany = $howmany + 1;
			}

			if ($howmany == 0)
			{
				echo<p>No result matches book name</p>
			}


			if ($howmany > 1)
			{	while(oci_fetch_array($stmt))
				{
					$name = oci_result($stmt, book_title);
					$author = oci_result($stmt, author);
					$price = oci_result($stmt, price );
					echo<p>Book name: .$name<br>;
					echo Author: .$author.<br>;
					echo Price: .$Price.</p>;
				}


			}
			?>
		 </div>
		</div>
	</body>
</html>