Pass PHP value to javascript using Ajax

Question

I have a php code that provides the database values. I need those values in the javascript variable.

Javascript Code

<script src="http://code.jquery.com/jquery-1.8.0.js"></script>
<script type="text/javascript">
    function text() {
        var textVal=$("#busqueda_de_producto").val();
        $.ajax(
        {
            type:"POST",
            url:"index.php",  //here goes your php script file where you want to pass value
            data: textVal,
            success:function(response)
            {
               // JAVSCRIPT VARIABLE = varable from PHP file.
            }
        });

        return false;
    }
</script>

PHP FILE CODE:

<?php
    $q11 = "select * from sp_documentocompra_detalle where dcd_codigo".$_GET['codigo']; 
    $res11 = mysql_query($q11);
    $row11 = mysql_fetch_array($res11);
?>

if you just want to pass variables from one php page to another just use SESSION. you are just getting variable from a script and passing back to index.php what is the use of them in you html/javascript page ? — GajendraSinghParihar
– GajendraSinghParihar, Commented Aug 30, 2012 at 9:56

Mihai Matei · Accepted Answer · 2012-08-30 09:52:35Z

2

Your returning data is in the response parameter. You have to echo your data in PHP to get the results

answered Aug 30, 2012 at 9:52

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jwchang · Accepted Answer · 2012-08-30 09:57:04Z

1

Using JSON format is convenient

because of its key-value nature.

Use json_encode to convert PHP array to JSON.

echo the json_encoded variable

you will be able to receive that JSON response data through $.ajax

answered Aug 30, 2012 at 9:57

jwchang

10.9k15 gold badges62 silver badges89 bronze badges

1 Comment

Harsimran Singh Over a year ago

but the result comming is NULL

Andreas Schrottenbaum · Accepted Answer · 2012-09-01 18:23:53Z

1

JavaScipt/HTML:

<script src="http://code.jquery.com/jquery-1.8.0.js"></script>
<script type="text/javascript">
    function text()
    {
        var textVal=$("#busqueda_de_producto").val();
        $.post('index.php', { codigo:textVal }, function(response) {
            $('#output').html(response.FIELDNAME);
        }, 'json');

        return false;
    }
</script>
<span id="output"></span>

PHP:

$q11 = "select * from sp_documentocompra_detalle where dcd_codigo='".mysql_escape_string($_POST['codigo'])."'";
$res11 = mysql_query($q11);
$row11 = mysql_fetch_array($res11);

echo json_encode($row11);

edited Sep 1, 2012 at 18:23

answered Sep 1, 2012 at 16:27

Andreas Schrottenbaum

11610 bronze badges

Comments

Undefined · Accepted Answer · 2012-08-30 09:57:17Z

0

You aren't echoing anything in your PHP script.

Try altering your PHP to this:

<?php
        $q11 = "select * from sp_documentocompra_detalle where dcd_codigo".$_GET['codigo']; 
        $res11 = mysql_query($q11);
        $row11 = mysql_fetch_array($res11);

        echo $row11; //This sends the array to the Ajax call. Make sure to only send what you want.
?>

Then in your Ajax call you can alert this by writing alert(response) in your success handler.

Tips

Send your data to the server as a URL serialised string : request=foo&bar=4. You can also try JSON if you fancy it.

Don't use mysql_* PHP functions as they are being deprecated. Try a search for PHP Data Objects (PDO).

answered Aug 30, 2012 at 9:57

Undefined

11.4k5 gold badges40 silver badges62 bronze badges

Comments

ianace · Accepted Answer · 2012-08-30 10:01:42Z

0

i see lots of things that needs to be corrected

the data in your ajax do it this way data: {'codigo':textVal}, since you are using $_GET['codigo'], which leads to the second correction, you used type:"POST" so you must also access the $_POST variable and not the $_GET variable and lastly the target of your ajax does not display / return anything you either echo it or echo json_encode() it

answered Aug 30, 2012 at 10:01

ianace

1,6352 gold badges17 silver badges32 bronze badges

Comments

Harsimran Singh · Accepted Answer · 2012-08-31 09:07:50Z

0

The best solution is to use echo json_encode("YOUR ARRAY/VALUE TO BE USED");

and then parse JSON in the javascript code as obj = JSON.parse(response);

answered Aug 31, 2012 at 9:07

Harsimran Singh

7484 gold badges13 silver badges29 bronze badges

Collectives™ on Stack Overflow

Pass PHP value to javascript using Ajax

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related