Problem with dhtmlxForm and dhtmlxConnector

futuredba · February 13, 2013, 8:02am

Hello,
I have a serious problem with the use of dhtmlxform and recording data from the form in my database.
in fact this is my form in client side:

function formanneeOnLoad() 
			{
				var formData = 
				[
					{
						type: "fieldset",  name: "mydata", label: "Espace année budgétaire", width:610,
						list:
						[
							{
								type: "fieldset",
								label: "Création d'une année budgétaire",
								inputWidth: 550,
								list: 
								[									
									{
										type: "input",
										label: "année budgétaire:",
										name: "nom",
										validate: "NotEmpty"
									},
									{
										type: "hidden",
										name: "iscurrent",
										value: "false"
									},
									{
										type: "hidden",
										name: "islocked",
										value: "false"
									},
									{
										type: "calendar",
										dateFormat:"%Y-%m-%d",
										name: "debut",
										label: "Début",
										validate: "NotEmpty",
										calendarPosition: "bottom"
									}, 
									{
										type: "calendar",
										dateFormat: "%Y-%m-%d",
										name: "fin",
										label: "Fin",
										validate: "NotEmpty",
										calendarPosition: "bottom"
									}, 
									{
										type: "button",
										value: "Enregistrer",
										name: "enregistrer"
									}
								]
							}
						]
					}
				];
				formannee = new dhtmlXForm("formannee", formData);
				var dp = new dataProcessor("controleurs/annee.php");
				dp.init(formannee);				
				formannee.enableLiveValidation(true);
				formannee.attachEvent("onButtonClick", function()
				{
					formannee.validate();
				});
				formannee.attachEvent("onButtonClick", function(id)
				{
					this.send("controleurs/annee.php");
				}
				);				
			}
<div id="myForm" style="height:30px; float:right;"></div>

my connector on server side:

<?php
try {		
		require_once("../vues/codebase/form_connector.php");
		require("../vues/codebase/db_pdo.php");
		$conn=new PDO('pgsql:host=localhost port=5436 dbname=mission', 'postgres', 'fb12fb12b');
		$form = new FormConnector($conn);
		$form->render_table("annee","id","id,nom,iscurrent,islocked,debut,fin");
    }
	catch (PDOException $e)
	{
		print "Erreur !: " . $e->getMessage() . "<br/>";
		die();
    }
?>

and i have the following erros:

in server side

[13-Feb-2013 07:34:38] PHP Notice:  Undefined index:  ids in H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\form_connector.php on line 56
[13-Feb-2013 07:34:38] PHP Fatal error:  Uncaught exception 'Exception' with message 'ID parameter is missed' in H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\form_connector.php:57
Stack trace:
#0 H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\base_connector.php(467): FormConnector->parse_request()
#1 H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\base_connector.php(398): Connector->render()
#2 H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\controleurs\annee.php(14): Connector->render_table('annee', 'id', 'id,nom,iscurren...')
#3 {main}
  thrown in H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\form_connector.php on line 57

in client side

"NetworkError: 500 Internal Server Error - http://localhost/Ordre%20de%20Mission/controleurs/annee.php"

can someone give some of his precious time to help me

Stanislav · February 13, 2013, 10:35am

Do you have connector.js included on the page ?
( must be included after dhtmlxdataprocessor.js )

futuredba · February 13, 2013, 10:44am

yes,
thank you for your time already

this is my include header

<meta charset="utf-8" />
        <title>Gestion Informatisée des Ordres de Mission à AXXENTIS</title>
		<link rel="stylesheet" href="vues/style/style.css" />
		<link rel="stylesheet" type="text/css" href="vues/dhtmlxCalendar/codebase/dhtmlxcalendar.css"></link>
		<link rel="stylesheet" type="text/css" href="vues/dhtmlxAccordion/codebase/skins/dhtmlxaccordion_dhx_skyblue.css">
		<link rel="stylesheet" type="text/css" href="vues/dhtmlxCalendar/codebase/skins/dhtmlxcalendar_dhx_skyblue.css"></link>
		<link rel="stylesheet" type="text/css" href="vues/dhtmlxForm/codebase/skins/dhtmlxform_dhx_skyblue.css">
		<link rel="stylesheet" type="text/css" href="vues/dhtmlxMessage/codebase/themes/message_default.css">
		
		<script src="vues/dhtmlxAccordion/codebase/dhtmlxcommon.js"></script>
		<script src="vues/dhtmlxAccordion/codebase/dhtmlxaccordion.js"></script>
		<script src="vues/dhtmlxCalendar/codebase/dhtmlxcalendar.js"></script>
		<script src="vues/dhtmlxForm/codebase/dhtmlxform.js"></script>
		<script src="vues/dhtmlxForm/codebase/ext/dhtmlxform_item_calendar.js"></script>		
		<script src="vues/dhtmlxAccordion/codebase/dhtmlxcontainer.js"></script>	
		<script src='vues/dhtmlxMessage/codebase/message.js'></script>
		<script src="vues/dhtmlxDataProcessor/codebase/dhtmlxdataprocessor.js"></script>
		<script src="vues/js/connector.js" charset="utf-8"></script>
		<script>

Stanislav · February 15, 2013, 4:58pm

List of includes looks valid, but error on server side is similar to the case when connector.js is not included. Please double check that connector.js really exists it defined location.

Also, you can try to alter form initialization code like next

dp.setTransactionMode("POST", true); formannee.enableLiveValidation(true);

also if you are inserting new record without loading it first, you may try the next code

dp.setTransactionMode("POST", true); formannee.formId = "someid"; formannee.resetDataProcessor("inserted"); formannee.enableLiveValidation(true);

futuredba · February 18, 2013, 11:02am

Bonjour une fois de plus,
ce problème me semble résolu mais, actullement je ne sais comment enregistrer les données d’un formulaire dans la base de données.
in client side, i hava this code,

function formanneeOnLoad() 
			{
				var formData = 
				[
					{
						type: "fieldset",  name: "mydata", label: "Espace année budgétaire", width:610,
						list:
						[
							{
								type: "fieldset",
								label: "Création d'une année budgétaire",
								inputWidth: 550,
								list: 
								[									
									{
										type: "input",
										label: "année budgétaire:",
										name: "nom",
										validate: "NotEmpty"
									},
									{
										type: "hidden",
										name: "iscurrent",
										value: "false"
									},
									{
										type: "hidden",
										name: "islocked",
										value: "false"
									},
									{
										type: "calendar",
										dateFormat:"%Y-%m-%d",
										name: "debut",
										label: "Début",
										validate: "NotEmpty",
										calendarPosition: "bottom"
									}, 
									{
										type: "calendar",
										dateFormat: "%Y-%m-%d",
										name: "fin",
										label: "Fin",
										validate: "NotEmpty",
										calendarPosition: "bottom"
									}, 
									{
										type: "button",
										value: "Enregistrer",
										name: "enregistrer"
									}
								]
							}
						]
					}
				];
				formannee = new dhtmlXForm("formannee", formData);
				var dp = new dataProcessor("controleurs/annee.php");
				dp.init(formannee);				
				formannee.enableLiveValidation(true);
				formannee.attachEvent("onButtonClick", function()
				{
					formannee.validate();
				});
				formannee.attachEvent("onButtonClick", function(name, command)
				{
					if(name=="enregistrer")
					{
						this.send("controleurs/annee.php");
						//alert("Enregistrer avec succès");
					}
				}
				);				
			}

in server side i have this code,

<?php
try {		
		//require_once("../vues/codebase/config.php");
		require_once("../vues/codebase/form_connector.php");
		require("../vues/codebase/db_pdo.php");			
		$conn=new PDO('pgsql:host=localhost port=5436 dbname=mission', 'postgres', 'fb12fb12b');
		//var_dump($_post); die();
		//$conn->query("INSERT INTO annee VALUES(NULL,'2011-2012',true,true,'2012-01-02','2013-06-02')");
		//$form = new FormConnector($conn);			
		//$form->render_table("annee","id","nom,iscurrent,islocked,debut,fin");
		
    }
	catch (PDOException $e)
	{
		print "Erreur sql !: " . $e->getMessage() . "<br/>";
		die();
    }

I don’t know what to put on the server to ensure that registration is effective.
Currently, I have no error in my client as I click save, but no data is recorded in a database.

Thank you for your help.

Stanislav · February 18, 2013, 1:15pm

The next two lines must be enough

$form = new FormConnector($conn,"PDO"); //PDO added as second param $form->render_table("annee","id","nom,iscurrent,islocked,debut,fin");

futuredba · February 18, 2013, 2:13pm

After doing what you said, I’m have the following error

POST http://localhost/Ordre%20de%20Mission/controleurs/annee.php
	
500 Internal Server Error
		1.6s

Thank you for your help.

futuredba · February 18, 2013, 2:18pm

in server side i have this error:

[18-Feb-2013 14:02:18] PHP Notice:  Undefined index:  ids in H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\form_connector.php on line 56
[18-Feb-2013 14:02:18] PHP Fatal error:  Uncaught exception 'Exception' with message 'ID parameter is missed' in H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\form_connector.php:57
Stack trace:
#0 H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\base_connector.php(467): FormConnector->parse_request()
#1 H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\base_connector.php(398): Connector->render()
#2 H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\controleurs\annee.php(9): Connector->render_table('annee', 'id', 'nom,iscurrent,i...')
#3 {main}
  thrown in H:\Program Files\Zend\Apache2\htdocs\Ordre de Mission\vues\codebase\form_connector.php on line 57

Stanislav · February 19, 2013, 10:31am

When you are opening connector file by url it expects that it will be opened as

some.php?id=123

That id parameter is mandatory, because without it form connector doesn’t know which record to fetch.
If you are saving data - try to use form.save(); instead of form.send();

futuredba · February 19, 2013, 11:03am

thank you,
I use form.save (), everything seems to market because I have no error at the client and at the server level, but only the data is not saved in my database.

when I look at the firebug console, I have this:

XML

<data>
<action type="error" sid="1361260494685" tid="1361260494685"></action>
</data>

POST

1361260494685_!nativeedit...	inserted
1361260494685_debut	2013-02-08
1361260494685_fin	2013-02-10
1361260494685_iscurrent	false
1361260494685_islocked	false
1361260494685_nom	ygukop
ids	1361260494685
Source
1361260494685_nom=ygukop&1361260494685_iscurrent=false&1361260494685_islocked=false&1361260494685_debut=2013-02-08&1361260494685_fin=2013-02-10&1361260494685_!nativeeditor_status=inserted&ids=1361260494685

response

<?xml version='1.0' ?><data><action type='error' sid='1361260494685' tid='1361260494685' ></action></data>

Stanislav · February 20, 2013, 11:58am

Try to enable logs, they must contain details about the error.
docs.dhtmlx.com/doku.php?id=dhtm … tor:errors

futuredba · February 20, 2013, 12:18pm

I could solve the problem,
it was at initialization dataprocessor and grid.

grid.load("controleurs/annee.php");	
dp = new dataProcessor("controleurs/annee.php");

au lieu de

grid.load("controleurs/annee.php");	
dp = new dataProcessor("controleurs/accueil.php");

even until now, I think it should be like this:

grid.load("controleurs/annee.php");	
dp = new dataProcessor("controleurs/accueil.html");

Thank you for your time