jason php datasheet - 需要帮助 [英] jason php datasheet - help needed

问题描述

请问我的代码有问题....它不会从数据库返回数据。

please am having problem with my code.... it's not returning data from database.

<script type="text/javascript">
var myTimer;

function ajax_json_data(){
    var databox = document.getElementById("databox");
    var arbitrarybox = document.getElementById("arbitrarybox");
    var hr = new XMLHttpRequest();
    hr.open("POST", "request.php", true);
    hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    hr.onreadystatechange = function() {
        if(hr.readyState == 4 && hr.status == 200) {
            var d = JSON.parse(hr.responseText);
            arbitrarybox.innerHTML = d.arbitrary.returntime;
            databox.innerHTML = "";
            for(var o in d){
                if(d[o].title){
                    databox.innerHTML += '<p><a href="page.php?id='+d[o].id+'">'+d[o].title+'</a><br>';
                    databox.innerHTML += ''+d[o].cd+'</p>';
                }
            }

        }

    }
   hr.send("limit=");
    databox.innerHTML = "requesting...";
    myTimer = setTimeout('ajax_json_data()',6000);
}
</script>

<?php
header("Content-Type: application/json");
if(isset($_POST['limit'])){
    $limit = preg_replace('#[^0-9]#', '', $_POST['limit']);
    include_once("phpincludes/dataconect.php");
    $i = 0;
    $jsonData = '{';
    $sqlString = "SELECT * FROM bible WHERE  ORDER BY RAND() LIMIT $limit";
    $query = mysqli_query($db_conx, $sqlString) or die (mysqli_error());
    while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
        $i++;
        $id = $row["id"];
        $title = $row["title"];
        $cd  = $row["creationdate"];
        $cd = strftime("%B %d, %Y", strtotime($cd));
        $jsonData .= '"article'.$i.'":{ "id":"'.$id.'","title":"'.$title.'", "cd":"'.$cd.'" },';
    }
    $now = getdate();
    $timestamp = $now[0];
    $jsonData .= '"arbitrary":{"itemcount":'.$i.', "returntime":"'.$timestamp.'"}';
    $jsonData .= '}';
    echo $jsonData;
    }else
        echo ("nothing was posted");

?>

推荐答案

_POST [' limit']））{

_POST['limit'])){

limit = preg_replace（' ＃[^ 0-9 ]＃'，' '，

limit = preg_replace('#[^0-9]#', '',

_POST [' limit']）;
include_once（ phpincludes / dataconect.php）;

_POST['limit']); include_once("phpincludes/dataconect.php");

这篇关于jason php datasheet - 需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！