深圳全飞鸿

标题: mysqli_next_result会导致死循环 [打印本页]
作者: zhgc    时间: 2019-12-23 16:43
标题: mysqli_next_result会导致死循环
以前的方法：
while( !mysqli_next_result( $db ) )
{
        $result = mysqli_store_result( $db );
        mysqli_free_result($result);
}

改为
do
{
    if ($result=mysqli_store_result($db))
    {
            mysqli_free_result($result);
    }
} while (mysqli_next_result($db));


作者: zhgc    时间: 2019-12-23 16:44
首次用于安徽看板

  1. <?php

  3. error_reporting(0);
  4. //$agile_include_path = dirname(__FILE__) . '/../php/';
  5. //set_include_path(get_include_path() . PATH_SEPARATOR . $agile_include_path);
  6. //require_once('agilelib.php');
  7. //date_default_timezone_set('America/Los_Angeles');
  8. require_once(dirname(__FILE__) . '/../php/kb_config.inc.php');
  9. $kbconf=new kb_config();
  10. ?>

  12. <html>
  13. <head>
  14.   <meta http-equiv=Content-Type content=text/html;charset=utf8>
  15.   <meta name="viewport" content="width=device-width,initial-scale=1.0,user-scalable=yes" />
  16. </head>
  17. <style type="text/css">
  18. body {
  19. margin:0.5%;
  20. font-size:150%;
  21. font: normal 100% Helvetica, Arial, sans-serif;
  22. color:black;
  23. background-color: white
  24. }
  25. h1 {
  26. font-size: 1.5em;
  27. }
  28. small {
  29. font-size: 0.875em;
  30. }
  31. table.gridtable {
  32.         font-family: verdana,arial,sans-serif;
  33.         font-size:18px;
  34.         border-width: 1px;
  35.         border-color: #666666;
  36.         border-collapse: collapse;
  37. }
  38. table.gridtable th {
  39.         border-width: 1px;
  40.         padding: 8px;
  41.         border-style: solid;
  42.         border-color: #666666;
  43. }
  44. table.gridtable td {
  45.         border-width: 1px;
  46.         padding: 8px;
  47.         border-style: solid;
  48.         border-color: #666666;
  49. }
  50. td.tdtitle {
  51.         FONT-WEIGHT: bold;
  52.         text-align:center;
  53.         vertical-align:middle;
  54.         FONT-SIZE: 1.5em;
  55. }
  56. td.tdtext {
  57.         text-align:center;
  58.         vertical-align:middle;
  59. }
  60. </style>
  61. <body>

  63. <?php

  65. $line=$kbconf->line;
  66. /*
  67. */
  68. $param=array(
  69.         // database server
  70.         "db_host"=>$kbconf->database,
  71.         "db_username"=>"report",
  72.         "db_password"=>"report",//"why do you want to crack my password? contact me 13760216621",
  73.         "db_database"=>"sfc",
  74.         "db_charset"=>"UTF8",
  75. );
  76.         $db = mysqli_connect($param["db_host"], $param["db_username"], $param["db_password"]);
  77.         if (!$db) {
  78.                         die("prepare_db: ".mysqli_connect_error());
  79.         }else
  80.         {
  81.         }       
  82. $data=array(
  83.         "line"=>array(
  84.                 "hstd"=>0,  //每小时的标准，班/10得到
  85.                 "day"=>"",
  86.                 "time"=>"",
  87.                 "week"=>"",
  88.                 "data1"=>$line,
  89.                 "data2"=>"未生产",
  90.                 "data3"=>"0",
  91.                 "data4"=>"0",
  92.                 "data5"=>"0",
  93.                 "data6"=>"0",
  94.         ),
  95.         "r102"=>array( //"08:00","09:00","10:00","11:00","13:00","14:00","15:00","16:00","18:00","19:00","20:00"
  96.                 "8"=>array("T"=>"08:00","C3"=>0,"C4"=>0),
  97.                 "9"=>array("T"=>"09:00","C3"=>0,"C4"=>0),
  98.                 "10"=>array("T"=>"10:00","C3"=>0,"C4"=>0),
  99.                 "11"=>array("T"=>"11:00","C3"=>0,"C4"=>0),
  100.                 "13"=>array("T"=>"13:00","C3"=>0,"C4"=>0),
  101.                 "14"=>array("T"=>"14:00","C3"=>0,"C4"=>0),
  102.                 "15"=>array("T"=>"15:00","C3"=>0,"C4"=>0),
  103.                 "16"=>array("T"=>"16:00","C3"=>0,"C4"=>0),
  104.                 "18"=>array("T"=>"18:00","C3"=>0,"C4"=>0),
  105.                 "19"=>array("T"=>"19:00","C3"=>0,"C4"=>0),
  106.         )
  107.    );
  108. $sql="call sfc.KANBAN_01_XCAH('{$line}');";
  109. $result = mysqli_query($db,$sql);  //must have $con parameter
  110. if($row = mysqli_fetch_assoc($result)){
  111.         $data["line"]=$row;
  112.         $data["line"]["hstd"]=$data["line"]["data5"]*1 / 10;
  113.         //echo $data["line"]["hstd"];
  114.         /* Array(
  115.                 [day] => 20191007
  116.                 [time] => 上午 00:00
  117.                 [week] => 星期一
  118.                 [data1] => L6
  119.                 [data2] => IPC019_A01
  120.                 [data3] => 7885
  121.                 [data4] => 4947
  122.                 [data5] => 7885
  123.                 [data6] => 100.00
  124.         )*/
  125. }
  126. mysqli_free_result($result);
  127. //fix by syant
  128. /*while( !mysqli_next_result( $db ) )
  129. {
  130.         $result = mysqli_store_result( $db );
  131.         mysqli_free_result($result);
  132. }*/
  133. do
  134. {
  135.     if ($result=mysqli_store_result($db))
  136.     {
  137.             mysqli_free_result($result);
  138.     }
  139. } while (mysqli_next_result($db));

  141. $sql="select * from sfc.p_tmp600_t order by c1,c2*1";
  142. $result = mysqli_query($db,$sql);  //must have $con parameter
  143. while($row = mysqli_fetch_assoc($result)){
  144.         /*Array(
  145.     [C1] => 20191006
  146.     [C2] => 10
  147.     [C3] => 429
  148.     [C4] => 210
  149.     [C5] =>
  150.     [C6] => )*/
  151.         $hour=$row["C2"]*1;
  152.         if($hour<8){
  153.                 //夜班的不做处理.   
  154.         }else if($hour==12){
  155.                 $data["r102"]["11"]["C3"]=$data["r102"]["11"]["C3"]*1+$row["C3"]*1;
  156.                 $data["r102"]["11"]["C4"]=$data["r102"]["11"]["C4"]*1+$row["C4"]*1;               
  157.         }else if($hour==17){
  158.                 $data["r102"]["16"]["C3"]=$data["r102"]["16"]["C3"]*1+$row["C3"]*1;
  159.                 $data["r102"]["16"]["C4"]=$data["r102"]["16"]["C4"]*1+$row["C4"]*1;                               
  160.         }else if($hour>19){
  161.                 $data["r102"]["19"]["C3"]=$data["r102"]["19"]["C3"]*1+$row["C3"]*1;
  162.                 $data["r102"]["19"]["C3"]=$data["r102"]["19"]["C4"]*1+$row["C4"]*1;               
  163.         } else {
  164.                 if(array_key_exists($row["C2"],$data["r102"])){
  165.                         $data["r102"][$row["C2"]]["C3"]=$row["C3"]*1;
  166.                         $data["r102"][$row["C2"]]["C4"]=$row["C4"]*1;
  167.                 }
  168.                
  169.         }
  170. }
  171. mysqli_free_result($result);
  172. mysqli_close($db);
  173. //--
  174. require_once('chart_1.php');
  175. /*
  176. print_r($data["r102"]);
  177. Array
  178. (
  179.     [8] => Array
  180.         (
  181.             [C1] => 20191006
  182.             [C2] => 8
  183.             [C3] => 574
  184.             [C4] => 178
  185.             [C5] =>
  186.             [C6] =>
  187.         )*/

  189. ?>

  191. <table style="width: 100%; height: 100%;" border=0 >
  192. <tr style="height: 2%;"><td>
  193. <!-- 第一行标题栏 -->

  195. <DIV style="width: 100%; height: 8%; background-color: transparent; text-align: center">
  196. <span style="COLOR: #222222; FONT-SIZE: 1em; FONT-FAMILY: Verdana" ><?php echo date('H:i:s',time()); ?> </span>&nbsp;&nbsp;&nbsp;
  197. <SPAN id=title style="FONT-WEIGHT: bold; FONT-SIZE: 2.5em; COLOR: black; FONT-FAMILY: Microsoft YaHei" >安徽协创-实时产出看板</SPAN>
  198. &nbsp;&nbsp;&nbsp;<span style="COLOR: #ffffff; FONT-SIZE: 1em; FONT-FAMILY: Verdana" ><?php echo date('Y-m-d H:i:s',time()); ?> </span>
  199. </DIV>

  201. </td></tr>
  202. <tr><td>
  203. <!-- 第二行图表栏 -->

  205. <font color =black>

  207. <table border=1 style="width: 100%; height: 100%;" class='gridtable'>
  208. <tr style="height: 8%;">
  209. <td width="7%" noWrap class='tdtitle'> 机种</td> <td noWrap class='tdtext'> <?php echo $data["line"]["data2"]; ?> </td>
  210. <td noWrap class='tdtitle'>线别</td>                 <td noWrap class='tdtext'> <?php echo $data["line"]["data1"]; ?> </td>
  211. <td noWrap class='tdtitle'>目标产出</td>         <td noWrap class='tdtext'> <?php echo $data["line"]["data5"]; ?> </td>
  212. <td noWrap class='tdtitle'>实际投入</td>         <td noWrap class='tdtext'> <?php echo $data["line"]["data3"]; ?> </td>
  213. <td noWrap class='tdtitle'>实际产出</td>         <td noWrap class='tdtext'> <?php echo $data["line"]["data4"]; ?> </td>
  214. <?php  

  216. $itarget=$data["line"]["data6"]*1.00;
  217. if($itarget>=100){
  218.         echo "<td noWrap class='tdtitle'>产出达成率</td>         <td noWrap class='tdtext' bgcolor='#92D050'>".$data["line"]["data6"]."</td>";
  219. } else if ($itarget>=90){
  220.         echo "<td noWrap class='tdtitle'>产出达成率</td>         <td noWrap class='tdtext' bgcolor='#FFFF2E'>".$data["line"]["data6"]."</td>";
  221. } else {
  222.         echo "<td noWrap class='tdtitle'>产出达成率</td>         <td noWrap class='tdtext' bgcolor='#FF3C3C'>".$data["line"]["data6"]."</td>";
  223. }
  224. ?>
  225. <td noWrap class='tdtitle'>日期</td>                 <td noWrap class='tdtext'> <?php echo date('Y-m-d',time()); ?> </td>
  226. </tr>


  229. <tr><td colspan=14 style="vertical-align:middle;text-align:center;">

  231. <img src='../pictures/ahxc.png?r=11' style="width: 100%; height: auto;" />


  234. </td></tr>

  236. </table>

  238. </font>

  240. </td></tr>
  241. </table>

  243. </body>
  244. </html>
复制代码
作者: zhgc    时间: 2019-12-23 16:44
首次用于安徽看板

  1. <?php

  3. error_reporting(0);
  4. //$agile_include_path = dirname(__FILE__) . '/../php/';
  5. //set_include_path(get_include_path() . PATH_SEPARATOR . $agile_include_path);
  6. //require_once('agilelib.php');
  7. //date_default_timezone_set('America/Los_Angeles');
  8. require_once(dirname(__FILE__) . '/../php/kb_config.inc.php');
  9. $kbconf=new kb_config();
  10. ?>

  12. <html>
  13. <head>
  14.   <meta http-equiv=Content-Type content=text/html;charset=utf8>
  15.   <meta name="viewport" content="width=device-width,initial-scale=1.0,user-scalable=yes" />
  16. </head>
  17. <style type="text/css">
  18. body {
  19. margin:0.5%;
  20. font-size:150%;
  21. font: normal 100% Helvetica, Arial, sans-serif;
  22. color:black;
  23. background-color: white
  24. }
  25. h1 {
  26. font-size: 1.5em;
  27. }
  28. small {
  29. font-size: 0.875em;
  30. }
  31. table.gridtable {
  32.         font-family: verdana,arial,sans-serif;
  33.         font-size:18px;
  34.         border-width: 1px;
  35.         border-color: #666666;
  36.         border-collapse: collapse;
  37. }
  38. table.gridtable th {
  39.         border-width: 1px;
  40.         padding: 8px;
  41.         border-style: solid;
  42.         border-color: #666666;
  43. }
  44. table.gridtable td {
  45.         border-width: 1px;
  46.         padding: 8px;
  47.         border-style: solid;
  48.         border-color: #666666;
  49. }
  50. td.tdtitle {
  51.         FONT-WEIGHT: bold;
  52.         text-align:center;
  53.         vertical-align:middle;
  54.         FONT-SIZE: 1.5em;
  55. }
  56. td.tdtext {
  57.         text-align:center;
  58.         vertical-align:middle;
  59. }
  60. </style>
  61. <body>

  63. <?php

  65. $line=$kbconf->line;
  66. /*
  67. */
  68. $param=array(
  69.         // database server
  70.         "db_host"=>$kbconf->database,
  71.         "db_username"=>"report",
  72.         "db_password"=>"report",//"why do you want to crack my password? contact me 13760216621",
  73.         "db_database"=>"sfc",
  74.         "db_charset"=>"UTF8",
  75. );
  76.         $db = mysqli_connect($param["db_host"], $param["db_username"], $param["db_password"]);
  77.         if (!$db) {
  78.                         die("prepare_db: ".mysqli_connect_error());
  79.         }else
  80.         {
  81.         }       
  82. $data=array(
  83.         "line"=>array(
  84.                 "hstd"=>0,  //每小时的标准，班/10得到
  85.                 "day"=>"",
  86.                 "time"=>"",
  87.                 "week"=>"",
  88.                 "data1"=>$line,
  89.                 "data2"=>"未生产",
  90.                 "data3"=>"0",
  91.                 "data4"=>"0",
  92.                 "data5"=>"0",
  93.                 "data6"=>"0",
  94.         ),
  95.         "r102"=>array( //"08:00","09:00","10:00","11:00","13:00","14:00","15:00","16:00","18:00","19:00","20:00"
  96.                 "8"=>array("T"=>"08:00","C3"=>0,"C4"=>0),
  97.                 "9"=>array("T"=>"09:00","C3"=>0,"C4"=>0),
  98.                 "10"=>array("T"=>"10:00","C3"=>0,"C4"=>0),
  99.                 "11"=>array("T"=>"11:00","C3"=>0,"C4"=>0),
  100.                 "13"=>array("T"=>"13:00","C3"=>0,"C4"=>0),
  101.                 "14"=>array("T"=>"14:00","C3"=>0,"C4"=>0),
  102.                 "15"=>array("T"=>"15:00","C3"=>0,"C4"=>0),
  103.                 "16"=>array("T"=>"16:00","C3"=>0,"C4"=>0),
  104.                 "18"=>array("T"=>"18:00","C3"=>0,"C4"=>0),
  105.                 "19"=>array("T"=>"19:00","C3"=>0,"C4"=>0),
  106.         )
  107.    );
  108. $sql="call sfc.KANBAN_01_XCAH('{$line}');";
  109. $result = mysqli_query($db,$sql);  //must have $con parameter
  110. if($row = mysqli_fetch_assoc($result)){
  111.         $data["line"]=$row;
  112.         $data["line"]["hstd"]=$data["line"]["data5"]*1 / 10;
  113.         //echo $data["line"]["hstd"];
  114.         /* Array(
  115.                 [day] => 20191007
  116.                 [time] => 上午 00:00
  117.                 [week] => 星期一
  118.                 [data1] => L6
  119.                 [data2] => IPC019_A01
  120.                 [data3] => 7885
  121.                 [data4] => 4947
  122.                 [data5] => 7885
  123.                 [data6] => 100.00
  124.         )*/
  125. }
  126. mysqli_free_result($result);
  127. //fix by syant
  128. /*while( !mysqli_next_result( $db ) )
  129. {
  130.         $result = mysqli_store_result( $db );
  131.         mysqli_free_result($result);
  132. }*/
  133. do
  134. {
  135.     if ($result=mysqli_store_result($db))
  136.     {
  137.             mysqli_free_result($result);
  138.     }
  139. } while (mysqli_next_result($db));

  141. $sql="select * from sfc.p_tmp600_t order by c1,c2*1";
  142. $result = mysqli_query($db,$sql);  //must have $con parameter
  143. while($row = mysqli_fetch_assoc($result)){
  144.         /*Array(
  145.     [C1] => 20191006
  146.     [C2] => 10
  147.     [C3] => 429
  148.     [C4] => 210
  149.     [C5] =>
  150.     [C6] => )*/
  151.         $hour=$row["C2"]*1;
  152.         if($hour<8){
  153.                 //夜班的不做处理.   
  154.         }else if($hour==12){
  155.                 $data["r102"]["11"]["C3"]=$data["r102"]["11"]["C3"]*1+$row["C3"]*1;
  156.                 $data["r102"]["11"]["C4"]=$data["r102"]["11"]["C4"]*1+$row["C4"]*1;               
  157.         }else if($hour==17){
  158.                 $data["r102"]["16"]["C3"]=$data["r102"]["16"]["C3"]*1+$row["C3"]*1;
  159.                 $data["r102"]["16"]["C4"]=$data["r102"]["16"]["C4"]*1+$row["C4"]*1;                               
  160.         }else if($hour>19){
  161.                 $data["r102"]["19"]["C3"]=$data["r102"]["19"]["C3"]*1+$row["C3"]*1;
  162.                 $data["r102"]["19"]["C3"]=$data["r102"]["19"]["C4"]*1+$row["C4"]*1;               
  163.         } else {
  164.                 if(array_key_exists($row["C2"],$data["r102"])){
  165.                         $data["r102"][$row["C2"]]["C3"]=$row["C3"]*1;
  166.                         $data["r102"][$row["C2"]]["C4"]=$row["C4"]*1;
  167.                 }
  168.                
  169.         }
  170. }
  171. mysqli_free_result($result);
  172. mysqli_close($db);
  173. //--
  174. require_once('chart_1.php');
  175. /*
  176. print_r($data["r102"]);
  177. Array
  178. (
  179.     [8] => Array
  180.         (
  181.             [C1] => 20191006
  182.             [C2] => 8
  183.             [C3] => 574
  184.             [C4] => 178
  185.             [C5] =>
  186.             [C6] =>
  187.         )*/

  189. ?>

  191. <table style="width: 100%; height: 100%;" border=0 >
  192. <tr style="height: 2%;"><td>
  193. <!-- 第一行标题栏 -->

  195. <DIV style="width: 100%; height: 8%; background-color: transparent; text-align: center">
  196. <span style="COLOR: #222222; FONT-SIZE: 1em; FONT-FAMILY: Verdana" ><?php echo date('H:i:s',time()); ?> </span>&nbsp;&nbsp;&nbsp;
  197. <SPAN id=title style="FONT-WEIGHT: bold; FONT-SIZE: 2.5em; COLOR: black; FONT-FAMILY: Microsoft YaHei" >安徽协创-实时产出看板</SPAN>
  198. &nbsp;&nbsp;&nbsp;<span style="COLOR: #ffffff; FONT-SIZE: 1em; FONT-FAMILY: Verdana" ><?php echo date('Y-m-d H:i:s',time()); ?> </span>
  199. </DIV>

  201. </td></tr>
  202. <tr><td>
  203. <!-- 第二行图表栏 -->

  205. <font color =black>

  207. <table border=1 style="width: 100%; height: 100%;" class='gridtable'>
  208. <tr style="height: 8%;">
  209. <td width="7%" noWrap class='tdtitle'> 机种</td> <td noWrap class='tdtext'> <?php echo $data["line"]["data2"]; ?> </td>
  210. <td noWrap class='tdtitle'>线别</td>                 <td noWrap class='tdtext'> <?php echo $data["line"]["data1"]; ?> </td>
  211. <td noWrap class='tdtitle'>目标产出</td>         <td noWrap class='tdtext'> <?php echo $data["line"]["data5"]; ?> </td>
  212. <td noWrap class='tdtitle'>实际投入</td>         <td noWrap class='tdtext'> <?php echo $data["line"]["data3"]; ?> </td>
  213. <td noWrap class='tdtitle'>实际产出</td>         <td noWrap class='tdtext'> <?php echo $data["line"]["data4"]; ?> </td>
  214. <?php  

  216. $itarget=$data["line"]["data6"]*1.00;
  217. if($itarget>=100){
  218.         echo "<td noWrap class='tdtitle'>产出达成率</td>         <td noWrap class='tdtext' bgcolor='#92D050'>".$data["line"]["data6"]."</td>";
  219. } else if ($itarget>=90){
  220.         echo "<td noWrap class='tdtitle'>产出达成率</td>         <td noWrap class='tdtext' bgcolor='#FFFF2E'>".$data["line"]["data6"]."</td>";
  221. } else {
  222.         echo "<td noWrap class='tdtitle'>产出达成率</td>         <td noWrap class='tdtext' bgcolor='#FF3C3C'>".$data["line"]["data6"]."</td>";
  223. }
  224. ?>
  225. <td noWrap class='tdtitle'>日期</td>                 <td noWrap class='tdtext'> <?php echo date('Y-m-d',time()); ?> </td>
  226. </tr>


  229. <tr><td colspan=14 style="vertical-align:middle;text-align:center;">

  231. <img src='../pictures/ahxc.png?r=11' style="width: 100%; height: auto;" />


  234. </td></tr>

  236. </table>

  238. </font>

  240. </td></tr>
  241. </table>

  243. </body>
  244. </html>
复制代码




欢迎光临 深圳全飞鸿 (http://www.nagomes.com/disc/) Powered by Discuz! X3.2