All pastes #956403 Raw Edit

Scotepi

public php v1 · immutable
#956403 ·published 2008-03-25 07:47 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;}