Questions Tagged mysql

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))"); $stmt-...

how-to javascript php mysql angular

Asked by vicky romanic 5 years ago. 2 replies, last reply 5 years ago.
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 (args.row.children...

article-27453-c reservation hotel javascript php html5 scheduler mysql how-to

Asked by Mikolaj 5 years ago. 2 replies, last reply 5 years ago.
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...

article-40087-c jsx scheduler shift javascript php react mysql

Asked by Roshani Mahale 5 years ago. 3 replies, last reply 5 years ago.
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.

article-46581-c html5 mysql php javascript timesheet sqlite how-to

Asked by Jose Guevara 5 years ago. .
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...

article-44666-c appointment scheduler html5 mysql doctor javascript calendar how-to

Asked by raja 5 years ago. 1 reply, last reply 5 years ago.
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?

article-93862-c javascript html5 gantt php sqlite mysql how-to

Asked by Anonymous 5 years ago. .
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...

article-27453-c reservation scheduler php mysql html5 javascript hotel

Asked by JONA 5 years ago. 1 reply, last reply 5 years ago.
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...

article-67423-c scheduler typescript angular9 angular angular8 php mysql how-to

Asked by Li 5 years ago. 1 reply, last reply 5 years ago.
How to run this source code?

how to run this source using xampp

article-97780-c scheduler php javascript html5 mysql annual-leave

Asked by Anonymous 6 years ago, 1 vote. .
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.

how-to javascript mysql

Asked by Anonymous 6 years ago, 2 votes. .
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...

how-to javascript mysql

Asked by Anonymous 6 years ago. 1 reply, last reply 6 years ago.
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...

article-97780-c html5 scheduler mysql php javascript annual-leave how-to

Asked by Anonymous 6 years ago. 3 replies, last reply 6 years ago.
remove demo

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

article-61166-c php mysql scheduler html5 shift javascript how-to

Asked by Anonymous 6 years ago. 1 reply, last reply 6 years ago.
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...

article-27988-c mysql event-calendar javascript html5 week php month day how-to

Asked by Quy 6 years ago. 2 replies, last reply 6 years ago.
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 use your own modal ...

article-50175-c angular6 mysql angular event-calendar angular8 typescript php how-to

Asked by Anonymous 6 years ago. 1 reply, last reply 6 years ago.
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 ...

article-44666-c appointment javascript mysql calendar scheduler doctor html5 feature

Asked by Anonymous 6 years ago. 1 reply, last reply 6 years ago.
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...

article-44666-c appointment javascript mysql calendar scheduler doctor html5 how-to

Asked by Anonymous 6 years ago. 1 reply, last reply 6 years ago.
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=...

how-to javascript mysql scheduler events

Asked by John C 7 years ago. 2 replies, last reply 7 years ago.
Need DayPilot Javscript non-minified source code

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

article-44666-c scheduler doctor mysql html5 appointment javascript calendar

Asked by Anonymous 7 years ago. 1 reply, last reply 7 years ago.
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...

article-13278-c php angular5 mysql scheduler angular6 restaurant angular4 typescript angular how-to

Asked by fradega 7 years ago. 2 replies, last reply 7 years ago.
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

article-44666-c scheduler doctor mysql html5 appointment javascript calendar how-to

Asked by ian kamau 7 years ago. 1 reply, last reply 7 years ago.
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"); // ... calendar....

article-44666-c tutorial html5 javascript doctor appointment calendar scheduler mysql how-to

Asked by jose giraldo 8 years ago. 1 reply, last reply 8 years ago.
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...

article-44666-c tutorial html5 javascript doctor appointment calendar scheduler mysql how-to

Asked by v 8 years ago, 2 votes. .
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"/"...

article-93862-c tutorial html5 javascript gantt php mysql how-to

Asked by FabrizioB 8 years ago. 1 reply, last reply 8 years ago.
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

article-44666-c tutorial html5 javascript doctor appointment calendar scheduler mysql feature

Asked by Anonymous 8 years ago, 1 vote. .
General

Answered: Unfortunately not at this moment.

article-44666-c tutorial html5 javascript doctor appointment calendar scheduler mysql

Asked by Anonymous 8 years ago. 1 reply, last reply 8 years ago.
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

article-77465-c tutorial hotel angularjs scheduler javascript php reservation mysql

Asked by wyn d 8 years ago. 2 replies, last reply 8 years ago.
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...

article-27453-c tutorial html5 javascript scheduler php hotel reservation mysql how-to

Asked by Dinesh kumar 8 years ago. .
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

article-27453-c tutorial html5 javascript scheduler php hotel reservation mysql how-to

Asked by Anonymous 8 years ago. 1 reply, last reply 8 years ago.
change doctors

Answered: You can simply delete the othe doctors in the database ('doctor' table).

article-44666-c tutorial html5 javascript doctor appointment calendar scheduler mysql how-to

Asked by Anonymous 9 years ago. 1 reply, last reply 9 years ago.