How to get database data in html-HTML Tutorial-php.cn

How to use HTML to obtain database data

Introducing the database

In HTML, the database cannot be accessed directly. Requires the use of backend technologies such as PHP, JavaScript, or Python to fetch data from the database.

Using PHP

PHP is a popular backend language that makes it easy to connect to databases. Here is a sample code:

connect_error) { die("连接失败: " . $conn->connect_error); } // 准备查询 $sql = "SELECT * FROM table_name"; // 执行查询 $result = $conn->query($sql); // 检索数据 while ($row = $result->fetch_assoc()) { echo $row["column_name"]; } // 关闭连接 $conn->close(); ?>

Copy after login

Using JavaScript

JavaScript can also use AJAX (Asynchronous JavaScript and XML) to get data from the database. The following is a sample code:

function getData() { // 创建 XMLHttpRequest 对象 var xhr = new XMLHttpRequest(); // 打开连接 xhr.open("GET", "get_data.php", true); // 设置回调函数 xhr.onload = function() { // 服务器响应后执行 if (xhr.status === 200) { // 解析 JSON 响应 var data = JSON.parse(xhr.responseText); // 输出数据 for (var i = 0; i < data.length; i++) { console.log(data[i].column_name); } } }; // 发送请求 xhr.send(); }

Copy after login

Using Python

Python can also use web frameworks such as Flask to get data from the database. Here is a sample code:

from flask import Flask, render_template, request app = Flask(__name__) @app.route('/') def index(): # 连接数据库 conn = pymysql.connect(host="localhost", user="username", password="password", db="database_name") cursor = conn.cursor() # 准备查询 sql = "SELECT * FROM table_name" # 执行查询 cursor.execute(sql) # 检索数据 data = cursor.fetchall() # 关闭连接 cursor.close() conn.close() # 渲染模板 return render_template('index.html', data=data) if __name__ == "__main__": app.run(debug=True)

Copy after login

The above is the detailed content of How to get database data in html. For more information, please follow other related articles on the PHP Chinese website!