Hello
For a new project, i need to build in php a small week calendar that we can update easly
Its for defining weekly planning of yoga center.
Each week of year will be always the same, it only need to have an output of the week that we can manage
For DB it need so for each planning part defined : Name of activity, Name of people who provide activity, type of activity
Planning need to have array from Monday to sunday, and to 8:00 to 20:30 with Half hour entry
I join what i have made actualy for display and php, but it need to be rebuild
I nedd so
1 php file for form (in table, not skinned)
1 php file for output (in table, not skinned)
The mysql db
We need a script created that shows the next 5 weeks in calendar form (Sat-Sun). In our database we have a table called product & there we have 2 fields: ps_start and ps_completed
what we’ll do is enter a start date and a date we want to complete the product by in those fields. Then if those dates are within the next 5 weeks we’d like it to show the SKU and NAME of that product on the calendar. The ps_start in RED Color and the ps_completed in Green color.
we’d like Each week to alternate background color.
We’d like to be able to add or take away how many weeks show up. So 5 right now but if we grow and want to show 7 weeks we’d like to be able to easily get in the script and change 5 to 7 or whatever.
Categories: MySQL, PHP Tags: Calendar, color, five, five week, five week calendar, Product, show, start, week, week calendar, weeks
