tokkille Posted March 9, 2006 Share Posted March 9, 2006 Hi,I have maneged to recive information from my database. but when i put in a search function on the homepage to search the database it dosent retrive the result in a table?!This is what it looks like:<html><head><title>Gött mos</title><link href="../skolan.css" rel="stylesheet" type="text/css"></head><body><h3 align="center">Goa Grejer </h3><p align="center">Sök vem som är göttigast </p><hr><?phpif ($searchstring) { $sql="SELECT * FROM maraton1 WHERE $searchtype LIKE '%$searchstring%' ORDER BY Plats ASC"; include("XXX.php"); $result = mysql_query($sql,$db); echo "<table border=1 align=center cellspacing=2 cellpadding=3>\n"; echo "<TR><TH>Plats<TH>Person<TH>Poäng</TR>\n"; while ($rad = mysql_fetch_array($result)) { echo "<TR><TD>$rad[Plats]<TD>$rad[Person]<TD>$rad[Poäng]\n"; } echo "</TABLE>"; }else { ?><form method="POST" action="<?php $PHP_SELF ?>"> <table border="1" align="center" cellspacing=2 cellpadding=3> <tr><td>Sök här</td> <td>Söktyp</td></tr> <tr> <td><input type="text" name="searchstring" size="40"></td> <td><select size="1" name="searchtype"> <option selected value="Person">Person</option> <option value="Plats">Plats</option> </select></td> </tr> </table> <p align="center"> <input type="submit" value="Sök" name="B1"> <input type="reset" value="Töm sökraden ovan" name="B2"> </p></form> <?php }?><hr><p align="center"><a href="../../../../Application Data/Macromedia/Dreamweaver 8/Configuration/ServerConnections/www.vahlne.se//index.php">Tillbaks</a><p></body></html>Thanks for any help!/Tokkille Quote Link to comment https://forums.phpfreaks.com/topic/4535-cant-recive-data-from-database-when-adding-search-function/ Share on other sites More sharing options...
lessthanthree Posted March 9, 2006 Share Posted March 9, 2006 There's a few errors. But for a start:[code]<?phpif ($searchstring){$sql="SELECT * FROM maraton1 WHERE $searchtype LIKE '%$searchstring%' ORDER BY Plats ASC";include("XXX.php");$result = mysql_query($sql,$db);[/code]should be [code]<?phpif (isset($_POST["searchstring"])){$searchstring = $_POST["searchstring"] //for security make sure you clean this value!!!!$searchtype = $_POST["searchtype"] //and this one!!!$sql="SELECT * FROM maraton1 WHERE $searchtype LIKE '%".$searchstring%' ORDER BY Plats ASC";include("XXX.php");$result = mysql_query($sql,$db);[/code] Quote Link to comment https://forums.phpfreaks.com/topic/4535-cant-recive-data-from-database-when-adding-search-function/#findComment-15807 Share on other sites More sharing options...
tokkille Posted March 9, 2006 Author Share Posted March 9, 2006 Thanks less then three!!My new code looks like this:<html><head><title>Gött mos</title><link href="file:///C|/Documents and Settings/vahlne/Desktop/PHP/Kap48/skolan.css" rel="stylesheet" type="text/css"></head><body><h3 align="center">Goa Grejer </h3><p align="center">Sök vem som är göttigast </p><hr><?phpif (isset($_POST["searchstring"])){$searchstring = $_POST["searchstring"]$searchtype = $_POST["searchtype"]$sql="SELECT * FROM maraton1 WHERE $searchtype LIKE '%$searchstring%' ORDER BY Plats ASC";include("XXX.php");$result = mysql_query($sql,$db); echo "<table border=1 align=center cellspacing=2 cellpadding=3>\n"; echo "<TR><TH>Plats<TH>Person<TH>Poäng</TR>\n"; while ($rad = mysql_fetch_array($result)) { echo "<TR><TD>$rad[Plats]<TD>$rad[Person]<TD>$rad[Poäng]\n"; } echo "</TABLE>"; }else { ?><form method="POST" action="<?php $PHP_SELF ?>"> <table border="1" align="center" cellspacing=2 cellpadding=3> <tr><td>Sök här</td> <td>Söktyp</td></tr> <tr> <td><input type="text" name="searchstring" size="40"></td> <td><select size="1" name="searchtype"> <option selected value="Person">Person</option> <option value="Plats">Plats</option> </select></td> </tr> </table> <p align="center"> <input type="submit" value="Sök" name="B1"> <input type="reset" value="Töm sökraden ovan" name="B2"> </p></form> <?php }?><hr><p align="center"><a href="index.php">Tillbaks</a><p></body></html>But know it complains about: Parse error: parse error, unexpected T_VARIABLE in /customers/vahlne.se/vahlne.se/httpd.www/sok funktion.php on line 17 Quote Link to comment https://forums.phpfreaks.com/topic/4535-cant-recive-data-from-database-when-adding-search-function/#findComment-15814 Share on other sites More sharing options...
lessthanthree Posted March 9, 2006 Share Posted March 9, 2006 add semicolons to the end of the strings...my fault.$searchstring = $_POST["searchstring"];$searchtype = $_POST["searchtype"]; Quote Link to comment https://forums.phpfreaks.com/topic/4535-cant-recive-data-from-database-when-adding-search-function/#findComment-15818 Share on other sites More sharing options...
tokkille Posted March 9, 2006 Author Share Posted March 9, 2006 Stupid of me could almost have figured that one out my self....Thanks alot it works fin now!/Tokkille Quote Link to comment https://forums.phpfreaks.com/topic/4535-cant-recive-data-from-database-when-adding-search-function/#findComment-15826 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.