Re: Search script problem

From: wikus.m@xxxxxxxxx ("Wikus Moller")
Date: Sun, 7 Jan 2007 01:20:06 +0200

So it should be like this (it still doesn't show the results):

<?php

echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD XHTML Mobile 1.0//EN\"
\"http://www.wapforum.org/DTD/xhtml-mobile10.dtd\";>";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\";>";

error_reporting(E_ALL ^ E_NOTICE);

$pwd = $_GET["pwd"];
$uid = $_GET["uid"];
$action = $_GET["action"];
$cid = $_GET["cid"];
$sid = $_GET["sid"];
$var = $_GET["q"];

include ("function.php");
include ("config.php");
connect($dbserver,$dbname,$dbuser,$dbpass);

/////////////////////////////////////////////Search main page
if(!isset($var)){
echo "<head>";
echo "<title>Search Engine</title>";
echo "<style type=\"text/css\">
.m3 {background-color: #291C6F;}
.n1 {background-color: #A0A0A0;}
.n2 {background-color: #888888;}
.c2 {color: #000000;}
.m2 {color: #91D0FF;}
body {font-family: Arial, sans-serif;
font-size: 12px;
color: #ffffff;
background-color: #000033;
margin-left: 0px;
margin-right: 0px;
margin-top: 0px;}
.ct1 {font-family: Arial, sans-serif;
font-size: 12px;
color: #800080;}
.cre {background-color: #1300A4;
padding: 2px 2px 2px 2px;
margin: 3px 0 0;
font-size: 12px;
color:#000000;
text-align: center;
border-width:1px 0;
border-style:solid;
border-color:#000000;}
</style>";
echo "</head>";
echo "<body>";
echo "<table>";
echo "<div class=\"cre\">";
echo "<b>Search Engine</b></div>";
echo "<form method=\"GET\"
action=\"search.php?uid=$uid&pwd=$pwd\">"; ///the uid and pwd is
nessecary cause my member features are very basic and the urls is used
to keep the user 'logged in'
echo "Keywords: <input type=\"text\" name=\"q\" /><br/>";
echo "<input type=\"submit\" name=\"Submit\"/>";
echo "</form>";
echo "</table>";
echo "<div class=\"cre\"><img src=\"images/home.gif\" alt=\"*\"/><a
href=\"index.php?uid=$uid&pwd=$pwd\">Home</a></div>";
echo "</body>";
echo "</html>";
}

///////////////////////////////////////////////////Display Results

if(isset($var)){
$var = $_GET["q"];
$trimmed = trim($var); //trim whitespace from the stored variable
echo "<head>";
echo "<title>Search Results</title>";
echo "<style type=\"text/css\">
.m3 {background-color: #291C6F;}
.n1 {background-color: #A0A0A0;}
.n2 {background-color: #888888;}
.c2 {color: #000000;}
.m2 {color: #91D0FF;}
body {font-family: Arial, sans-serif;
font-size: 12px;
color: #ffffff;
background-color: #000033;
margin-left: 0px;
margin-right: 0px;
margin-top: 0px;}
.ct1 {font-family: Arial, sans-serif;
font-size: 12px;
color: #800080;}
.cre {background-color: #1300A4;
padding: 2px 2px 2px 2px;
margin: 3px 0 0;
font-size: 12px;
color:#000000;
text-align: center;
border-width:1px 0;
border-style:solid;
border-color:#000000;}
</style>";
echo "</head>";
echo "<body>";
echo "<div class=\"cre\">";
echo "<b>Search Results</b></div>";
echo "<table>";
// Get the search variable from URL

// check for an empty string and display a message.
if ($trimmed == "")
{
echo "Please enter a search...";
exit;
}

if($pg==0)$pg=1;
$pg--;
$lmt = $pg*20;
$pg++;
$cou =$lmt+1;
$scount = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM table
WHERE keywords like \"%$trimmed%\" AND banned='0' AND hits_in >=
'2'"));
$pgs = ceil($scount[0]/20);
// Build SQL Query
$sql = "SELECT * FROM table WHERE keywords like \"%$trimmed%\" AND
banned='0' and hits_in >='2' ORDER by hits_in DESC LIMIT ".$lmt.", 20;";
// EDIT HERE and specify your table and field names for the SQL query
$sites=mysql_query($sql);

while ($site = mysql_fetch_array($sites))
{
$dscr =htmlspecialchars($site[11]);
$snm=htmlspecialchars($site[1]);
echo "<tr><td align=\"left\"><a
href=\"index.php?action=vsite&sid=$site[0]&uid=$uid&pwd=$pwd\">$snm</a></td></tr>";
echo "<tr><td align=\"left\">$dscr</td></tr>";
$cou++;
}
$npage = $pg+1;
$ppage = $pg-1;
if($pg<$pgs)
//this is just for clicking on the site's name when the results are displayed
{

$nlink = "<a
href=\"index.php?action=vsites&pg=$npage&uid=$uid&pwd=$pwd&cid=$cid\"
accesskey=\"1\"><img src=\"images/next.gif\" alt=\"1\"/>Next</a>";

}
if($pg >1)
{
$plink = "<a
href=\"index.php?action=vsites&pg=$ppage&uid=$uid&pwd=$pwd&cid=$cid\"
accesskey=\"2\"><img src=\"images/prev.gif\" alt=\"2\"/>Prev</a>";
}

echo "<tr class=\"m2\"><td align=\"right\">$nlink</td></tr>";
echo "<tr class=\"m2\"><td align=\"left\">$plink</td></tr>";

echo "</table>";
echo "<div class=\"cre\"><img src=\"images/home.gif\" alt=\"*\"/><a
href=\"index.php?uid=$uid&pwd=$pwd\">Home</a></div>";
echo "</body>";
echo "</html>";
}
?>

On 1/7/07, Wikus Moller <wikus.m@xxxxxxxxx> wrote:

And the hits_in of the mysql query are the same, I just made a typing
mistake.

On 1/7/07, Wikus Moller <wikus.m@xxxxxxxxx> wrote:
> Hi.
>
> I am having problems with a script I wrote which searches keywords
> from a field in a mysql db table.
>
> It is a very simple, one-page script. My site is a toplist, very
> basic, still in it's infancy. When I go to the page, key in the
> keywords and press submit, the head, body etc. part of the result
> script is shown, but no results.
> , although there are rows in my database containing the `keyword` field
> data.
>
> Below is the script, please see if you find any errors, it could be
> that I just made a stupid mistake.
>
> <?php
>
> echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
> echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD XHTML Mobile 1.0//EN\"
> \"http://www.wapforum.org/DTD/xhtml-mobile10.dtd\";>";
> echo "<html xmlns=\"http://www.w3.org/1999/xhtml\";>";
>
> error_reporting(E_ALL ^ E_NOTICE);
>
> $pwd = $_GET["pwd"];
> $uid = $_GET["uid"];
> $action = $_GET["action"];
> $cid = $_GET["cid"];
> $sid = $_GET["sid"];
> $var = $_GET["q"];
>
> include ("function.php");
> include ("config.php");
> connect($dbserver,$dbname,$dbuser,$dbpass);
>
>
>
> /////////////////////////////////////////////Search main page
> if(!isset($var)){
> echo "<head>";
> echo "<title>Search Engine</title>";
> echo "<style type=\"text/css\">
> .m3 {background-color: #291C6F;}
> .n1 {background-color: #A0A0A0;}
> .n2 {background-color: #888888;}
> .c2 {color: #000000;}
> .m2 {color: #91D0FF;}
> body {font-family: Arial, sans-serif;
> font-size: 12px;
> color: #ffffff;
> background-color: #000033;
> margin-left: 0px;
> margin-right: 0px;
> margin-top: 0px;}
> .ct1 {font-family: Arial, sans-serif;
> font-size: 12px;
> color: #800080;}
> .cre {background-color: #1300A4;
> padding: 2px 2px 2px 2px;
> margin: 3px 0 0;
> font-size: 12px;
> color:#000000;
> text-align: center;
> border-width:1px 0;
> border-style:solid;
> border-color:#000000;}
> </style>";
> echo "</head>";
> echo "<body>";
> echo "<table>";
> echo "<div class=\"cre\">";
> echo "<b>Search Engine</b></div>";
> echo "<form method=\"GET\"
> action=\"search.php?uid=$uid&pwd=$pwd\">"; ///the uid and pwd is
> nessecary cause my member features are very basic and the urls is used
> to keep the user 'logged in'
> echo "Keywords: <input type=\"text\" name=\"q\" /><br/>";
> echo "<input type=\"submit\" name=\"Submit\"/>";
> echo "</form>";
> echo "</table>";
> echo "<div class=\"cre\"><img src=\"images/home.gif\" alt=\"*\"/><a
> href=\"index.php?uid=$uid&pwd=$pwd\">Home</a></div>";
> echo "</body>";
> echo "</html>";
> }
>
> ///////////////////////////////////////////////////Display Results
>
> if(isset($var)){
> $var = $_GET["q"];
> $trimmed = trim($var); //trim whitespace from the stored variable
> echo "<head>";
> echo "<title>Search Results</title>";
> echo "<style type=\"text/css\">
> .m3 {background-color: #291C6F;}
> .n1 {background-color: #A0A0A0;}
> .n2 {background-color: #888888;}
> .c2 {color: #000000;}
> .m2 {color: #91D0FF;}
> body {font-family: Arial, sans-serif;
> font-size: 12px;
> color: #ffffff;
> background-color: #000033;
> margin-left: 0px;
> margin-right: 0px;
> margin-top: 0px;}
> .ct1 {font-family: Arial, sans-serif;
> font-size: 12px;
> color: #800080;}
> .cre {background-color: #1300A4;
> padding: 2px 2px 2px 2px;
> margin: 3px 0 0;
> font-size: 12px;
> color:#000000;
> text-align: center;
> border-width:1px 0;
> border-style:solid;
> border-color:#000000;}
> </style>";
> echo "</head>";
> echo "<body>";
> echo "<div class=\"cre\">";
> echo "<b>Search Results</b></div>";
> echo "<table>";
> // Get the search variable from URL
>
>
>
> // check for an empty string and display a message.
> if ($trimmed == "")
> {
> echo "Please enter a search...";
> exit;
> }
>
>
>
> if($pg==0)$pg=1;
> $pg--;
> $lmt = $pg*20;
> $pg++;
> $cou =$lmt+1;
> $scount = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM table
> WHERE keywords like \"%$trimmed%\" AND banned='0' AND hitsin >=
> '2'"));
> $pgs = ceil($scount[0]/20);
> // Build SQL Query
> $sql = "SELECT * FROM table WHERE keywords like \"%$trimmed%\" AND
> banned='0' and hits_in >='2' ORDER by hin DESC LIMIT ".$lmt.", 20;";
> // EDIT HERE and specify your table and field names for the SQL query
> $sites=mysql_query($sql);
>
>
> while ($site = mysql_fetch_array($sites))
> {
> $dscr =htmlspecialchars($site[11]);
> $snm=htmlspecialchars($site[1]);
> echo "<tr><td align=\"left\"><a
>
href=\"index.php?action=vsite&sid=$site[0]&uid=$uid&pwd=$pwd\">$snm</a></td></tr>";
> echo "<tr><td align=\"left\">$dscr</td></tr>";
> $cou++;
> }
> $npage = $pg+1;
> $ppage = $pg-1;
> if($pg<$pgs)
> //this is just for clicking on the site's name when the results are
> displayed
> {
>
> $nlink = "<a
>
href=\"index.php?action=vsites&pg=$npage&uid=$uid&pwd=$pwd&cid=$cid\"
> accesskey=\"1\"><img src=\"images/next.gif\" alt=\"1\"/>Next</a>";
>
> }
> if($pg >1)
> {
> $plink = "<a
>
href=\"index.php?action=vsites&pg=$ppage&uid=$uid&pwd=$pwd&cid=$cid\"
> accesskey=\"2\"><img src=\"images/prev.gif\" alt=\"2\"/>Prev</a>";
> }
>
>
> echo "<tr class=\"m2\"><td align=\"right\">$nlink</td></tr>";
> echo "<tr class=\"m2\"><td align=\"left\">$plink</td></tr>";
>
> echo "</table>";
> echo "<div class=\"cre\"><img src=\"images/home.gif\" alt=\"*\"/><a
> href=\"index.php?uid=$uid&pwd=$pwd\">Home</a></div>";
> echo "</body>";
> echo "</html>";
> }
> ?>
>
> Like I said, very basic. I know there must be a screw-up somewhere but
> I can't seem to find it.
>
> Thanks
> Wikus
>

Follow-Ups:
- RE: [PHP] Re: Search script problem
  - From: "Peter Lauri"

References:
- Search script problem
  - From: "Wikus Moller"
- Re: Search script problem
  - From: "Wikus Moller"

Prev by Date: Re: Search script problem
Next by Date: RE: [PHP] Re: Search script problem
Previous by thread: Re: Search script problem
Next by thread: RE: [PHP] Re: Search script problem
Index(es):
- Date
- Thread

Relevant Pages

Search script problem
... I am having problems with a script I wrote which searches keywords ... one-page script. ... font-size: 12px; ... margin-left: 0px; ...
(php.general)
Re: [PHP] Search script problem
... one-page script. ... this is in contrast to the tactic your using, namely: dump some output, ... font-size: 12px; ... margin-left: 0px; ...
(php.general)
Re: MIME format in pop3 email
... should not be in the header. ... I would disable the AVG E-mail scanning. ... font-size: 11px; ... margin-left: 0px; ...
(microsoft.public.windows.inetexplorer.ie6_outlookexpress)
Re: MIME format in pop3 email
... Are you seeing that in the normal message reading window or when looking ... MIME headers in the message are corrupted. ... font-size: 11px; ... margin-left: 0px; ...
(microsoft.public.windows.inetexplorer.ie6_outlookexpress)
RE: [PHP] Re: Search script problem
... Have you tried to catch (echo) the query you try to execute in mysql and ... font-size: 12px; ... margin-left: 0px; ...
(php.general)