connect_errno ) die( 'Failed to connect to MySQL: ' . $conn->connect_error ); echo " "; $q = $_GET["q"]; $sql = "select * from bookList where ISBN ='". $q . "'"; $result = $conn->query( $sql ); // Print the results row by row. if ( $result->num_rows > 0 ) { while ( $row = $result->fetch_assoc( ) ) { echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "

ISBN	Title	Price
" . $row['ISBN'] . "	" . $row['title'] . "	" . $row['price'] . "

"; // Close the database connection. $conn->close( ); ?>