dongxiao_0528 2015-01-08 06:04
浏览 36
已采纳

php中的Json_encode并在jquery中检索它

I am new to Jquery, Hence i am posting this question, may be its simple .

I have written the query in php page and i want to retrive it it jquery page .The php page is as follows.

   $chkuser = "SELECT A.* FROM mcd_users A WHERE A.User_Handle=('{$User_Handle}') 
   AND A.User_Password=('{$User_Password}')  AND A.Rec_Status='A' AND      
   A.User_Status='A'";

    try {
        $dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);  
        $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $stmt = $dbh->prepare($chkuser);  
        //$stmt->bindParam("id", $_GET[id]);
        $stmt->execute();
        $login = $stmt->fetchObject();
        $dbh = null;

        echo '{"item":'. json_encode($login) .'}'; 

JQuery Code :-

      $.ajax({
                        url: 'ajax_files/login.php',
                   crossDomain: true,
                            type: 'post',
                        data: $("#loginForm").serialize(), 
                       success: function(data){
                        if(data!== null)
                        {alert(data);
                            //var res=$json.decode(data);
                            //alert(res);                           
                        }

                    }
        }); // Ajax Call

Now when i alert(data); it shows.

  {"item": 
{"User_Id":"1110","Rec_Status":"A","Rec_Seq":"3","UserApplication_Id":"101",
"User_Type":"U","
User_Handle":"MCD_Admin","User_Password":"827ccb0eea8a706c4c34a16891f84e7b",
"PasswordChanged_Date":"2014-08-04",
"User_Status":"A","User_Email":"gasian@muj.com","User_Phone":"8877665544",
"Locked":"N","Reset":"N","Customer_Id":"10","CreatedBy":"1110",
"CreatedOn":"2013-07-30  00:00:00","ModifiedBy":"1110","ModifiedTime":"2014-08-04 10:49:20"}}   **

Now i need to display only the User_Handle which is MCD_Admin in jquery.js page.How to retrieve it.Any help appreciated.

  • 写回答

5条回答 默认 最新

  • duandian4501 2015-01-08 06:08
    关注

    Try this

    alert(data.item.User_Handle)
    

    EDIT

    If above code not works try this

    var result = JSON.parse(data);
    alert(result.item.User_Handle);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥15 方程如何编到C语言!
  • ¥20 关于#qt#的问题:Qt代码的移植问题
  • ¥50 求图像处理的matlab方案
  • ¥50 winform中使用edge的Kiosk模式
  • ¥15 关于#python#的问题:功能监听网页
  • ¥15 怎么让wx群机器人发送音乐
  • ¥15 fesafe材料库问题
  • ¥35 beats蓝牙耳机怎么查看日志
  • ¥15 Fluent齿轮搅油
  • ¥15 八爪鱼爬数据为什么自己停了