2 回答

TA贡献1842条经验 获得超21个赞
你可以这样做:
<?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);
编辑:假设您已连接到数据库:
if ($_SERVER['REQUEST_METHOD'] == 'GET'){
$pdo = new PDO("mysql:host={$db['host']};dbname={$db['db']}", $db['username'], $db['password']);
$sql = $pdo->prepare("CALL consulta administratdor()";
$sql->execute();
$results = $statement->fetchALL(PDO::FETCH_ASSOC);
$json = json_encode($results);
}

TA贡献1775条经验 获得超11个赞
我得到了问题的解决方案,问题是在我的数据库中我有json_encode函数无法理解的特殊字符,为了解决它,请将此行聚合到我的代码中$dbConn->query("SET NAMES 'UTF8'");:
$dbConn = connect($db);
$dbConn->query("SET NAMES 'UTF8'");
if ($_SERVER['REQUEST_METHOD'] == 'GET'){
$sql = "CALL consulta_administrador()";
$q = $dbConn->query($sql);
$data = $q->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($data, JSON_UNESCAPED_UNICODE);
}
- 2 回答
- 0 关注
- 139 浏览
添加回答
举报