如何通过jquery $ .ajax函数从php脚本中理解和检索多个值？

Question

While using jquery $.ajax or $.post, to submit a value (say uid {user id}) how can I define a callback function to retrieve multiple values from the php script and retrieve values from my mysql table say(user details, corresponding to the uid) and store them in vars, using the default datatype:datatype???

Can anyone please show me both the jquery and php scripts please. And yes the database is runninga mySQL 5.5.24 and PHP version is 5.3

Answer 1

instead of using $.ajax you can also use this...

var id=$("#id").val();
 $.getJSON('script.php', {id:id}, function(json) {
                        var id=json.id;
                        var name=json.name;
                        var email=json.email;

        });
            }


in your php scrip..    
<?php 
    mysql_connect($host,$dbuser,$dbpass);
    mysql_select_db($db_name);
    $id=$_GET['id'];
    $query="select * from tbl_name where id='$id'";
    $rs=mysql_query($query);
    $row=mysql_fetch_assoc($rs);
    $id=$row['id'];
    $name=$row['name'];
    $email=$row['email'];
    $data=array("id"=>$id,"name"=>$name,"email"=>$email);
    echo json_encode($data);
    ?>