LAMP/LNMP环境下：phpinfo php连接mysql php执行mysql查询 测试代码及响应

1.测试php环境搭建完成：

<?php

phpinfo();

?>

===========================

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())