PRC Management

{source}
<?php
$dbcon = mysql_connect(“localhost”, “standup_ipuser”, “T942mwxFna%G”) or die(mysql_error());
mysql_select_db(“standup_ip2location”, $dbcon);
print “<p><a href=’add-prc’></a></p>“;
//Filtering
print “<div><table cellspacing=’6′><tr><td>Filter by: “;
$locquery = mysql_query(“SELECT DISTINCT state FROM prc_info ORDER BY state”)or die(mysql_error());
print “<select name=’filter’ onChange=’FilterState(this.value)’>
<option value=”>State</option>“;
while ($row = mysql_fetch_array($locquery, MYSQL_ASSOC)) {
$state = $row[‘state’];
print “<option value=’$state’>$state</option>“;
}
print “</select></td>“;
$locquery2 = mysql_query(“SELECT DISTINCT country FROM prc_info ORDER BY country”)or die(mysql_error());
print “<td><select name=’filter’ onChange=’FilterCountry(this.value)’>
<option value=”>Country</option>“;
while ($row = mysql_fetch_array($locquery2, MYSQL_ASSOC)) {
$country = $row[‘country’];
print “<option value=’$country’>$country</option>“;
}
print “</select></td><td><a href=’prc-management’>Show All</a></td>
</tr></table></div>“;
if (isset($_GET[‘state’])) {
$loc = $_GET[‘state’];
$result = mysql_query(“SELECT * FROM prc_info WHERE state = ‘$loc’ ORDER BY id DESC”)or die(mysql_error());
}else if (isset($_GET[‘country’])) {
$loc = $_GET[‘country’];
$result = mysql_query(“SELECT * FROM prc_info WHERE country = ‘$loc’ ORDER BY id DESC”)or die(mysql_error());
}else {
$result = mysql_query(“SELECT * FROM prc_info ORDER BY id DESC”)or die(mysql_error());
}
//List PRCs
print “<table cellspacing=’10’ width=’100%’ border=’0′>
<tr><td></td><td><b>PRC</b></td><td><b>Contact</b></td><td align=’center’><b>Test</b></td><td align=’center’><b>Email</b></td></tr>“;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$id = $row[‘id’];
$prc = $row[‘name’];
$address = $row[‘address’];
$city = $row[‘city’];
$state = $row[‘state’];
$zip = $row[‘zip’];
$contact = $row[‘contact’];
$phone = $row[‘phone’];
$email = $row[’email’];
$date = $row[‘date’];
$ip = $row[‘ip’];
$ipLoc = $row[‘ipLoc’];
$tested = $row[‘tested’];
$emailed = $row[’emailed’];
print “<tr><td width=’250′ valign=’top’><a class=’prcinfopop’><img src=’http://www.standupgirl.com/images/info.png’><b>Address</b><br />$address<br />$city, $state $zip<br /><b>Phone</b> – $phone</td><td width=’300′ valign=’top’>$prc</td></td><td valign=’top’>$contact</td>“;
if ($tested == 1) {
print “<td valign=’top’ align=’center’><img src=’http://www.standupgirl.com/images/green_check.png’></td>“;
}else if ($tested == 2) {
print “<td valign=’top’ align=’center’><img src=’http://www.standupgirl.com/images/red_x.png’></td>“;
}else {
if ($ipLoc == ‘Outside Area’ || $ip == ”) {
print “<td valign=’top’ align=’center’><a href=’prc-test?ip=$ip&prcid=$id&sbmt=3′>
<img src=’http://www.standupgirl.com/images/warning.png’></a></td>“;
}else if ($ipLoc == ‘Within 30 miles’) {
print “<td valign=’top’ align=’center’><a href=’prc-test?ip=$ip&prcid=$id&sbmt=2′><img src=’http://www.standupgirl.com/images/test.png’></a></td>“;
}else if ($ipLoc == ‘PRC’) {
print “<td valign=’top’ align=’center’><a href=’prc-test?ip=$ip&prcid=$id&sbmt=1′><img src=’http://www.standupgirl.com/images/test.png’></a></td>“;
}
}
if ($tested != 0) {
if ($emailed == 1) {
print “<td valign=’top’ align=’center’><img src=’http://www.standupgirl.com/images/mail-sent.png’></td>“;
}else {
print “<td valign=’top’ align=’center’><a href=’prc-management?prcid=$id’><img src=’http://www.standupgirl.com/images/send-mail.png’></a></td>“;
}
}
print “</tr>“;

}
print “</table>“;
?>
{/source}