All pastes #945166 Raw Edit

Scotepi

public text v1 · immutable
·published 2008-03-16 19:04 UTC
rendered paste body
function 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;
}