本文介绍了PHP从数组插入mysql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想弄清楚如何遍历发布的表单数据并插入到mysql。我的数据库表包含两列名称和年龄
I'm having a heck of a time trying to figure out how to loop through my posted form data and inserting to mysql. My database table contains two columns "name" and "age"
我的表单:
<form action="form.php" method="post">
<input type="text" name="data[][name]" value=""/>
<input type="text" name="data[][age]" value=""/>
<input type="text" name="data[][name]" value=""/>
<input type="text" name="data[][age]" value=""/>
<input type="text" name="data[][name]" value=""/>
<input type="text" name="data[][age]" value=""/>
<input type="text" name="data[][name]" value=""/>
<input type="text" name="data[][age]" value=""/>
<input type="text" name="data[][name]" value=""/>
<input type="text" name="data[][age]" value=""/>
<input type="text" name="data[][name]" value=""/>
<input type="text" name="data[][age]" value=""/>
<input type="submit" value="submit" name="submit" />
</form>
PHP:
<?php
// Create Mysqli object
$db = new mysqli('localhost', 'root', 'root', 'database');
// Create statement object
$stmt = $db->stmt_init();
if (isset($_POST['submit'])) {
// Create a prepared statement
if($stmt->prepare("INSERT INTO contact (name, age) VALUES (?, ?)")) {
// Bind your variables to replace the ?s
$stmt->bind_param('si', $name, $age);
$returnedData = $_POST['data'];
foreach($returnedData as $data) {
$name = $data['name'];
$age = $data['age'];
$stmt->execute();
}
// Close statement object
$stmt->close();
}
}
// Close Connection
mysqli_close($link);
?>
推荐答案
当前,您的表单返回此数组-
Currently your form returns this array -
$_POST['data'] = array(
0 => array('name'=> 'string'),
1 => array('age'=> #),
2 => array('name'=> 'string'),
3 => array('age'=> #),
4 => array('name'=> 'string'),
5 => array('age'=> #),
6 => array('name'=> 'string'),
7 => array('age'=> #),
8 => array('name'=> 'string'),
9 => array('age'=> #),
10 => array('name'=> 'string'),
11 => array('age'=> #);
您要么想要重做表单,以给姓名/年龄相同的密钥-
So you either want to redo your form to give the name/age the same key-
<form action="form.php" method="post">
<input type="text" name="data[0][name]" value=""/>
<input type="text" name="data[0][age]" value=""/>
<input type="text" name="data[1][name]" value=""/>
<input type="text" name="data[1][age]" value=""/>
<input type="text" name="data[2][name]" value=""/>
<input type="text" name="data[2][age]" value=""/>
<input type="text" name="data[3][name]" value=""/>
<input type="text" name="data[3][age]" value=""/>
<input type="text" name="data[4][name]" value=""/>
<input type="text" name="data[4][age]" value=""/>
<input type="text" name="data[5][name]" value=""/>
<input type="text" name="data[5][age]" value=""/>
<input type="submit" value="submit" name="submit" />
</form>
-OR-
更改foreach循环-
change your foreach loop -
$returnedData = $_POST['data'];
for($i=0;$i<count($returnedData);$i+=2){
$name = $returnedData[$i]['name'];
$age = $returnedData[$i+1]['age'];
$stmt->execute();
}
这篇关于PHP从数组插入mysql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!