$servername = "localhost";
$username = "yosha";
$password = "leon0924";
$dbname = "test";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
/数据插入操作
$sql3 = "INSERT INTO student(SID,Name,Age) values('B23','Yosha','22')";
if ($conn->query($sql3) === TRUE) {
echo "新记录插入成功";
}
else {
echo "Error: " . $sql3 . "
" . $conn->error;
}
// $sql2= "INSERT INTO student(SID,Name,Age) VALUES('B23','Yosha',22)";
$sql = "SELECT * FROM student";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出每行数据
while ($row = $result->fetch_assoc()) {
echo "
学号: " . $row["SID"] . " 姓名: " . $row["Name"] . " 年龄:" . $row["Age"];
}
} else {
echo "0 个结果";
}
$conn->close();
?>