"Fossies" - the Fresh Open Source Software Archive

Member "faqadmin/faq/search.php" (31 Oct 2006, 1406 Bytes) of package /linux/www/old/faqadmin-current.tgz:

The requested HTML page contains a <FORM> tag that is unusable on "Fossies" in "automatic" (rendered) mode so that page is shown as HTML source code syntax highlighting (style: standard) with prefixed line numbers and code folding option. Alternatively you can here view or download the uninterpreted source code file. For more information about "search.php" see the Fossies "Dox" file reference documentation. 
    1 <html>
    2 <HEAD>
    3 <TITLE>Faq Administrator Search Results</TITLE>
    4 </HEAD>
    5 <body bgcolor=white text=black>
    6 <?
    7 include ("links.php");
    8 include ("connect.php");
    9 ?>
   10 <form action="search.php" method=get>
   11 <table>
   12 <TR><TD>
   13 <IMG SRC="falo1.jpg">&nbsp;
   14 </TD>
   15 <TD>
   16 <input type="text" size="25" maxlength="25" name="keywd"> <input type="submit" value="Search">
   17 </TD></TR></TABLE>
   18 </FORM>
   19 <P>
   20 <FONT COLOR=BLUE><B>YOUR SEARCH RESULTS:</B></FONT>
   21 <P>
   22 
   23 <?php
   24 
   25 if (ereg(".", $keywd) == 1)
   26 
   27 {
   28 
   29 if ($keywd == "")
   30 {$keywd == "";}
   31 
   32 $result = mysql_query ("SELECT * FROM faq_dat, faq_re_dat
   33                          WHERE faq_dat.faq_date = faq_re_dat.faq_re_memo
   34             and  faq_re_dat.refaq_data like '%$keywd%'
   35             or  faq_dat.faq_dat like '%$keywd%'
   36             and faq_re_dat.fodr = faq_dat.fodr
   37             GROUP BY faq_re_dat.faq_re_memo
   38             order by faq_re_dat.refac_date
   39                    ");
   40 
   41 if ($row = mysql_fetch_array($result)) {
   42 
   43 do {
   44 
   45 $faq_date = $row["faq_date"];
   46 $fid = $row["faq_fid"];
   47 $xfm = $row["faq_memo"];
   48 $fodr = $row["fodr"];
   49 
   50   print ("<br>");
   51   printf("<a href=\"faqhist.php?fodrx=$fodr&m1=$m1&fm=%s&fid=$fid\">%s</a><br>\n\n", $row["faq_memo"], $row["faq_memo"]);
   52   print $row["faq_re_memo"];
   53   print ("<P>");
   54 
   55 } while($row = mysql_fetch_array($result));
   56 
   57 } else {print "Sorry, no records were found!";}
   58 
   59 $verify = "OK";
   60 }
   61 else
   62 {
   63     print ("<B>Error:</B> you must supply a Search Term");
   64     $verify = "bad";
   65 }
   66 
   67 ?>
   68 
   69 <P>
   70 </body>
   71 </html>