许愿墙select/php/标准查询

无缺公子

https://www.zhihu.com/video/1601636423999856640
mb_internal_encoding php文件编码类型
mysqli_set_charset防止浏览器乱码
htmlspecialchars输出特殊字符
mysqli_fetch_all将结果集转为关联数组
划重点

$sql='select * from `wish` order by `id` desc ';
$res = mysqli_query($link, $sql);
$data = mysqli_fetch_all($res, mysqli_assoc);
mysqli_free_result($res);
mb_internal_encoding mysqli_set_charset MYSQLI_ASSOC word-break htmlspecialchars