The MySQL table should be as simple as possible, regardless of the output that is required - for example, this could be created with just 4 fields and one or more related tables for people and maybe timeslots:
date (or day - depending on your implementation)
timeslot (possibly an FK)
You don't say whether the schedule is the same for every week, where you'd use Day as the second field, or whether this is entered in advance and changes from week to week, in which case you'd use Date. Using Day is probably not the way to go as you'd lose history by overwriting.
The production of the html could be quite tricky, depending on whether you have different number of people for each timeslot and each day. In that case you'd need to prepare your data with rowspans. Please provide more info.
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...