/
stateinfo.php
85 lines (84 loc) · 2.56 KB
/
stateinfo.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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php
include ('config.php');
?>
<?php
session_start();
//checks if the login session is true
if (!isset($_SESSION['username']))
{
header("location:index.php");
}
$username = $_SESSION['username'];
?>
<!-- Le styles -->
<link href="bootstrap/css/bootstrap.css" rel="stylesheet">
<script src="http://code.jquery.com/jquery.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
<?php
//List of state codes
$states = array(
"ALABAMA" => "AL",
"ALASKA" => "AK",
"ARIZONA" => "AZ",
"ARKANSAS" => "AR",
"CALIFORNIA" => "CA",
"COLORADO" => "CO",
"CONNECTICUT" => "CT",
"DELAWARE" => "DE",
"DISTRICT OF COLUMBIA" => "DC",
"FLORIDA" => "FL",
"GEORGIA" => "GA",
"HAWAII" => "HI",
"IDAHO" => "ID",
"ILLINOIS" => "IL",
"INDIANA" => "IN",
"IOWA" => "IA",
"KANSAS" => "KS",
"KENTUCKY" => "KY",
"LOUISIANA" => "LA",
"MAINE" => "ME",
"MONTANA" => "MT",
"NEBRASKA" => "NE",
"NEVADA" => "NV",
"NEW HAMPSHIRE" => "NH",
"NEW JERSEY" => "NJ",
"NEW MEXICO" => "NM",
"NEW YORK" => "NY",
"NORTH CAROLINA" => "NC",
"NORTH DAKOTA" => "ND",
"OHIO" => "OH",
"OKLAHOMA" => "OK",
"OREGON" => "OR",
"MARYLAND" => "MD",
"MASSACHUSETTS" => "MA",
"MICHIGAN" => "MI",
"MINNESOTA" => "MN",
"MISSISSIPPI" => "MS",
"MISSOURI" => "MO",
"PENNSYLVANIA" => "PA",
"RHODE ISLAND" => "RI",
"SOUTH CAROLINA" => "SC",
"SOUTH DAKOTA" => "SD",
"TENNESSEE" => "TN",
"TEXAS" => "TX",
"UTAH" => "UT",
"VEMONT" => "VT",
"VIRGINIA" => "VA",
"WASHINGTON" => "WA",
"WEST VIRGINIA" => "WV",
"WISCONSIN" => "WI",
"WYOMING" => "WY"
);
$state = $_GET['state'];
$state = strtoupper($state);
echo $state . " - " . $states[$state];
$output = "<table class=\"table table-striped\"><thead><th>GLOBAL VENDOR</th><th>LOCAL VENDOR</th><th>CITY</th><th>STATE</th><th>ZIP CODE</th></thead><tbody>";
$query = mysql_query("SELECT global_vendor.vendor_name AS global, vendor.vendor_name, address.city, address.zipcode FROM address LEFT JOIN vendor ON vendor.DUNS = address.DUNS LEFT JOIN global_vendor ON global_vendor.DUNS = vendor.global_duns where address.state=\"" . $states[$state] . "\" ORDER BY vendor.vendor_name");
for ($x = 0; $x < mysql_num_rows($query); $x++)
{
$match = mysql_fetch_array($query);
$output = $output . "<tr><td>" . $match['global'] . "</td><td>" . $match['vendor_name'] . "</td><td>" . $match['city'] . "</td><td>" . $state . "</td><td>" . $match['zipcode'] . "</td></tr>";
}
$output = $output . "</tbody></table>";
echo $output;
?>