1.测试php环境搭建完成:
<?phpphpinfo();?>
===========================
2.测试php连接mysql数据成功:
<?php$mysqli = new mysqli("127.0.0.1", "root", "passwd"); if(!$mysqli) { echo"database error"; }else{echo "connection successfully!"}$mysqli->close(); ?>
3.测试php连接mysql,执行sql语句:
<?php $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())