}
$valuelist .= "`{$key}` = {$val}, ";
$this->setLog(" add:`{$key}` = {$val}, ");
}
$valuelist = ereg_replace(', $', '', $valuelist);
$query = "UPDATE `{$table}` SET {$valuelist} WHERE {$primarykey}";
}
$this->setLog("\n Running query:\n" . $query);
$sql_query = $query;
$qSaveData = new sqlQuery($dbc);
$result = $qSaveData->query($query);
// $uniqid = $qSaveData->getInsertId() ; PL 20030516 not used
if (!$result) {
$error = $qSaveData->getError();
$this->addParam("recordupdated", "no");
$disp->setPage($urlerror);
$disp->addParam("message", $strInsertError . $error);
$this->setDisplayNext($disp);
} else {
$disp->setPage(urldecode($goto));
if (strlen($setmessage) > 0) {
$strUpdateOk = $setmessage;
}
$this->addParam("recordupdated", "yes");
$disp->addParam("message", $strUpdateOk);
// $disp->addParam("updateid", $uniqid) ; ; PL 20030516 not used could be replace with value of primary key
$disp->addParam("update", "yes");
$this->setDisplayNext($disp);
}
if (!empty($_SERVER['PHP_SELF'])) {
$disp->save("displayUpdateRecord", $_SERVER['PHP_SELF']);
}
$fieldlist = ereg_replace(', $', '', $fieldlist);
$valuelist = ereg_replace(', $', '', $valuelist);
$query = "INSERT INTO `{$table}` ({$fieldlist}) VALUES ({$valuelist})";
}
$this->setLog("\n Running query:\n" . $query);
$message = urlencode($strInsertOk);
$sql_query = $query;
$qSaveData = new sqlQuery($this->dbc);
$result = $qSaveData->query($query);
$uniqid = $qSaveData->getInsertId($table, "id" . $table);
$this->addParam("insertid", $uniqid);
if (!$result) {
$error = $qSaveData->getError();
$this->addParam("recordinserted", "no");
$disp->setPage($urlerror);
$disp->addParam("message", $strInsertError . $error);
} else {
$disp->setPage($goto);
if (strlen($setmessage) > 0) {
$strInsertOk = $setmessage;
}
$this->addParam("recordinserted", "yes");
$disp->addParam("message", $strInsertOk);
$disp->addParam("insertid", $uniqid);
$disp->addParam("updage", "no");
}
$this->setDisplayNext($disp);
}
if (!empty($_SERVER['PHP_SELF'])) {
$disp->save("displayAddRecord", $_SERVER['PHP_SELF']);
session_unregister("manageData");
$globalevents[displayTableOrder] = 0;
$globalevents[manageData] = 0;
session_register("globalevents");
if ($doSave != "no") {
$infoDisplay = new Display();
$infoDisplay->addParam("mydb_num", $mydb_num);
if ($displaytype == "form") {
$infoDisplay->addParam("goto", $gotonext);
// $infoDisplay->addParam("toto", "toto") ;
if (strlen($empty) > 0) {
$infoDisplay->addParam("empty", $empty);
} else {
if (strlen($table) > 0) {
$infoDisplay->addParam("table", $table);
$infoDisplay->addParam("id" . $table, ${"id" . $table});
}
}
$goto = "displayform.php";
}
if (strlen($goto) > 0) {
$infoDisplay->setPage($goto);
$this->setDisplayNext($infoDisplay);
$infoDisplay->save("infoDisplay", basename($goto));
} else {
$infoDisplay->setPage("displayreport.php");
$this->setDisplayNext($infoDisplay);
$infoDisplay->save("infoDisplay", "displayreport.php");
}
}
//echo $this->getUrlNext() ;
