Hi
I really hope I am posting this in the correct forum area.
I have a html page on my currently existing web site where I sell books over the internet. I need to change this page so that it can do a search on my MySql database that I have already set up. Therefore this page will change to .php.
I found a search somewhere on the internet and changed it to more or less what I think I need and want. But I have run into troubleshooting problems.
Firstly, I am not sure how to implement the search into my html code and secondly, I want to get the search to work so that I can enable my clients to search for books.
I also realize that I will have to create a new .html page (I think it will be .html) to display the results of the search. Each book should have a small picture as well as a description of the book. I have not yet stored the picture anywhere. I think someone said that only the link to the picture should be stored in the database, the picture itself will probably be stored somewhere on my ISP's server under my domain.....? Any help in this regard will also be highly appreciated.
Here is the code so far:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Petru-Nell Boekwinkel</title>
<META NAME="description" CONTENT="Ons verkoop boeke. Fiksie, nie-fiksie, liefdesverhale, spanningsverhale, enige genre." />
<META NAME="keywords" CONTENT="boeke tweedehandse boeke, nuwe boeke, liefesverhale. spanningsverhale, boekwinkel, leeskring"/>
<META NAME="skrywer" CONTENT="Drie van die Bestes volume 2, Francois Bloemhof, Peet Venter, Tom Weiss, Diamante in die stof, Marlene Breytenbach, Maroelas uit Libanon, Sarah du Pisanie, Straataf, Jeanne Goosen, Drie van die Bestes Volume 5, Wilmari Jooste, Chanette Paul, Magda Schmidt, Tussen Stasies, Irma Joubert, 'n Nuwe Lente, Sophia Kapp, Waar die hart is, Sophia Kapp, Infanta, Bottervisse in die jêm, Deon Meyer, Die Buiteveld, John Miles, Drie van die Bestes Volume 4, Chris Moolman, Christo van der Merwe, CJ Venter, Willemien, Deborah, Isabelle, Chanette Paul, Liefde verdra alles, Pierre Uys, Maestro uit die newels, Vasgevang in gister, Mona van der Schyff, My liefste Romein, Frenette van Wyk, Gelouterde liefde, Lambert Visser, Katriena, Nee!, Nou lieg jy mos, Katriena, Riana Scheepers, Kort stories vir lang ure, Johan Vosloo, Splinters, Hans du Plessis, Die liefde van 'n leeftyd, Nelia Engelbrecht, Diepwater, Jeanette Ferreira, Ons die regverdiges, Cornelia Kruger, Die vrousoeker, AJ Swanepoel, Theo die biblioteekkat, Wendy Hartmann, Voelers, Jaco Jacobs, Lisa het 'n plan, Martie Preller, Karen Lilje, Kom ons teken met kryt, Southern African Garden Birds, Ulrich Oberprieler, Burger Cillié, Skuinslig, Hennie Aucamp, Voetspore op die strand, Johan Badenhorst, Threshold, MC Grove, HMAM Hauptfleisch, Boegoe van die liefde, Hans du Plessis." />
<link href="../pnskryf.css" rel="stylesheet" type="text/css" />
<!-- [if lt IE 7] -->
<style type="text/css" media="screen">
#menuh{float:none;}
body{
behavior:url(file:///C|/wippn.co.za/csshover.htc);
font-size:100%;
background-color: #FFFFCC;
}
#menuh ul li{float:left; width: 100%;}
#menuh a{height:1%;font:bold 0.7em/1.4em arial, sans-serif;}
a:link {
color: #990000;
}
a:visited {
color: #990000;
}
</style>
<!-- [endif] -->
</head>
<body>
<!-- end the menuh div -->
<table width="100%" height="100%" border="0">
<!--DWLayoutTable-->
<tr>
<td height="110" colspan="10"><div align="center">
<p align="center"><span class="bladsyhoofgroot"> <img src="../images/Logo_3.gif" alt="Petru-Nell Skryfbesigheid" width="980" height="185" /><a name="top" id="top"></a><br />
Boekwinkel</span></p>
</div></td>
</tr>
<tr>
<td height="254" width="14%" colspan="3" rowspan="106" valign="top" bgcolor="#FFFFCC"><p class="onsfontbold"><a href="../index.html">Tuis</a></p>
<p class="onsfontbold"><span class="onsfontboldgroenH1">Oor skryf:</span><br />
<span class="navigation"><a href="newskryfkursus.html">Skryfkursus</a></span><br />
<a href="newskryfoefeninge.html" class="navigation">Skryfoefeninge</a><br />
<a href="newvraenantwoorde.html" class="navigation">Vrae en antwoorde oor skryf</a><br />
<a href="newskryfkomps.html" class="navigation">Skryfkompetisies </a><br />
<a href="skrywerskring.html">Skrywerskring</a> <span class="onsfontboldgroenH1">NUUT!</span></p>
<p class="onsfontbold"><span class="onsfontboldgroenH1">Oor lees:</span><br />
<a href="http://petrunellleeskring.lefora.com" target="_blank" class="navigation">Leeskringforum</a><br />
<a href="newleeslys.html" class="navigation">Leeslys</a></p>
<p class="onsfontbold"><span class="onsfontboldgroenH1">Oor boeke:</span><br />
<a href="nuweboek.html" class="navigation style1">Nuwe boekbekend-<br />
stellings</a><br />
<a href="newnuus.html">Die Nuutste Boekenuus</a><br />
<a href="newboekwinkel.html" class="navigation">Boekwinkel</a><br />
<a href="soeknboek.html" class="navigation">Soek 'n boek</a></p>
<p class="onsfontbold"><span class="onsfontboldgroenH1">Vir ons gemeenskap:</span><br />
<a href="newgemeenskapsprojekte.html" class="navigation">Gemeenskapsprojekte</a></p>
<p class="onsfontbold"><a href="kontakons.html">Kontak ons</a></p>
<p class="onsfontbold"> </p>
<p class="onsfontbold"> </p></td>
<td height="98" width="72%" colspan="2" bgcolor="#FFCC99"><blockquote>
<p align="justify" class="onsfontnormaal">Vir boekbestellings vul die bestelvorm in en e-pos dit aan Hester by <a href="mailto:hester@pnskryf.co.za"><strong>hester@pnskryf.co.za</strong></a>.<br />
<br />
Sodra jou betaling ontvang is, word die boek aan jou gepos op die goedkoopste manier. <br />
Indien jy 'n vinniger opsie wil hê, kan jy dit so aandui op die bestelvorm. </p>
<p align="left" class="style3"><span class="onsfontbold"><a href="Petru-Nell BoekbestelvormSA.xls" target="_blank">Vir bestellings binne Suid-Afrika: Laai die bestelvorm af</a></span> <span class="klein10Bold">(50K)</span> </p>
<p align="left" class="style3"><span class="onsfontbold"><span class="style1"><u><a href="http://www.pnskryf.co.za/text/bestelbuitesa1.xls" target="_blank">Vir bestellings buite Suid-Afrika: Laai hierdie bestelvorm af</a></u></span> </span><span class="klein10Bold">(51k)</span> </p>
<p align="left" class="style3"> </p>
<p align="left" class="style3">Soek:<br />
<html>
<title>My Simple Search Form</title>
<style type="text/css">
#error {
color: red;
}
</style>
<body>
<?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">
Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?$searchTerms:''; ?>" /><br />
Search In:<br />
Titel: <input type="checkbox" name="Titel" value="on" <?php echo isset($_GET['body'])?"checked":''; ?> /> |
Skrywer: <input type="checkbox" name="Skrywer" value="on" <?php echo isset($_GET['title'])?"checked":''; ?> /> |
ISBN: <input type="checkbox" name="ISBN" value="on" <?php echo isset($_GET['desc'])?"checked":''; ?> /><br />
Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?><br /><br />
<input type="submit" name="submit" value="Search!" />
</form>
<?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>
</body>
</html>
</p>
</blockquote> </td>
<td width="14%" rowspan="106" valign="top" bgcolor="#FFFFCC"><p class="onsfontbold"><a href="../index.html">Tuis</a></p>
<p class="onsfontbold"><a href="newuitspanplek.html" class="onsfontbold">Uitspanplekke vir skrywers</a></p>
<p class="onsfontbold"><a href="newruilhoekie.html">Ruilhoekie</a></p>
<p class="onsfontbold"><a href="newkunsenhandwerk.html">Hand- en kunswerk</a></p>
<p class="onsfontbold"><a href="newkleinadvertensies.html">Klein advertensies</a></p></td>
</tr>
<tr>
<td height="400" colspan="2" bordercolor="#FFFF00" bgcolor="#FFCC99"><p align="center" class="onsfontbold"><span class="onsfontboldgroenH1">Gaan kyk na ons</span> <a href="#specials" class="onsfontboldDonkerGroenH1">spesiale aanbiedinge</a> <span class="onsfontboldDonkerGroenH1">!</span></p>
<p align="center" class="onsfontbold"><span class="onsfontboldgroenH1">Of soek alle GROEN titels, dit is al ons boeke wat nou op spesiale aanbieding is.</span> </p>
<p> </p>
<ul><li class="onsfontboldDonkerOranjeH2"><a href="#fiksie" class="onsfontboldDonkerOranjeH2">Fiksie</a><br />
<br />
</li>
<li class="onsfontboldDonkerOranjeH2"><a href="#kortkuns" class="onsfontboldDonkerOranjeH2"> Kortkuns</a><a href="#niefiksie" class="style22"><br />
</a><br />
</li>
<li class="onsfontboldDonkerOranjeH2"><a href="#grootdruk" class="onsfontboldDonkerOranjeH2">Grootdruk</a><br />
<br />
</li>
<li class="onsfontboldDonkerOranjeH2"><a href="#kinderenjeugboeke" class="onsfontboldDonkerOranjeH2"> Kinder- en Jeugboeke </a><br />
<br />
</li>
<li class="onsfontboldDonkerOranjeH2"><a href="#anderniefiksie" class="onsfontboldDonkerOranjeH2">Ander nie-fiksie</a><a href="#niefiksie" class="style22"><br />
<br />
</a></li>
<li class="onsfontboldDonkerOranjeH2"><a href="#opvoedkundig" class="onsfontboldDonkerOranjeH2">Opvoedkundig</a><br />
<br />
</li>
<li class="onsfontboldDonkerOranjeH2"><a href="#poesie" class="onsfontboldDonkerOranjeH2">Poësie</a></li>
</ul> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><div align="center"><span class="bladsyhoofgroot"><u class="onsfontboldDonkerOranjeH1">Fiksie</u><a name="fiksie" id="fiksie"></a></span></div></td>
</tr>
<tr>
<td width="17%" bgcolor="#FFCC99"><div align="center"><img src="../images/Drie_vd_bestes2.jpg" alt="3 van die Bestes Volume 2" width="130" height="200" align="top" /></div></td>
<td width="54%" valign="top" bgcolor="#FFCC99"><p class="onsfontbold"><u>3 van die Bestes Volume 2</u></p>
<p class="onsfontnormaal">3 VAN DIE BESTES VOLUME 2 is ’n bundel met lekkerleesverhale van skrywers wat weet hoe om ’n spanningsverhaal te skryf.</p>
<p class="onsfontnormaal">Vrou in die Maan<br />
As die regters swyg<br />
Diep moord</p>
<p class="onsfontnormaal"><strong>Outeurs:</strong> Bloemhof, Francois;
Venter, Peet; Weiss, Tom<br />
<strong>ISBN No:</strong> 0799328367 <br />
<strong>Bestelno:</strong> 11 <br />
<strong>Prys:</strong> R60</p></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td bgcolor="#FFCC99"><div align="center"><img src="../images/Diamante_in_die_stof.jpg" alt="Diamante_in_die_stof" width="130" height="200" /></div></td>
<td valign="top" bgcolor="#FFCC99"><p class="onsfontbold">Diamante in die Stof</p>
<p class="onsfontnormaal">Vier keer brand die opsitkers vir hulle, toe vra François de Villiers Katharina om te trou. Sy weet dit gaan eintlik om haar erfplaas. Kat is nogtans van plan om sy hart te wen. Al is hy ’n moeilike man, afsydig, selfs koud. Toe François agterkom sy skoonpa is bankrot, vat hy die pad diamantvelde toe. ’n Tweede keer probeer Kat haar huwelik red, maar besluit sy sal haar nie weer deur François laat verneder nie. Sy het genoeg geld om haar toekoms te verseker, al is die prys hoe hoog.</p>
<p class="onsfontnormaal"><strong>Outeur:</strong> Breytenbach, Marlene <br />
<strong>ISBN No:</strong> 0799336157<br />
<strong>Bestelno:</strong> 4<br />
<strong>Prys:</strong> R90.00</p></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
... just more information on books currently on my web page...
<td bgcolor="#FFCC99"><div align="center"><img src="../images/boegoevandieliefde.jpg" alt="boegoe van die liefde" width="130" height="200" /></div></td>
<td valign="top" bgcolor="#FFCC99"><p align="left"><span class="onsfontbold"><strong>Boegoe van die liefde</strong></span><span class="onsfontbold"><span class="onsfontboldRooiH1">(geen voorraad nie)</span> </span></p>
<p class="onsfontnormaal">Kom ons dans nourie liefde lekker los!<br />
Die liefde het eentlikie dood se krag, hy gryp jou wa jy niks vewag, die liefde die soek okkie ytie, vra nou nie wat jy self beslytie.<br />
Die liefde brandsteek 'n annerlike vier, en jy kannie hele waterse kom stier, of goi ma Grootrivier yt op hy se kop, more sien jy, hie statie liefde self wee op! <strong><br />
<br />
Outeur:</strong> du Plessis, Hans <br />
<strong>ISBN No:</strong> 0 7993 3050 7<br />
<strong>Bestelno:</strong> 18 <br />
<strong>Prys:</strong> R60.00 </p></td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFCC99"><!--DWLayoutEmptyCell--> </td>
</tr>
</table>
<p> </p>
<table width="98%" height="34">
<tr>
<hr align="center" />
<td width="42%" valign="top" class="klein10Bold"><div align="center" class="onsfontbold">
<div align="left" class="klein10Bold">© 2008-2009 Petru-Nell Skryfbesigheid</div>
</div></td>
<td width="42%" valign="top" class="klein10Bold"> </td>
<td width="16%" valign="top"><div align="right"><a href="http://www.lefora.com" target="_blank" class="baieklein9">free forum hosting by lefora</a></div></td>
</tr>
</table>
</body>
</html>