how to execute codes only by clicking button

kalasag

hi!

Im working on a php page that will retrieve data into a database.

My problem is the data is displayed already when i run the page.

I want the data to display only when push the submit button..

heres my simple code..btw im using adodb.

$search = $_POST['searchbox'];
$sql = "SELECT main_entry,part_of_speech,synonyms,antonyms FROM thesauri where synonyms LIKE '%$search%'";
$rs = &$db->Execute($sql);
if (!$rs) {
print $db->ErrorMsg(); // Displays the error message if no results could be returned
}

thanks!

devinemke

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	searchbox: <input type="text" name="searchbox"><br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	// connect to db here
	$search = $_POST['searchbox'];
	$sql = "SELECT main_entry,part_of_speech,synonyms,antonyms FROM thesauri where synonyms LIKE '%$search%'";
	$rs = &$db->Execute($sql);
	if (!$rs) {print $db->ErrorMsg();}
}
?>

kalasag

thanks! but its not working..maybe because im using Adodb, i dont know..thanks!

anyone have any ideas?

kalasag

Hey devinemke thanks a lot!! i finally got it to work..thanks for your help,i really appreciate it.