confirming a message

learnphp1

I have a message to show to the user in a pop up window style. If the user agrees to it i want to update the database but if the user decides to cancel, then there we dont update the database.

I dont know how to accomplish this in php or do we need to usie javascript/jquery

dalecosp

Both, I'd expect.

learnphp1

dalecosp;10969813 wrote:
Both, I'd expect.

Is there any example that i can follow so that i can head in the right direction.

i dont know how to go ahead


if($error == 'No'){
		////count the number of records///
		$sqlRec = "SELECT COUNT(*) AS NumberOfRec FROM ratecodes_TEST";
		$resultRec = es_query($sqlRec);
		$numRec = mysql_fetch_array($resultRec);
		echo 'Number of Records '.$numRec[0];
	?>
    <script type="text/javascript" >
		var answer= confirm("Total number of rows in the file are . If this matched with the rows in the uploaded file the click ok otherwise click cancel to cancel uploading the file" )
	</script>

<?php 

}

now if answer is yes i want to do some php coding but i dont know how to combine javascript and php variables..

dalecosp

PHP can output javascript. You can't "intermingle" exactly; PHP is server-side and request-driven. Maybe:

<html>
   <head>
      <title>Confirm</title>
   </head>
   <body onload=confirmation()>
<script type="text/javascript">
<!--
function confirmation() {
        var answer = confirm("Save your work?")
        if (answer){
                alert("Bye bye!")
                window.location = "http://www.mysite.com?page=write2db.php";
        }
        else{
                alert("Work not saved!")
        }
}
</script>
   </body>
</html>

... then in write2db.php you'd do your database work.

dalecosp

You can do this:

    <script type="text/javascript" >
        var answer= confirm("Total number of rows in the file are <?php echo $numRec; ?>. If this matched with the rows in the uploaded file the click ok otherwise click cancel to cancel uploading the file" )
    </script>