new_events.php

<?php
include("includes/config.php");
if(isset($_POST['eventTitle'])) {
    $title = (int)$_POST['eventTitle'];
    if(empty($title)){
      echo json_encode(false);
      exit;
    }
}
$action = $_GET['action'];
switch($action)
{
        case 'add':
                    $sql = "INSERT INTO ".DBSPCL_CHARGE." SET
                                                    property_id =".dkode($_POST['propID']).",
                                                    start_date = '".$_POST['startDate']."' ,
                                                    end_date = '".$_POST['endDate']."',
                                                    amount = '".$_POST['eventTitle']."' ";
                    break;
       case 'edit':
                    $sql = "UPDATE ".DBSPCL_CHARGE." SET amount = '".$_POST['eventTitle']."'
                            WHERE charge_id =".(int)$_POST['eventId']." ";
                    break;
       case 'del' :
                    $sql = "DELETE FROM ".DBSPCL_CHARGE." WHERE charge_id =".(int)$_POST['eventId']." ";
                    break;
}
    $query = $db->query($sql);
    echo json_encode($query);
?>