您可以使用内置的PHP函数json_encode()http://php.net/manual/zh/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);