if (isset($_GET['offender_id'])) {
$offenderid = $_GET['offender_id'];
}
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'dnoxa5yj';
$conn = new mysqli($dbhost, $dbuser, $dbpass);
if(! $conn ) {
die('Could not connect: ' . mysqli_connect_error($conn));
}
$db = mysqli_select_db($conn, 'megan_db_develop');
$query1 = "SELECT * FROM megan_db_develop.offenders WHERE offender_id='$offenderid'";
$results = mysqli_query($conn, $query1) or trigger_error(mysqli_error($conn), E_USER_ERROR);
$numrow = mysqli_num_rows($results);
if ($numrow > 0) {
while ($row = mysqli_fetch_assoc($results)) {
$name = $row['last_name'] . ", " . $row['first_name'] . " " . $row['middle_name'];
$address = $row['address_line1'];
$risklevel = $row['risk_level'];
$designation = $row['designation'];
$city = $row['city'];
$zipcode = $row['zipcode'];
$specialconditions = $row['special_condition'];
$offense_description = $row['offense_description'];
$victim_relationship = $row['victim_relationship'];
$weapon_used = $row['weapon_used'];
$force_used = $row['force_used'];
$computer_used = $row['computer_used'];
$porn_involved = $row['porn_involved'];
if (empty($city) && $zipcode == 0) {
$address2 = "New York";
} else if (empty($city)) {
$address2 = "New York " . $zipcode;
} else if ($zipcode == 0) {
$address2 = $city . ", New York ";
} else {
$address2 = $city . ", New York " . $zipcode;
}
$dob = $row['dob'];
$height = $row['height'];
$sex = $row['sex'];
$weight = $row['weight'];
}
}
$query1 = "SELECT * FROM megan_db_develop.offendereasy WHERE offender_id='$offenderid'";
$results = mysqli_query($conn, $query1) or trigger_error(mysqli_error($conn), E_USER_ERROR);
$numrow = mysqli_num_rows($results);
if ($numrow > 0) {
while ($row = mysqli_fetch_assoc($results)) {
$race = $row['race'];
$haircolor = $row['haircolor'];
$eyes = $row['eyecolor'];
$glasses = $row['glasses'];
$images = $row['image_name'];
}
}
$query1 = "SELECT * FROM megan_db_develop.marks WHERE offenders_id='$offenderid'";
$results = mysqli_query($conn, $query1) or trigger_error(mysqli_error($conn), E_USER_ERROR);
$numrow = mysqli_num_rows($results);
if ($numrow > 0) {
while ($row = mysqli_fetch_assoc($results)) {
$description = $row['description'];
$comments = $row['comments'];
}
}
$query1 = "SELECT * FROM megan_db_develop.Alias WHERE offenders_id='$offenderid'";
$results = mysqli_query($conn, $query1) or trigger_error(mysqli_error($conn), E_USER_ERROR);
$numrow = mysqli_num_rows($results);
if ($numrow > 0) {
while ($row = mysqli_fetch_assoc($results)) {
$last_name = $row['last_name'];
$first_name = $row['first_name'];
$middle_initial = $row['middle_initial'];
}
}
$query1 = "SELECT * FROM megan_db_develop.jurisdiction WHERE offender_id='$offenderid'";
$results = mysqli_query($conn, $query1) or trigger_error(mysqli_error($conn), E_USER_ERROR);
$numrow = mysqli_num_rows($results);
if ($numrow > 0) {
while ($row = mysqli_fetch_assoc($results)) {
$agency = $row['agency'];
}
}
$query1 = "SELECT * FROM megan_db_develop.vehicles WHERE offenders_id='$offenderid'";
$results = mysqli_query($conn, $query1) or trigger_error(mysqli_error($conn), E_USER_ERROR);
$numrow = mysqli_num_rows($results);
if ($numrow > 0) {
while ($row = mysqli_fetch_assoc($results)) {
$vehicle_license_plate = $row['vehicle_license_plate'];
$vehicle_year = $row['vehicle_year'];
$vehicle_model = $row['vehicle_model'];
}
}
[/insert_php]
Identity:
PFML ID:
[insert_php] echo $offenderid; [/insert_php]
Name:
[insert_php] echo $name; [/insert_php]
Address:
[insert_php] echo $address; [/insert_php]
[insert_php] echo $address2; [/insert_php]
Status:
Risk Level:
[insert_php] echo $risklevel; [/insert_php]
Designation:
[insert_php] echo $designation; [/insert_php]
Description:
DOB:
[insert_php] echo $dob; [/insert_php]
Height:
[insert_php] echo $height; [/insert_php]
Sex:
[insert_php] echo $sex; [/insert_php]
Weight:
[insert_php] echo $weight; [/insert_php]
Race:
[insert_php] echo $race; [/insert_php]
Hair:
[insert_php] echo $haircolor; [/insert_php]
Glasses:
[insert_php] echo $glasses; [/insert_php]
Eyes:
[insert_php] echo $eyes; [/insert_php]
Scars, Marks and Tattoos:
Description:
[insert_php] echo $description; [/insert_php]
Comments:
[insert_php] echo $comments; [/insert_php]
Additional Names/Aliases:
Last Name:
[insert_php] echo $last_name; [/insert_php]
First Name:
[insert_php] echo $first_name; [/insert_php]
Middle Int:
[insert_php] echo $middle_initial; [/insert_php]
Law Enforcement Agency Having Jurisdiction:
Agency:
[insert_php] echo $agency; [/insert_php]
Charge/Sentence Information:
Title:
Section:
Subsection:
Class:
Category:
Count(s):
Description:
Victim Age:
Victim Sex:
Conviction Date:
Crime Date:
Supervising Agency:
Arresting Agency:
Previous Conviction(s) Requiring Registration:
None Reported
Employer Information:
Employer Status:
Employer Street:
Employer City:
Employer State:
Employer Zip:
Vehicles:
Lic Plate No:
State:
Vehicle Year:
Make:
Model:
Color:
Modus Operandi:
Relationship to Victim:
[insert_php] echo $victim_relationship; [/insert_php]
Weapons Used:
[insert_php] echo $weapon_used; [/insert_php]
Force Used:
[insert_php] echo $force_used; [/insert_php]
Computer Used :
[insert_php] echo $computer_used; [/insert_php]
Pornography Involved:
[insert_php] echo $porn_involved; [/insert_php]
Narrative:
Narrative Information:
Special Conditions:
[insert_php] echo $specialconditions; [/insert_php]
Offense Desc:
[insert_php] echo $offense_description; [/insert_php]
Photo Date: