Install Schedular to codeigniter

Scheduler Javascript
#1

Here is my controller

[code]<?php if ( ! defined(‘BASEPATH’)) exit(‘No direct script access allowed’);

class Booking extends CI_Controller {

public function index()
{   
    if(!$this->session->userdata('logged_in'))
    {
        redirect('login');
    }
    // include('../../../codebase/connector/scheduler_connector.php');
    $data['user_id']=$this->session->userdata['user_id'];
    $this->load->view('site/booking/header',$data);
    $this->load->view('site/left.php',$data);
    $this->load->view('site/booking/userevents',$data);
    $this->load->view('site/footer');
}

}[/code]

[code]<?php
$_SESSION[‘user_id’]=$user_id;
?>

 
 
[/code]

and here is (codebase/userevents.php)

[code]<?php
include (’…/codebase/connector/scheduler_connector.php’);
$server = “localhost”;
$user = “root”;
$pass = “root”;
$db_name= “AGU”;
$res=mysql_connect($server, $user, $pass);
mysql_select_db($db_name);
$scheduler = new schedulerConnector($res);
$scheduler->enable_log(“log.txt”,true);
$query=“select * from tbl_events where user_id=”.$_SESSION[‘user_id’];
$scheduler->render_sql($query, “event_id”,“start_date,end_date,event_name,details”);

?>[/code]

it’s cant recieve $_SESSION[‘user_id’] variable! so how can i put some variable to (codebase/userevents.php)! thanks for reading

#2

it’s cant recieve $_SESSION[‘user_id’] variable!
I may be wrong, but most probably adding of session_start will resolve problem

<?php session_start(); include ('../codebase/connector/scheduler_connector.php');

#3

It doesnt work too! The point is load event that with my condition!For example: in the table
events(event_id, event_name, start_date, end_date, details, equipment_id, user_id)

how can i load the event with user_id=3;

how can i pass the variable user_id=3 to (codebase/userevents.php)???

[code]<?php
include (’…/codebase/connector/scheduler_connector.php’);
$server = “localhost”;
$user = “root”;
$pass = “root”;
$db_name= “AGU”;
$res=mysql_connect($server, $user, $pass);
mysql_select_db($db_name);
$scheduler = new schedulerConnector($res);
$scheduler->enable_log(“log.txt”,true);
$query=“select * from tbl_events where user_id=”.$_SESSION[‘user_id’];
$scheduler->render_sql($query, “event_id”,“start_date,end_date,event_name,details”);

?>[/code]

any solution? can i still can load the event without loading that file?

scheduler.load("<?= base_url();?>codebase/userevents.php");
      
 var dp = new dataProcessor("<?= base_url();?>codebase/userevents.php");
#4

here is my new controler

[code]<?php if ( ! defined(‘BASEPATH’)) exit(‘No direct script access allowed’);

class Booking extends CI_Controller {

 function __construct()
   {
        parent::__construct();
            $this->load->library('javascript'); 
            $this->load->library('Dhtmlx');
   }

public function index()
{   
    if(!$this->session->userdata('logged_in'))
    {
        redirect('login');
    }
    $res=mysql_connect("localhost","root", "root");
    mysql_select_db("AGU");
    $scheduler = new schedulerConnector($res);
    $scheduler->render_table("tbl_events","event_id","start_date,end_date,event_name,details");
    $data['scheduler_result']=$scheduler;
    $this->load->view('site/booking/header');
    $this->load->view('site/booking/userevents',$data);
    $this->load->view('site/footer');
}

}[/code]

when i run it show that

<data><event id="109"><start_date><![CDATA[2012-02-03 06:50:00]]></start_date><end_date><![CDATA[2012-02-03 13:55:00]]></end_date><text><![CDATA[New event]]></text><details><![CDATA[]]></details></event><event id="110"><start_date><![CDATA[2012-02-02 07:50:00]]></start_date><end_date><![CDATA[2012-02-02 13:00:00]]></end_date><text><![CDATA[New event]]></text><details><![CDATA[]]></details></event><event id="111"><start_date><![CDATA[2012-01-31 06:50:00]]></start_date><end_date><![CDATA[2012-01-31 10:25:00]]></end_date><text><![CDATA[New event]]></text><details><![CDATA[]]></details></event><event id="112"><start_date><![CDATA[2012-02-07 07:00:00]]></start_date><end_date><![CDATA[2012-02-07 14:55:00]]></end_date><text><![CDATA[New event]]></text><details><![CDATA[]]></details></event><event id="113"><start_date><![CDATA[2012-02-11 09:05:00]]></start_date><end_date><![CDATA[2012-02-11 13:15:00]]></end_date><text><![CDATA[New event]]></text><details><![CDATA[]]></details></event><event id="114"><start_date><![CDATA[2012-02-08 07:50:00]]></start_date><end_date><![CDATA[2012-02-08 10:50:00]]></end_date><text><![CDATA[New event]]></text><details><![CDATA[]]></details></event><event id="116"><start_date><![CDATA[2012-02-10 08:15:00]]></start_date><end_date><![CDATA[2012-02-10 12:30:00]]></end_date><text><![CDATA[Sự kiện mới]]></text><details><![CDATA[asdasdasd]]></details></event></data>

so i wonder how to read it in the view? Plz help me :slight_smile: