mysql - How to create PHP insert query based on selected timing

one text

Solution:

One option uses a recursive query - available in MySQL 8.0 only:

insert into mytable (sno, time)
with recursive cte as (
    select 1 sno, '09:00:00' time
    union all
    select sno + 1, time + interval 30 minute 
    from cte 
    where time + interval 30 minute <= '11:00:00'
)
select sno, time from cte

You can easily turn this to a parameterized query to pass the three parameters as needed.