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->quer