Code: Select all
<html>
<head>
<title>Messaging results</title>
</head>
<h1>Messaging results</h1>
<?php
$searchtype=$_POST['searchtype'];
$searchterm=$_POST['searchterm'];
echo $searchterm;
if (!get_magic_quotes_gpc())
{
$searchtype = addslashes($searchtype);
}
@ $db = new mysqli('localhost', '*****', '****', 'messages');
if (mysqli_connect_errno())
{
echo 'Error: Coult not connect to the database. Please try again later.';
exit;
}
$query = "select * from messages where $searchtype = '$searchterm'";
$result = $db->query($query);
$num_results = $result->num_rows;
echo '<p>Messages found: '.$num_results.'</p>';
for($i = 0; $i < $num_results; $i++)
{
$row = $result->fetch_assoc();
echo '<p><strong>'.($i+1).'.Name: ';
echo $row['Name'];
echo '<p></strong><br />Date and Time: ';
echo $row['Date']." at ";
echo $row['Time'];
echo '<p>Recipient: ';
echo $row['Recipient'];
echo '<p>Message: ';
echo $row['Message'];
}
?>
</html>