noob question, cant find the problem ><

johnz77 · March 19, 2010

im getting this error but i cant find the problem ><:

Parse error: syntax error, unexpected T_VARIABLE, expecting '(' in C:\xampp\htdocs\cmd\ZOEKFinal.php on line 29

<?php
$dbHost = 'localhost'; 
$dbUser = 'root'; 
$dbPass = 'bla';
$dbDatabase = 'cmd';
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());
mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());

$error = array();
$results = array();

if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); 
   
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms);
   
   if (strlen($searchTerms) < 3) {
	  $error[] = "De zoekterm moet langer dan 3 letters zijn";
   }else {
	  $searchTermDB = mysql_real_escape_string($searchTerms); 
   }
   
   if (count($error) < 1) {
      $searchSQL = "SELECT titel, omschrijving, afbeelding FROM fotos WHERE ";
{
     if $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
}
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "De zoekterm {$searchTerms} heeft geen resultaten opgleverd";
      }else {
         $results = array(); 
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['omschrijving']}<br />{$row['plaats']}<br />{$row['afbeelding']}<br /><br />";
            $i++;
	 }
   }
}

function removeEmpty($var) {
   return (!empty($var)); 
}
?>

<html>
   <omschrijving>Zoeken</omschrijving>
   <style type="text/css">
      #error {
         color: red;
      }
   </style>
   <titel>
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
         Zoeken <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />        
         <input type="submit" name="submit" value="Search!" />
      </form>
      <?php echo (count($results) > 0)?"Zoek: {$searchTerms} resultaat:<br /><br />" . implode("", $results):""; ?>
   </titel>
</html>

any help would be apprciated

Deoctor · March 19, 2010

try modifying it like this

<?php
$dbHost = 'localhost'; 
$dbUser = 'root'; 
$dbPass = 'bla';
$dbDatabase = 'cmd';
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());
mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());
$error = array();
$results = array();
if (isset($_GET['search'])) 
{
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); 
if (isset($_GET['search']))
{
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms);
   if (strlen($searchTerms) < 3) {
  $error[] = "De zoekterm moet langer dan 3 letters zijn";
   }   else {
  $searchTermDB = mysql_real_escape_string($searchTerms); 
   }
   if (count($error) < 1) {
     $searchSQL = "SELECT titel, omschrijving, afbeelding FROM fotos WHERE ";
{
     if $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
}
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "De zoekterm $searchTerms heeft geen resultaten opgleverd";
      }else {
         $results = array(); 
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['omschrijving']}<br />{$row['plaats']}<br />{$row['afbeelding']}<br /><br />";
            $i++;
}
}
}
}
}
function removeEmpty($var) {
   return (!empty($var)); 
}
?>
<html>
   <omschrijving>Zoeken</omschrijving>
   <style type="text/css">
      #error {
         color: red;
      }
   </style>
   <titel>
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
         Zoeken <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />        
         <input type="submit" name="submit" value="Search!" />
      </form>
      <?php echo (count($results) > 0)?"Zoek: {$searchTerms} resultaat:<br /><br />" . implode("", $results):""; ?>
   </titel>
</html>

Sign In

noob question, cant find the problem ><

Recommended Posts

johnz77

Link to comment

Share on other sites

Deoctor

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information