Displaying a progress bar in php file

manpreet Best Answer 2 years ago

I have a php file which selects a large amount of data from mutiple sql table. Naturally it takes a long time to complete the whole process. I want to display a progress bar which will express the progress of the script running. How to display a progress bar? The script below shows a portion of the php file.

php

//RIGHT(AdmitCode,1), PartCode, MID(AdmitCode,2,2),  MID(AdmitCode,1,1) DESC, RollCode
$query = "SELECT * FROM students1 ORDER BY PartCode, AdmitCode, yearcode  desc, RollCode";

$result = mysql_query($query);

// start a table tag in the HTML
echo ""; 
echo "";//$row['index'] the index here is a field name
echo "";

$ty=0;while($row = mysql_fetch_array($result)){//Creates a loop to loop through   results
    $ty++;if($ty%2==0)
        echo "";else
        echo "";
    echo "";}

echo "

            
List of candidates for Three year Degree  
                (Honours/General) Programme Examination-".$bx1." (".$bx2.")
            
    


        
 Sl. No 
        
ID 
        
 Semester 
        
    Roll No 
        
 Registration No
        
 Name 
        
 Honours 
        
  Elective-1 
        
 Elective-2 
        
 Elective-3 
        
 MIL 
        
  Foundation 
        
 Soft studies 
        
 Syllabus 
    

   
     

    
$ty
            
" . $row['StudentID']." 
            
" . $row['PartCode']."
            
" . $row['AdmitRollNo'] . "
            
" . $row['RegistrationNo']. "
            
" . $row['Name'] . "
            
" . $row['HonoursSubject'] . "
            
". $row['ElectiveSubject1'] . "
            
". $row['ElectiveSubject2'] . "
            
". $row['ElectiveSubject3'] . "
            
". $row['MIL'] . "
            
". $row['Foundation'] . "
            
". $row['SoftStudies'] . "
            
". $row['Syllabus'] . "
        
  
"; //Close the table in HTML

manpreet 2 years ago