I have a php script which goes to database created by SilverStripe, f.e.:
dosearch.php:
<?php
// database info
$query ="SELECT * FROM StaffPage WHERE `lastname` LIKE '$_POST[last_name]%'";
$result = mysql_query($query) or die("Could not execute query");
if (mysql_num_rows($result)==0 ) {print("Not found "); return;
}
while($row = mysql_fetch_array($result)) {
echo $row[lastname].", ".$row[lfirstname];
}
?>
Now I want to put on some page form which is
<form action='./dosearch.php'>
<input type='text' name='last_name'>
<input type='submit'>
</form>
I surely can do it via iframes but it has its drawbacks. What is the recommended approach? How to accommodate/modify such script
Thank you in advance. Victor