How to implement image query and display function in php-PHP Problem-php.cn

How to implement image query and display function in php

PHPz

Release： 2023-04-03 20:30:01

Original

1408 people have browsed it

In website development, image transmission is a very important function. Among them, PHP query image transmission is a common implementation method. It allows users to query related pictures in the database by entering keywords and display them on the web page for users to view and download.

There are many ways to implement PHP query and display images. Below we will introduce a common implementation method.

1. Establish database and data table

First, we need to create a picture table in the MySQL database to store information about all pictures. The structure of the table is as follows:

CREATE TABLE pic (
 id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT &#39;主键ID&#39;,
 title varchar(100) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;图片标题&#39;,
 description varchar(255) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;图片描述&#39;,
 url varchar(255) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;图片URL&#39;,
 created datetime NOT NULL DEFAULT &#39;0000-00-00 00:00:00&#39; COMMENT &#39;创建时间&#39;,
 PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT=&#39;图片存储表&#39;;

Copy after login

2. Create a PHP connection

In order to connect to the database and perform query operations, we need to create a PHP connection. You can use mysqli or PDO and other connection methods. The following is a sample code for mysqli connection:

//数据库连接配置
define(&#39;DB_HOST&#39;, &#39;localhost&#39;);
define(&#39;DB_DATABASE&#39;, &#39;test&#39;);
define(&#39;DB_USERNAME&#39;, &#39;root&#39;);
define(&#39;DB_PASSWORD&#39;, &#39;&#39;);
//连接数据库
$mysqli = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if ($mysqli->connect_errno) {
die(&#39;Connect Error: &#39; . $mysqli->connect_error);
}

Copy after login

3. Write the query function

After connecting to the database, we need to write the query function. Usually, the user will enter a keyword to query, and we need to compare it with the title and description in the database, and return the matching image URL to the user. The following is a basic query code:

//定义查询关键字
$keyword = $_GET[&#39;keyword&#39;];
//执行查询
$query = "SELECT * FROM pic WHERE title LIKE &#39;%$keyword%&#39; OR description LIKE &#39;%$keyword%&#39;";
$result = $mysqli->query($query);
//处理查询结果
$pic_arr = array();
if ($result) {
while ($row = $result->fetch_assoc()) {
    $pic_arr[] = array(
        &#39;title&#39; => $row[&#39;title&#39;],
        &#39;description&#39; => $row[&#39;description&#39;],
        &#39;url&#39; => $row[&#39;url&#39;],
    );
}
}

Copy after login

4. Display query results

Finally, we need to display the query results on the web page for users to view and download. This can be implemented using technologies such as HTML and CSS. The following is a basic display code:

//遍历所有查询结果
foreach ($pic_arr as $pic) {
echo &#39;<div class="pic">&#39;;
echo &#39;<img src="&#39;.$pic[&#39;url&#39;].&#39;" />&#39;;
echo &#39;<h3>&#39;.$pic[&#39;title&#39;].&#39;</h3>&#39;;
echo &#39;<p>&#39;.$pic[&#39;description&#39;].&#39;</p>&#39;;
echo &#39;</div>&#39;;
}

Copy after login

Through the above steps, we can implement a simple PHP image query and display function. However, in actual projects, related functions such as image uploading and watermark adding may also need to be considered to meet actual needs.

The above is the detailed content of How to implement image query and display function in php. For more information, please follow other related articles on the PHP Chinese website!