数组文件操作 本帖最后由 lazygc520 于 2013-09-05 13:13:44 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我用foreach来遍历2个2维数组,就例中而言,数组b存在: 'cust_no' => '310F6 1VA5A', 'lotno' => '2X15'数组a也存在: 'cust_no' => '310F6 1VA5A', 'lotno' => '2X15'。因为对应的cust_no和lotno键值都相等,所以进行update操作。 foreach ($a as $a1) { foreach ($b as $b1) { if $a1['cust_no'] == $b1['cust_no'] && $a1['lotno'] == $b1['lotno'] { ...你都四角了,我感觉你这帖子是在开玩笑吧? $a = array ( 0 => array ( 'cust_no' => '310F6 1VA5A', 'lotno' => '2X15', 'count' => '0', ), 1 => array ( 'cust_no' => '310F6 1VA5A', 'lotno' => '2Z15', 'count' => '16', ),); $b = array ( 0 => array ( 'cust_no' => '310F6 1VA5A', 'lotno' => '2X15', 'count' => '0', ), 1 => array ( 'cust_no' => '310F6 1VA5A', 'lotno' => '2Z15', 'count' => '32', ), 2 => array ( 'cust_no' => '310F6 1VA5A', 'lotno' => '3528', 'count' => '80', ),);foreach($b as $i=>$v) { print_r($v); if(isset($a[$i]) && count(array_intersect_assoc($v, $a[$i])) == count($v)) { echo "update table sql\n"; }else echo "insert table sql\n";}Array( [cust_no] => 310F6 1VA5A [lotno] => 2X15 [count] => 0)update table sqlArray( [cust_no] => 310F6 1VA5A [lotno] => 2Z15 [count] => 32)insert table sqlArray( [cust_no] => 310F6 1VA5A [lotno] => 3528 [count] => 80)insert table sql 可能我表述不清,结果不是这样的。foreach($bb as $cc) { foreach($tt as $tts) { if(($tts['cust_no'] == $cc['cust_no'])&&($tts['lotno'] == $cc['lotno'])) { $sql = "update `".$o."` set count = '".$tts['count']."' where cust_no = '".$tts['cust_no']."' and lotno = '".$tts['lotno']."'"; echo $sql.'<br />'; } else { $sql2 = "insert into `".$o."`(cust_no,lotno,count) values ('".$tts['cust_no']."','".$tts['lotno']."','".$tts['count']."')"; echo $sql2.'<br />'; } } }//结果是这样的:update `kw_mount` set count = '0' where cust_no = '310F6 1VA5A' and lotno = '2X15'insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','2Z15','32')insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','3528','80')insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','2X15','0')update `kw_mount` set count = '32' where cust_no = '310F6 1VA5A' and lotno = '2Z15'insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','3528','80')//而我想得到的结果是update `kw_mount` set count = '0' where cust_no = '310F6 1VA5A' and lotno = '2X15'update `kw_mount` set count = '32' where cust_no = '310F6 1VA5A' and lotno = '2Z15'insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','3528','80')这样要怎么求? Array( [cust_no] => 310F6 1VA5A [lotno] => 2X15 [count] => 0)update table sqlArray( [cust_no] => 310F6 1VA5A [lotno] => 2Z15 [count] => 32)insert table sql //这里要变成update table sql,因为cust_no和lotno都相同Array( [cust_no] => 310F6 1VA5A [lotno] => 3528 [count] => 80)insert table sql 要什么条件自己改foreach($b as $i=>$v) { print_r($v); if(isset($a[$i]) && $v['cust_no'] == $a[$i]['cust_no'] && $v['lotno'] == $a[$i]['lotno']) { echo "update table sql\n"; }else echo "insert table sql\n";} 用smarty的一个关于登录的问题,纠结、、、 Zend 推出新开发套件 PHP码农也能开发iOS应用 soap传参,参数传不过去 PHP程序在nginx下面不允许生成和删除目录,怎么改? 帮忙把这个绝对路径改成相对路径 通过PDO连接ORACLE出现错误,请路过的帮忙解答 PHP 通过数据库进行模糊查询 求助.用discuz的cookie共享问题 谁有支持gif的gd库的源代码包请给我发一份... MYSQL中的删除语句???? 织梦中如何实现不用日历表查询数据不用点击提交按钮就有数据查询出来....求思路! php页面显示内容后延时跳转
数组a也存在: 'cust_no' => '310F6 1VA5A', 'lotno' => '2X15'。因为对应的cust_no和lotno键值都相等,所以进行update操作。
foreach ($b as $b1) {
if $a1['cust_no'] == $b1['cust_no'] && $a1['lotno'] == $b1['lotno'] {
...你都四角了,我感觉你这帖子是在开玩笑吧?
0 =>
array (
'cust_no' => '310F6 1VA5A',
'lotno' => '2X15',
'count' => '0',
),
1 =>
array (
'cust_no' => '310F6 1VA5A',
'lotno' => '2Z15',
'count' => '16',
),
);
$b = array (
0 =>
array (
'cust_no' => '310F6 1VA5A',
'lotno' => '2X15',
'count' => '0',
),
1 =>
array (
'cust_no' => '310F6 1VA5A',
'lotno' => '2Z15',
'count' => '32',
),
2 =>
array (
'cust_no' => '310F6 1VA5A',
'lotno' => '3528',
'count' => '80',
),
);
foreach($b as $i=>$v) {
print_r($v);
if(isset($a[$i]) && count(array_intersect_assoc($v, $a[$i])) == count($v)) {
echo "update table sql\n";
}else echo "insert table sql\n";
}Array
(
[cust_no] => 310F6 1VA5A
[lotno] => 2X15
[count] => 0
)
update table sql
Array
(
[cust_no] => 310F6 1VA5A
[lotno] => 2Z15
[count] => 32
)
insert table sql
Array
(
[cust_no] => 310F6 1VA5A
[lotno] => 3528
[count] => 80
)
insert table sql
{
foreach($tt as $tts)
{
if(($tts['cust_no'] == $cc['cust_no'])&&($tts['lotno'] == $cc['lotno']))
{
$sql = "update `".$o."` set count = '".$tts['count']."' where cust_no = '".$tts['cust_no']."' and lotno = '".$tts['lotno']."'";
echo $sql.'<br />';
}
else
{
$sql2 = "insert into `".$o."`(cust_no,lotno,count) values ('".$tts['cust_no']."','".$tts['lotno']."','".$tts['count']."')";
echo $sql2.'<br />';
}
}
}//结果是这样的:
update `kw_mount` set count = '0' where cust_no = '310F6 1VA5A' and lotno = '2X15'
insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','2Z15','32')
insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','3528','80')
insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','2X15','0')
update `kw_mount` set count = '32' where cust_no = '310F6 1VA5A' and lotno = '2Z15'
insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','3528','80')//而我想得到的结果是
update `kw_mount` set count = '0' where cust_no = '310F6 1VA5A' and lotno = '2X15'
update `kw_mount` set count = '32' where cust_no = '310F6 1VA5A' and lotno = '2Z15'
insert into `kw_mount`(cust_no,lotno,count) values ('310F6 1VA5A','3528','80')
这样要怎么求?
(
[cust_no] => 310F6 1VA5A
[lotno] => 2X15
[count] => 0
)
update table sql
Array
(
[cust_no] => 310F6 1VA5A
[lotno] => 2Z15
[count] => 32
)
insert table sql //这里要变成update table sql,因为cust_no和lotno都相同
Array
(
[cust_no] => 310F6 1VA5A
[lotno] => 3528
[count] => 80
)
insert table sql
print_r($v);
if(isset($a[$i]) && $v['cust_no'] == $a[$i]['cust_no'] && $v['lotno'] == $a[$i]['lotno']) {
echo "update table sql\n";
}else echo "insert table sql\n";
}