-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathquery1_controller.php
executable file
·64 lines (57 loc) · 1.33 KB
/
query1_controller.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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<!--
Created By: Sandesh Koirala
UTA ID#: 1001552326
-->
<html>
<head>
<title> Query 1</title>
<style>
table,td,thead {
border: 1px solid black;
}
</style>
</head>
<body>
<?php
$host = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbname = "covid19";
$conn = new PDO('mysql:host='.$host.';dbname='.$dbname, $dbusername, $dbpassword);
if(!$conn)
{
die("Connection Failed");
}
else
{
$name = filter_input(INPUT_POST, 'name');
$query = "SELECT C.CDate,C.County_Name,C.Daily_Count_Cases,C.Daily_Deaths
FROM coviddata C, states S
WHERE C.State_Ab=S.State_Ab AND S.State_Name=:name";
$stmt = $conn->prepare($query);
$stmt->execute(array(':name' => $name));
if (($rows = $stmt->fetchALL(PDO::FETCH_ASSOC))==NULL){
echo "Data for given state deos not exists!";
die();
}
else{
?>
<b> All maching records for <?php echo $name?> follows:</b></br></br>
<table>
<thead>
<td>Date</td>
<td>County Name</td>
<td>Daily Count Cases</td>
<td>Daily Deaths</td>
</thead>
<?php foreach ($rows as $row) { ?>
<tr>
<td><?php echo $row["CDate"];?></td>
<td><?php echo $row["County_Name"];?></td>
<td><?php echo $row["Daily_Count_Cases"];?></td>
<td><?php echo $row["Daily_Deaths"];?></td>
</tr>
<?php } }} ?>
</table>
</body>
</html>