In onderstaand script krijg ik de volgende foutmelding: Parse error: parse error in /var/www/vhosts/phphulp.nl/httpdocs/find.php on line 95
Regel 95 is de laatste regel van het script!!
Iemand enig idee???? (Apache/1.3.20, PHP v4.1.2, MySQL v3.23.39, Unix). Url=http://henkegberts.nl/search.htm = zoekformulier.
<?
$server = "localhost";
$user = "user";
$pass = "pass";
$databasename = "dbname";
$db = mysql_connect($server, $user, $pass);
mysql_select_db($databasename,$db);
$sql = "SELECT * FROM MP3sTabelle";
$query = mysql_query($sql,$db);
$total_results = mysql_num_rows($query);
$limit = "25"; //limit of archived results per page.
$total_pages = ceil($total_results / $limit); //total number of pages
if (empty($page))
{
$page = "1"; //default page if none is selected
}
$offset = ($page - 1) * $limit; //starting number for displaying results out of DB
$var = @$_GET['q'] ;
$trimmed = trim($var); //trim whitespace from the stored variable
$query = "SELECT Artist, Album, Trackno, Songname, GenreReal FROM MP3sTabelle WHERE Arist LIKE \"$trimmed\" ORDER BY Album LIMIT $offset, $limit";
$result = mysql_query($query);
if (!$result) { die($query."<br />".mysql_error()); }
//This is the start of the normal results...
while ($row = mysql_fetch_array($result))
{
print "{$row['Artist']}{$row['Album']}{$row['Trackno']}{$row['Songname']}{$row['GenreReal']}<br>";
{
// Release the Result Set
mysql_free_result($result);
// Close the connection
mysql_close($db);
// This is the Previous/Next Navigation
echo "<font face=Verdana size=1>";
echo "Pages:($total_pages) "; // total pages
if ($page != 1)
{
echo "<a href=$PHP_SELF?page=1><< First</a> "; // First Page Link
$prevpage = $page - 1;
echo " <a href=$PHP_SELF?page=$prevpage><<</a> "; // Previous Page Link
}
if ($page == $total_pages)
{
$to = $total_pages;
}
elseif ($page == $total_pages-1)
{
$to = $page+1;
}
elseif ($page == $total_pages-2)
{
$to = $page+2;
}
else
{
$to = $page+3;
}
if ($page == 1 || $page == 2 || $page == 3)
{
$from = 1;
}
else
{
$from = $page-3;
}
for ($i = $from; $i <= $to; $i++)
{
if ($i == $total_results) $to=$total_results;
if ($i != $page)
{
echo "<a href=$PHP_SELF?showold=yes&page=$i>$i</a>";
}
else
{
echo "<b><font face=Verdana size=2>[$i]</font></b>";
}
if ($i != $total_pages)
echo " ";
}
if ($page != $total_pages)
{
$nextpage = $page + 1;
echo " <a href=$PHP_SELF?page=$nextpage>>></a> "; // Next Page Link
echo " <a href=$PHP_SELF?page=$total_pages>Last >></a>"; // Last Page Link
echo "</font>";
}
?>
1.043 views