Question

我正试图拟定一份申请情况报告,我有一阵列,有数名。我正在通过这份清单,确定每个问题的期限,并把它保留一个相应的阵列,然后进行计算。我试图将其印成一张桌子,但没有ice。我有我的试样,也有旁观,我拿着一阵列,但坐着一只手.,我可以指出原因。由于这一帮助,我可以回答问题。我将在底部投入一个月/年,提交纽伦,将同一页次接回。

<?php
                $applist = array( default1 , default2 , default3 );
                $numofapps = 3;
                $i=0;
                $downtime;
                if($_POST[ submitted ]==1)
                {
                    $month = $_POST[ startmonth ];
                }   
                else {
                    $month = date("m");
                }
                echo "<br />";

                switch ($month){
                    case 01:
                    case 03:
                    case 05:
                    case 07:
                    case 08:
                    case 10:
                    case 12:
                        $totaltime = 31 * 1440;
                        break;
                    case 04:
                    case 06:
                    case 09:
                    case 11:
                        $totaltime = 30 * 1440.0;
                        break;
                    case 02:
                        $year = $_POST[ startyear ];
                        if(($year%4)==0)
                        {
                            $totaltime = 29 * 1440.0;
                        }
                        else {
                            $totaltime = 28 * 1440.0;
                        }
                        break;

                }
                echo "<br />";
                while($numofapps > $i)
                {
                    $query="Select `duration` from `issuetrack` WHERE `app`= " . $applist[$i] . " ";
                    $result=mysql_query($query);

                    while($row = mysql_fetch_array($result))
                    {
                        echo $downtime[$i];
                        echo "TEST downtime <br />";
                        echo $row[$i];
                        echo "ETST DURATION <br />";
                        $downtime[$i]+=$row[ duration ];
                    }
                    $appavail[$i]=($downtime[$i] / $totaltime) * 100;

                    $i++;                   

                    echo "<br />";
                }
                $j=0;
                echo "<table border = 1 >";
                        echo "<tr><th>Application Affected</th><th>Application Availability</th>";

                        while ($numofapps > $j)
                        {
                            echo "<tr><td>";
                            echo $applist[$i];
                            echo "</td><td>";
                            echo $appavail[$i];
                            echo "</td></tr>";
                        }
                        echo "</table>";



            ?>

Answer 1

核对$result等变量

if($result)
 echo "1";
else
 echo mysql_error();

即便您没有数据,如果问询正确,它还是印刷了1份,否则就会出现错误。

并检查你的我的connect-联系,以发现你与 d有关系:

mysql_connect( localhost , username , password ) or die (mysql_error());

Answer 2

如果贵国的字母编号为while($row = mysql_fetch_array($result),则该编号为查询结果。印刷你的询问(echo query/code>),并直接用我sql操作,看看它给什么。



The variables in the while ($numofapps > $j) loop are indexed by $i but they should be indexed by $j. Also, you need a $j++ there or it will loop until the script execution time limit is reached.

Answer 3

as a first step check the mysql connection

mysql_connect( localhost , username , password ) or die (mysql_error());

if there is connection then check the query is returning something by using the following query

 $count=mysql_num_rows($result);
       if($count!=0)
       {
           while($row = mysql_fetch_array($result))
          {
               echo $downtime[$i];
               echo "TEST downtime <br />";
               echo $row[$i];
               echo "ETST DURATION <br />";
               $downtime[$i]+=$row[ duration ];
          }
      }
     else
     {
         echo "The query returned empty";
     }

友情链接