Hi
I have an xml file with an options connector. The form loads but the options are not. There is an error in the server side log file. Below are the log, xml and php files.
I looked in the php file at the line of the error but can’t see the problem.
Could someone please help with this urgently ?
I am using the latest connector downloaded from github today.
XML file:
[code]<?xml version="1.0" encoding="UTF-8"?>
<item type="settings" labelAlign="left" labelWidth="120" offsetLeft="10" />
<item type="select" name="customerID" label="Customer" inputWidth="250" connector="php/company.php?act=comboList" validate="NotEmpty" />
[/code]
php file:
[code]<?php
include(‘logmein.php’);
$log = new logmein();
$log->encrypt = true; //set encryption
// //parameters are(SESSION, name of the table, name of the password field, name of the username field)
if($log->logincheck($_SESSION[‘loggedin’]) == false) {
die(); // direct access to the script without logging in beforehand
}
require_once("…/config/config.php");
$resConnect=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_select_db(“installManager”);
$action=isset($_GET[‘act’])?$_GET[‘act’] : “none”;
switch($action){
case ‘companyList’:
$sql = “select id,name from company order by name”;
$result = qry($sql);
if($result && (mysql_num_rows($result) > 0)){
while($r = mysql_fetch_array($result)) {
$row[] = $r;
}
echo json_encode($row);
}
exit;
case 'comboList':
require_once("codebase/form_connector.php");
$conn = new FormConnector($resConnect);
$conn->enable_log("company.log");
$conn->render_table("company","ID","name");
exit;
}
require_once(“codebase/grid_connector.php”);
$conn = new GridConnector($resConnect);
$conn->enable_log(“company.log”);
$conn->render_table(“company”,“id”,“name”);
function qry($query) {
// dbconnect();
$args = func_get_args();
$query = array_shift($args);
$query = str_replace("?", “%s”, $query);
$args = array_map(‘mysql_real_escape_string’, $args);
array_unshift($args,$query);
$query = call_user_func_array(‘sprintf’,$args);
$result = mysql_query($query) or die(mysql_error());
if($result){
return $result;
}else{
$error = “Error”;
return $result;
}
}
?>[/code]
log file error:
====================================
Log started, 26/07/2014 07:58:39
Undefined index: ids at /var/www/htdocs/im/php/codebase/form_connector.php line 51
!!!Uncaught Exception
Code: 0
Message: ID parameter is missed
Help is appreciated
regards
Grant