[RESOLVED] Form updates when page loads?

damienmcd

I have a form that updates my database when the page loads, however I only want the database to be updated when the button is clicked to submit the data.

I'm sure it's a simple function call but unfortunately I'm a complete newbie to PHP.

Any help would be brilliant!

damienmcd

PHP code:
function update_summary()
{
// Needs to be clled when Update button is pressed and not just called when the page loads!!
$summary = $_GET["summary_text"];
$result = mysql_query("UPDATE kpi_summary SET summary_text='$summary' WHERE subsystem_name='total_topups'")
or die(mysql_error());
}

HTML Form:
<table width="700" align="center" cols="1">
<form name="total_topups_summary" method="get" onsubmit="<?php update_summary() ?>">
<tr>
<td>Please enter new summary:</td>
</tr>

<tr>
	<td><textarea rows="4" name="summary_text"><?php print $tot_topups[5]; ?></textarea></td>
</tr>

<tr>
	<td width="500"><input type="submit" value="Update Summary"></td>
</tr>

</table>

devinemke

move the code that updates the db to your form handling script

damienmcd

Do you mean something like:

<table width="700" align="center" cols="1">
<form name="total_topups_summary" method="get"
onsubmit="<?php function update_summary()
{
// Needs to be clled when Update button is pressed and not just called when the page loads!!
$summary = $_GET["summary_text"];
$result = mysql_query("UPDATE kpi_summary SET summary_text='$summary' WHERE subsystem_name='total_topups'")
or die(mysql_error());
} ?>
">
<tr>
<td>Please enter new summary:</td>
</tr>

<tr>
	<td><textarea rows="4" name="summary_text"><?php print $tot_topups[5]; ?></textarea></td>
</tr>

<tr>
	<td width="500"><input type="submit" value="Update Summary"></td>
</tr>

</table>

devinemke

you are getting confused between client-side and server-side programming. PHP runs on the server, not the client. thus it cannot be called via the onsubmit event handler. you need to specify a form handling script in the action tag of your form. this is where your code that processes the form data (and updates your db) should go.

damienmcd

Thanks,
Put the MySql statement in a separate page on the server and it updated the DB.