![Decabeza](http://static.forosdelweb.com/fdwtheme/images/smilies/decabeza.png)
Estoy con un calendario de eventos el cual encontre en la web y lo e modificado para mostrar datos de una tabla de mi BD sin embargo estoy necesitando jalar datos desde mas de una tabla pero no c en q parte del codigo puedo meter mano.
E obssrvado que realiza el llamado de la base ded datos a travez de un array.Bueno aki les pongo el codigo espero me ayuden.
events.php
Código PHP:
<?php
include ('codebase/connector/scheduler_connector.php');
include ('config.php');
$res=mysql_connect($server, $user, $pass);
mysql_select_db($db_name);
$scheduler = new schedulerConnector($res);
//$scheduler->enable_log("log.txt",true);
$scheduler->render_table("tareas","id","fecha_inicio,fecha_fin,codigo");
?>
Código PHP:
<script src="codebase/dhtmlxscheduler.js?v=090722" type="text/javascript" charset="utf-8"></script>
<link rel="stylesheet" href="codebase/dhtmlxscheduler.css" type="text/css" media="screen" title="no title" charset="utf-8">
<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.config.xml_date="%Y-%m-%d %H:%i";
scheduler.config.lightbox.sections=[
{name:"description", height:40, map_to:"text", type:"textarea" , focus:true},
{name:"location", height:20, type:"textarea", map_to:"details" },
{name:"time", height:20, type:"time", map_to:"auto"}
]
scheduler.config.first_hour=8;
scheduler.locale.labels.section_location="Location";
scheduler.config.update_render="true"
scheduler.attachEvent("onEventCreated",function(id,e){
var date = scheduler.getEvent(id).start_date;
date.setHours(8);
scheduler.getEvent(id).start_date = date;
var date1 = scheduler.getEvent(id).end_date;
date1.setHours(8);
scheduler.getEvent(id).end_date = date1;
})
scheduler.init('scheduler_here',null,"month");
scheduler.load("events.php?uid="+scheduler.uid());
var dp = new dataProcessor("events.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>
db_mysqli.php
Código PHP:
<?php
require_once("db_common.php");
class MySQLiDBDataWrapper extends MySQLDBDataWrapper{
public function query($sql){
LogMaster::log($sql);
$res = $this->connection->query($sql);
if ($res===false) throw new Exception("MySQL operation failed\n".$this->connection->error);
return $res;
}
public function get_next($res){
return $res->fetch_assoc();
}
protected function get_new_id(){
return $this->connection->insert_id;
}
public function escape($data){
return $this->connection->real_escape_string($data);
}
public function tables_list() {
$result = $this->connection->query("SHOW TABLES");
if ($result===false) throw new Exception("MySQL operation failed\n".$this->connection->error);
$tables = array();
while ($table = $result->fetch_array()) {
$tables[] = $table[0];
}
return $tables;
}
public function fields_list($table) {
$result = $this->connection->query("SHOW COLUMNS FROM `".$table."`");
if ($result===false) throw new Exception("MySQL operation failed\n".$this->connection->error);
$fields = array();
while ($field = $result->fetch_array()) {
if ($field['Key'] == "PRI") {
$fields[$field[0]] = 1;
} else {
$fields[$field[0]] = 0;
}
}
return $fields;
}
}
?>
espero puedan ayuadarme!!GRACIAS