function MySQL_associativesingleton($query)
{
$r = _MySQL_queryhelper($query);
$arr = array();
while ($r->hasRows()) {
$tmp = $r->getRow();
if (count($tmp) != 2) {
die("Incorrect result quantity in associative singleton query!");
}
$arr[$tmp[0]] = $tmp[1];
}
return $arr;
}
<?php
/* $Id: delete.php,v 1.2 2003/06/22 23:07:07 robbat2 Exp $ */
/* $Source: /code/convert/cvsroot/infrastructure/rats/delete.php,v $ */
include './header.inc.php';
$perm = v('perm', 'del');
include 'lib/commontable.inc.php';
if ($tablePerm[$perm]) {
$idDel = v('id');
$tableDel = v('table');
$query = 'DELETE FROM ' . $tableName . ' WHERE ' . $tableData[$tableName]['_idkey'] . '=' . MySQL_quote($idDel);
echo $query;
$m = _MySQL_queryhelper($query);
$m->checkerror();
$_SESSION['msg'] = 'Item deleted from ' . $tableName;
if (!dodbg()) {
httpredirect('view.php?table=' . $tableName);
}
}
/* vim: set ft=php expandtab shiftwidth=4 softtabstop=4 tabstop=4: */
echo "<br />\nEnd of Data<br />\n";
}
foreach ($tableData[$tableName] as $kv => $val) {
if ($kv[0] != '_' && $val['datatype'] == 'DATETIME') {
if (dodbg(3)) {
echo 'Squashing date for ' . $kv . "<br />\n";
}
$tmp = $data[$kv];
$data[$kv] = squashDateArray($tmp);
}
}
$query = str_replace('__VALUES__', MySQL_arrayToSequence($data, TRUE, TRUE, $tableData[$tableName]['_view_cols']), $query);
if (dodbg()) {
echo $query;
}
$res = _MySQL_queryhelper($query);
if ($perm = 'add') {
$_SESSION['msg'] = 'Item added to ' . $tableName;
} else {
$_SESSION['msg'] = 'Item edited in ' . $tableName;
}
if (!dodbg()) {
httpredirect('view.php?table=' . $tableName);
} else {
echo 'MSG: ' . $_SESSION['msg'] . "<br />\n";
}
// TODO
} else {
echo __FILE__ . ' permission denied';
}
/* vim: set ft=php expandtab shiftwidth=4 softtabstop=4 tabstop=4: */
