CODEWITHSUNDEEP
javascriptajaxfullcalendar
yongseung
yongseung

Reputation: 79

fullcalendar ajax success does not working

I am making reservation website using fullcalendar. I insert event into my DB using Ajax. However, the problem is that success function was not working, but every data was successfully inserted into DB. Also I changed success to error, but still nothing happened. Here is code where I insert event into DB

select: function(start, end,  allDay)
        {
         var teacher = prompt("Enter ResourceID");
         if(teacher)
         {
          var start = $.fullCalendar.formatDate(start, "Y-MM-DD HH:mm:ss");
          var end = $.fullCalendar.formatDate(end, "Y-MM-DD HH:mm:ss");
          $.ajax({
           url:"http://show981111.cafe24.com/login-system/addevent.php",
           type:"POST",
           data:{userName: '<?php echo $name; ?>' , newlyBookedDate:start, courseTeacher : teacher, userBranch:'<?php echo $userBranch; ?>', userID: '<?php echo $userID; ?>'},

           success:function()
           {
            calendar.fullCalendar('refetchEvents');
            alert("Added Successfully");
           }
          })
         }
        },

Here is where I get the php variables that I use above

<?php

session_start();


if ( $_SESSION['logged_in'] != 1 ) {
  $_SESSION['message'] = "You must log in before viewing your profile page!";
  header("location: error.php");    
}
else {
    // Makes it easier to read
    $name = $_SESSION['userName'];
    $userBranch = $_SESSION['userBranch'];
    $userID = $_SESSION['userID'];


}

?>

This is code for addevent.php

<?php

// Values received via ajax
$userName = $_POST['userName'];
$newlyBookedDate = $_POST['newlyBookedDate'];
$courseTeacher = $_POST['courseTeacher'];
$userBranch = $_POST['userBranch'];
$userID = $_POST['userID'];
// connection to the database
try {
$bdd = new PDO('mysql:host=localhost;dbname=show981111', 'show981111', 'pass');
} catch(Exception $e) {
exit('Unable to connect to database.');
}

// insert the records
$sql = "INSERT INTO DAYSCHEDULE (newlyBookedDate, userID, userName, courseTeacher,userBranch ) VALUES (:newlyBookedDate, :userID, :userName, :courseTeacher, :userBranch)";
$q = $bdd->prepare($sql);
$q->execute(array(':newlyBookedDate'=>$newlyBookedDate, ':userID'=>$userID, ':userName'=>$userName,  ':courseTeacher'=>$courseTeacher,':userBranch'=>$userBranch ));

?>

Upvotes: 0

Views: 422

Answers (1)

Shakil Ahammed
Shakil Ahammed

Reputation: 21

if your data inserted into DB then take the response from your controller/W to the success function parameter and see the log.

$.ajax({
           url:"http://show981111.cafe24.com/login-system/addevent.php",
           type:"POST",
           data:{userName: '<?php echo $name; ?>' , newlyBookedDate:start, courseTeacher : teacher, userBranch:'<?php echo $userBranch; ?>', userID: '<?php echo $userID; ?>'},

           success:function(response)
           {
            console.log(response);
            calendar.fullCalendar('refetchEvents');
            alert("Added Successfully");
           }
          });

if you are getting no error then in the success function should be 

success:function(response)
           {
            console.log(response);
            //calendar.fullCalendar('refetchEvents');
            //if calendar is used as an id then 
            $("#calendar").fullCalendar('refetchEvents');
            //or it is a class then
            $(".calendar").fullCalendar('refetchEvents');
            alert("Added Successfully");
           }

Upvotes: 1

Related Questions