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条)

报告相同问题?

悬赏问题

  • ¥188 需要修改一个工具,懂得汇编的人来。
  • ¥15 livecharts wpf piechart 属性
  • ¥20 数学建模,尽量用matlab回答,论文格式
  • ¥15 昨天挂载了一下u盘,然后拔了
  • ¥30 win from 窗口最大最小化,控件放大缩小,闪烁问题
  • ¥20 易康econgnition精度验证
  • ¥15 msix packaging tool打包问题
  • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题