Secure Search 1

LTeeple · Nov 8, 2002

Hi all you experts out there! I am on a quest for knowledge, here's my problem:

I wish to create a page in notes (*.nsf) in which the user will enter search data (first name, last name).
The submittal will call a php function which will handle the search - searching a maximizer database.

I would like the php function to live outside the search pages, so the form action will invoke a completely independent program, passing the search data as variables.

Could someone please point me in the direction to find out more information how to do this? Or even some tips/hints to get started. Greatly appreciated!

[flowerface]

Cheers!
Laura

Bastien · Nov 8, 2002

Hi Laura

so you what the forms page to be html, to submitted to a php script, and then have another page show the results?

html page (search.html)
<html><body><form action="search.php" method=post>
search for firstname:<input name=firstname type=text size=15>
search for lastname:<input type=text name=lastname size=15>
<input type=submit value="search></form></body></html>

search.php

<?
[red]//db connection info either thru require or in this file
//you can set this up[/red]
$sql="select * from mytable where firstname like '%".$_POST['firstname']."%' and lastname like '%".$_POST['lastname']."%'";

$result=mysql_query($sql) or die("Can't query&quot

;
if (!$result){ [red]//no results...[/red]
echo "no results returned. try again";
[red]//pass the user back to the search page[/red]
header("location:

http://www.mysite.com/search.html");

exit;
}else{ [red]//there are results[/red]
echo "<table><th>first name</th><th>last name</th>";
while ($rows=mysql_fetch_array($result)){
[red]//the two lines below are not really needed... included for
//clarity in displaying the results[/red]
$firstname = $rows['firstname'];
$lastname = $rows['lastname'];

echo "<tr><td>$firstname</td><td>$lastname</td></tr>";
} [red]//end of display loop[/red]
echo "</table>";
} [red]//end of if then statement[/red]
?>

is this the type of thing that you are after?
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

LTeeple · Nov 8, 2002

Hi Bastien,
Thanks for your speedy reply!

[cheers]

Cheers!
Laura

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Secure Search 1

LTeeple

Programmer

Bastien

Programmer

LTeeple

Programmer

Similar threads

Part and Inventory Search

Sponsor