How I Can move variable from JavaScript into a php Query?

Question

Here is my Code I want to move my Variable of "Hellow"

from JavaScript

to PHP Query at: document.write("<?php $result = mysql_query("SELECT Urdu FROM translate where English= 'Variable'"); ?>");.

Kindly any help?

   <script type='text/javascript'>

   var Variable = "Hellow";


document.write("<?php


$db = mysql_connect("localhost","root","");
mysql_select_db("Dictionary",$db);

?>");

document.write("<?php $result = mysql_query("SELECT Urdu FROM translate where English=     'Variable'"); ?>");

document.write("<?php

 while($row = mysql_fetch_array($result))
  {

echo  $row['Urdu'] ;

 }


mysql_close($db); 

?>");

</script>

Answer 1

You can't/should not do what you propose. JS is executed client side, while PHP is a server side language, and even if it is possible to send a file to the server and execute it, it would come with a host of security issues.

What you could do however is to make a get/ajax request that sends your variable to a php script, but remember to clean up the variable before using it in any mysql query.

Answer 2

What you are trying to do won't work because the PHP processing happens earlier in the stack than the Javascript. You will need to use ajax to send data back to the server once the page has loaded.

jQuery can make this pretty easy for you. Look up $.ajax methods for jquery.