Database Reference
In-Depth Information
print
"
$common_name
- <i>
$scientific_name
</i> <br/>"
;
}
$sth->
close
();
$connect->
close
();
?>
</body>
</html>
This example is almost the same as the two major sections shown previously. We've ad-
ded opening and closing HTML tags and some with text in between the two PHP code
snippets. We also positioned a couple of the lines in different places, but it flows the same.
Here's the text returned to the web user when searching forAvocet birds:
Birds - "Avocet"
Below is a list of birds in our database based on your search
criteria:
Pied Avocet -
Recurvirostra avosetta
Red-necked Avocet -
Recurvirostra novaehollandiae
Andean Avocet -
Recurvirostra andina
American Avocet -
Recurvirostra americana
Mountain Avocetbill -
Opisthoprora euryptera
More Information
If you would like tolearn more about using the PHP API
mysqli
, there's an extensive
manual on the PHP site, including a
MySQL Improved Extension manual
. You might also
like to read Robin Nixon's book,
Learning PHP, MySQL & Javascript
(O'Reilly) to learn
more about using PHP within web pages to accessMySQL.