Menampilkan data dari database berdasarkan diantara tanggal tertentu sangat memungkinkan, dengan penambahan sedikit memodifikasi pada query sql yang dibangun. Teknik ini digunakan pada saat membuat sebuah laporan berdasarkan jarak (range) tanggal atau pencarian.<\/p>\n
<\/p>\n
\u201cselect * from (nama_tabel) where (nama_kolom_yang_akan_difilter) between \u2018tanggal mulai\u2019 and \u2018tanggal akhir\u2019\u201d;<\/pre>\nimplementasi pada query diatas, sebagai berikut:<\/p>\n
$sql = \"SELECT * FROM tbl_sales WHERE tanggal BETWEEN '$dt1' AND '$dt2'\";<\/pre>\nSekarang akan diuji coba, silahkan buat beberapa file diantaranya:<\/p>\n
file
index.php<\/code><\/p>\n<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>Date Range PHP<\/title>\r\n<\/head>\r\n<body>\r\n\t<h3>MySQL- Get Data Between Two Dates<\/h3>\r\n\t\r\n\t<h4>Sales Report<\/h4>\r\n\r\n\t<table border=\"1\">\r\n\t\t<thead>\r\n\t\t\t<tr>\r\n\t\t\t\t<th>No<\/th>\r\n\t\t\t\t<th>Products<\/th>\r\n\t\t\t\t<th>Date<\/th>\r\n\t\t\t<\/tr>\r\n\t\t<\/thead>\r\n\t\t<tbody>\r\n\t\t\t<?php\r\n\t\t\t\t$koneksi = mysqli_connect('localhost','root','','db_date') or die (mysqli_error());\r\n\t\t\t\t$sql = \"SELECT * FROM tbl_sales\";\r\n\t\t\t\t$query = mysqli_query($koneksi,$sql) or die (mysqli_error($koneksi));\r\n\t\t\t\t\r\n\t\t\t\t$no = 1;\r\n\r\n\t\t\t\twhile($data = mysqli_fetch_array($query)){?>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td><?php echo $no;?><\/td>\r\n\t\t\t\t\t\t<td><?php echo $data['product'];?><\/td>\r\n\t\t\t\t\t\t<td><?php echo $data['tanggal'];?><\/td>\r\n\t\t\t\t\t<\/tr>\r\n\r\n\t\t\t\t\t<?php $no++; ?>\r\n\t\t\t\t\r\n\t\t\t\t<?php }\r\n\t\t\t?>\r\n\t\t<\/tbody>\r\n\t<\/table>\r\n\t\t\r\n\t<br>\t\r\n\r\n\t<form action=\"\" method=\"post\">\r\n\t\t<input type=\"date\" name=\"tgl1\">\r\n\t\t<input type=\"date\" name=\"tgl2\">\r\n\t\t<input type=\"submit\" name=\"tampilkan\" value=\"TAMPILKAN\">\r\n\t<\/form>\r\n\t\r\n\t<h3>Hasil Sorting by Tanggal<\/h3>\r\n\t<p>Akan ditampilkan dibawah ini!<i>(filenya proses akan disatukan langsung dengan isset PHP)<\/i><\/p>\r\n\t\r\n\t<?php\r\n\t\tif(isset($_POST[\"tampilkan\"])){\r\n\t\t\t$dt1 = $_POST[\"tgl1\"];\r\n\t\t\t$dt2 = $_POST[\"tgl2\"];\r\n\r\n\t\t\t$no = 1;\r\n\r\n\t\t\t$sql = \"SELECT * FROM tbl_sales WHERE tanggal BETWEEN '$dt1' AND '$dt2'\";\r\n\t\t\t$query = mysqli_query($koneksi,$sql) or die (mysqli_error($koneksi));\r\n\r\n\t\t\techo \"<table border='1'>\r\n\t\t\t\t\t<thead>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th>No<\/th>\r\n\t\t\t\t\t\t\t<th>Products<\/th>\r\n\t\t\t\t\t\t\t<th>Date<\/th>\r\n\t\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t<\/thead>\r\n\t\t\t\t\t<tbody>\";\r\n\r\n\t\t\t\t\twhile($data = mysqli_fetch_array($query)){?>\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td><?php echo $no;?><\/td>\r\n\t\t\t\t\t\t\t<td><?php echo $data['product'];?><\/td>\r\n\t\t\t\t\t\t\t<td><?php echo $data['tanggal'];?><\/td>\r\n\t\t\t\t\t\t<\/tr>\r\n\r\n\t\t\t\t\t\t<?php $no++; ?>\r\n\r\n\t\t\t\t\t<?php }\r\n\r\n\t\t\techo \"\t<\/tbody>\r\n\t\t\t\t <\/table>\";\r\n\r\n\t\t}\r\n\t\t\t\r\n\t?>\r\n\r\n<\/body>\r\n<\/html><\/pre>\nUntuk databasenya silahkan dapat dikopi skrip berikut, kemudian simpan dengan nama database yang diinginkan.
\nMisal:laporan.sql<\/code><\/p>\n-- phpMyAdmin SQL Dump\r\n-- version 4.7.7\r\n-- https:\/\/www.phpmyadmin.net\/\r\n--\r\n-- Host: 127.0.0.1\r\n-- Generation Time: May 03, 2018 at 03:23 PM\r\n-- Server version: 10.1.13-MariaDB\r\n-- PHP Version: 5.6.23\r\n\r\nSET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\r\nSET AUTOCOMMIT = 0;\r\nSTART TRANSACTION;\r\nSET time_zone = \"+00:00\";\r\n\r\n\r\n\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;\r\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;\r\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;\r\n\/*!40101 SET NAMES utf8mb4 *\/;\r\n\r\n--\r\n-- Database: `db_date`\r\n--\r\n\r\n-- --------------------------------------------------------\r\n\r\n--\r\n-- Table structure for table `tbl_sales`\r\n--\r\n\r\nCREATE TABLE `tbl_sales` (\r\n `id_sales` int(11) NOT NULL,\r\n `product` varchar(100) NOT NULL,\r\n `tanggal` date NOT NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\r\n\r\n--\r\n-- Dumping data for table `tbl_sales`\r\n--\r\n\r\nINSERT INTO `tbl_sales` (`id_sales`, `product`, `tanggal`) VALUES\r\n(1, 'Tas', '2018-05-01'),\r\n(2, 'Kaos', '2018-05-01'),\r\n(3, 'Tas Kulit', '2018-04-01'),\r\n(4, 'Kaos Polo', '2018-04-20'),\r\n(5, 'Laptop A', '2018-05-02'),\r\n(6, 'Celana Jeans', '2018-04-18');\r\n\r\n--\r\n-- Indexes for dumped tables\r\n--\r\n\r\n--\r\n-- Indexes for table `tbl_sales`\r\n--\r\nALTER TABLE `tbl_sales`\r\n ADD PRIMARY KEY (`id_sales`);\r\n\r\n--\r\n-- AUTO_INCREMENT for dumped tables\r\n--\r\n\r\n--\r\n-- AUTO_INCREMENT for table `tbl_sales`\r\n--\r\nALTER TABLE `tbl_sales`\r\n MODIFY `id_sales` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;\r\nCOMMIT;\r\n\r\n\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;\r\n\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;\r\n\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;\r\n<\/pre>\n