PHP Page is not displaying the full data. Getting time out

[Senthilkumar]

Dear Team,

In my database table (billing), I have 271988 rows of data. When I am trying to display that data in the table of my PHP page, I am getting the following error while loading the page:

My table code is 

				<table class="table row-border hover cell-border" id="example" style="font-size:12px">
					<tr>
						<th>Sales Document Type</th>
						<th>Billing Date</th>
						<th>Material</th>
						<th>Gross Amount</th>
						<th>Sales Office</th>
						<th>Plant</th>
						<th>Distribution Channel Desp</th>
						<th>Div(Hdr)</th>
						<th>Div(Hdr)</th>
					</tr>
					<?PHP
					$Query = "SELECT * FROM billing";
					$result = mysqli_query($conn, $Query);
					while ($row = mysqli_fetch_assoc($result)) {

						?>
						<tr>
							<td>
								<?PHP echo $row['sales_doc_type']; ?>
							</td>
							<td>
								<?PHP echo $row['billing_date']; ?>
							</td>
							<td>
								<?PHP echo $row['material']; ?>
							</td>
							<td>
								<?PHP echo $row['gross_amount']; ?>
							</td>
							<td>
								<?PHP echo $row['sales_office']; ?>
							</td>
							<td>
								<?PHP echo $row['plant']; ?>
							</td>
							<td>
								<?PHP echo $row['distribution_channel_description']; ?>
							</td>
							<td>
								<?PHP echo $row['division']; ?>
							</td>
							<td>
								<?PHP echo $row['division_header']; ?>
							</td>
						</tr>
						<?PHP
					}
					?>
				</table>

Is it possible to display 271988 rows? Please tell me how to do this.

My database table dump is attached the below link

https://drive.google.com/file/d/1i2fTg4GnMTgXWPHc1JkwOHfQu--eYKky/view?usp=sharing

 

[requinix]

That's a browser error, not a PHP error.

271k rows of data on a page is ridiculous. Use pagination.

[Senthilkumar]

Thanks for your reply. I will check with pagination.