honey pot
// Enable error reporting
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
# Variables
$state_id = isset($_GET['state_id']) ? $_GET['state_id'] : '';
$table = "gmrs_rpt";
# Includes
include '../repeater_includes/liahona_pdo.inc';
include '../repeater_includes/user_agent.php';
# Validation
# Get the name of the state we are dealing with, if there is one.
if (!empty($state_id && $state_id != 'none')) {
try{
$SQL = "SELECT state_name, state_abbrev FROM states
WHERE state_id=:state_id LIMIT 1";
$query_state_name=$db->prepare($SQL);
$query_state_name->bindValue(':state_id', $state_id, PDO::PARAM_STR);
$query_state_name->execute();
}
catch(PDOException $e) {
$query_error = $e->getMessage(); $line = __LINE__;
}
$row_state_name = $query_state_name->fetch(PDO::FETCH_ASSOC);
}
$state = isset($row_state_name['state_name']) ? $row_state_name['state_name'] : '';
$state_abbrev = isset($row_state_name['state_abbrev']) ? $row_state_name['state_abbrev'] : '';
?>
