如何通过foreach循环实现数据库插入操作？
- 内容介绍
- 文章标签
- 相关推荐
本文共计144个文字，预计阅读时间需要1分钟。
php通过Foreach循环插入数据，并使用LEFT JOIN连接表，然后按时间降序排序，结果如下：insertByForeach.php + alias('a') - join('__USER__ + ac', 'a.openid=ac.openid', 'left') - field('a.*, ac.*, a.id as idd') - order('a.time', 'desc') - select();foreach($list as $key=> $v) { $cwhere['a.payid']=$list[$key]['id']; $comment=Db::name('l');}
alias('a') ->join('__USER__ ac', 'a.openid = ac.openid', "left") ->field('a.*,ac.*,a.id as idd') ->order('a.time', 'desc') ->select(); foreach($list as $key=>$v){ $cwhere['a.payid'] = $list[$key]['id']; $comment = Db::name('lun')->alias('a')->join('__USER__ ac', 'a.openid = ac.openid', "left")->field('a.*,ac.*')->where($cwhere)->order('time desc')->select(); $list[$key]['comment'] = $comment; }
本文共计144个文字，预计阅读时间需要1分钟。
php通过Foreach循环插入数据，并使用LEFT JOIN连接表，然后按时间降序排序，结果如下：insertByForeach.php + alias('a') - join('__USER__ + ac', 'a.openid=ac.openid', 'left') - field('a.*, ac.*, a.id as idd') - order('a.time', 'desc') - select();foreach($list as $key=> $v) { $cwhere['a.payid']=$list[$key]['id']; $comment=Db::name('l');}
alias('a') ->join('__USER__ ac', 'a.openid = ac.openid', "left") ->field('a.*,ac.*,a.id as idd') ->order('a.time', 'desc') ->select(); foreach($list as $key=>$v){ $cwhere['a.payid'] = $list[$key]['id']; $comment = Db::name('lun')->alias('a')->join('__USER__ ac', 'a.openid = ac.openid', "left")->field('a.*,ac.*')->where($cwhere)->order('time desc')->select(); $list[$key]['comment'] = $comment; }