Skip to content

Instantly share code, notes, and snippets.

@purwandi
Last active December 12, 2015 04:18
Show Gist options
  • Save purwandi/4713054 to your computer and use it in GitHub Desktop.
Save purwandi/4713054 to your computer and use it in GitHub Desktop.

Skenario Pertama

Field

id
name
created_at

User Interce user

<input type="date" name="start_date" />
<input type="date" name="end_date" />

Query

Asumsi start_date dan end_date pada saat user melakukan input mereka menggunakan format Y-m-d, sehingga kita perlu melakukan convert.

$date_1 = $_POST['start_date'];
$date_2 = $_POST['end_date'];

$SQL = 'SELECT * FROM tableA WHERE created_at BETWEEN '".$date_1."' AND '".$date_2."';

Klo format user hanya bulan dan tahun maka SQL nya berubah menjadi

$date_1 = date('Y-m', strtotime($_POST['start_date']));
$date_2 = date('Y-m', strtotime($_POST['end_date']));

$SQL = 'SELECT * FROM tableA WHERE DATE_FORMAT(created_at,"%Y-%m") BETWEEN '".$date_1."' AND '".$date_2."';

Skenario Kedua

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment