Home > Article > Backend Development > How to write a simple online dictionary function via PHP
How to write a simple online dictionary function via PHP
- WBOYOriginal
- 2023-09-24 12:33:03953browse
How to write a simple online dictionary function through PHP
With the continuous development of the Internet, people's demand for online dictionaries is also increasing. In this article, we will introduce how to write a simple online dictionary function using PHP.
To implement an online dictionary function, we first need a dictionary database. Here, we will use a MySQL database named "dictionary" and create a data table named "words" to store words and corresponding explanations.
First, we need to install and configure PHP, MySQL, Apache and other environments on the server. Once the environment is set up, we can start writing code to implement the online dictionary functionality.
First, we need to display a search box and a display area on the web page to display query results. We can create this user interface using HTML and CSS.
<!DOCTYPE html>
<html>
<head>
<title>在线词典</title>
<style>
input[type=text] {
width: 300px;
height: 30px;
font-size: 16px;
}
#result {
margin-top: 10px;
font-size: 16px;
}
</style>
</head>
<body>
<h1>在线词典</h1>
<form action="" method="post">
<input type="text" name="word" placeholder="请输入要查询的单词">
<input type="submit" value="查询">
</form>
<div id="result">
<?php
// 在这里编写PHP代码
?>
</div>
</body>
</html>Then, we need to write PHP code to handle the user's query request and retrieve the explanation of the word from the database. We can use PHP's MySQL extension to connect and operate the database.
<?php
// 连接数据库
$mysqli = new mysqli("localhost", "root", "password", "dictionary");
// 检查连接是否成功
if ($mysqli->connect_error) {
die("连接数据库失败：" . $mysqli->connect_error);
}
// 处理查询请求
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$word = $_POST["word"];
// 构建查询语句
$sql = "SELECT * FROM words WHERE word = '$word'";
// 执行查询
$result = $mysqli->query($sql);
// 检查查询结果
if ($result->num_rows > 0) {
// 输出单词的解释
$row = $result->fetch_assoc();
echo "<p>" . $row["word"] . ": " . $row["definition"] . "</p>";
} else {
echo "<p>未找到该单词的解释。</p>";
}
// 释放结果集
$result->free();
}
// 关闭数据库连接
$mysqli->close();
?>The above code does the following:
- Connect to the database
- Get the words entered by the user from the POST request
- Build a SELECT query statement to retrieve the explanation of the word
- Execute the query and output the results. If the corresponding explanation is not found, the corresponding prompt message will be output
- Release the query results and close the database connection
Finally, we need to insert this PHP code into the PHP tag in the previously created HTML file, thus completing the writing of the online dictionary function.
Through the above steps, we have successfully written a simple online dictionary function using PHP. Users can now enter the word they want to query in the search box and see the corresponding explanation in the display area.
Of course, this is just a simple example. You can modify and expand the code according to your own needs, such as adding user registration and login functions, supporting multiple languages, etc.
I hope this article can be helpful to your PHP programming, and I wish you happy programming!
The above is the detailed content of How to write a simple online dictionary function via PHP. For more information, please follow other related articles on the PHP Chinese website!