prefix . "booked_appointments";
$insert_booking = "INSERT INTO $table_name (
`bk_ap_id` ,
`bk_ap_name` ,
`bk_ap_email` ,
`bk_ap_service` ,
`bk_ap_cellno` ,
`bk_ap_sttime` ,
`bk_ap_edtime` ,
`bk_ap_stdate` ,
`bk_ap_eddate` ,
`bk_ap_desc`
)
VALUES (
NULL , '$name', '$email', '$service', '$cellno', '$sttm', '$edtm', '$stdt', '$eddt', '$desc'
);";
//echo "here";
$wpdb->query($insert_booking);
}
?>
prefix . "calendar_event";
$x = $wpdb->get_results("select * from $table_name");
foreach( $x as $xx)
{
$xtitle[] = $xx->ev_title;
$xst[] = $xx->ev_start_time;
$xet[] = $xx->ev_end_time;
}
?>
";*/
$xenddate = $xx->ev_end_date;
$ey = substr($xenddate,0,4);
$em = substr($xenddate,5,2);
$ed = substr($xenddate,8,2);
/*$date1 = new DateTime($xstartdate);
$date2 = new DateTime($xenddate);
$interval = $date1->diff($date2);
//$diff = "difference " . $interval->y . " years, " . $interval->m." months, ".$interval->d." days ";
$y = $interval->y;
$m = $interval->m;
$d = $interval->d;
$d = ($y*365) + ($m*30) + $d;*/
$date1 = $xstartdate;
$date2 = $xenddate;
$diff = abs(strtotime($date2) - strtotime($date1));
$y = floor($diff / (365*60*60*24));
$m = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
$d = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
$d = ($y*365) + ($m*30) + $d;
for($j=0; $j<=$d; $j++)
{
?>
{
title: '',
start: new Date(, , , ),
end: new Date(, , , ),
allDay: false
},
],
textColor: 'yellow',
backgroundColor: 'black',
}
]
});
});