All,
I am running a LAMP server on Ubuntu 8.10. Can connect to the database using
either phpmyadmin or the CLI and manipulate databases successfully. I can
also run .php files in my browser successfully provided the files do not
contain any database functions.
However, when I try to use PHP with MySQL functions, I get either a blank
page or a syntax error. What am I doing wrong?
For instance, the following code results in the syntax error:
*Parse error:* syntax error, unexpected T_STRING in *
/var/www/Test_Database_Access.php* on line 6
<html>
<head></head>
<body>
<?php
// open connection to MySQL server
$connection = mysql_connect('localhost', 'guest', 'pass') ↵
or die ('Unable to connect!');
// select database for use
mysql_select_db('northwind') or die ('Unable to select database!');
// create and execute query
$query = 'SELECT * FROM items';
$result = mysql_query($query) ↵
or die ('Error in query: $query. ' . mysql_error());
// check if records were returned
if (mysql_num_rows($result) > 0)
{
// print HTML table
echo '<table width=100% cellpadding=10 cellspacing=0 border=1>';
echo
'<tr><td><b>ID</b></td><td><b>Name</b></td><td><b>Price</b></td></tr>';
// iterate over record set
// print each field
while($row = mysql_fetch_row($result))
{
echo '<tr>';
echo '<td>' . $row[0] . '</td>';
echo '<td>' . $row[1] . '</td>';
echo '<td>' . $row[2] . '</td>';
echo '</tr>';
}
echo '</table>';
}
else
{
// print error message
echo 'No rows found!';
}
// once processing is complete
// free result set
mysql_free_result($result);
// close connection to MySQL server
mysql_close($connection);
?>
</body>
</html>
Thanks
Simon Mutama
_______________________________________________
LUG mailing list
[email protected]
http://kym.net/mailman/listinfo/lug
%LUG is generously hosted by INFOCOM http://www.infocom.co.ug/
The above comments and data are owned by whoever posted them (including
attachments if any). The List's Host is not responsible for them in any way.
---------------------------------------
