{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=’https://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=’https://www.standupgirl.com/images/green_check.png’></td>“;
}else if ($tested == 2) {
    print “<td valign=’top’ align=’center’><img src=’https://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=’https://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=’https://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=’https://www.standupgirl.com/images/test.png’></a></td>“;
    }
}
if ($tested != 0) {
    if ($emailed == 1) {
    print “<td valign=’top’ align=’center’><img src=’https://www.standupgirl.com/images/mail-sent.png’></td>“;
    }else {
    print “<td valign=’top’ align=’center’><a href=’prc-management?prcid=$id’><img src=’https://www.standupgirl.com/images/send-mail.png’></a></td>“;
    }
}
print “</tr>“;
    
}
print “</table>“;
?>
{/source}