Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Form Questions /

Outputting external php into Silverstripe


Reply


1127 Views

Avatar
Victor

Community Member, 128 Posts

16 March 2009 at 2:23pm

Edited: 16/03/2009 2:25pm

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