T_FOREACH error

**groovyben008** · 02-22-2010 10:36 AM

Hi, i am macking a search engiene called wingot and have come across a T_FOREACH error the code is the folowing

Code:

<html>
<head>
<title>wingot</title>
</head>
</body>
<?php

//get data
$search = $_GET['q'];
//html header
echo "<center><form action='search.php' method='GET'><a href='index.php'><img src='images/logo.png' alt='wingot' border='0' width='200' height='50' style='vertical-align:middle'></a>&nbsp&nbsp<input type='text' size='50' name='q'>&nbsp<input type='submit' value='search'></center><hr hight='1'>";
echo "<table border='0' width=100%><tr width=100%><td>You searched for: $search</td><td align=right>Number of results: ";
//connect to database
@msql_connect("mysql15.**********.com","a9765945_wingot","pilgrim008")or die(mysql_error());
@msql_select_db("a9765945_wingot")or die(mysql_error());
 //explode search term
 $search_exploded = explode(" ",$search)
 
foreach ($search_exploded as $search_each){
 //construct query
 $x++;
 if ($x==1)
 $construct .= "Keywords LIKE '%$search_each%'";
 else
  $construct .= "OR Keywords LIKE '%$search_each%'";
 }

$construct = "SELECT * FROM search WHERE $construct";
$run = mysql_query($construct);

$found = mysql_num_rown($run)

if ($found==0)
echo "0</td></tr></table><br/>";
else
{
echo "$found</td></tr></table><br/>";
}

while ($runrows = mysql_fetch_addoc($run)) 
(
//get data
$title = $runrows['title']
$desc = $runrows['description']
$url = $runrows['url']

echo "
<b><a href='$url' color = 'black'>$title</a></b><br/>
$desc<br/>
<a href='$url'>$url</a>
";

)

?>
</body>
</html>

i get the error

Parse error: syntax error, unexpected T_FOREACH in /home/a9765945/public_html/search.php on line 19

please can someone help me!

**NogDog** · 02-22-2010 11:49 AM

Missing semi-colon on the preceding line.

**aj_nsc** · 02-22-2010 12:10 PM

Check out Notepad++ as a text editor when writing code.

Full disclosure: it wouldn't have changed any syntax highlighting to make this mistake obvious, but it's still a really useful tool!

**groovyben008** · 02-23-2010 01:51 AM

Now after some more debbuging i get

Parse error: syntax error, unexpected T_VARIABLE in /home/a9765945/public_html/search.php on line 44

here is the code after debbuging:

Code:

<html>
<head>
<title>wingot</title>
</head>
</body>
<?php

//get data
$search = $_GET['q'];
//html header
echo "<center><form action='search.php' method='GET'><a href='index.php'><img src='images/logo.png' alt='wingot' border='0' width='200' height='50' style='vertical-align:middle'></a>&nbsp&nbsp<input type='text' size='50' name='q'>&nbsp<input type='submit' value='search'></center><hr hight='1'>";
echo "<table border='0' width=100%><tr width=100%><td>You searched for: $search</td><td align=right>Number of results: ";
//connect to database
@msql_connect("mysql15.**********.com","a9765945_wingot","pilgrim008")or die(mysql_error());
@msql_select_db("a9765945_wingot")or die(mysql_error());
 //explode search term
 $search_exploded = explode(" ",$search);
 
foreach ($search_exploded as $search_each){
 //construct query
 $x++;
 if ($x==1)
 $construct .= "Keywords LIKE '%$search_each%'";
 else
  $construct .= "OR Keywords LIKE '%$search_each%'";
 }

$construct = "SELECT * FROM search WHERE $construct";
$run = mysql_query($construct);

$found = mysql_num_rown($run);

if ($found==0)
echo "0</td></tr></table><br/>";
else
{
echo "$found</td></tr></table><br/>";
}

while ($runrows = mysql_fetch_addoc($run)) 
(
//get data
$title = $runrows['title']
$desc = $runrows['description'];
$url = $runrows['url'];

echo "
<b><a href='$url' color = 'black'>$title</a></b><br/>
$desc<br/>
<a href='$url'>$url</a>
";

)

?>
</body>
</html>

**Mindzai** · 02-23-2010 03:28 AM

It's the same issue as NogDog posted above, you are missing a semi colon on the previous line.

**groovyben008** · 02-23-2010 10:23 AM

if i do what you just said it comes up with:

Parse error: syntax error, unexpected ';' in /home/a9765945/public_html/search.php on line 43

**NogDog** · 02-23-2010 11:47 AM

You while() loop toward the end needs to use curly braces instead of parentheses around the code block that is looped:

PHP Code:


<html>
<head>
<title>wingot</title>
</head>
</body>
<?php
//get data
$search = $_GET['q'];
//html header
echo "<center><form action='search.php' method='GET'><a href='index.php'><img src='images/logo.png' alt='wingot' border='0' width='200' height='50' style='vertical-align:middle'></a>&nbsp&nbsp<input type='text' size='50' name='q'>&nbsp<input type='submit' value='search'></center><hr hight='1'>";
echo "<table border='0' width=100%><tr width=100%><td>You searched for: $search</td><td align=right>Number of results: ";
//connect to database
@msql_connect("mysql15.**********.com", "a9765945_wingot", "pilgrim008") or die(mysql_error());
@msql_select_db("a9765945_wingot") or die(mysql_error());
//explode search term
$search_exploded = explode(" ", $search);
foreach($search_exploded as $search_each) {
   //construct query
   $x++;
   if ($x == 1) $construct.= "Keywords LIKE '%$search_each%'";
   else $construct.= "OR Keywords LIKE '%$search_each%'";
}
$construct = "SELECT * FROM search WHERE $construct";
$run = mysql_query($construct);
$found = mysql_num_rown($run);
if ($found == 0) echo "0</td></tr></table><br/>";
else {
   echo "$found</td></tr></table><br/>";
}
while ($runrows = mysql_fetch_assoc($run)) {
   //get data
   $title = $runrows['title'];
   $desc = $runrows['description'];
   $url = $runrows['url'];
   echo "
<b><a href='$url' color = 'black'>$title</a></b><br/>
$desc<br/>
<a href='$url'>$url</a>
";
}
?>
</body>
</html>

**groovyben008** · 02-23-2010 01:52 PM

after changing the code it now does not display any results.

Thread: T_FOREACH error

Thread Tools

Display

T_FOREACH error

Another Error

Then i get this

it does not display results

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions