Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

Problem in displaying data inside table format

php table form loop

This topic has been archived. This means that you cannot reply to this topic.
No replies to this topic

#1 newphpcoder

newphpcoder

    CC Devotee

  • Senior Member
  • PipPipPipPipPipPip
  • 527 posts

Posted 25 July 2013 - 09:32 PM

Hi,

I created report form for reject type.

Now I need help in displaying the rejects amount per reject type.

here is my code:


<?php
ob_start();
include "connection.php";

$id = "30";
if($id == '30')
{    

   //----code for date only----//
   $sql = "SELECT DISTINCT r.reject_date, r.process_id
    FROM op_reject AS r
    JOIN process_list AS p ON (p.process_id = r.process_id)
    WHERE WEEK(reject_date) + 1 = '$id'
    GROUP BY r.reject_date ORDER BY r.reject_date  ASC";
    
    
    $res = mysql_query($sql);
 
    echo "<table>";
    echo "<tr>";
    echo "<thead>";
    echo "<th>Compound</th>";

    while($row = mysql_fetch_assoc($res))
    {
        $report_date[]  = $row['reject_date'];
        $process_[]   = $row['process_id'];
    }
    
        $i = 1;
        foreach($report_date AS $report_date)
        {
            echo "<th id=col".$i." colspan=\"3\">$report_date</th>";
            $i++;
        }
        echo "</thead>";
    echo "</tr>";  
    echo '
<script type="text/javascript">
    document.getElementById("col2").colSpan='.$i.';
</script>';
        $sql_comp = "SELECT DISTINCT p.process_name , r.process_id, r.reject_date
        FROM op_reject AS r
        JOIN process_list AS p ON (p.process_id = r.process_id)
                WHERE WEEK(reject_date) + 1 = '$id' GROUP BY process_name ORDER BY p.process_id ASC";     
        $res_comp = mysql_query($sql_comp);
        
        
             echo "<tr>";
             while($row_comp = mysql_fetch_assoc($res_comp))
             {
                                
                $process      = $row_comp['process_name'];
                $process_id   = $row_comp['process_id'];
                $reject_date  = $row_comp['reject_date'];
              
                echo "<td>$process</td>";
    
            
$sql_date = "SELECT DISTINCT r.reject_date
                                                    FROM op_reject AS r
                                                    JOIN process_list AS p ON (p.process_id = r.process_id)
                                                    WHERE WEEK(reject_date) = '$id'
                                                    GROUP BY r.reject_date ORDER BY r.reject_date  ASC";
                                                    $res_date = mysql_query($sql);
                                
                                                    while($row_date = mysql_fetch_assoc($res_date))
                                                    {
                                                        $report_date_  = $row_date['reject_date'];                                         

                                                        
                                                        $sql_rej = "SELECT DISTINCT reject_type FROM op_reject WHERE reject_date = '$report_date_' and                                                                  process_id = '$process_id' ORDER BY reject_type";
                                                        $res_rej = mysql_query($sql_rej);
                                                        $cnt_rej = mysql_num_rows($res_rej);
                                                        
                                                        
                                                        if($cnt_rej > 0)
                                                        {
                                                        while($row_rej=mysql_fetch_assoc($res_rej))
                                                        {
                                                            $reject_type = $row_rej['reject_type'];
                                                            
                                                            echo "<td>$reject_type</td>";
                                                        }
                                                        }   
                                                    }
    
                                $comp = "
                                (SElECT DISTINCt r.compound_type FROM op_reject AS r WHERE r.process_id = '$process_id'  AND WEEK(r.reject_date) + 1 = '$id')
                                ORDER BY compound_type ASC";

                                    $c = mysql_query($comp);
                                    
                                    $cnt = mysql_num_rows($c);
                                            
                                            echo "<tr>";
                                            while($co = mysql_fetch_assoc($c))
                                            {
                                                    $compound_type   = $co['compound_type'];
                                                    $process_i       = $co['process_id'];
                                                    $shift_date      = $co['shift_date'];  
                                                 
                                                    echo "<td>$compound_type</td>";
                                                 
                                                    $sql_date = "SELECT DISTINCT r.reject_date
                                                    FROM op_reject AS r
                                                    JOIN process_list AS p ON (p.process_id = r.process_id)
                                                    WHERE WEEK(reject_date) = '$id'
                                                    GROUP BY r.reject_date ORDER BY r.reject_date  ASC";
                                                    $res_date = mysql_query($sql);
                                
                                                    while($row_date = mysql_fetch_assoc($res_date))
                                                    {
                                                        $report_date_  = $row_date['reject_date'];                                         
                                
                                                    //-----
                                             
                                             
                                                    //-----
                                                    $sql_reject = "SELECT compound_type, SUM(reject) AS reject, reject_type FROM op_reject
WHERE compound_type = '$compound_type' and process_id = '$process_id' AND reject_date = '$report_date_' GROUP BY  compound_type, process_id, reject_TYPE";
                                                    $res_reject = mysql_query($sql_reject);
                                                    
                                                    $cnt_rej = mysql_num_rows($res_reject);
                                                   
                                                   if($cnt_rej > 0)
                                                   {
                                                    
                                                    while($row_reject = mysql_fetch_assoc($res_reject))
                                                    {
                                                        $reject = $row_reject['reject'];   
                                                      
                                                        echo "<td>$reject</td>";         
                                                        
                                                   }
                                                   }
                                                   else
                                                   {
                                                       echo "<td></td>";
                                                   }  
                                                    }

                                                   echo "</tr>";
                                          

            }

     }   
  echo "</table>";
 }
?>


for better understanding I attached my updated database, the screenshot display for this code and also the correct output i need to display.


thank you.

 

Attached Thumbnails

  • need table output.JPG
  • new output.JPG

Attached Files






Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download