回答編集履歴
2
追記
test
CHANGED
|
@@ -7,3 +7,9 @@
|
|
|
7
7
|
$stmt = $pdo->prepare($sql);
|
|
8
8
|
$stmt->execute($names);
|
|
9
9
|
```
|
|
10
|
+
|
|
11
|
+
# 参考
|
|
12
|
+
```SQL
|
|
13
|
+
create table tbl(id int primary key auto_increment ,name varchar(10));
|
|
14
|
+
insert into tbl(name) values ('aaa'),('bbb'),('ccc');
|
|
15
|
+
```
|
1
調整
test
CHANGED
|
@@ -1 +1,9 @@
|
|
|
1
1
|
バルクで流し込むときは名前付きprepare処理ではなく疑問符式ににしたほうが楽でしょう
|
|
2
|
+
|
|
3
|
+
```PHP
|
|
4
|
+
$names=["一森 純","飯倉 大樹","白坂 楓馬","オビ パウエル オビンナ","永戸 勝也","畠中 槙之輔"];
|
|
5
|
+
$sql="INSERT INTO players (name) VALUES";
|
|
6
|
+
$sql.=implode(",",array_fill(0,count($names),"(?)"));
|
|
7
|
+
$stmt = $pdo->prepare($sql);
|
|
8
|
+
$stmt->execute($names);
|
|
9
|
+
```
|