方法一
添加页面
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<center>
<body>
<form action="add.php" method="post">
<table>
<tr>
<td>user1</td>
<td><input type="text" name="user[]"></input></td>
</tr>
<tr>
<td>pwd1</td>
<td><input type="text" name="age[]"></input></td>
</tr>
<tr>
<td>user2</td>
<td><input type="text" name="user[]"></input></td>
</tr>
<tr>
<td>pwd2</td>
<td><input type="text" name="age[]"></input></td>
</tr>
<tr>
<td><input type="submit"></td>
<td></td>
</tr>
</table>
</form>
</body>
</center>
</html>
后台处理入库
<?php
header('content-type:text/html; charset=utf8');
$a=array();
$a['user']=$_POST['user'];
$a['age']=$_POST['age'];
$new = [];
foreach ($a as $k => $v) {
foreach ($v as $key => $val) {
$new[$key][$k]=$val;
}
}
print_r($new);
echo "<hr>";
$data=[];
foreach ($new as $k => $v) {
$data[]="('".implode("','",$v)."')";
}
print_r($data);
$pdo = new PDO('mysql:host=127.0.0.1;dbname=test','root','root');
if($pdo->exec("insert into user(`name`,`age`) values".implode(',',$data))){
echo "入库成功";
}
方法二
以都好分割入库
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<center>
<body>
<form action="add.php" method="post">
<table>
<tr>
<td>user1</td>
<td><input type="text" name="user"></input></td>
</tr>
<tr>
<td>pwd1</td>
<td><input type="text" name="age"></input></td>
</tr>
<tr>
<td><input type="submit"></td>
<td></td>
</tr>
</table>
</form>
</body>
</center>
</html>
后台处理
<?php
header('content-type:text/html; charset=utf8');
print_r($_POST);
$data['user']=$_POST['user'];
$data['age']=$_POST['age'];
print_r($data);
$a=[];
foreach ($data as $key => $val) {
$a[]=explode(',',$val);
}
p($a);
$new=[];
foreach ($a as $k => $v) {
foreach ($v as $key => $val) {
$new[$key][$k]=$val;
}
}
print_r($new);
$data=[];
foreach ($new as $k => $v) {
$data[]="('".implode("','",$v)."')";
}
print_r($data);
$pdo = new PDO('mysql:host=127.0.0.1;dbname=test','root','root');
if($pdo->exec("insert into user(`name`,`age`) values".implode(',',$data))){
echo "chengg";
}