Button to delete Fullcalendar events - Celke

Question

In the code below, when I click on "Delete event" gives an error that you need to select the event(event ID).

Code where events are loaded:

eventClick: function(event) {

                    $('#visualizar #id').text(event.id);
                    $('#visualizar #id').val(event.id);
                    $('#visualizar #title').text(event.title);
                    $('#visualizar #title').val(event.title);
                    $('#visualizar #start').text(event.start.format('DD/MM/YYYY HH:mm:ss'));
                    $('#visualizar #start').val(event.start.format('DD/MM/YYYY HH:mm:ss'));
                    $('#visualizar #end').text(event.end.format('DD/MM/YYYY HH:mm:ss'));
                    $('#visualizar #end').val(event.end.format('DD/MM/YYYY HH:mm:ss'));
                    $('#visualizar #color').val(event.color);
                    $('#visualizar').modal('show');
                    return false;

                },

Knob:

<a class="btn btn-danger" type="button" href="deletar_evento.php">Excluir evento</a>

deletar_event.php:

<?php
session_start();
include_once("conexao.php");
$id = filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT);
if(!empty($id)){
    $result_events = "DELETE FROM events WHERE id='$id'";
    $resultado_events = mysqli_query($conn, $result_usuario);
    if(mysqli_affected_rows($conn)){
        $_SESSION['msg'] = "<div class='alert alert-success' role='alert'>Evento excluído com sucesso!<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>&times;</span></button></div>";
        header("Location: index.php");
    }else{

        $_SESSION['msg'] = "<div class='alert alert-danger' role='alert'>Erro ao excluír evento!<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>&times;</span></button></div>";
        header("Location: index.php");
    }
}else{  
    $_SESSION['msg'] = "<div class='alert alert-danger' role='alert'>É necessário selecionar um evento!<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>&times;</span></button></div>";
    header("Location: index.php");
}

Site do Celke: https://celke.com.br/artigo/como-editar-um-evento-no-fullcalendar-com-janela-modal-do-bootstrap

Answer 1

I think you need to put the dots to join the string with the variable:

Thereof:

$result_events = "DELETE FROM events WHERE id='$id'";

For that reason:

$result_events = "DELETE FROM events WHERE id='".$id."'";

If it’s not a mistake please...

Answer 2

If you’re familiar with Jquery, I’m not sure how you have the code but you can try it like this

The tag <a> should have a id, kind of: <a href="deletar_inscricao.php" id="tag_a_alterar">

$('#calendar').fullCalendar({
  eventClick: function(event) {
     $("#tag_a_alterar").attr("href", "deletar_inscricao.php?id="+calEvent.id);
  }
});

So every time you click on an event, you will change the href for what you want to delete.

To define the id of an event, you will need to add an extra field when showing that event.

If that’s how I think it is, that’s what the code looks like, just add one id

$('#calendar').fullCalendar({
  events: [
    {
      title  : 'event1',
      start  : '2010-01-01'
      id: '1'
    },
    {
      title  : 'event2',
      start  : '2010-01-05',
      end    : '2010-01-07'
      id: '2'
    }
  ]
});