To merely display the information in your database without the
use of a form to call a php script you simply create your HTML
document as you would any other web page but instead of the
extension of .htm or .html you need to name the file with the
extension .php. Then within the document itself the
section that you'd like to be the PHP code, you begin it with <?
and end it with ?>. For instance:
<P>These are the
products I sell:</P>
<TABLE BORDER="1">
<?
mysql_connect("localhost", username, password);
$result = mysql(mydatabase, "select * from products");
$num = mysql_numrows($result);
$i = 0;
while($i < $num) {
echo "<TR>n";
echo "<TD>n";
echo mysql_result($result,$i,"prodid");
echo "</TD>n<TD>";
echo mysql_result($result,$i,"name");
echo "</TD>n<TD>";
echo mysql_result($result,$i,"price");
echo "</TD>n";
echo "</TR>n";
$i++;}
?>
</TABLE>
Thus having the loop in the php program create a table with the
products listed. NOTE your username and password for the
database are not written in the file when it's displayed on the
Internet so users viewing the source of your webpage will not
see your password.
When using a CGI script to pull information from a form which
has been submitted by a browser you must have the first line of
the script have this command on it (Much like perl scripts):
#!/usr/local/bin/php |
 |
MySQL/PHP - two great tutorials:
PHP/MySQL Tutorial Overview
http://hotwired.lycos.com/webmonkey/
programming/php/tutorials/tutorial4.html
Open source has brought a lot more than Linux to the computing
world. It has also given us PHP and MySQL. According to this
Webmonkey tutorial, PHP and MySQL are the world's best
combination for creating data-driven sites. In the first
installment of this three-lesson tutorial, he covers everything
you need to know to begin developing database hubs. He gives
instructions for installation on both Unix and Windows, and then
goes on to show some simple scripts that will insert information
into a database and display that data on a Web page.
Building a Database-Driven Web Site Using PHP and MySQL
http://www.webmasterbase.com/article.php?aid=228
In this 10-part weekly series of articles, the author provides a
hands-on look at what's involved in building a database-driven
Web site using the PHP scripting language and the MySQL
relational database.
|