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

Questions Tagged mysql

multiple event

Answered: This is not supported in the Calendar component at the moment but you can take a look at the Scheduler component which can group concurrent events automatically: https://doc.daypilot.org/scheduler/co...

Multiple event show +1

Answered: > If we have multiple event can we show +2 or +3 etc Please see my answer here: https://forums.daypilot.org/question/5848/multiple-event > in weekly can we change date format You can change the calen...

DB Connection data not showing at index

Answered: I recommend checking the HTTP calls to the API (especially work_order_resources.php and work_order_list.php) in the browser developer console (Network tab). Make sure that the response includes the c...

MySQL cannot use just SQlite can use only why?

Answered: In order to switch to MySQL please follow the instructions at the bottom of the article (a section called "Database (MySQL, SQLite)"). You need to edit _db.php and _mysql.php files.

php hotel room booking

Answered: You can find the licensing options at the Buy page: https://javascript.daypilot.org/buy/

JSON error in file: daypilot-all.min.js

Answered: This happens if the PHP backend returns an error instead of a JSON response. I recommend checking the backend HTTP request using browser developer tools. The response will contain an error message wh...

How to add a database and script to handle public holidays.

Answered: There is a tutorial available that shows how to display holidays (by setting a custom scheduler cell background color): https://code.daypilot.org/93068/javascript-scheduler-displaying-holidays I beli...

How to load row axis based on selected items from dropdown by the user

Answered: You need to make sure that the URL used in dp.rows.load() call returns the data correctly. I recommend using browser developer tools (Ctrl-Shift-I or Option-Command-I), the Network tab, to inspect th...

load data based on dropdown list

Answered: Please see my answer here: https://forums.daypilot.org/question/5494/how-to-refresh-gannt-chart-based-on-dropdown-values

How to refresh gannt chart based on dropdown values

Answered: The following tutorial includes a project that displays a drop-down list with locations: https://code.daypilot.org/61166/php-shift-planning-javascript-html5-mysql-database When a user selects an item...

How to change color of duration bar based on values in database

Answered: The backend_events.php script should look like this: <?php require_once '_db.php'; $stmt = $db->prepare("SELECT * FROM leave_event WHERE NOT ((leave_end <= :start) OR (leave_start >= :end))"); ...

Empy header cell for next columns if treeEnabled = true

Answered: The column content is set in onBeforeRowHeaderRender event handler. You'll need to modify it to exclude parent rows: dp.onBeforeRowHeaderRender = (args) => { // skip parent rows if (arg...

Features available for react js schedular

Answered: All DayPilot Pro for JavaScript features are available in React as well. To learn more about event editing, please see the following documentation page: https://doc.daypilot.org/scheduler/event-editi...

Total hour by Employee by tasks

El total que me da por empleado, no es correct. Estoy utilizando una prueba de Scheduler y no suma los minitos correctaente, me ma menos.

How to convert php to spring boot

Answered: Unfortunately, this tutorial is not available for Spring Boot at this moment. To see how the Calendar and Scheduler components can be used with Spring Boot backend, please see the following tutorials...

i want to chart add in codeigniter but data not fetch from conreoller

i want to chart add in codeigniter but data not fetch from conreoller anyone can send me code for codeigniter same chart?

What program should i use for the codes?

Answered: In order to run the project, you'll need PHP, a webserver and a MySQL database server. A decent knowledge of JavaScript is also necessary if you want to customize the project. If you are a complete b...

Console.log display error unique ID

Answered: Unfortunately, I'm not able to reproduce the problem using the sample project. Please note that duplicate IDs are not allowed. Every event that you add to the Scheduler needs to have a unique ID ("id...

How to run this source code?

how to run this source using xampp

New Event with dropdown values as name

On the creation of a new event, instead of typing name, get possible values from a query to a mysql. Getting a dropdown menu to select the name of the event.

New Event from a list of pre define events

Answered: I'm not sure if this is what you are looking for but if you have existing unscheduled events/tasks that need to be scheduled you can use external drag and drop to move them to a specific time slot in...

No of Days Calculation is getting reduced by One Day

Answered: If you only work with full days, you can switch to eventEndSpec="Date" mode which will translate the end date to "end of day": https://doc.daypilot.org/scheduler/event-end-date-time/ But that will no...

remove demo

Answered: You'll need to purchase a license: https://javascript.daypilot.org/buy/ The tutorial includes a trial version of DayPilot Pro.

How can I fetch value of new column from database and display it on the calendar?

Answered: You can use onBeforeEventRender event handler to modify the event HTML (args.data.html) using the staff column (args.data.staff): https://doc.daypilot.org/calendar/event-customization/ You can also m...

Customer Event Add Modal

Answered: When the users selects a time range the Scheduler fires the onTimeRangeSelected event: onTimeRangeSelected: args => { this.create.show(args); } You can modify the event handler to...

db not working

Answered: The database will be created and initialized automatically - see also the _db_mysql.php script for details. Just make sure that _db.php points to the mysql backend (and not sqlite). Also, check that ...

change doctor name and add doctor

Answered: Management of the doctors is not included in the project - in order to keep it simple. 1. You can add traditional form-based web interface to edit the doctors table. 2. You can extend the manager's i...

How to load events only from a specific userID

Answered: PHP is not my primary language, but maybe you can try adding the userId as a parameter to the backend url. So dp.events.load("backend_events.php"); becomes: dp.events.load("backend_events.php?userid=...

Need DayPilot Javscript non-minified source code

Answered: Please see the licensing options here: https://javascript.daypilot.org/buy/

2 rows for one resource

Answered: It is possible to display two rows for each resource: 1. The resource id needs to be unique. This can be done by prefixing a certain string to the resource id, e.g. "R" + id for reservations rows, "I...
Questions 1-30 of 47 Next