mysql - Looping through a table in php to find best spot to fit my data -

mysql - Looping through a table in php to find best spot to fit my data -

after running mysql query list containing info in next form:

$result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "<br> id: ". $row["event_id"]. " - timestamp: ". $row["event_start"]. " " . $row["event_duration"] . "<br>"; } }

basically each row has 3 fields:

event_id | event_start | event_duration

now, want accomplish iterate in php through returned rows , find place can set new event event_start timestamp , event_duration. place i'm looking has free , ready filled event_id through whole event_duration.

quick example: let's in database i've got 4 events:

e1 starts @ 1:00:10 , lasts 30 seconds e2 starts @ 1:00:40 , lasts 20 seconds e3 starts @ 1:01:30 , lasts 40 seconds e4 starts @ 1:02:50 , lasts 20 seconds.

now want insert e5 lasts 20 seconds, perfect spot between e2 , e3, after provide id of e5 , duration, receive timestamp of can set (in illustration 1:01:00). how can create loop in php this?

edit:

the select query returns info me follows:

select event_id, event_start, event_duration table event_start>= 'begin-boundary-time' , event_start+ event_duration <= 'end-boundary-time'

i wouldn't worry looping through info , finding place insert if using mysql database store events. can sort info when looking @ events using order statement in sql query. (depending on size, fragmentation, or indexes on table) faster having php loop running every time. inserts more accurate since won't delayed looping through find slot.

php mysql sql algorithm sorting