How to query data within date with php+mysql

The first step is to create a database table and insert some data. Let's create a table named "orders", including the following fields:

• id: self-increment ID

• date: place an order Date

• #amount: Order amount

Use the following SQL statement to create the table:

CREATE TABLE orders ( id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, date DATE, amount DECIMAL(10,2) );

Next, we can insert some To test the data, use the following SQL statement:

INSERT INTO orders (date, amount) VALUES ('2021-01-01', 100), ('2021-01-02', 50), ('2021-01-03', 200), ('2021-01-04', 150), ('2021-01-05', 75);

Now we have a table containing order data.

The next step is to write PHP code to query the data within the date range. We will create a new file named "search.php" and then use the following code:

connect_error) { die("Connection failed: " . $conn->connect_error); } //检查搜索日期的输入 if (isset($_POST['from_date']) && isset($_POST['to_date'])) { //将输入的日期格式化为MySQL日期格式 $from_date = date('Y-m-d', strtotime($_POST['from_date'])); $to_date = date('Y-m-d', strtotime($_POST['to_date'])); //查询日期区间内的订单数据 $sql = "SELECT * FROM orders WHERE date >= '$from_date' AND date <= '$to_date'"; $result = $conn->query($sql); //输出查询结果 if ($result->num_rows > 0) { echo ""; while($row = $result->fetch_assoc()) { echo ""; } echo "
ID
Date
Amount
".$row["id"]."
".$row["date"]."
".$row["amount"]."
"; } else { echo "0 results"; } } //关闭连接 $conn->close(); ?>

This code connects to the database and then checks the search date range entered by the user. If a date range is entered, the script will format the entered date into MySQL date format, then query the order data and output the results in a table. If there are no results, "0 results" will be output.

Now, we need to create an HTML form that accepts user input. Here is the complete code for the "search.php" file:

    
  
Search Orders By Date Range
 
 From:  To:   
   

This HTML file creates a form that allows the user to enter a starting and end date. We will submit the form to the same page using the POST method and include the PHP code we just created above.

Now, we can open this file in a browser and use the form to enter a date range to search for order data. The results will be displayed in a table.

The above is the detailed content of How to query data within date with php+mysql. For more information, please follow other related articles on the PHP Chinese website!