mysqli_connect
时间: 2023-09-04 13:09:45 浏览: 33
mysqli_connect 是 PHP 语言中用于连接到 MySQL 数据库的函数。该函数需要四个参数,分别是 MySQL 服务器的地址、用户名、密码和要连接的数据库名称。例如:
```
$servername = "localhost";
$username = "myusername";
$password = "mypassword";
$dbname = "mydatabase";
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 检查连接是否成功
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
echo "连接成功";
```
在成功连接之后,可以使用 mysqli_query 函数执行 SQL 查询语句,例如:
```
$sql = "SELECT * FROM mytable";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// 输出数据
while($row = mysqli_fetch_assoc($result)) {
echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Age: " . $row["age"]. "<br>";
}
} else {
echo "0 结果";
}
mysqli_close($conn);
```