search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

How can i extract data from application

Asked by Ryan
6 years ago.

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.

Answer posted by Dan Letecky [DayPilot]
6 years ago.

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.

Comment posted by Ryan
6 years ago.

Thank you very much great help needed some visualisation on the data and have it now

Great software !!

This question is more than 1 months old and has been closed. Please create a new question if you have anything to add.