datediff Archives

[Solved] Get total number of each day between two date in php

October 24, 2022 by Kirat

Try; define(‘ONE_WEEK’, 604800); // 7 * 24 * 60 * 60 function number_of_days($day, $start, $end) { $w = array(date(‘w’, $start), date(‘w’, $end)); return floor( ( $end – $start ) / ONE_WEEK ) + ( $w[0] > $w[1] ? $w[0] <= $day || $day <= $w[1] : $w[0] <= $day && $day <= $w[1] ); } … Read more

[Solved] Minus a day in DATEDIFF query

October 4, 2022 by Kirat

I just change my check out string from this $check_out = date(“Y-m-d” strtotime($_POST[‘co’]) to $check_out = date(“Y-m-d”, strtotime(‘-1 day’, strtotime($_POST[‘co’]))); And remove the DATEDIFF() & ABS() in the query like this below SELECT r.*, rr.rid, SUM(rr.rate) as totalsum, rr.sdate, rr.edate FROM rooms r LEFT JOIN rates as rr ON r.id=rr.rid WHERE rr.sdate >= :ci AND … Read more