When trying to use php script to access records from mysql table getting
following error
"No input file specified."
I am using example php scripts and datatables as defined in the PHP & MySQL
for Dummies Book.
The installation is on a standalone PC and comprises the following
Windows98
Apache 1.3.23
PHP 4.3.0
MySQL 3.23
I know PHP is working through apache as I have used a sample test page which
shows the configuration of PHP as installed. I also believe MySQL is
working as I have been able to apply the same selection SQL via MySQLadmin
as contained in the PHP script I am using to extract records. Below is the
php script I am using:
*********************************************************************
<html>
<head><title>Pet Catalog</title></head>
<body>
<?php
$user="root";
$host="localhost";
$password="password";
$database = "PetCatalog";
$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");
$pettype = "horse"; //horse was previously typed in a form by user
$query = "SELECT * FROM Pet WHERE petType='$pettype'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$nrows = mysql_num_rows($result);
/* Display results in a table */
echo "<h1>Horses</h1>";
echo "<table cellspacing='15'>";
echo "<tr><td colspan='4'><hr></td></tr>";
for ($i=0;$i<$nrows;$i++)
{
$n = $i + 1; //add 1 so that numbers don't start with 0
$row = mysql_fetch_array($result);
extract($row);
$f_price = number_format($price,2);
echo "<tr>\n
<td>$n.</td>\n
<td>$petID</td>\n
<td>$petDescription</td>\n
<td align='right'>\$$f_price</td>\n
</tr>\n";
echo "<tr><td colspan='4'><hr></td></tr>\n";
}
echo "</table>\n";
?>
</body>
</html>
********************************************************************
I think that perhaps the connections are not being made as a simple test I
have deliberately changed the host, database and password to force an error
and this does not happen.
Any help would be appreciated.
Regards
Craig
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
