-
Notifications
You must be signed in to change notification settings - Fork 0
/
Modify_vlg_service_show.php
executable file
·49 lines (37 loc) · 1.51 KB
/
Modify_vlg_service_show.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<?php require_once("includes/session.php"); ?>
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php require_once("includes/validation_functions.php"); ?>
<?php confirm_logged_in(); ?>
<?php include("includes/header.php"); ?>
<div class="row2">
<div class = "col1"></div>
<div class = "col2">
<br>
<div Class="sidebar">
<a class="heading1" href="Modify_data.php">BACK</a>
</div>
<button class="btn btn-success" onClick ="printDiv('printableArea')">PDF Export</button>
<button class="btn btn-success" onClick ="$('#table1').tableExport({type: 'excel', escape: 'false'});">Excel Export</button>
<button class="btn btn-success" onClick ="$('#table1').tableExport({type: 'png', escape: 'false'});">PNG Export</button>
<br><br>
<div id="printableArea">
<h3>VLG - Services</h3>
<?php
$query = "SELECT * FROM elec_VLG_SERVICES ORDER BY Feeder_Name ASC";
$result = mysqli_query($connection,$query);
echo '<table id="table1" style="width:200%" class="sortable">';
echo'<th>Feeder_Name</th><th>Vault_Name</th><th>Vault_Section</th>';
while($data = mysqli_fetch_assoc($result))
{
echo'<tr style="text-align:center">';
echo '<td>'.$data['Feeder_Name'].'</td><td>'.$data['Vault_Name'].'</td><td>'.$data['Vault_Section'].'</td>';
echo'</tr>';
}
echo '</table>';
?>
</div>
<br>
</div>
</div>
<?php include("includes/footer.php"); ?>