Home > Article > Backend Development > How to send php query data to the front end
PHP is a commonly used back-end language in web development. Sometimes it is necessary to query data from the database and transfer it to the front-end page so that users can view and use the data. In this article, we will introduce how to query the database in PHP and transfer the data to the front end so that you can develop more complex web applications.
1. Connect to the database
Before using PHP to query the database, you need to establish a connection with the database first. Connecting to the database using PHP can be achieved through PHP's mysqli and PDO extensions. The specific steps are as follows:
$servername = "localhost"; // 数据库主机名 $username = "username"; // 数据库用户名 $password = "password"; // 数据库密码 $dbname = "myDB"; // 数据库名 // 创建连接 $conn = mysqli_connect($servername, $username, $password, $dbname); // 检查连接是否成功 if (!$conn) { die("Connection failed: " . mysqli_connect_error()); }
$servername = "localhost"; // 数据库主机名 $username = "username"; // 数据库用户名 $password = "password"; // 数据库密码 $dbname = "myDB"; // 数据库名 // 创建连接 try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // 设置 PDO 错误模式为异常 $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); }
2. Query data
After successfully connecting to the database, you can query the data. Querying the database using PHP can be achieved through mysqli and PDO extensions. The specific steps are as follows:
$sql = "SELECT id, name, email FROM users"; $result = mysqli_query($conn, $sql); 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 results"; }
$sql = "SELECT id, name, email FROM users"; $result = $conn->query($sql); if ($result->rowCount() > 0) { // 输出数据 while($row = $result->fetch()) { echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Email: " . $row["email"]. "<br>"; } } else { echo "0 results"; }
The above code The values of the id, name and email fields will be queried from the database table named "users". If the data is queried, the data will be output to the front end. If no data is found, "0 results" is output.
3. Send data to the front-end
After querying the data, you need to send them to the front-end page. In PHP, data can be passed to the frontend via JSON format. The specific steps are as follows:
$sql = "SELECT id, name, email FROM users"; $result = mysqli_query($conn, $sql); $data = array(); if(mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_assoc($result)) { $data[] = $row; } } $json = json_encode($data);
Use AJAX technology can asynchronously transmit server-side data to the front-end, allowing the front-end page to display data more quickly.
<script> var xmlhttp = new XMLHttpRequest(); var url = "getdata.php"; xmlhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { var data = JSON.parse(this.responseText); // 将数据渲染至前端页面 // ... } }; xmlhttp.open("GET", url, true); xmlhttp.send(); </script>
The above code will obtain data in JSON format from the file named "getdata.php" and render the data to the front-end page.
Conclusion
Through the introduction of this article, you have learned how to connect to the database, query data and transfer data to the front-end page in PHP. At the same time, we also introduced common ways to use JSON to transfer data. Now, you can use these techniques to develop more complex web applications.
The above is the detailed content of How to send php query data to the front end. For more information, please follow other related articles on the PHP Chinese website!