Hi there just a quick question with regards the web application for tennis courts.
Where are the tables created and stored. I would like to extract the data i.e date, time, name and carry out some operations on this data.
The Tennis court tutorial (https://code.daypilot.org/11478/html5-tennis-court-reservation-php-javascript) stores the data in a SQLite database that is created automatically when you start the application. The event data
At the bottom of the tutorial you can find "Database Schema (DDL)" section that shows the database schema. The events (reservations) are stored in "events" table.
SQLite is a file-based database - the database file is called daypilot.sqlite and you'll find it in the application root. You can use a manager application such as SQLiteStudio (https://sqlitestudio.pl/index.rvt) to view and edit the file.
The database-related PHP code can be found in _db.php. You can modify it as needed.
Thank you very much great help needed some visualisation on the data and have it now
Great software !!
This question is more than 1 month old and has been closed. Please create a new question if you have anything to add.
DayPilot