<div class="col-lg-12 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<h4 class="card-title">State List</h4>
<div class="table-responsive">
<table class="table table-striped">
<thead>
<tr>
<th>Sr. No.</th>
<th>State Name</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$sqlState = mysqli_query($cn, "select * from `tbl_state`");
while($sqlStateData = mysqli_fetch_array($sqlState)){
?>
<tr>
<td style="width:40%;"><?php echo $i++;?></td>
<td style="width:60%;"><?php echo $sqlStateData['name'];?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>