Click a day to open a new page about calendar HOT 7 CLOSED

Hi pakoArtal.

This is the code I used, quite simply really..

// PREPARE THE STATEMENT
$i = 0;
$stmt_meetings = mysqli_query($conn, $sql_meetings);

if($stmt_meetings === false) {
trigger_error('Wrong SQL: ' . $sql_meetings . ' Error: ' .
$conn->error, E_USER_ERROR);
exit();
}

while ($meetings_row = mysqli_fetch_array($stmt_meetings)) {

// CHECK TO SEE IF THERE ARE MULITPLE MEETINGS ON THIS DATE
$sql_meetings_multiple = "SELECT * FROM meetings WHERE DATE(date_from)
= DATE('" . date("Y-m-d", strtotime($meetings_row['date_from'])) . "')
AND $access_levels";

// PREPARE THE STATEMENT
$stmt_meetings_multiple = mysqli_query($conn, $sql_meetings_multiple);

if(mysqli_num_rows($stmt_meetings_multiple) > 1){

// PUT MEETINGS INTO ARRAY IF THERE ARE MULTIPLE MEETINGS
while ($meetings_multiple_row =
mysqli_fetch_array($stmt_meetings_multiple)) {
$multiple_meetings_title = $multiple_meetings_title . '

$date = date("Y-m-d", strtotime($meetings_row['date_from']));
$dates[$i] = array(
 'date' => $date,
 'badge' => true,
 'title' => 'Multiple Meetings',
 'body' => '
 <p class="lead">There are multiple meetings on this date</p>' . 

stripslashes($multiple_meetings_title) . '
',
'footer' => '
Close
<a href="MEETINGS_view.php?meetings_view_date_from=' .
date("Y-m-d", strtotime($meetings_row['date_from'])) .
'&today_only=1">

// ELSE IF THERE IS ONLY ONE MEETING
}else{

$date = date("Y-m-d", strtotime($meetings_row['date_from']));
$dates[$i] = array(
 'date' => $date,
 'badge' => false,
 'title' => stripslashes($meetings_row['title']) . " - [ " . 

date("H:i", strtotime($meetings_row['date_from'])) . " ]",
'body' => '

' . stripslashes($meetings_row['description']) .
'

}
unset($multiple_meetings_title);
$i++;

 }

 echo json_encode($dates);

} else {
echo json_encode(array());
}

.

from calendar.

Hello Nick,

Thanks for your message, Unfortunately I haven't designed this calendar I have planned to do some changes especially with events, but I didn't.

You can try to contact creator of project here:
https://github.com/zabuto

if there is no response, drop me message again and we will see what we can do :)

Best,

Martin

from calendar.

Oh, sorry Martin don't know how That happened!

I did a good workaround in the end anyways. Just made the modal list events on that particular day instead of showing just one event

Cheers!

Nick

MartinBodocky [email protected] wrote:

Hello Nick,

Thanks for your message, Unfortunately I haven't designed this calendar
I have planned to do some changes especially with events, but I didn't.

You can try to contact creator of project here:
https://github.com/zabuto

if there is no response, drop me message again and we will see what we
can do :)

Best,

Martin

---

Reply to this email directly or view it on GitHub:
#1 (comment)

Sent from my Android device with Gmail Plus. Please excuse my brevity.

This e-mail and any attachments may contain confidential and/or privileged
material; it is for the intended addressee(s) only. If you are not a named
addressee, you must not use, retain or disclose such information. The
Streetly Academy cannot guarantee that the email or attachments are free
from viruses.
The Streetly Academy, Registered Address Queslett Road East, Sutton
Coldfield, West Midlands, B74 2EX. Registered in England and Wales.
Registered No. 07841414

from calendar.

Hi Nick,
could you explain how did you make the modal list events?

Thank you!

from calendar.

Thank you woottonn !

from calendar.

Server side solution to the problem. Nice stuff!

from calendar.

hi - is there a way to update the calendar every x seconds? ie i have linked it to a booking system, and it only displays the changes if i refresh the page.. even clicking to a new month and back doesnt update it. I am loading this through a bootstrap modal. Otherwise thanks for a cool little app -

:p

from calendar.