创建PHP测试页面,连接并查询MariaDB数据库。
#cat /usr/local/nginx/html/test2.php
<?php ##注意 php与?之间不能有空格
$mysqli = new mysqli('localhost','root','123(密码)','mysql(数据库)');
if (mysqli_connect_errno()){
die('Unable to connect!').mysqli_connect_error();
}
$sql = "select * from user";
$result = $mysqli->query($sql);
while($row = $result->fetch_array()){
printf("Host:%s",$row[0]);
printf("</br>");
printf("Name:%s",$row[1]);
printf("</br>");
}
?>
cat /etc/phpinfo.php
<?php
phpinfo();
?>