Untitled

<?php
$db_hostname = 'test';
$db_username = 'test';
$db_password = 'test';
$db_database = 'awaken';

// Database Connection String
$con = mysql_connect($db_hostname,$db_username,$db_password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db($db_database, $con);
?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title>Death Log Ma Ninja</title>
    </head>
    <body>
<form action="" method="post">
Search: <input type="text" name="term" /><br />
<input type="submit" value="Submit" />
</form>
<?php
if (!empty($_REQUEST['term'])) {

$term = mysql_real_escape_string($_REQUEST['term']);

$sql = "SELECT * FROM deathlog WHERE Description LIKE '%".$term."%'";
$r_query = mysql_query($sql);

while ($row = mysql_fetch_array($r_query)){
echo 'Primary key: ' .$row['PRIMARYKEY'];
echo '<br /> Time: ' .$row['Time'];
echo '<br /> Victim: '.$row['Victim'];
echo '<br /> Killer: '.$row['Killer'];
echo '<br /> Details: '.$row['Details'];
}

}
?>
    </body>
</html>