Jump to content

mystery error on line 3

happygolucky

By happygolucky
in PHP Coding Help

Recommended Posts

happygolucky Newbie

happygolucky

Posted
Posted 

<html>
    <head><title>Media Mart</title>
    </head>
        <body>
            <p>Search Media Mart:<br />
                <form action="index.php" method="post">Keyword:<br />
                <input type="text" name="keyword" size="20" maxlength="40" value="" /><br />Field:<br />
                    <select name="field">
                        <option value="">Choose field:</option>
                        <option value="artist_name">Artist</option>
                        <option value="album_name">Album</option>
                        <option value="track_name">Track</option>
                    </select>

                <input type="submit" value="Search!" />
                </form>
            </p>
<?php
// set db variables
// Edit these with your own info

$dbhost = "xxxxxxxxx.xxxx.xxxx.co.uk";
$dbuser = "xxxxxx";
$dbpass = "xxxxxxxxxx";
$dbname = "xxxxxx";

/* If the form has been submitted with a supplied keyword */
if (isset($_POST['field'])){
include "pgsql.class.php";
/* Connect to server and select database */
$pgsqldb = new pgsql($dbhost,$dbuser,$dbpass,$dbname);
$pgsqldb->connect();

/* Set the posted variables to a convenient name */
$keyword = $_POST['keyword'];
$field = $_POST['field'];

/* Create the query based on the type of search */
if ($field == "artist_name") {
	$pgsqldb->query("SELECT artist_name, genre FROM artists WHERE artist_name='$keyword'");
}
else if($field == "album_name") {
	$pgsqldb->query("SELECT album_name FROM albums WHERE album_name='$keyword'");
}
else if($field == "track_name") {
	$pgsqldb->query("SELECT track_name FROM tracks WHERE track_name='$keyword'");
}

// if records are found, output them
if ($pgsqldb->numrows() > 0){
	while ($row = $pgsqldb->fetchobject()) {
		if ($field == "artist_name") {
			echo "Artist: $row->artist_name<br />Genre: $row->genre<br />";
		}
		else if($field == "album_name"){
			echo "Album: $row->album_name<br />";
		}
		else if($field == "track"){
			echo "Track: $row->track_name<br />";
		}
	}
}
else
{
echo "No Results found.";
}
}
?>
    </body>
</html>

 

<?php
class pgsql {
   private $linkid;      // PostgreSQL link identifier
   private $host;        // PostgreSQL server host
   private $user;        // PostgreSQL user
   private $passwd;      // PostgreSQL password
   private $db;          // PostgreSQL database
   private $result;      // Query result
   private $querycount;  // Total queries executed
   /* Class constructor. Initializes the $host, $user, $passwd
      and $db fields. */
   function __construct($host, $db, $user, $passwd) {
      $this->host = $host;
      $this->user = $user;
      $this->passwd = $passwd;
      $this->db = $db;
   }
   /* Connects to the PostgreSQL Database */
   function connect(){
      try{
         $this->linkid = @pg_connect("host=$this->host dbname=$this->db
            user=$this->user password=$this->passwd");
         if (! $this->linkid)
            throw new Exception("Could not connect to PostgreSQL server.");
      }
   catch (Exception $e) {
      die($e->getMessage());
   }
}
/* Execute database query. */
function query($query){
   try{
      $this->result = @pg_query($this->linkid,$query);
      if(! $this->result)
         throw new Exception("The database query failed.");
   }
   catch (Exception $e){
      echo $e->getMessage();
   }
   $this->querycount++;
   return $this->result;
}
/* Determine total rows affected by query. */
function affectedRows(){
   $count = @pg_affected_rows($this->linkid);
   return $count;
}
/* Determine total rows returned by query */
function numRows(){
   $count = @pg_num_rows($this->result);
   return $count;
}
/* Return query result row as an object. */
function fetchObject(){
   $row = @pg_fetch_object($this->result);
   return $row;
}
/* Return query result row as an indexed array. */
function fetchRow(){
   $row = @pg_fetch_row($this->result);
   return $row;
}
/* Return query result row as an associated array. */
function fetchArray(){
   $row = @pg_fetch_array($this->result);
   return $row;
}
   /* Return total number of queries executed during
      lifetime of this object. Not required, but
      interesting nonetheless. */
   function numQueries(){
      return $this->querycount;
   }
}
/* Return the number of fields in a result set */
function numberFields() {
   $count = @pg_num_fields($this->result);
   return $count;
}
/* Return a field name given an integer offset. */
function fieldName($offset){
   $field = @pg_field_name($this->result, $offset);
   return $field;
}
function getResultAsTable() {
   if ($this->numrows() > 0) {
      // Start the table
      $resultHTML = "<table border='1'>\n<tr>\n";
      // Output the table headers
      $fieldCount = $this->numberFields();
      for ($i=0; $i < $fieldCount; $i++){
          $rowName = $this->fieldName($i);
          $resultHTML .= "<th>$rowName</th>";
      } // end for
      // Close the row
      $resultHTML .= "</tr>\n";
      // Output the table data
      while ($row = $this->fetchRow()){
          $resultHTML .= "<tr>\n";
          for ($i = 0; $i < $fieldCount; $i++)
             $resultHTML .= "<td>".htmlentities($row[$i])."</td>";
          $resultHTML .= "</tr>\n";
      }
      // Close the table
      $resultHTML .= "</table>";
   }
   else {
      $resultHTML = "<p>No Results Found</p>";
   }
   return $resultHTML;
}

function pageLinks($totalpages, $currentpage, $pagesize, $parameter) {
   // Start at page one
   $page = 1;
   // Start at record 0
   $recordstart = 0;
   // Initialize page links
   $pageLinks = '';
   while ($page <= $totalpages) {
      // Link the page if it isn't the current one
      if ($page != $currentpage) {
         $pageLinks .= "<a href=\"".$_SERVER['PHP_SELF'].
         "?$parameter=$recordstart\">$page</a> ";
      // If the current page, just list the number
      }
      else {
         $pageLinks .= "$page ";
      }
      // Move to the next record delimiter
      $recordstart += $pagesize;
      $page++;
   }
   return $pageLinks;
}

?>

 

im recieving an error message from the second part of the code that reads....

 

Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home2/webusers/07/344740/public_html/mediamart/pgsql.class.php on line 3

 

this is after i submit the search.

 

the databse was built with PuTTy onto an apache server. i may have some sill errors as im new to this. if anyone can tell me where my mistakes are id appreciate it. Thankyou

Link to comment
https://forums.phpfreaks.com/topic/157157-mystery-error-on-line-3/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.