fullcalendar stops showing events after more than 10k events
up vote
1
down vote
favorite
Hi I want to use fullcalendar with a database its works but as soon as I put more than 10k events in the calendar it stops showing events.
Is there a way to stop fullcalendar from stopping to show events?
The version below is 4.0.0
(I used both 3.9.0 and 4.0.0 of fullcalendar both are not working)
<script type="text/javascript">
document.addEventListener('DOMContentLoaded', function () { // DOMContentLoaded zorgt ervoor dat eerst de html laad
var calendarEl = document.getElementById('calendar'); // grab element reference
var calendar = new FullCalendar.Calendar(calendarEl, {
// put your options and callbacks here
events: [
<?php
include_once('./assets/handlers/DB_Handler.php');
try {
$getCalenderItems = $conn->prepare("SELECT COD.CursusID, O.Onderdeelnaam,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumBegin ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumBegin ) , ',', MINUTE( CO.DatumBegin ) ) AS Start,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumEind ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumEind ) , ',', MINUTE( CO.DatumEind ) ) AS Eind
FROM cursusonderdeeldocenten COD
INNER JOIN onderdelen O ON COD.OnderdeelID = O.OnderdeelID
INNER JOIN cursusonderdelen CO ON COD.CursusID = CO.CursusID
WHERE COD.DocentID = 15
AND CO.DatumBegin >= DATE_ADD(CURDATE(), INTERVAL -8 MONTH)
ORDER BY CO.DatumBegin");
$getCalenderItems->bindParam(':DocentID', $DiD);
// Select docent
$DiD = 15;
$getCalenderItems->execute();
$count = $getCalenderItems->rowCount();
} catch (PDOException $e) {
$e->getMessage();
}
$i = 0;
while ($row = $getCalenderItems->fetch()) {
echo '
{
title: "' . $row['Onderdeelnaam'] . '",
start: new Date(' . $row['Start'] . '),
end: new Date(' . $row['Eind'] . '),
url: "./beoordelen/' . $row['CursusID'] . '"
}';
if ($i >= $count) {
echo "";
} else {
echo ",";
}
$i++;
}
?>
]
});
calendar.render();
});
</script>
<div id='calendar'></div>
</div>
javascript php fullcalendar
add a comment |
up vote
1
down vote
favorite
Hi I want to use fullcalendar with a database its works but as soon as I put more than 10k events in the calendar it stops showing events.
Is there a way to stop fullcalendar from stopping to show events?
The version below is 4.0.0
(I used both 3.9.0 and 4.0.0 of fullcalendar both are not working)
<script type="text/javascript">
document.addEventListener('DOMContentLoaded', function () { // DOMContentLoaded zorgt ervoor dat eerst de html laad
var calendarEl = document.getElementById('calendar'); // grab element reference
var calendar = new FullCalendar.Calendar(calendarEl, {
// put your options and callbacks here
events: [
<?php
include_once('./assets/handlers/DB_Handler.php');
try {
$getCalenderItems = $conn->prepare("SELECT COD.CursusID, O.Onderdeelnaam,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumBegin ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumBegin ) , ',', MINUTE( CO.DatumBegin ) ) AS Start,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumEind ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumEind ) , ',', MINUTE( CO.DatumEind ) ) AS Eind
FROM cursusonderdeeldocenten COD
INNER JOIN onderdelen O ON COD.OnderdeelID = O.OnderdeelID
INNER JOIN cursusonderdelen CO ON COD.CursusID = CO.CursusID
WHERE COD.DocentID = 15
AND CO.DatumBegin >= DATE_ADD(CURDATE(), INTERVAL -8 MONTH)
ORDER BY CO.DatumBegin");
$getCalenderItems->bindParam(':DocentID', $DiD);
// Select docent
$DiD = 15;
$getCalenderItems->execute();
$count = $getCalenderItems->rowCount();
} catch (PDOException $e) {
$e->getMessage();
}
$i = 0;
while ($row = $getCalenderItems->fetch()) {
echo '
{
title: "' . $row['Onderdeelnaam'] . '",
start: new Date(' . $row['Start'] . '),
end: new Date(' . $row['Eind'] . '),
url: "./beoordelen/' . $row['CursusID'] . '"
}';
if ($i >= $count) {
echo "";
} else {
echo ",";
}
$i++;
}
?>
]
});
calendar.render();
});
</script>
<div id='calendar'></div>
</div>
javascript php fullcalendar
any console errors? that is really a huge number of events, maybe it simply can't cope with the volume, or it's just taking a very long time to process them.
– ADyson
Nov 22 at 9:38
P.S. It seems you are trying to load 8 months worth of events at once? That's unnecessary. If, instead of injectig your events into the JavaScript code, you specify your events as a feed URL which accepts start and end dates as input parameters (and which just returns the events between those dates as JSON), then fullCalendar will just go and fetch the events for the necessary time period, if and when the user views that time period. If they never look at that month, it never bothers to load them. See fullcalendar.io/docs/events-json-feed
– ADyson
Nov 22 at 9:41
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
Hi I want to use fullcalendar with a database its works but as soon as I put more than 10k events in the calendar it stops showing events.
Is there a way to stop fullcalendar from stopping to show events?
The version below is 4.0.0
(I used both 3.9.0 and 4.0.0 of fullcalendar both are not working)
<script type="text/javascript">
document.addEventListener('DOMContentLoaded', function () { // DOMContentLoaded zorgt ervoor dat eerst de html laad
var calendarEl = document.getElementById('calendar'); // grab element reference
var calendar = new FullCalendar.Calendar(calendarEl, {
// put your options and callbacks here
events: [
<?php
include_once('./assets/handlers/DB_Handler.php');
try {
$getCalenderItems = $conn->prepare("SELECT COD.CursusID, O.Onderdeelnaam,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumBegin ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumBegin ) , ',', MINUTE( CO.DatumBegin ) ) AS Start,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumEind ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumEind ) , ',', MINUTE( CO.DatumEind ) ) AS Eind
FROM cursusonderdeeldocenten COD
INNER JOIN onderdelen O ON COD.OnderdeelID = O.OnderdeelID
INNER JOIN cursusonderdelen CO ON COD.CursusID = CO.CursusID
WHERE COD.DocentID = 15
AND CO.DatumBegin >= DATE_ADD(CURDATE(), INTERVAL -8 MONTH)
ORDER BY CO.DatumBegin");
$getCalenderItems->bindParam(':DocentID', $DiD);
// Select docent
$DiD = 15;
$getCalenderItems->execute();
$count = $getCalenderItems->rowCount();
} catch (PDOException $e) {
$e->getMessage();
}
$i = 0;
while ($row = $getCalenderItems->fetch()) {
echo '
{
title: "' . $row['Onderdeelnaam'] . '",
start: new Date(' . $row['Start'] . '),
end: new Date(' . $row['Eind'] . '),
url: "./beoordelen/' . $row['CursusID'] . '"
}';
if ($i >= $count) {
echo "";
} else {
echo ",";
}
$i++;
}
?>
]
});
calendar.render();
});
</script>
<div id='calendar'></div>
</div>
javascript php fullcalendar
Hi I want to use fullcalendar with a database its works but as soon as I put more than 10k events in the calendar it stops showing events.
Is there a way to stop fullcalendar from stopping to show events?
The version below is 4.0.0
(I used both 3.9.0 and 4.0.0 of fullcalendar both are not working)
<script type="text/javascript">
document.addEventListener('DOMContentLoaded', function () { // DOMContentLoaded zorgt ervoor dat eerst de html laad
var calendarEl = document.getElementById('calendar'); // grab element reference
var calendar = new FullCalendar.Calendar(calendarEl, {
// put your options and callbacks here
events: [
<?php
include_once('./assets/handlers/DB_Handler.php');
try {
$getCalenderItems = $conn->prepare("SELECT COD.CursusID, O.Onderdeelnaam,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumBegin ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumBegin ) , ',', MINUTE( CO.DatumBegin ) ) AS Start,
CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumEind ) , INTERVAL -1 MONTH ) , '-', ',' ) , ',', HOUR( CO.DatumEind ) , ',', MINUTE( CO.DatumEind ) ) AS Eind
FROM cursusonderdeeldocenten COD
INNER JOIN onderdelen O ON COD.OnderdeelID = O.OnderdeelID
INNER JOIN cursusonderdelen CO ON COD.CursusID = CO.CursusID
WHERE COD.DocentID = 15
AND CO.DatumBegin >= DATE_ADD(CURDATE(), INTERVAL -8 MONTH)
ORDER BY CO.DatumBegin");
$getCalenderItems->bindParam(':DocentID', $DiD);
// Select docent
$DiD = 15;
$getCalenderItems->execute();
$count = $getCalenderItems->rowCount();
} catch (PDOException $e) {
$e->getMessage();
}
$i = 0;
while ($row = $getCalenderItems->fetch()) {
echo '
{
title: "' . $row['Onderdeelnaam'] . '",
start: new Date(' . $row['Start'] . '),
end: new Date(' . $row['Eind'] . '),
url: "./beoordelen/' . $row['CursusID'] . '"
}';
if ($i >= $count) {
echo "";
} else {
echo ",";
}
$i++;
}
?>
]
});
calendar.render();
});
</script>
<div id='calendar'></div>
</div>
javascript php fullcalendar
javascript php fullcalendar
edited Nov 21 at 13:32
Olexander Pobuta
32429
32429
asked Nov 21 at 13:23
Ruben van de Bunt
62
62
any console errors? that is really a huge number of events, maybe it simply can't cope with the volume, or it's just taking a very long time to process them.
– ADyson
Nov 22 at 9:38
P.S. It seems you are trying to load 8 months worth of events at once? That's unnecessary. If, instead of injectig your events into the JavaScript code, you specify your events as a feed URL which accepts start and end dates as input parameters (and which just returns the events between those dates as JSON), then fullCalendar will just go and fetch the events for the necessary time period, if and when the user views that time period. If they never look at that month, it never bothers to load them. See fullcalendar.io/docs/events-json-feed
– ADyson
Nov 22 at 9:41
add a comment |
any console errors? that is really a huge number of events, maybe it simply can't cope with the volume, or it's just taking a very long time to process them.
– ADyson
Nov 22 at 9:38
P.S. It seems you are trying to load 8 months worth of events at once? That's unnecessary. If, instead of injectig your events into the JavaScript code, you specify your events as a feed URL which accepts start and end dates as input parameters (and which just returns the events between those dates as JSON), then fullCalendar will just go and fetch the events for the necessary time period, if and when the user views that time period. If they never look at that month, it never bothers to load them. See fullcalendar.io/docs/events-json-feed
– ADyson
Nov 22 at 9:41
any console errors? that is really a huge number of events, maybe it simply can't cope with the volume, or it's just taking a very long time to process them.
– ADyson
Nov 22 at 9:38
any console errors? that is really a huge number of events, maybe it simply can't cope with the volume, or it's just taking a very long time to process them.
– ADyson
Nov 22 at 9:38
P.S. It seems you are trying to load 8 months worth of events at once? That's unnecessary. If, instead of injectig your events into the JavaScript code, you specify your events as a feed URL which accepts start and end dates as input parameters (and which just returns the events between those dates as JSON), then fullCalendar will just go and fetch the events for the necessary time period, if and when the user views that time period. If they never look at that month, it never bothers to load them. See fullcalendar.io/docs/events-json-feed
– ADyson
Nov 22 at 9:41
P.S. It seems you are trying to load 8 months worth of events at once? That's unnecessary. If, instead of injectig your events into the JavaScript code, you specify your events as a feed URL which accepts start and end dates as input parameters (and which just returns the events between those dates as JSON), then fullCalendar will just go and fetch the events for the necessary time period, if and when the user views that time period. If they never look at that month, it never bothers to load them. See fullcalendar.io/docs/events-json-feed
– ADyson
Nov 22 at 9:41
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
I added 3k+ events to my calendar and it works fine. You can check my code here.
Could you check the browser console to see if there is an error?
The version that I use is 3.9.0.
Ok so it does work when i delete title and url from the $row fetch but these are important is there any other way to load the data?
– Ruben van de Bunt
Nov 22 at 8:28
@RubenvandeBunt I added title and URL, and it still works. Can you provide the HTML code your program generated and we can see what's going on there?
– iLtc
Nov 22 at 21:04
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I added 3k+ events to my calendar and it works fine. You can check my code here.
Could you check the browser console to see if there is an error?
The version that I use is 3.9.0.
Ok so it does work when i delete title and url from the $row fetch but these are important is there any other way to load the data?
– Ruben van de Bunt
Nov 22 at 8:28
@RubenvandeBunt I added title and URL, and it still works. Can you provide the HTML code your program generated and we can see what's going on there?
– iLtc
Nov 22 at 21:04
add a comment |
up vote
0
down vote
I added 3k+ events to my calendar and it works fine. You can check my code here.
Could you check the browser console to see if there is an error?
The version that I use is 3.9.0.
Ok so it does work when i delete title and url from the $row fetch but these are important is there any other way to load the data?
– Ruben van de Bunt
Nov 22 at 8:28
@RubenvandeBunt I added title and URL, and it still works. Can you provide the HTML code your program generated and we can see what's going on there?
– iLtc
Nov 22 at 21:04
add a comment |
up vote
0
down vote
up vote
0
down vote
I added 3k+ events to my calendar and it works fine. You can check my code here.
Could you check the browser console to see if there is an error?
The version that I use is 3.9.0.
I added 3k+ events to my calendar and it works fine. You can check my code here.
Could you check the browser console to see if there is an error?
The version that I use is 3.9.0.
answered Nov 21 at 23:17
iLtc
214
214
Ok so it does work when i delete title and url from the $row fetch but these are important is there any other way to load the data?
– Ruben van de Bunt
Nov 22 at 8:28
@RubenvandeBunt I added title and URL, and it still works. Can you provide the HTML code your program generated and we can see what's going on there?
– iLtc
Nov 22 at 21:04
add a comment |
Ok so it does work when i delete title and url from the $row fetch but these are important is there any other way to load the data?
– Ruben van de Bunt
Nov 22 at 8:28
@RubenvandeBunt I added title and URL, and it still works. Can you provide the HTML code your program generated and we can see what's going on there?
– iLtc
Nov 22 at 21:04
Ok so it does work when i delete title and url from the $row fetch but these are important is there any other way to load the data?
– Ruben van de Bunt
Nov 22 at 8:28
Ok so it does work when i delete title and url from the $row fetch but these are important is there any other way to load the data?
– Ruben van de Bunt
Nov 22 at 8:28
@RubenvandeBunt I added title and URL, and it still works. Can you provide the HTML code your program generated and we can see what's going on there?
– iLtc
Nov 22 at 21:04
@RubenvandeBunt I added title and URL, and it still works. Can you provide the HTML code your program generated and we can see what's going on there?
– iLtc
Nov 22 at 21:04
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53413020%2ffullcalendar-stops-showing-events-after-more-than-10k-events%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
any console errors? that is really a huge number of events, maybe it simply can't cope with the volume, or it's just taking a very long time to process them.
– ADyson
Nov 22 at 9:38
P.S. It seems you are trying to load 8 months worth of events at once? That's unnecessary. If, instead of injectig your events into the JavaScript code, you specify your events as a feed URL which accepts start and end dates as input parameters (and which just returns the events between those dates as JSON), then fullCalendar will just go and fetch the events for the necessary time period, if and when the user views that time period. If they never look at that month, it never bothers to load them. See fullcalendar.io/docs/events-json-feed
– ADyson
Nov 22 at 9:41