PHP和MySQL建立连接

编写测试文件

PHP5.x版本

<?php
//$links=mysql_connect('主机名','用户','密码');
//mysql -u用户 -p密码 -h 主机
$links=mysql_connect("localhost","root","");
if($links){
echo "link db ok!!";
}
else{
echo "link db no !!";
}
?>

 

PHP7.x版本

<?php
        $servername = "localhost";
        $username = "root";
        $password = "oldboy123";
        //$link_id=mysqli_connect('主机名','用户','密码');
        //mysql -u用户 -p密码 -h 主机
        $conn = mysqli_connect($servername, $username, $password);
        if ($conn) {
              echo "mysql successful by root !\n";
           }else{
              die("Connection failed: " . mysqli_connect_error());
           }
?>