how to use fullcalendar events as a variables?

Question

hello i'm using fullcalendar and i want to declare event.start and event.end as a variable to use it inside my PHP code like this:

$sql = "SELECT * 
        FROM chambre
         WHERE id NOT IN (SELECT id_chambre 
                          FROM reservation_client 
                          WHERE start <= event.end 
                            AND end >= event.start)";

event.start and event.end are the two date that i select. is it possible to mix between JavaScript and php like this?

You may find https://fullcalendar.io/docs/events-json-feed to be useful reading as well, in the particular case of fullCalendar — ADyson, Jul 21 '19 at 20:49

score 3 · Accepted Answer · edited Jul 21 '19 at 20:47

3

You mix client side code (JavaScript) and server side code (PHP). With JavaScript, you can only access resources at the client (your Browser), not on the server.

I suggest making an Ajax call with parameters event.start and event.end. Then on the Sever make a php script to check the availability of the date and return the result back to the client, Example for Ajax-request:

$.ajax({
  method: "POST",
  url: "some.php",
  data: { name: "John", location: "Boston" }
})
.done(function( msg ) {
  alert( "Data Saved: " + msg );
});

You have to modify the data to your requests.

The PHP-Example:

$name =  $_POST['name'];
...
// do your query to the db
// return the result:
echo json_encode($results);

Adjust the script to your needs.

edited Jul 21 '19 at 20:47

ADyson

57,178
14
51
63

answered Jul 20 '19 at 13:18

wado55

66
4

can you please explaine this by give me a script because i dont know how to do it ? – omayma uchiha Jul 20 '19 at 14:40
It should be noted that this example uses jQuery for the AJAX call. If you don't wish to use jQuery, then use fetch() instead. – ADyson Jul 21 '19 at 20:48

how to use fullcalendar events as a variables?

1 Answers1