html怎么读取sql数据库连接,如何将我的sql数据库与html网页连接并从中检索数据？...

步骤1您需要连接到您的数据库

第2步你需要一些东西将数据库中的值传递给你的html来显示它们 .

因此，从您开始我建议使用php将值传递到数据库或从数据库传递值 .

要连接到您的数据库，您需要指定4件事 . servername您为数据库创建的用户的用户名，用户密码和数据库的实际名称我在下面给出了一个示例

$dbServername = "localhost";

$dbUsername = "root";

$dbPassword = "Brendan7";

$dbName = "cars";

$conn = mysqli_connect( $dbServername , $dbUsername , $dbPassword , $dbName );

现在，一旦连接，您就可以创建一个SQL select语句，将数据带入您的html中

include_once 'header.php';

$user_id = $_SESSION["u_id"];

$sql = "SELECT * FROM `person` WHERE person_id = " .$user_id." ";

// $sql = "SELECT SINGLE `user_id` FROM `users` WHERE user_id = '".$user_id."'";

$conn = mysqli_connect( $dbServername , $dbUsername , $dbPassword , $dbName );

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

echo "user_id: " . $row["person_id"]. " - person_id: " . $row["person_first"]. " " . $row["person_last"]. "
";

$person_id = $row["person_id"];

$person_first = $row["person_first"];

}

} else {

echo $sql;

}

$conn->close();

?>

First Name

Last Name

Mobile

Address

Email

SSN

include_once 'footer.php';

?>