How to return data to the front desk in php

How PHP returns data to the front desk:

1. PHP connects to the database to obtain the database information and puts it into json_encode($css);{The file is: db.php }

Using the json_encode() built-in function in php (php > 5.2) can enable data in php to be transferred and used well with other languages.

<span style="font-size:14px;"><?php
$host="localhost";
$username="root";
$password="root";
$dbName="baixing";
$port=3306;
$conn=new mysqli($host,$username,$password,$dbName,$port);
if(!$conn){
    die("error:".$conn->connect_error);
}
//设置查询结果的编码，一定要放在query之前
$conn->query("SET NAMES &#39;UTF8&#39;");
$result=$conn->query("select * from hotgoods");
//$conn->query()获取的是二进制
//将查询的结果集封装到一个数组里
$css=$result->fetch_all();
//以json的格式发送ajax的success中由data接收
echo json_encode($css);
$conn->close();</span>

2. Put the data of json_encode($css) in success: function(data), as follows: {baixing.html}

$.ajax({
        type: 'POST',
        url: 'db.php',
        data:{
//            "username":"admin",
//            "password":"123456"
        },
        success: function (data) {
            var result=eval("("+data+")");
            alert(result);
            for(var i=0;i<result.length;i++){
                var str=&#39;<div class="home1">&#39;+
                        &#39;<img src="&#39;+result[i][1]+&#39;" alt="&#39;+result[i][3]+&#39;"/>&#39;+
                        &#39;<p><a href="&#39;+result[i][2]+&#39;">&#39;+result[i][3]+&#39;</a></p>&#39;+
                        &#39;<div class="price">&#39;+
                        &#39;<span>￥&#39;+result[i][4]+&#39;</span>&#39;+
                        &#39;<del>￥&#39;+result[i][5]+&#39;</del>&#39;+
                        &#39; <a href="#">预定：<b>&#39;+result[i][6]+&#39;</b>件</a>&#39;
                &#39;</div> </div>&#39;
                $(".box7 #hotSale").append(str);//追加到你需要放在的位置
            }
        }
    });$.ajax({
        type: &#39;POST&#39;,
        url: &#39;db.php&#39;,
        data:{
//            "username":"admin",
//            "password":"123456"
        },
        success: function (data) {
            var result=eval("("+data+")");
            alert(result);
            for(var i=0;i<result.length;i++){
                var str=&#39;<div class="home1">&#39;+
                        &#39;<img src="&#39;+result[i][1]+&#39;" alt="&#39;+result[i][3]+&#39;"/>&#39;+
                        &#39;<p><a href="&#39;+result[i][2]+&#39;">&#39;+result[i][3]+&#39;</a></p>&#39;+
                        &#39;<div class="price">&#39;+
                        &#39;<span>￥&#39;+result[i][4]+&#39;</span>&#39;+
                        &#39;<del>￥&#39;+result[i][5]+&#39;</del>&#39;+
                        &#39; <a href="#">预定：<b>&#39;+result[i][6]+&#39;</b>件</a>&#39;
                &#39;</div> </div>&#39;
                $(".box7 #hotSale").append(str);
            }
        }
    });

Recommended: php server

The above is the detailed content of How to return data to the front desk in php. For more information, please follow other related articles on the PHP Chinese website!