Home >Backend Development >PHP Tutorial >【4个数组同时写到数据库如何写?】

【4个数组同时写到数据库如何写?】

WBOY
WBOYOriginal
2016-06-13 12:01:181109browse

【4个数组同时写到数据库怎么写?】
$_POST['a']       值为1,2,3,4,5
$_POST['b']       值为a,b,c,d,e
$_POST['c']       值为男,女,女,男,男
$_POST['d']       值为25,26,27,26,26


这四个数组同时是从里接收过来的。现在我要把它们都写入到数据库里,循环应该怎么写?

最后写到数据库的格式应该是
               编号 姓名   性别 年龄
第一条:1       a         男     25
第二条:2       b         女     26
第三条:3       c         女     27
第四条:4       d         男     26
第五条:5       e         男     26
------解决方案--------------------

<br />$_POST['a'] = '1,2,3,4,5';<br />$_POST['b'] = "a,b,c,d,e";<br />$_POST['c'] = "男,女,女,男,男";<br />$_POST['d'] = "25,26,27,26,26";<br /><br />$a = explode(',', $_POST['a']);<br />$b = explode(',', $_POST['b']);<br />$c = explode(',', $_POST['c']);<br />$d = explode(',', $_POST['d']);<br /><br /><br />foreach($a as $key=>$value){<br />    $sql = "inser into tbl_name values('$value', '{$b[$key]}', '{$c[$key]}', '{$d[$key]}');";<br />    //mysql_query($sql);<br />    echo $sql, PHP_EOL;<br /><br />

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn