41 lines
864 B
PHP
41 lines
864 B
PHP
<?php
|
|
include('pdf_header.php');
|
|
include('includes/config/config.php');
|
|
//include('pop_up_top.php');
|
|
?>
|
|
<h2 style="text-align: center;">districts List</h2>
|
|
<table border="1" cellspacing="0" cellpadding="5">
|
|
<?php
|
|
$ohc_type_id = "d.ohc_type_id = " . $_SESSION['current_ohcttype'];
|
|
|
|
$sql = "SELECT
|
|
d.id AS id,
|
|
d.name AS name,
|
|
s.name AS state_id
|
|
FROM
|
|
districts d
|
|
JOIN
|
|
states s ON d.state_id = s.id where $ohc_type_id";
|
|
$result = mysqli_query($conn, $sql);
|
|
?>
|
|
<tr bgcolor='#eeeeee'>
|
|
<th width="200%">District Name</th>
|
|
<th width="200%">State Name</th>
|
|
|
|
</tr>
|
|
<?php
|
|
while ($rowOfprograme = mysqli_fetch_array($result)) {
|
|
?>
|
|
<tr>
|
|
<td><?php echo $rowOfprograme['name']; ?></td>
|
|
<td><?php echo $rowOfprograme['state_id']; ?></td>
|
|
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|