Questions Tagged sqlite

Creating and execute

Answered: You will need a webserver with PHP enabled. For development purposes, you can run the project using the built-in PHP webserver: Linux: php -S 127.0.0.1:8090 -t /path/to/project Windows: php.exe -S lo...

Asked by joy 11 months ago. 1 reply, last reply 11 months ago.

Add group line in PhpMyadmin

Answered: You have added it correctly - but it will only display the expand/collapse icon when you add some child resources. If you want to hide the additional columns for these empty groups, you can remove th...

article-87166-c scheduler html5 php mysql sqlite javascript how-to

Asked by kree 1 years ago. 4 replies, last reply 1 years ago.

Yay

Answered: I hope it helps!

article-75084-c php sqlite mysql javascript laravel scheduler

Asked by Kym 1 years ago. 1 reply, last reply 1 years ago.

Changing date format on Day/Week view

Answered: You can use the locale property to apply culture-specific settings (such as date format, first day of week….). const calendar = new DayPilot.Calendar("calendar", { locale: "en-au", // ... }); calenda...

article-27988-c date-picker week javascript php html5 day month sqlite mysql open-source event-calendar how-to

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

isnt working

Answered: Do you see any error in the JavaScript console?

article-27988-c date-picker week javascript php html5 day month sqlite mysql open-source event-calendar how-to

Asked by tk 1 years ago. 1 reply, last reply 1 years ago.

increase day-time insert events column

Answered: The cell duration (and number of cells per hour) can be configured in the Calendar , but this option is only available in the Pro version.

article-27988-c date-picker week javascript php html5 day month sqlite mysql open-source event-calendar how-to

Asked by chia 1 years ago. 1 reply, last reply 1 years ago.

I need to group the timings to show from time and to time, instead of hours.

Answered: If you just want to change the content of the time header , you can use the onBeforeTimeHeaderRender event handler to customize it in the Pro version of the Calendar . To define custom time slots , i...

article-87709-c sqlite open-source php javascript mysql how-to

Asked by Deepak 1 years ago. 1 reply, last reply 1 years ago.

Changing the date in the resource calendar

Answered: To change the current date, it is necessary to update the startDate property, which is used as the default date for the columns (if they don’t specify a custom date). You can find an example here: Ne...

article-87709-c sqlite open-source php javascript mysql how-to

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

Timeline & resync events in resource view

Answered: > Any possibility to show the current timeline or highlight the current cell duration with different background in lite version? This is not supported in the Lite version at the moment. In the Pro ve...

article-87709-c sqlite open-source php javascript mysql how-to

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

How to prevent even dragging and resize on selected events

Answered: Drag and drop In the Lite (open-source) version, you can only enable/disable drag and drop for all calendar events using eventMoveHandling and eventResizeHandling . In the Pro version, you can disabl...

article-87709-c sqlite open-source php javascript mysql

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

newResourceId is undefined on event resize

Answered: There is no args.newResource available in onEventResize as the resource doesn’t change during resizing. You can access the event resource ID using args.e.resource() .

article-87709-c php mysql open-source sqlite javascript bug

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

Backend events are not loaded in the resource calender

Answered: Thanks for the update! The problem is the type of events.resource_id database field. It is incorrectly set to varchar instead of integer . Older versions of PHP/PDO converted integer values to string...

article-87709-c javascript open-source php sqlite mysql bug

Asked by Anonymous 2 years ago. 5 replies, last reply 2 years ago.

Part Time employees

Answered: You can mark specified days as disabled using onBeforeCellRender in the Scheduler component . This method is used in the tutorial to disable weekends: onBeforeCellRender: (args) => { const day = args...

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

Asked by radu 2 years ago. 1 reply, last reply 2 years ago.

Impossible to show events from my database (resource calendar)

Answered: When displaying a resource calendar ( viewType: "Resources" ), it is necessary to specify the resource id for events using the resource property. This value needs to match the column id exactly (incl...

article-87709-c javascript open-source php sqlite mysql how-to

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

Moving and resizing tasks was not explained

Answered: You can find the documentation here: Resizing: https://doc.daypilot.org/gantt/task-resizing/ https://api.daypilot.org/daypilot-gantt-ontaskresize/ Moving (horizontal): https://doc.daypilot.org/gantt/...

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

Asked by Sam Benrekia 3 years ago. 1 reply, last reply 3 years ago.

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...

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

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

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. .

start date and end date

Answered: You can use "startDate" to change the visible date range: https://doc.daypilot.org/calendar/manual-date-switching/ The end date is calculated automatically, depending on the viewType value ( https://...

article-47550-c javascript sqlite ajax html5 event-calendar php how-to

Asked by vishal 7 years ago. 1 reply, last reply 7 years ago.

Changing the Daypilot instance

Answered: I found the solution myself, would be of help to others if ever come across this question. I simply used the dispose() method of the DayPilot, so when the event is triggered, I first got rid of the e...

article-50604-c tutorial javascript php sqlite scheduler html5 ajax

Asked by kRaYzie_kAy 8 years ago. 2 replies, last reply 8 years ago.

How can i translate days into another language

Answered: Please take a look at the Localization topic in the documentation: https://doc.daypilot.org/month/localization/ You can use one of the predefined locales or you can define your own. In addition to sw...

article-57519-c tutorial javascript php sqlite month event-calendar html5 ajax how-to

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

Demo

Answered: You can see a live demo of the Scheduler here: https://javascript.daypilot.org/demo/

article-50604-c tutorial javascript php sqlite scheduler html5 ajax

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

delete and/or view

hi, how do i delete/cancel the event on your program? also, how or where can i access or view it's database? 'coz i can't see it in my localhost. i'm using uwamp server. it would be great if you help...

article-57519-c tutorial javascript php sqlite month event-calendar html5 ajax how-to

Asked by thesis-haggard 9 years ago. .