Forums

I do not see any search results. Please see code below. I am trying to do a simple database search. I need to display the search results on the same page as my search text field.

I am using POST method.

Do I need to put anything in the Form URL fields? They are both empty right now.

I will appreciate much. I have been struggling with this for a while now.

Is there a tutorial available for a Simple Search form in Chronoform? I have been trying to locate one.

On Submit Code<?php echo $PHP_SELF;?>Form HTML<h2>Search</h2> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="Fname">First Name</option> <Option VALUE="Lname">Last Name</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> <? //This is only displayed if they have submitted the form if ($searching =="yes"«») { echo "<h2>Results</h2><p>"; //If they did not enter a search term we give them an error if ($find == ""«») { echo "<p>You forgot to enter a search term"; exit; } // Otherwise we connect to our Database mysql_connect("localhost", "root", ""«») or die(mysql_error()); mysql_select_db("joomla15"«») or die(mysql_error()); // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); echo $find; //Now we search for our search term, in the field the user specified $data = mysql_query("SELECT * FROM jos_chronoforms_1 WHERE Fname like 'a%'"«»); //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['Fname']; echo " "; echo $result['Lname']; echo "<br>"; echo "<br>"; } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } //And we remind them what they searched for echo "<b>Searched For:</b> " .$find; } ?><br><br>Post edited by: GreyHead, at: 2008/04/16 12:54

Hi Rohit,

Quick and incomplete answer:

This code <h2>Search</h2> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="Fname">First Name</option> <Option VALUE="Lname">Last Name</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" />needs to stay in the HTML Code box. And this code:<? //This is only displayed if they have submitted the form if ($searching =="yes"«») { echo "<h2>Results</h2><p>"; //If they did not enter a search term we give them an error if ($find == ""«») { echo "<p>You forgot to enter a search term"; exit; } // Otherwise we connect to our Database mysql_connect("localhost", "root", ""«») or die(mysql_error()); mysql_select_db("joomla15"«») or die(mysql_error()); // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); echo $find; //Now we search for our search term, in the field the user specified $data = mysql_query("SELECT * FROM jos_chronoforms_1 WHERE Fname like 'a%'"«»); //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['Fname']; echo " "; echo $result['Lname']; echo "<br>"; echo "<br>"; } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } //And we remind them what they searched for echo "<b>Searched For:</b> " .$find; } ?>in the OnSubmit after email box. But there is no such variable as $searching, you need to set it from the form results in the $_POST array:$searching = $_POST['searching'];I'd also suggest that you use the Joomla database code, you can find an example in the Autogenerated box of any form that has a table created.

Bob