<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Wines</title>
</head>
<body> <pre>
<?php
// (1) Open the database connection
$connection = mysql_connect("localhost","fred","shhh");
// (2) Select the winestore database
mysql_select_db("winestore", $connection);
// (3) Run the query on the winestore through the connection
$result = mysql_query ("SELECT * FROM wine", $connection);
// (4) While there are still rows in the result set, fetch the current
// row into the array $row
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{ // (5) Print out each element in $row, that is, print the values of
// the attributes
foreach ($row as $attribute)
print "{$attribute} ";
// Print a carriage return to neaten the output print "\n"; }
?>
</pre>
</body>
</html>
<title>Wines</title>
</head>
<body> <pre>
<?php
// (1) Open the database connection
$connection = mysql_connect("localhost","fred","shhh");
// (2) Select the winestore database
mysql_select_db("winestore", $connection);
// (3) Run the query on the winestore through the connection
$result = mysql_query ("SELECT * FROM wine", $connection);
// (4) While there are still rows in the result set, fetch the current
// row into the array $row
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{ // (5) Print out each element in $row, that is, print the values of
// the attributes
foreach ($row as $attribute)
print "{$attribute} ";
// Print a carriage return to neaten the output print "\n"; }
?>
</pre>
</body>
</html>
Connect to the server with the MySQL function mysql_connect(
) .We use three parameters here: the
hostname of the database server, a username, and a password. Let's assume here
that MySQL is installed on the same server as the scripting engine and,
therefore, localhost is the hostname. If the servers are on different
machines, you can replace localhost with the domain name of the
machine that hosts the database server.
The function mysql_connect( ) returns a connection resource that is used later to work with the
server. Many server functions return resources that you pass to further calls.
In most cases, the variable type and value of the resource isn't important: the
resource is simply stored after it's created and used as required.