Questions Tagged mysql
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...
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...
limited timeframe
Answered: already found the solution need to change $morning_shift_starts = 9; $morning_shift_ends = 13; $afternoon_shift_starts = 14; $afternoon_shift_ends = 18; in the backend_create.php thankyou anyway
options to split hour
Answered: For the Calendar component (used in index.php and doctor.php) you can adjust the scale to show 15-minute cells using cellDuration property:
var calendar= new DayPilot.Calendar("dp");
// ...
calen...
the patient interface doesnt allows entries or shows available slots
im running it on local server(wamp) manager can set schedule but the doctor or patient can not enter the data into the scheduled slots even after clicking on them any suggestions? i have uploaded ind...
Gantt graph appearance height
Answered: You can use dp.heightSpec = "Parent100Pct" to set the Gantt height to 100% of the parent element. Just make sure that the parent height is set explicitly (either using "height" style or using "top"/"...
Database
I have done everything and yet no error but when I insert a data, it does not show in my database. Please help. Thank you
bespoke development
Answered: Thanks Dan. In all honesty, it would still be over my head! Obviously, I'd like to licence your code, but would anyone else be interested in helping me adapt it to our specific needs? Thanks
Display mysql data
I have two input box and with the help of this two input data i wants to display my mysql data Ex. i have so many employee data in a single table then i wants to display only to those people whose ha...
fatal error
Answered: It looks like the 'ODBC' user doesn't have sufficient permissions (to access the database). See also: https://dev.mysql.com/doc/refman/5.7/en/privilege-system.html
DEMO NOTE (ORANGE IN EVENT CALENDAR)
Answered: As noted in the tutorial text, the project download includes a trial version of DayPilot Pro that displays the DEMO label. It's licensed for evaluation purposes only. If you want to use the tutorial ...
Month problem
What if our project has many tasks throughout a couple of months. How can I show the diff tasks on the same chart although they're on different months?
how to reduce amount
Hi sir, This is valueable to codeing .but small doubt . iask to how to reduce in amount .
How to display more than one(current) mont ?
I have a sheduler like on screenshot. Unfortunately it shows only reservations(load from database) from current month. I'm able to display more days (eg dp.days = 365;) but there's no cells(only line...
problem with overlaps in Server.
Answered: The Scheduler supports client-side overlap detection (https://doc.daypilot.org/scheduler/event-overlapping/). This helps with real-time UI feedback but it's also necessary to implement server-side va...
Can't load events from mysql
I'm setting up the calendar and I am having trouble switching from the sqlite database in the tutorial to my mysql database. I'm using the tutorial code created and populated a mysql databse using _d...
ASP.net and MySql Support
I am trying to decide on a Scheduler Control addon for our website but our current Backend Database is MySQL. I have searched the forums and googled ever combination of DayPilot and MySQL but cannot ...