php - WordPress $wpdb。插入多条记录

Question

有没有办法在 Wordpress 中使用 $wpdb->insert 或

完成以下操作

$wpdb->query($wpdb->prepare)):

INSERT into TABLE (column1, column2, column3) 
VALUES
('value1', 'value2', 'value3'),
('otherval1', 'otherval2', 'otherval3'),
('anotherval1', 'anotherval2', 'anotherval3')

...等

Answer 1

好的，我想通了!

为实际值和占位符设置数组

$values = array();
$place_holders = array();

初始查询:

$query = "INSERT INTO orders (order_id, product_id, quantity) VALUES ";

然后循环遍历您要添加的值，并将它们插入到适当的数组中:

foreach ( $_POST as $key => $value ) {
     array_push( $values, $value, $order_id );
     $place_holders[] = "('%d', '%d')" /* In my case, i know they will always be integers */
}

然后将这些位添加到初始查询中:

$query .= implode( ', ', $place_holders );
$wpdb->query( $wpdb->prepare( "$query ", $values ) );