-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathproviders.html
More file actions
135 lines (116 loc) · 5.66 KB
/
providers.html
File metadata and controls
135 lines (116 loc) · 5.66 KB
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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
#!/usr/local/bin/php
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />-->
<!-- Material Design fonts -->
<link rel="stylesheet" type="text/css" href="https://fonts.googleapis.com/css?family=Roboto:300,400,500,700">
<link rel="stylesheet" type="text/css" href="https://fonts.googleapis.com/icon?family=Material+Icons">
<!-- Bootstrap -->
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<!-- Bootstrap Material Design -->
<link rel="stylesheet" type="text/css" href="https://www.cise.ufl.edu/~abh/css/bootstrap-material-design.css">
<link rel="stylesheet" type="text/css" href="https://www.cise.ufl.edu/~abh/css/ripples.min.css">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>CellCheck - Providers</title>
<style type="text/css">
* { margin: 0; padding: 0; }
p { margin-top: 5%;padding: 0px; }
.cproviders{position: absolute; left: 0; top: 0; width: 100%; height: 100%; background: #49B24E;}
</style>
<link rel="stylesheet" type="text/css" href="https://www.cise.ufl.edu/~abh/kekmon.css">
</head>
<body style = "background:#26272B;">
<nav class="navbar navbar-default"style="margin-top:-20px;background:#49B24E;">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="https://www.cise.ufl.edu/~abh/index.html">CellCheck</a>
</div>
<ul class="nav navbar-nav">
<li class="active"><a href="https://www.cise.ufl.edu/~abh/providers.html">Providers</a></li>
<li><a href="https://www.cise.ufl.edu/~abh/contracts.html">Contracts</a></li>
<li><a href="https://www.cise.ufl.edu/~abh/coverage.html">Coverage</a></li>
</ul>
</div>
</nav>
<div class="container" >
<div class="row">
<div class="col-md-3">
</div>
<div class="col-md-6" style="text-align:center;">
<h2 style="color:white;margin-bottom:20px;"><br>Choose a Provider<br></h2>
<ul class="nav nav-pills green">
<li class="active"><a data-toggle="pill" href="#ATnT">AT&T</a></li>
<li><a data-toggle="pill" href="#Sprint">Sprint</a></li>
<li><a data-toggle="pill" href="#TMobile">T-Mobile</a></li>
<li><a data-toggle="pill" href="#Verizon">Verizon</a></li>
</ul>
<div class="tab-content" style="color:#aaa;">
<div id="ATnT" class="tab-pane fade in active">
<p style="margin-bottom:-20px;"><br></p>
<img src="https://ahanuschak.com/cis4301/att-logo.png" class="img-responsive" alt="AT&T"style = "border-radius:8px;display:block; margin:0 auto;">
<?php
$connection = oci_connect($username = 'anrivera', $password = '$MarkusS4301!', $connection_string = '//oracle.cise.ufl.edu/orcl');
if (!$connection) {
$m = oci_error();
echo $m['message'], "\n";
exit;
}
else {
//print "Sucessfully connected to Oracle!";
}
$sqlstatement = "SELECT HEADQUARTERS FROM Provider where name = 'Verizon'";
$test = oci_parse($connection, $sqlstatement);
oci_execute($test);
oci_fetch($test);
//List Name
echo "Verizon";
//List Headquarters address
echo oci_result($test, 'HEADQUARTERS');
$sqlstatement = "SELECT CONTACT FROM Provider where name = 'Verizon'";
$test = oci_parse($connection, $sqlstatement);
oci_execute($test);
oci_fetch($test);
//List Contact Number
echo oci_result($test, 'CONTACT');
$sqlstatement = "SELECT COUNT(*) FROM FL_CELL_SITES WHERE MNC IN (SELECT MNC FROM Network WHERE Provider = 'Verizon')";
$test = oci_parse($connection, $sqlstatement);
oci_execute($test);
oci_fetch($test);
//Total Number of Towers
echo "total number of towers: ";
echo oci_result($test, 'COUNT(*)');
oci_free_statement($test);
oci_close($connection);
?>
<form action="contracts.html" method="get">
<div class="form-group label-floating">
<input type="submit" value="select" class="btn btn-raised btn-default" selection="atnt">
</div>
</form>
</div>
<div id="Sprint" class="tab-pane fade">
<p style="margin-bottom:-15px;"><br></p>
<img src="https://ahanuschak.com/cis4301/sprint-logo.png" class="img-responsive" alt="Sprint"style = "border-radius:8px;display:block; margin:0 auto;">
<p>This is a paragraph about Sprint. I really like their phones. <br>I hope they come out with a few good ones next year.</p>
</div>
<div id="TMobile" class="tab-pane fade">
<p style="margin-bottom:-20px;"><br></p>
<img src="https://ahanuschak.com/cis4301/tmobile-logo.png" class="img-responsive" alt="T-Mobile"style = "border-radius:8px;display:block; margin:0 auto;padding:10px;">
<p>This is a paragraph about Tmobile. I really like their phones. <br>I hope they come out with a few good ones next year.</p>
</div>
<div id="Verizon" class="tab-pane fade">
<p style="margin-bottom:-15px;"><br></p>
<img src="https://ahanuschak.com/cis4301/verizon-logo.png" class="img-responsive" alt="Verizon"style = "border-radius:8px;display:block; margin:0 auto;">
<p>This is a paragraph about verizon. I really like their phones. <br>I hope they come out with a few good ones next year.</p>
</div>
</div>
</div>
<div class="col-md-9">
</div>
</div>
</div>
</body>
</html>