dpi96151 2013-10-08 18:51
浏览 54
已采纳

如何将从mysql数据库返回的数据转换为json

I am trying to learn backbone.JS using WAMP server. when I am trying to retrieve the data from database using fetch function, I couldn't convert the data extracted from database into JSON objects. So here I used Index.php for client side and views.php for server side. Name of my database is dss.Thanks in advance. So here is my code

index.php

            <!doctype html>
            <html>
                <title>
                    backbone example
                </title>
                <body>
                    <script src="jquery-1.9.1.js"></script>
                    <script src="underscore.js"></script>
                    <script src="backbone.js"></script>
                    <div id="container">
                    <h1>
                        HELLO
                    </h1>
                        <div id="page">

                        </div>
                    </div>
                    <script>
                        var User=Backbone.Collection.extend(
                            {
                                url:'backbone sample/users'
                            }
                        );
                        var UserList=Backbone.View.extend(
                        {   

                            el:'#page',
                            render:function()
                            {
                                  var that=this;
                                var users=new User;

                                        users.fetch({

                                            success:function()
                                            {
                                                    alert('success');
                                            }
                                    }
                            );
                                }
                        }
                        );
                         var router=Backbone.Router.extend(
                         {
                             routes:
                                 {
                                 '':'home'
                                 }
                         });

                         var userList=new UserList();
                         var rou=new router();
                         rou.on('route:home',function(){

                               userList.render();

                         });
                         Backbone.history.start();
                    </script>
                </body>
            </html>

users.php

                <?php 

                    $request_method = strtolower($_SERVER['REQUEST_METHOD']);



                        $a=$_GET['id'];
                        mysql_connect("localhost", "root", "") or die("connection error");
                        mysql_select_db("dss") or die("db error");
                        $results=  mysql_query("select * from subscribers where EmailId='$a'");

                ?>
  • 写回答

1条回答 默认 最新

  • duanqiao2225 2013-10-08 19:17
    关注

    I agree, get off of mysql_* funcs now and use mysqli_* or PDO. I don't know anything about backbone or how you can call users.php, but for the PHP I'll use mysqli to echo out the json object:

    echo json_encode(mysqli_fetch_object($results));
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 程序不包含适用于入口点的静态Main方法
  • ¥15 素材场景中光线烘焙后灯光失效
  • ¥15 请教一下各位,为什么我这个没有实现模拟点击
  • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记