Schedule grid with PHP

Question

I’m having a little problem with my code, which generates schedule, it’s not entering the last time.

type 07:00 to 10:00 30 min interval but it only goes until 9:30 does not record the 10:00

This is my code :

<?
date_default_timezone_set("Brazil/East");
$con=@mysql_connect("localhost","root","");
$bd=mysql_select_db("test",$con);
//$hora_inicio = $_POST['hora_inicio'];  
//$hora_final = $_POST['hora_final'];
$hora_inicio = "07:00";  
$hora_final = "10:00";             
$ini = strtotime($hora_inicio);
$fim = strtotime($hora_final);
$atu = $ini;
$i = 1;
for ($atu = $ini ;  $atu < $fim; $atu = strtotime('+30 minutes', $atu)) {
$hr_agendamento = date('H:i', $atu);
$sql = mysql_query("INSERT INTO agenda (id_agenda,hr_agendamento) VALUES('','$hr_agendamento')");                        
}
echo"agenda criada";
?>

Answer 1

This is happening because you’re comparing in your for in your line 13, if $atu is less than $fim.

for ($atu = $ini ; $atu < $end; $atu = strtotime('+30 minutes', $atu))

In order for him to do what you want, you must also compare if $atu is equal to $fim.

for ($atu = $ini ; $atu <= $end; $atu = strtotime('+30 minutes', $atu))

Getting your loop like this:

date_default_timezone_set("Brazil/East");
$con=@mysql_connect("localhost","root","");
$bd=mysql_select_db("test",$con);
//$hora_inicio = $_POST['hora_inicio'];  
//$hora_final = $_POST['hora_final'];
$hora_inicio = "07:00";  
$hora_final = "10:00";             
$ini = strtotime($hora_inicio);
$fim = strtotime($hora_final);
$atu = $ini;
$i = 1;
for ($atu = $ini ;  $atu <= $fim; $atu = strtotime('+30 minutes', $atu)) {
    $hr_agendamento = date('H:i', $atu);
    $sql = mysql_query("INSERT INTO agenda (id_agenda,hr_agendamento) VALUES('','$hr_agendamento')");                        
}
echo "agenda criada";

You can see running here on ideone.