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