Detect form submit with Javascript

[john87423]

I am trying to to detect a form submit with Javascript although the code I am using - shown below does not work.

Once the alert works, I can make the SQL work.

Please suggest why I cannot get the alert working.
Cheers

<?php
	echo '<script type="text/javascript">
		<!--
			function submitForm(action)
			{
				document.addUser.submit.value = action;
				document.addUser.submit.submit();

			if($_POST["submit"] == "submit") 
			{
				alert("hello");
			}
		}
	//-->
</script>';	

include 'DBConnect.php';

echo "<a href='Users.php'>User list</a><br>";

echo "<form id='addUser' method='post' action='addUserForm.php?ID=$ID'>";	
echo "Name:<br><input type='text' name='Name'><br>";
echo "Initials:<br><input type='text' name='Initials'><br>";
echo "Password:<br><input type='text' name='Password'><br>";
echo "Email:<br><input type='text' name='Email'><br>";
echo "<input type='submit' name='submit' onClick='submitForm(submit)' value='Update'>";
echo "</form>";

$name = $_REQUEST['Name'];
$initials = $_REQUEST['Initials'];
$password = $_REQUEST['Password'];
$email = $_REQUEST['Email'];

//header("Location: Users.php");
//$records = $conn->Execute("INSERT INTO WebUsers (Name, Initials, Pass, EMail) VALUES ('$name', '$initials', '$password', '$email')");	
?>

[bpat1434]

Here's the issue: you're mixing PHP and javascript.

PHP is a server-side language, and as such will only be run on the server.
Javascript is a client-side language and is run inside the browser (or on the client's computer).

Now, what you have is the form submitting to itself with an ID in the URL (as a $_GET variable). Now, when your script reloads, all that POST data will be available to it.

Now, in your javascript, you use PHP to check for the submit item. Since Javascript has no idea what $_POST is, nothing will happen. Now, if you were to pull that if() statement out of the echo statement, you'd get the alert added as you expect; however, there is a minor detail. The alert will only show up after the form is submitted for a second time.... yet the form submission reloads the page 🙁

[john87423]

How would I (briefly and clues only), use PHP and Javascript in one file to execute an SQL query when a submit button is used.

Sorry if my PHP is rusty - I have not done this for a while.

Thanks

[condoug]

As far as I can see, there is no requirement to use Javascript to submit your PHP form.

At the top of your PHP script, just put something like the following:

if (isset($_POST['submit'])) {
 $name =  addslashes(trim($_POST['name']));
 $title = addslashes(trim($_POST['initials']));

// then do something here like an update to the database or run another script etc

}

[john87423]

Oops ignore this reply...