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; }