function dbmanagement_simple($table, $key, &$keyvalue, &$mode, $process, $vals)
{
global $sql_debug;
if ($process == 'delete') {
// Delete the record from table
dbs::delrecord($table, $key, $keyvalue);
$mesg = DELETED;
$mode = 'preview';
} elseif ($process == 'add' || $process == 'edit') {
// generate table column field names
$cols = dbs::genfieldnames($table, '0');
if (!empty($keyvalue)) {
/*
this is an existing record
adjust the columns and values parts of the replace sql statement
*/
$cols = "`" . $key . "`, " . $cols;
$vals = "'" . $keyvalue . "', " . $vals;
$request = "REPLACE";
} else {
// this is a new record so set the insert sql statement
$request = "INSERT";
}
// run the sql for the live database
echo $cols;
echo $vals;
dbs::irrecord($request, $table, $cols, $vals);
$mesg = SAVED;
// get the primary key for the previously inserted record
if (empty($keyvalue)) {
$row = dbs::getlast();
$keyvalue = $row[0];
}
// set return mode
$mode = "edit";
}
return $mesg;
}
function irrecordArray($table, $valsarray, $showkey)
{
if ($table && sizeof($valsarray)) {
$vals = '';
//Generate column names
$cols = dbs::genfieldnames($table, $showkey);
$cols = preg_replace('/`|\\s/', '', $cols);
//Break up into an array
$keyarray = arrays::array_explode($cols, ",");
//$valsarray_size = sizeof($valsarray);
$valsarray_size = sizeof($keyarray);
$sql = "INSERT INTO `{$table}` (" . $cols . ") VALUES";
for ($valueIndex = 0; $valueIndex < sizeof($valsarray); $valueIndex++) {
$vals = '';
for ($index = 0; $index < $valsarray_size; $index++) {
if ($index != 0) {
$vals .= ",";
}
$vals .= "'" . $valsarray[$valueIndex][$keyarray[$index]] . "'";
}
if ($valueIndex != sizeof($valsarray) - 1) {
$sql .= "(" . $vals . "),";
} else {
$sql .= "(" . $vals . ")";
}
}
debug::message($sql . '<br><br>');
$result = mysql_query($sql) or die("Couldna execute record insert/replace - " . mysql_errno() . ": " . mysql_error());
return mysql_insert_id();
}
return false;
}
