How to write php code in javascript tag

Question

I have code like this

<select onchange="getval(this);"> 
     <option value="">Select</option>
     <option value="1">one</option>
     <option value="2">two</option>
     <option value="3">three</option>
</select>

And my script like this

function getval(sel){
//alert(sel.value);
    <?php $sql = "SELECT * FROM tbl_table WHERE id="?>+(sel.value)
}

I want select data from table where id values from javascript but I don't know how to write php in javascript tag and how to add javascript's variable (sel.value) after PHP

How can I correct this syntax?

Use ajax, you can't do it like this. You can't assign javascript variable or value to PHP. — jogesh_pi
– jogesh_pi, Commented Oct 22, 2014 at 5:03
this is a bad idea. Don't do like this. Better use ajax other than use PHP with in javascript — Arun
– Arun, Commented Oct 22, 2014 at 5:04

bhavesh vala · Accepted Answer · 2014-10-22 05:27:57Z

May this will help you. You can use with ajax...

mainfile.php

<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script>

function getval(x){
    var data_arr="id="+x;  
    $.ajax({
        type:"POST",
        url:"anotherfile.php",
        data:data_arr,
         success: function(response){
            // here your response will come now you have to deside how to maintain this response...
         }

    });
}
</script>

<select onchange="getval(this.value);"> 
     <option value="">Select</option>
     <option value="1">one</option>
     <option value="2">two</option>
     <option value="3">three</option>
</select>

and your another file which contain ajax code is here...

anotherfile.php

<?php 
mysql_connect("hostname","username","password");
mysql_select_db("database_name");
$sql = "SELECT * FROM tbl_table WHERE id=".$_REQUEST['id'];
while($row = mysql_fetch_array($sql)){
    // here your out put data code...
}
// and finally write all data in echo statement they will return as response

hope you got it...

Aitazaz Khan · Accepted Answer · 2014-10-22 05:26:52Z

3

Php is server side scripting language and JavaScript is client side language so it seems to be impossible! Further Explanation.

PHP is a programming language. It is often used for server side programming, but has uses in general programming too.

JavaScript is a programming language. It is the only language that has a decent level of native support for running in a browser.

Similarity:

Both languages are almost exclusively for the web and were created specifically for web use in the mid 90s.
Syntax styles are both based on C
Until only recently with PHP going full OO, both languages were not officially OO languages
Both languages are platform independent (compiler or ‘runtime environment’ is required though)

Differences:

PHP is server side while JavaScript is client side.
PHP makes use of classes while JavaScript only has constructors and functions.
JavaScript is used for a lot of visual effects and enhancements for web GUIs.
Users are able to disable all JavaScript while browsing the internet due to its client-side compilation.

Solution:

AJAX = Asynchronous JavaScript and XML.

AJAX is not a new programming language, but a new way to use existing standards.

AJAX is the art of exchanging data with a server, and updating parts of a web page - without reloading the whole page.

edited Oct 22, 2014 at 5:26

answered Oct 22, 2014 at 5:03

Aitazaz Khan

1,6031 gold badge14 silver badges35 bronze badges

1 Comment

Kevin Over a year ago

thats why they added the XMLHttpRequest API to circumvent this limitation.

IKnowledge · Accepted Answer · 2014-10-22 05:24:25Z

1

If I understood you correctly, you cannot write PHP in this way. PHP stays on the server, and never gets shown on the page. You need to either POST the page or use AJAX. The most basic way is to use a 'Submit' button and handle the result with PHP. Look at this basic example: http://www.tizag.com/phpT/forms.php?

edited Oct 22, 2014 at 5:24

answered Oct 22, 2014 at 5:07

IKnowledge

2213 silver badges12 bronze badges

1 Comment

Max Leske Over a year ago

Please don't use w3schools as a resources. See this: meta.stackexchange.com/questions/87678/….

Collectives™ on Stack Overflow

How to write php code in javascript tag

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related