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 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值