Execute MySQL only if JS if = true

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kout
    New Member
    • Nov 2008
    • 5
    #1

    Execute MySQL only if JS if = true

    Hey

    I've got a mysql query that I'd like to process *only* if a javascript if is true. Is that possible?

    Something like this:

    Code:
    <script language="javascript">
if (condition is true) { 
<?php
$query = "UPDATE table SET example = '3' WHERE id = '1'";
$result = mysql_query($query);
?>
alert('Example'); 
window.location.reload() 
</script>
    Somehow, as soon as the web is loaded, the query is sent.

    Thank you :)
    Tags: None
    • serdar
      New Member
      • Nov 2008
      • 88
      #2
      What you are trying to do above won't work because php code is processed on the server-side (before browser gets the page content) and javascript code on client-side (after the php script processed and page downloaded by the browser).

      So you have to find a way to check if javascript is enabled within your php script, and here it is Servers side JavaScript detection in PHP4

      EDIT: I thought you want to detect javascript at first, but now I see you need something different. Well you can do what you need through an XMLHttpRequest (AJAX). A simple AJAX tutorial can be found at: AJAX Tutorial

      And here is more to show why the code above won't work:
      Code:
      <?php
	$city='London';
?>
<html>
	<head></head>
	<body>
		<script language="javascript">
			if (0) {
				<?php
					$city='Paris';
				?>
			}
		</script>
<?php
	echo $city;
?>	
	</body>
</html>
      Browser always displays 'Paris' because php code is already processed and browser just gets the resulting page.

      IMPORTANT NOTE: Using AJAX or any other javascript-based validations/tests does not guarantee that your php script cannot be run without passing the validation/test. You can only secure your test through server-side validations.

        Comment

        • Atli
          Recognized Expert Expert
          • Nov 2006
          • 5062
          #3
          Yea, serdar is correct. Doing this the way you are trying is not possible.

          The key thing to remember is that PHP is a server-side language, executed by the server to create the content that is to be sent to the client.
          Javascript is a client-side language, which is sent as a part of the content that PHP creates and executed by the client's browser.

          Neither of them can directly work with the other simply because they are not being executed by the same computer. When the Javascript is executed, the PHP code has already been executed and closed.

          But, like serdar suggested, you can use AJAX to get around this.
          An AJAX request is basically just your Javascript requesting another page from the server. If you want the client code to execute a SQL query on the server, you will have to create a PHP page on the server that executes the query, and call that page from you Javascript by using AJAX.

            Comment

            • kout
              New Member
              • Nov 2008
              • 5
              #4
              Thank you both, I'll try it now and let you know how it goes :)

                Comment

                • kout
                  New Member
                  • Nov 2008
                  • 5
                  #5
                  Worked just fine, topic solved :)

                  (PS: no edit button?)

                    Comment

                    • Markus
                      Recognized Expert Expert
                      • Jun 2007
                      • 6092
                      #6
                      Originally posted by kout
                      Worked just fine, topic solved :)

                      (PS: no edit button?)
                      Edit button disappears after 5 minutes, I think. What do you want to edit?

                        Comment

                        • kout
                          New Member
                          • Nov 2008
                          • 5
                          #7
                          Nothing, was trying to avoid double posting I did above :P

                            Comment

                            Previous template Next
                            Working...