Как разместить массив в MySQL

Петля над первым подмассивом и сохраните индекс $i для доступа ко второму:

 $stmt = $pdo->prepare("INSERT INTO things (date,amount) VALUES (?,?)"); foreach ($array["date"] as $i=>$_ignore) { $stmt->execute( array($array["date"][$i], $array["amount"][$i]) ); } 

Попробуй это:

 <?php $arr = $_POST['payment']; $insert = array(); foreach($arr['date'] as $key => $date){ $date = mysql_real_escape_string($date); $amount = (int)$arr['amount'][$key]; $insert[] = "('$date', $amount)"; } mysql_query("INSERT INTO table(date, amount) VALUES " . implode(",", $insert)); 

Вот версия mysqli (непроверенная, и я никогда не использую mysqli, но должен работать, я считаю)

 // the sql statement for the insert $sql = 'INSERT INTO yourTable ( `id`, `date`, `amount` ) VALUES( null, ?, ? )'; // prepare the query for binding to the placeholders later on $stmt = $mysqli->prepare( $sql ); // bind some variables to the placeholders $stmt->bind_param( 'si', $date, $amount ); // loop through all date values foreach( $yourArray[ 'date' ] as $key => $value ) ) { // check if there is an equivalent index in $yourArray[ 'amount' ] // change to isset if you want to guard againt null values if( !array_key_exists( $key, $yourArray[ 'amount' ] ) ) { // throw an exception of perhaps use some other form of error throw new Exception( 'missing parameter' ); } // give the previously bound variables values for this query execution $date = $yourArray[ 'date' ][ $key ]; $amount = $yourArray[ 'amount' ][ $key ]; // execute it! $stmt->execute(); } 

 function mysql_insert_array($into, $columns, $array){ $column = explode(",", $columns); foreach($column as $c){ $c = $post[$c]; $v .= "'$c',"; } $v = trim($v, ","); $query = ("INSERT INTO $into($columns) VALUES($v)"); mysql_query($query); return mysql_insert_id(); } $post["username"] = "Little Bobby Tables"; $post["password"] = "x' OR 1 = 1"; mysql_insert_array("users", "username,password", $post) 

edit: О, 2D-массив, с этим не работает.