Accessing mysql from my php script

dobbouk

Whenever I try to search for a record in my database, it just displays my PHP Script. I've been given this PHP code by the administrators in my university to use to access MySQL:

PHP Script

<?php
include_once(DB.php);
$dbtype = 'mysql';
$dbuser = ='user';
$dbpass = 'pass';
$dbhost='host';
$dbname = 'cmptdobb';
$dsn="$dbtype://$dbuser:$dbpass@$dbhost/$dbname";
$db=DB::connect($dsn);
if(DB::isError($db)){
die($db-getMessage());
}
$resultset=$db->query("Select * FROM products1");
while($row = $resultset->fetchRow(DB_FETCHMODE_ASSOC)){
echo $row["ProductName"]. ";
}
$db->disconnect();
?>

and my HTML Script is:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
  <title>Book-O-Rama Catalog Search</title>
</head>
<body>
  <h1>Book-O-Rama Catalog Search</h1>
  <form action="DB.php" method="post">
    Choose Search Type: <br />
    <select name="searchtype">
      <option value="ProductName">Product Name</option>
      <option value="Size">Size</option>
      <option value="ProductCode">ProductCode</option>
    </select>
    <br />
    Enter Search Term: <br />
    <input name="searchterm" type="text">
    <br />
    <input type="submit" value="Search">
  </form>
</body>
</html>

johanafm

That means your php script is not recognized as a php script. Either you do not have php installed and properly configured for use with your web server, or you are using a file extension not recognized by the web server as being a php script.

halojoy

and it is horribly dangerous
putting out your details
$dbuser = ='';
$dbpass = '';
$dbhost='';
$dbname = '';
Hope some moderator edit it quickly!

bradgrafelman

I hope the administrators didn't give you that same exact script, as I immediately notice a parse error, another error involving a comparison operator versus an assignment operator, and the use of a "SELECT *" query.

But as johanafm points out, your PHP script isn't being parsed at all if you can see the code in your browser, so I would worry bout fixing that first.

EDIT: Make that 2 parse errors.