rendered paste bodyfunction insert($table, $arr, $where=null) {
if (is_array($where)) {
foreach ($arr as $key=>$val) {
$val = str_replace("'", "\'", $val);
$val = str_replace("\\\\", "\\", $val);
$set .= "`$key` = '$val', ";
}
foreach ($where as $key=>$val) {}
$sql = "UPDATE `$table` SET " . substr($set, 0, -2) . " WHERE `$table`.`$key` = '$val';";
}
else {
foreach ($arr as $key=>$val) {
if (is_array($val)) {
foreach ($val as $ke=>$v) {
if (!$keys) {
$k .= "`$ke`, ";
}
}
} else {
$val = str_replace("'", "\'", $val);
$val = str_replace("\\\\", "\\", $val);
$keys .= "`$key`, ";
$vals .= "'$val', ";
}
}
$sql = "INSERT IGNORE INTO `$table` (" . substr($keys, 0, -2) . ") VALUES (" . substr($vals, 0, -2) . ");";
}
$ret = $this->query($sql);
return $ret;
}