首先,需要通过mysqli_connect()函数创建一个MySQL数据库连接:
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mydatabase";
$mysqli = mysqli_connect($servername, $username, $password, $dbname);
if (!$mysqli) {
die("Connection failed: " . mysqli_connect_error());
}
接着,可以使用mysqli_query()函数来执行MySQL查询:
$result = mysqli_query($mysqli, "SELECT * FROM mytable");
if (mysqli_num_rows($result) > 0) {
// 输出数据
while($row = mysqli_fetch_assoc($result)) {
echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Email: " . $row["email"]. "<br>";
}
} else {
echo "0 结果";
}
如果要执行插入、更新或删除操作,可以使用mysqli_query()函数,并检查是否执行成功:
$sql = "INSERT INTO mytable (name, email) VALUES ("John Doe", "johndoe@example.com")";
if (mysqli_query($mysqli, $sql)) {
echo "新记录插入成功";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($mysqli);
}
最后,需要使用mysqli_close()函数关闭MySQL数据库连接:
mysqli_close($mysqli);