insert in postgresql

hi,



I would like to know how to manually insert into the schedule. I have it from the page as follows:



    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”);





    function insercion($action){



        $status = $action->get_status();



        $id_evento = $action->get_value(“id_evento”);



        $start_date = $action->get_value(“start_date”);

        $end_date = $action->get_value(“end_date”);

        $evento_nombre = $action->get_value(“evento_nombre”);

        $detalles = $action->get_value(“detalles”);





        if ($status == “inserted”){

            $scheduler->sql->query(""INSERT INTO eventos (id_evento, start_date,end_date,evento_nombre) VALUES ((id_evento, start_date,end_date,evento_nombre) );

            $action->success();

        }



    }



    $scheduler = new schedulerConnector($res,“Postgre”);



    $scheduler->event->attach(“afterProcessing”,“insercion”);



    $scheduler->render_table(“eventos”,“id_evento”,“start_date,end_date,evento_nombre,detalles”);



how to capture the values to create a new event


Hello,


you can use addEvent method to insert new event


dhtmlx.com/dhxdocs/doku.php?id=d … r_addevent


In order to send request with an event that is added by addEvent method you can use the following method:


dataProcessor.setUpdated(event_id,true,“inserted”);


dataProcessor.sendData();


Here dataProcessor is DataProcessor object.

a) If you want to intercept insert action, you need to use beforeInsert , not the afterProcessing server side event.
b)
$action->success();
need to be replaced with
$action->success($new_id_value); //inform about new ID of event

hi,

thank you very much for answering my question and thanks for your effort and dedication.

what happens is this this is my page events.php

<?php

    include (’…/componentes/codebase/connector/scheduler_connector.php’);
    include_once(’…/componentes/codebase/connector/db_postgre.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”);


    function insercion($action){

        $status = $action->get_status();

 
        if ($status == “inserted”){
            $scheduler->sql->query(“insert”,"INSERT INTO eventos(id_evento,start_date,end_date,evento_nombre,detalles) VALUES (“xxxx,xxxx,xxxx,xxxxx”);
            $action->success();
        }

    }

 
    $scheduler = new schedulerConnector($res,“Postgre”);

    $scheduler->event->attach(“afterProcessing”,“insercion”);

    $scheduler->render_table(“eventos”,“id_evento”,“start_date,end_date,evento_nombre,detalles”);

?>

What
I would like to know is how to receive data from the timetable on the
events page I noticed that when you create an event sent by the POST
method

1262619087106_!nativeeditor_status inserted
1262619087106_end_date 2010-01-04 06:05
1262619087106_id 1262619087106
1262619087106_start_date 2010-01-04 06:00
1262619087106_text example event text description
ids 1262619087106

how can I retrieve the data on my sales page to send the attachment manually

insistence and apologize for any inconvenience caused and thanks for your time


If you mean the same page where scheduler resides, you can use

var ev = scheduler.getEvent(id);
var text = ev.text;
var start_date = scheduler.template.xml_format(ev.start_date);
var end_date = scheduler.template.xml_format(ev.start_date);

Id - id of added|updated event.


thank you very much for your response

but what I need is to receive the data on the webpage dataprocesor

constructs the page where the calendar is this:




    function init() {

         
        scheduler.config.xml_date=“%Y-%m-%d %H:%i”;

        scheduler.config.lightbox.sections=[     
            {name:“description”, height:130, map_to:“text”, type:“textarea” , focus:true},

            //{name:“location”, height:43, type:“textarea”, map_to:“details” },

            {name:“time”, height:72, type:“time”, map_to:“auto”}

        ]

        scheduler.config.first_hour=4;

        //scheduler.locale.labels.section_location=“Location”;

        scheduler.config.details_on_create=true;

        scheduler.config.details_on_dblclick=true;

     
        scheduler.init(‘scheduler_here’,null,“month”);

        scheduler.load(“events.php?uid=”+scheduler.uid());

         
        var dp = new dataProcessor(“events.php”);

        dp.init(scheduler);
 
    }


your code if I would serve on that page but I need to recover the data on page events.php that is:

include (‘…/componentes/codebase/connector/scheduler_connector.php’);
    include_once(‘…/componentes/codebase/connector/db_postgre.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”);


    function insercion($action){

        $status = $action->get_status();

 
        if ($status == “inserted”){
            //$action->set_status(“deleted”);
            $scheduler->sql->query(“insert”,"INSERT INTO eventos(id_evento,start_date,end_date,evento_nombre,detalles) VALUES (xxxxx,xxxx,xxxxx,xxxx);
            $action->success();
        }

    }

 
    $scheduler = new schedulerConnector($res,“Postgre”);

    //$scheduler->enable_log(“log.txt”,true);
    $scheduler->event->attach(“afterProcessing”,“insercion”);

    $scheduler->render_table(“eventos”,“id_evento”,“start_date,end_date,evento_nombre,detalles”);

and when I check the events page I get the following error:

Fatal error: Uncaught exception ‘Exception’ with message
‘Incorrect incoming data, ID of incoming records not recognized’ in
/var/www/sitiosphp/medicos/componentes/codebase/connector/dataprocessor.php:64
Stack
trace:
#0
/var/www/sitiosphp/medicos/componentes/codebase/connector/base_connector.php(336):
DataProcessor->process(Object(DataConfig),
Object(DataRequestConfig))
#1
/var/www/sitiosphp/medicos/componentes/codebase/connector/base_connector.php(290):
Connector->render()
#2 /var/www/sitiosphp/medicos/scripts/events.php(32):
Connector->render_table(‘eventos’, ‘id_evento’,
‘start_date,end_…’)
#3 {main} thrown in /var/www/sitiosphp/medicos/componentes/codebase/connector/dataprocessor.php on line 64


thanks for your time


calendario_postgresql.html.zip (1.12 KB)
events.php.zip (710 Bytes)

hi,

This would serve to the page that draws the schedule

var ev = scheduler.getEvent(id);
var text = ev.text;
var start_date = scheduler.template.xml_format(ev.start_date);
var end_date = scheduler.template.xml_format(ev.start_date);

as I do the same but from a php page

Fatal error: Uncaught exception ‘Exception’ with message ‘Incorrect incoming data, ID of incoming records not recognized’
Such error can occurs if you are calling
events.php?editing=true
which marks dataprocessor call, but there is no valid $_POST[“ids”] value.



if ($status == “inserted”){

$id_evento = $action->get_id();
$start_date = $action->get_value(“start_date”);
$end_date = $action->get_value(“end_date”);
$evento_nombre = $action->get_value(“evento_nombre”);
$detalles = $action->get_value(“detalles”);


$scheduler->sql->query(“insert”,“INSERT INTO eventos(id_evento,start_date,end_date,evento_nombre,detalles) VALUES (’{$id_evento}’,’{$start_date}’,’{$end_date}’,’{$evento_nombre}’,’{$detalles}’)”);
$action->success(); // <= parameter need to be added if ID is changes
}


thanks for your response and your time

not
if you could help me as I fix the problem because what I want is to
delete operations, insert and update manually and retrieve the data in
the php page that assumed it to this form:

$id_evento = $action->get_id();
      $start_date = $action->get_value(“start_date”);
      $end_date = $action->get_value(“end_date”);
      $evento_nombre = $action->get_value(“evento_nombre”);
      $detalles = $action->get_value(“detalles”);


and if this is not good or if I’m wrong

     
$scheduler->sql->query(“insert”,“INSERT INTO
eventos(id_evento,start_date,end_date,evento_nombre,detalles) VALUES
(‘{$id_evento}’,‘{$start_date}’,‘{$end_date}’,‘{$evento_nombre}’,‘{$detalles}’)”);
      $action->success();

please help, thanks

Inside any server side event ( beforeInsert, beforeUpdate, beforeDelete, etc. ) you can use the same code as above to fetch parameters and execute your custom SQL
To have custom logic for insert|update|delete you will need to attach code for 3 above mentioned events.

function my_code($action){
$id_evento = $action->get_id();
$start_date = $action->get_value(“start_date”);
$end_date = $action->get_value(“end_date”);
$evento_nombre = $action->get_value(“evento_nombre”);
$detalles = $action->get_value(“detalles”);

$sch->sql->query(“insert”,“INSERT INTO eventos(id_evento,start_date,end_date,evento_nombre,detalles) VALUES (’{$id_evento}’,’{$start_date}’,’{$end_date}’,’{$evento_nombre}’,’{$detalles}’)”);

$action->success();
}
$sch->event(“beforeInsert”,my_code)
$sch->render…