LAMP/LNMP环境下:phpinfo php连接mysql php执行mysql查询 测试代码及响应
发布时间:2018-06-09 20:15,
浏览次数:382
, 标签:
LAMP
LNMP
phpinfo
php
mysql
1.测试php环境搭建完成:
phpinfo();
?>
===========================
2.测试php连接mysql数据成功:
$mysqli = new mysqli("127.0.0.1", "root", "passwd");
if(!$mysqli) {
echo"database error";
}else{
echo "connection successfully!"
}
$mysqli->close();
?>
3.测试php连接mysql,执行sql语句:
$mysqli = new mysqli("127.0.0.1", "root", "passwd","yourDB");
$uresult = $mysqli->query("SELECT * FROM tb_name", MYSQLI_USE_RESULT);
if(!$mysqli) {
echo"database error";
}else{
if ($uresult) {
while ($row = $uresult->fetch_assoc()) {
echo $row['name'] . PHP_EOL; #输出表中的字段
}
}
}
$uresult->close();
$mysqli->close();
?>