Hello, everyone, I’m trying to display some data that I have stored in a database. I can at least show the calendar and populate it with data from arrays (client-side); but when I try to use my database, tings go wrong and I can’t see any data. I think I’m making some mistakes, but I have checked my code, the documentation and guides, and can’t get the results I would like to.
This is my html:
<!DOCTYPE html>
<html>
<head>
<title>How to start</title>
<meta http-equiv="Content-type" content="text/html;" charset="utf-8">
<script src="scheduler/dhtmlxscheduler.js" type="text/javascript" charset="utf-8"> </script>
<link rel="stylesheet" href="scheduler/dhtmlxscheduler.css" type="text/css" charset="utf-8">
</head>
<style type="text/css" media="screen">
html, body{
margin:0px;
padding:0px;
height:100%;
overflow:hidden;
}
</style>
<script type="text/javascript" charset="utf-8">
function init() {
scheduler.init('scheduler_here', new Date(),"month");
scheduler.load("connector.php");
var dp = new dataProcessor("connector.php");
dp.init(scheduler);
}
</script>
<body onload="init();">
<div id="scheduler_here" class="dhx_cal_container" style='width:100%; height:100%;'>
<div class="dhx_cal_navline">
<div class="dhx_cal_prev_button"> </div>
<div class="dhx_cal_next_button"> </div>
<div class="dhx_cal_today_button"></div>
<div class="dhx_cal_date"></div>
<div class="dhx_cal_tab" name="day_tab" style="right:204px;"></div>
<div class="dhx_cal_tab" name="week_tab" style="right:140px;"></div>
<div class="dhx_cal_tab" name="month_tab" style="right:76px;"></div>
</div>
<div class="dhx_cal_header"></div>
<div class="dhx_cal_data"></div>
</div>
</body>
</html>This is my connector.php file:
<?php
require("scheduler/connector/scheduler_connector.php");
require("scheduler/connector/db_mysqli.php");
$conn = new mysqli("127.0.0.1", "root", "root", "meddb");
$scheduler = new SchedulerConnector($conn, "MySQLi");
$scheduler->render_table("citas","id","start_date,end_date,text");
?>The table in the database was created like this:
CREATE TABLE `citas` (
`id` int(11) NOT NULL,
`start_date` datetime NOT NULL,
`end_date` datetime NOT NULL,
`text` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;I’m sorry for asking such a thing, but I’m a little lost.
Thank you for your time
greetings from Mexico.