将语句转换为json

您可以使用内置的php函数json\u encode() http://php.net/manual/en/function.json-encode.php

<?php
$pdo = new PDO("mysql:dbname=database;host=127.0.0.1", "user", "password");
$statement = $pdo->prepare("SELECT * FROM table");
$statement->execute();
$results = $statement->fetchAll(PDO::FETCH_ASSOC);
$json = json_encode($results);

fetchAll() 方法来检索值数组,然后将其传递给 json_encode() .

$resultJSON = json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));

$array = $statement->fetchAll( PDO::FETCH_ASSOC );
$json = json_encode( $array );

我还发现在返回json_encode()返回的json对象之前插入并设置PHP头('Content-Type:application/json')非常有用

试试这个也许对你有帮助

 $data = array();
        if($stmt->execute()){
          while ($row = $stmt->fetchAll(PDO::FETCH_ASSOC)) {
                $data['data'] = $row;
            }
          }
      }
    
    if(!empty($data)){
        header("Access-Control-Allow-Origin: *");//this allows cors
        header('Content-Type: application/json');
        print json_encode($data);
    }else{
      echo 'error';
    }