Extracting present time entry from database
i have sql database showing hourly booking slots admin web page.
i'm trying find out how set front end web page show people slot presently available/unavailable?
this first project in dw , appreciate help/guidance.
what database , backend programming language using? makes big difference.
here general info:
- store date , time in database's date/time format, using datetime data type. not store dates text. mysql format this: yy-mm-dd hh:mm:ss
- you return hour slots database array, then, programming language iterate through possible hours in sequence, asking "if 2pm slot taken, mark taken, else mark free."
. . .however, think challenging first project not know php or backend language. challenging. if hope allow people register slot , pay it, becomes advanced project. may want read couple of books on php before start working on this.
More discussions in Dreamweaver support forum
adobe
Comments
Post a Comment