Using Select with Form (value from DB)

akolamb1 · July 31, 2011, 7:14pm

Hello,
I am trying to do a simple dhtmlxForm example with select.

However, i am getting values in the “Select” menu which dont make sense.
Example: 1312138715x0.
Also, i am getting “Undefined Offset: 1” error in the log.txt file

Below is the code:

<html>
<head>
	<link rel='STYLESHEET' type='text/css' href='../dhtmlx_suite/dhtmlxGrid/codebase/dhtmlxgrid.css'>
	
	<link rel="stylesheet" type="text/css" href=".../dhtmlx_suite/dhtmlxForm/codebase/skins/dhtmlxform_dhx_skyblue.css">	
	<script src="../dhtmlx_suite/dhtmlxForm/codebase/dhtmlxcommon.js"></script>
	<script src="../dhtmlx_suite/dhtmlxForm/codebase/dhtmlxform.js"></script>
	
</head>
<body>
	
<div id="my_form"></div>
<script>
	formData = [
		{type:"select", label:"Values", connector:"connector2.php" }
	];
	new dhtmlXForm("my_form",formData);
</script>

</body>
</html>

connector2.php

<?php
	require_once("../dhtmlx_suite/dhtmlxConnector/codebase/form_connector.php");
	require_once("../dhtmlx_suite/dhtmlxConnector/codebase/options_connector.php");
	
	$host="127.0.0.1"; 
	$username="user1"; 
        $password="enter"; 
        $db_name="dhtmlx_db";    
	$res2=mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
	mysql_select_db("$db_name");
	
	$options = new SelectOptionsConnector($res2,"MySQL");
	$options->enable_log("log.txt");
	$options->render_sql("SELECT taskName from tasks","","taskName");
?>

The log.txt file gives the following errors:
Log started, 31/07/2011 08:07:13

SELECT taskName FROM tasks

Undefined offset: 1 at C:\Program Files\EasyPHP-5.3.3\www\dhtmlxSuite_web\dhtmlx_suite\dhtmlxConnector\codebase\options_connector.php line 12

Done in 0.022663831710815s

Attached below is the DB table i am using
Also attached is what i see on the HTML page in the Select Menu!
Any help will be appreciated!!

Alexandra · August 1, 2011, 1:03pm

Combo option includes both value and text. The following command gets only one:
$options->render_sql(“SELECT taskName from tasks”,"",“taskName”);

Probably this would be more correct:

$options->render_sql(“SELECT taskId,taskName from tasks”,"",“taskId,taskName”);

akolamb1 · August 1, 2011, 1:12pm

That worked. Thanks!

Using Select with Form (value from DB)

The log.txt file gives the following errors: Log started, 31/07/2011 08:07:13

The log.txt file gives the following errors:
Log started, 31/07/2011 08:07:13