如何从数组中打印特定值？

i want to print first value of id 219 is mentioned in the screenshot for case:downloadl then i need to print 2nd value id=219 for case :downloadp.but,the array $value['printp'] getting both the values into the table(ex:Select usera Select userb). but i need to print only one and first value for this $value['printp'].

case 'downloadl':


$sql = "SELECT post_id,printprocess,printsupply,printesb,printwork,printpri,printmate FROM printtable WHERE post_id=" .$post_id;

        $query = $db->sql_query($sql);
        $print_data = array();
        while($roww = mysqli_fetch_array($query)){

                 $print_data[] = array(
                 'printp'   =>  $roww['printprocess'],
                 'prints'   =>  $roww['printsupply'],
                 'printsb'  =>  $roww['printesb'],
                 'printwrk' =>  $roww['printwork'],
                 'printpr'  =>  $roww['printpri'],
                 'printmat' =>  $roww['printmate'],
                 );
        }

              foreach($print_data as $value) {

                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$j, '');
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, '');
                    $j++;
                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$j, 'Printing Process');
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printp']);
                    $j++;
                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$j, 'Supplier');
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['prints']);
                    $j++;
                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$j, 'Espon Sub');
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printsb']);
                    $j++;
                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$j, 'WorkFlow ID');
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printpr']);
                    $j++;
                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$j, 'Printer');
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printwrk']);
                    $j++;
                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$j, 'Printing Material');
                    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printmat']);
                    $i++;
                    $j++;
                }
 break;
              case:downloadp:

            foreach($print_data as $value) {

                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A'.$j, '');
                            $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, '');
                            $j++;
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A'.$j, 'Printing Process');
                            $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printp']);
                            $j++;
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A'.$j, 'Supplier');
                            $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['prints']);
                            $j++;
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A'.$j, 'Espon Sub');
                            $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printsb']);
                            $j++;
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A'.$j, 'WorkFlow ID');
                            $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printpr']);
                            $j++;
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A'.$j, 'Printer');
                            $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printwrk']);
                            $j++;
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A'.$j, 'Printing Material');
                            $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printmat']);
                            $i++;
                            $j++;
                        }
       break;

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

4条回答默认最新

doucuan5365 2017-06-01 10:42

关注

Change your query in the different cases.

switch ($something) {
    case 'downloadl':
        $sql = "SELECT post_id,printprocess,printsupply,printesb,printwork,printpri,printmate FROM printtable WHERE post_id=" .$post_id . " AND printprocess = 'Select UserA'";
        break;
    case 'downloadp':
        $sql = "SELECT post_id,printprocess,printsupply,printesb,printwork,printpri,printmate FROM printtable WHERE post_id=" .$post_id . " AND printprocess = 'Select UserB'";
        break;
}

$query = $db->sql_query($sql);
$print_data = array();
while($roww = mysqli_fetch_array($query)){

    $print_data[] = array(
     'printp'   =>  $roww['printprocess'],
     'prints'   =>  $roww['printsupply'],
     'printsb'  =>  $roww['printesb'],
     'printwrk' =>  $roww['printwork'],
     'printpr'  =>  $roww['printpri'],
     'printmat' =>  $roww['printmate'],
     );
}

foreach($print_data as $value) {

    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$j, '');
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, '');
    $j++;
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$j, 'Printing Process');
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printp']);
    $j++;
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$j, 'Supplier');
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['prints']);
    $j++;
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$j, 'Espon Sub');
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printsb']);
    $j++;
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$j, 'WorkFlow ID');
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printpr']);
    $j++;
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$j, 'Printer');
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printwrk']);
    $j++;
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$j, 'Printing Material');
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $value['printmat']);
    $i++;
    $j++;
}

本回答被题主选为最佳回答 , 对您是否有帮助呢?

查看更多回答(3条)

报告相同问题？

关注问题

如何从数组中删除特定项目？ javascript 有问必答
2022-01-08 15:33

回答 3 已采纳 splice就搞定了 const array = [2, 5, 9]; const index = array.indexOf(5); if (index > -1) { array.s
Java怎么去掉随机数组中的最大值？ java
2022-10-26 23:12

回答 2 已采纳对最大值做一个索引标记，然后数组随机赋值完成后对该标记的数组赋值为零即可 int[] a = new int[10]; int currentMax = 0;//记录
React Hooks中的useState怎么修改数组中的值? javascript react.js 前端框架
2022-02-07 17:01

回答 1 已采纳 setData([{a:1,b:2},{a:2,b:10}]) 或者 const temp = data; temp[2].b = 10; setDa
2021大数据学习之旅 JavaSE·数组&IDEA使用
2021-06-07 11:34

机仔的泪的博客系列文章比较适合非科班的同学, 由浅及深, 循序渐进, 从基础开始走上大数据之路让我们一起努力, 达成目标, 实现理想最后恳请留下你的小❤, 点赞给我一个小小的鼓励吧一、数组的定义和访问 1.1 容器概述案例...
SQL查询 - 如何从数组中获取值？ mysql php
2015-07-11 18:26

回答 2 已采纳 It seems all I needed to do was change this line: AND g.meta_value = '$category' to this: AND
如何使用PHP从数组中获取key的值？ php
2019-02-27 07:43

回答 7 已采纳 $expectedDate = '2019-02-11'; foreach($arr as $key => $val){ if($expectedDate ==$val['week_st
vue 中多个关键字选择，怎么把选中的关键字存到数组中重复被点击的就从数组中删除？？？ javascript vue.js 前端
2017-09-12 06:30

回答 1 已采纳没有必要这样，一般选中会有单独的.class样式，比如.active 你只需要最后返回数组的时候，用jquery去查哪些被选中就可以了，像： var doms = $(".active");
玩转大数据15：常用的分类算法和聚类算法
2023-12-12 18:22

沛哥儿的博客分类算法通常用于预测离散的目标变量（例如，电子邮件是否为垃圾邮件），并产生一个概率模型，该模型可以预测目标变量取特定值的概率。决策树，作为一种简单易用的数据分类算法，在机器学习领域具有广泛的应用。
浮点数怎么存入数组再拿出来计算？ c++ c语言有问必答算法
2022-08-09 22:32

回答 4 已采纳这样啊, 注意数组名不能和a变量重名 float a,b,c,d; cin >> a >> b >> c; float arr[3];
random随机数组，如何执行特定任务？ python
2022-05-18 09:54

回答 2 已采纳
如何在VB.net中获取JSON数组或对象的值？ json php
2016-04-28 04:54

回答 2 已采纳 For C# : JObject jResults = JObject.Parse("JsonString"); String naming = jResults["sensors"]["na
elasticsearch 数组包含查询
2022-09-07 18:00

抓码男孩的博客默认情况下，任何字段都可以包含零个或多个值，当包含多个值时，它就表示array了。但是，数组中的所有值必须具有相同的数据类型(要么同为字符串，要么同为整型，不能数组中一些值为字符串，另一些值为整型)。
数组中找最大值和最小值 java 开发语言
2021-10-16 11:17

回答 1 已采纳 package shuzu; import java.util.Scanner; import java.util.Arrays; public class shuzu { /** * @p
如何在Ruby中使用数组方法
2020-08-11 23:35

cukw6666的博客有时您想从数组中获取随机值，而不是特定值。让我们探讨一下。从数组中获取随机条目 (Getting a Random Entry from an Array) You might be working on a game of chance, or maybe you’re writing a program ...
shell脚本中数组的使用_Shell脚本中的数组
2020-07-07 09:54

cunchi4221的博客 shell脚本中数组的使用Knowing how to work with arrays in shell scripts will help you work with larger datasets in a much efficient manner. But what are arrays and how can you create arrays? Let’s find...
没有解决我的问题, 去提问

悬赏问题

¥20 sub地址DHCP问题
¥15 delta降尺度计算的一些细节，有偿
¥15 Arduino红外遥控代码有问题
¥15 数值计算离散正交多项式
¥30 数值计算均差系数编程
¥15 redis-full-check比较两个集群的数据出错
¥15 Matlab编程问题
¥15 训练的多模态特征融合模型准确度很低怎么办
¥15 kylin启动报错log4j类冲突
¥15 超声波模块测距控制点灯，灯的闪烁很不稳定，经过调试发现测的距离偏大

码龄粉丝数原力等级 --

如何从数组中打印特定值？

4条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

如何从数组中打印特定值？

4条回答 默认 最新

悬赏问题

4条回答默认最新