求php多数组组合写入数据库方法 本帖最后由 wjm_hi 于 2013-10-25 15:55:24 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 php多循环,然后将数据下标循环最后写入数据库,PHP基础差,请求大侠们帮忙 <?php$xk=Array ("1","2");$nj=Array ("1","2","3");$bj=Array ("1","2","3","4","5","6","7");$xk=count($xk);$nj=count($nj);$bj=count($bj);$test="$xk*$nj*$bj";echo $test;exit;?> 我是要生成INSERT INTO语句该怎么写呢 INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES ($nj ,$bj ,$xk),VALUES 后面要插入$xk*$nj*$bj这么多条,该怎么弄呢 写个笨方法。$xk=Array ("1","2");$nj=Array ("1","2","3");$bj=Array ("1","2","3","4","5","6","7");$arr = array();for($i=0;$i<count($xk);$i++){ for($j=0;$j<count($nj);$j++){ for($k=0;$k<count($bj);$k++){ $arr[] = array($xk[$i],$nj[$j],$bj[$k]); } }}foreach($arr as $row){ //插入数据} 这个有这么复杂嘛,用FOR可以做吗for($i=0;$i<count($bj);$i++){echo $bj;} $xk=Array ("1","2");$nj=Array ("1","2","3");$bj=Array ("1","2","3","4","5","6","7");$arr = array();for($i=0;$i<count($xk);$i++){ for($j=0;$j<count($nj);$j++){ for($k=0;$k<count($bj);$k++){ $arr[] = array($xk[$i],$nj[$j],$bj[$k]); } }}foreach($arr as $row){ //插入数据} 这个好像可行,foreach里面插入数据该怎么写SQL语句呢 能不能把 //插入数据 echo一下调用方法。 我要的就是这个效果,我要将INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES ($nj ,$bj ,$xk)放到//插入数据的位置,我该怎么写呢。 $xk=Array ("1","2");$nj=Array ("1","2","3");$bj=Array ("1","2","3","4","5","6","7");$arr = array();for($i=0;$i<count($xk);$i++){ for($j=0;$j<count($nj);$j++){ for($k=0;$k<count($bj);$k++){ $arr[] = array($xk[$i],$nj[$j],$bj[$k]); } }}foreach($arr as $row){ $sql = "INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES ('".$row[0]."' ,'".$row[1]."','".$row[2]."')";} 非常感谢,但这SQL语句能做点优化最好了,INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES ($nj ,$bj ,$xk)一直是这句在循环,如果做成INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES (1 ,1 ,1),(1 ,1 ,2),(1 ,1 ,3)这样的SQL语句的话就完美了。 求教 htmlentities过滤问题 图片居中 请问如何将数据库,转换为带分页的静态html 如何获取请求服务器的IP 帮忙看看:为什么vbscript不能使用this对象 求高手解决下面的问题 PHP支持的FTP函数ftp_connect()吗? 请教高手们! magent做memcached集群问题求教 高分在线求助XML解析 zen cart中一条语句的用法
$xk=Array ("1","2");
$nj=Array ("1","2","3");
$bj=Array ("1","2","3","4","5","6","7");
$xk=count($xk);
$nj=count($nj);
$bj=count($bj);
$test="$xk*$nj*$bj";
echo $test;
exit;
?>
我是要生成INSERT INTO语句该怎么写呢
INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES ($nj ,$bj ,$xk),VALUES 后面要插入$xk*$nj*$bj这么多条,该怎么弄呢
$xk=Array ("1","2");
$nj=Array ("1","2","3");
$bj=Array ("1","2","3","4","5","6","7");
$arr = array();
for($i=0;$i<count($xk);$i++){
for($j=0;$j<count($nj);$j++){
for($k=0;$k<count($bj);$k++){
$arr[] = array($xk[$i],$nj[$j],$bj[$k]);
}
}
}
foreach($arr as $row){
//插入数据
}
$nj=Array ("1","2","3");
$bj=Array ("1","2","3","4","5","6","7");
$arr = array();
for($i=0;$i<count($xk);$i++){
for($j=0;$j<count($nj);$j++){
for($k=0;$k<count($bj);$k++){
$arr[] = array($xk[$i],$nj[$j],$bj[$k]);
}
}
}
foreach($arr as $row){
//插入数据
}
这个好像可行,foreach里面插入数据该怎么写SQL语句呢
我要的就是这个效果,我要将INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES ($nj ,$bj ,$xk)放到//插入数据的位置,我该怎么写呢。
$nj=Array ("1","2","3");
$bj=Array ("1","2","3","4","5","6","7");
$arr = array();
for($i=0;$i<count($xk);$i++){
for($j=0;$j<count($nj);$j++){
for($k=0;$k<count($bj);$k++){
$arr[] = array($xk[$i],$nj[$j],$bj[$k]);
}
}
}
foreach($arr as $row){
$sql = "INSERT INTO `examinfo` (`nj`,`bj`,`xk`) VALUES ('".$row[0]."' ,'".$row[1]."','".$row[2]."')";
}