Running a Function from Submit Button

[Anon]

Hi,

I am trying to run a php script from a submit button using the following code. The code displays and works fine but I cannot get the function to execute. Any suggestions?

<table border="0" width="400">
<tr>
<form method="post" action="<?php echo $PHP_SELF?>">
First name:<input type="Text" name="$search1" ><input type="Submit" name="submit" OnSubmit="Searchdb($search1)"> <br>

    </form>
    </td>
</tr>

</table>
</center></div>

<p align="center"><font size="2">This page is under development.<br>
</font></p>

<script language="php">
Function Searchdb($search1) {
$db = mysql_connect("localhost", "username", "password") or die("connect error: " . mysql_error());
mysql_select_db("geologyone_com",$db) or die("select_db error: " . mysql_error());
$sql_query = "SELECT * FROM minerals Where mineral_name Like $search1";
$eresult = mysql_query($sql_query,$db) or die("query error: " . mysql_query());
$num = mysql_numrows($eresult);

[Anon]

You can't call the function with "onSubmit". PHP doesn't work like Javascript in this respect. To make your example work you would need to submit the page to itself. When the page is submitted the variables $submit and $search1 will be present so you can add this code to the bottom of your page to make the function work:

if($submit) {
Searchdb($search1);
}

Also in your form name take out the "$" in $search1. Just name it search1. You use the "$" to refer to the variable search1 which will be created when the form is submitted. You probably don't want to put it in the input field name.

Trevor DeVore
Blue Mango Multimedia

[Anon]

OnSubmit has nothing to do with PHP. It is (I assume) something
in Javascript that could run on the browser, but that's it.

You do, however, have the form correctly pointing back to your
script. What exactly is the problem you are having? Don't forget
that if you are expecting the same script to both generate and
process the form, you have to distinguish the post by
doing something like:

<?php
if ($REQUEST_METHOD == 'POST')
&nbsp;&nbsp;{
&nbsp;&nbsp;// process the form here
&nbsp;&nbsp;}
else
&nbsp;&nbsp;{
&nbsp;&nbsp;// generate it here
&nbsp;&nbsp;echo "<form ....
&nbsp;&nbsp;"
?>

[Anon]

Hi,

Thanks for the info. This got it working.

Rob

[Anon]

I have an form with more then one submit button. I am processing the form with PHP. How can I find out on the server site which of these submit buttons were pressed?

Thank you?

[Anon]

When the form is submitted the button name becomes a variable. So if one of your submit buttons is:
<input type="submit" name="myButton" value="Submit">
then $myButton becomes a variable when it is submitted. So just give all of your submit buttons different names and set up your if statements accordingly.

If you are using images to submit the form then the image name becomes the variable but with x or y tacked on to the end (which gives the coordinates of where the image was clicked). So instead of checking for $myButton you would check for $myButton_x or $myButton_y.

Trevor DeVore
Blue Mango Multimedia
mangomultimedia.com