Calling A Function Using A Form - REVISED

[jeff_lawik]

Hello - thanks for viewing:

Here's what I want to accomplish: The problem I am having/trying to avoid, is I don't want query_update to execute when the page is loaded. Rather, I would like it to execute after the form is submitted which will also provide the function with the required variables for a sucessful update.

Thanks For The Help! Jeff

$variable = jeff;
$record_id = MSFT;
          print "
          <form action=\"runUpdate\" method=\"POST\">
          Company Name
          <input type=\"text\" name=\"input\">
          <input type=\"submit\" value=\"Update Record\" class=\"pushbutton\"></form>";

function Update()
{
          $query_update = mysql_query( "UPDATE market_research SET company_name = '$input' WHERE symbol = '$record_id'" );
          if ( $query_update )
            {
            print "SUCCESS";
            }
          else
            {
            print "ERROR";
            }
}

[daveyboy]

You have to use a URL as the action of a form. Like 'myfile.php' or similar. You can't call a function from the form. You cannot capture events from the browser, like key clicks or whatever, only requests to your server. There is no way to execute a PHP function AFTER the page has been sent to the client. PHP is server-side. Once your page is generated only client-side scripting - JavaScript, Flash etc. - can be used. You have to execute your update when a page is called upon form submission.

You could give your submit button a name, let's say 'kirsty' (why not?):

if ( $_POST['kirsty'] == "Update Record" ){
    Update();
} else {
    show_mr_form();
}

If that really is no good for you, you could use a Flash button to call the PHP page and execute the update without updating the page in the browser, but why would you want to do that? The page would be out of date.