php7连接到mysql

开发环境：

xampp7.1.26;

windows10;

今天要用php连接mysql，本想偷懒，直接上网查教程，可查了不少都依然连接失败，最后还是灰溜溜地上官网找官网示例代码，竟然查到了就摘抄一下，省得下次又再看一遍英语。

<?php
$mysqli = new mysqli("localhost", "user", "password", "database");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
echo $mysqli->host_info . "\n";
?>

连接成功后输出以下结果：

127.0.0.1 via TCP/IP

如果不是默认端口号，可以把端口号填入"3306"的位置。

<?php
    $mysqli = new mysqli("127.0.0.1", "user", "password", "database", 3306);
    if ($mysqli->connect_errno) {
        echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
    }

echo $mysqli->host_info . "\n";
?>

连接成功后，输出结果同上。