mysqli_fetch_all在共享主机上的替代方案是什么

Question

mysqli_fetch_all不工作。

$conn = mysqli_connect("localhost","root","","file_upload");
$sql= "SELECT * FROM files";
$result = mysqli_query($conn,$sql);
$files = mysqli_fetch_all($result, MYSQLI_ASSOC);

Answer 1

这对使用PDO有任何帮助吗。

$dsn = "mysql:host=$host;dbname=$dbname;";
$conn = new PDO($dsn, $user, $pass, null);
$sql = "SELECT * FROM files";
$rs = $conn->query($sql);
$files = $rs->fetchAll(PDO::FETCH_ASSOC);