Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by diego on Dec 16, 2009 12:12
open dhtmlx forum
scheduler with postgresql

Muchisimas gracias si le puse el parametro postgresql y me cargo la pagina pero me arroja error de xml Error type: LoadXML
Description: Incorrect XML

lo unico que hice fue una tabla en postgresql con la siguiente estructura:

CREATE TABLE eventos
(
  id_evento character varying NOT NULL,
  start_date date,
  end_date date,
  evento_nombre character varying,
  detalles character varying,
  CONSTRAINT eventos_pkey PRIMARY KEY (id_evento)
)
WITH (  OIDS=FALSE );

y estoy utilizando como ejemplo la pagina: 05_loading_mysql.html  la cual carga la pagina events.php:

events.php:
<?php
    //session_start();
    include ('../componentes/codebase/connector/scheduler_connector.php');
    require_once("../componentes/comunicacion.inc");
   
    global $DB_SERVER,$DB_PORT,$DB_NAME,$DB_USER,$DB_PASSWORD;
  $res = pg_connect("host=$DB_SERVER port=$DB_PORT dbname=$DB_NAME user=$DB_USER password=$DB_PASSWORD");
    //$res=mysql_connect($server, $user, $pass);
    //mysql_select_db($db_name);
     
    $scheduler = new schedulerConnector($res,"Postgre");
    //$scheduler->enable_log("log.txt",true);
    $scheduler->render_table("eventos","id_evento","start_date,end_date,evento_nombre,detalles");
?>

muchas gracias por tu tiempo y comprension


Answer posted by Stanislav (support) on Dec 17, 2009 01:26
You need just one small addition

<?php
  include_once('../components/codebase/connector/scheduler_connector.php');
  include_once('../components /codebase/connector/db_postgre.php');
  
Answer posted by diego on Dec 17, 2009 06:44
thank you very much for the help worked perfect