doufeikuang7724 2015-09-25 13:04
浏览 62

使用wordpress从php和mySql查询获取json输出

I'm trying to create a php page that should shows me a json output.. I'm in a wordpress website and maybe it's a little bit different to retrive datas from database than in a normal php page. By the way, this is my code:

<?php


    $path = $_SERVER['DOCUMENT_ROOT'];

    include_once $path . '/wp-config.php';
    include_once $path . '/wp-load.php';
    include_once $path . '/wp-includes/wp-db.php';
    include_once $path . '/wp-includes/pluggable.php';
    global $wpdb;

    $code = ''; 
    $code=$_REQUEST['code'];

    $timestamp = ''; 
    $timestamp=$_REQUEST['timestamp'];

    $username = ''; 
    $username=$_REQUEST['username'];

    $selectData = "SELECT * FROM protocol_data_list WHERE username = '$current_user->user_login'";
    //Create an array
    $json_response = array();
    $result = $wpdb->query($selectData);

    echo $result; 
    while ($row=mysqli_fetch_array($result, MYSQL_ASSOC)) {
    echo $row;
    $row_array['code'] = $row['code'];
    $row_array['timestamp'] = $row['timestamp'];
    $row_array['username'] = $row['username'];

        array_push($json_response,$row_array);
    }

    $json_response = str_replace('\\/', '/', json_encode(array('item' => $json_response), 128));

    echo $json_response;


?>

this kind of code is the one i use always to create a json.. But in wordpress it returns an empty array.. I don't know if something's wrong.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Matlab编程问题
    • ¥15 训练的多模态特征融合模型准确度很低怎么办
    • ¥15 kylin启动报错log4j类冲突
    • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
    • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序
    • ¥15 onvif+openssl,vs2022编译openssl64
    • ¥15 iOS 自定义输入法-第三方输入法
    • ¥15 很想要一个很好的答案或提示
    • ¥15 扫描项目中发现AndroidOS.Agent、Android/SmsThief.LI!tr
    • ¥15 怀疑手机被监控,请问怎么解决和防止