<form action="index.php" method="get">
Name: <input type='text' name='name' />
<input type='submit' value='submit' /><br />
</form>

<?php
require_once 'facebook.php';
require_once('simpletest/browser.php');
$appapikey = 'ca796429422ebff9257a144a9fbe9d8d';
$appsecret = 'c08f0cf680ab89108bfd6badce4aef7d';
$facebook = new Facebook($appapikey, $appsecret);
$user_id = $facebook->require_login();
$dbhost = 'localhost';
$dbuser = 'seanan';
$dbpass = 'purrrr';
$dbname = 'aafhez5y_dailypolicelog';

echo "Welcome to NARC";
echo "<br> <br>";

$db_connection = mysql_connect($dbhost, $dbuser, $dbpass ) or die ('Error connecting to mysql database! <br />');
$gotDatabase = mysql_select_db($dbname, $db_connection);

if( !$gotDatabase )
{
    echo "Error accessing Police Log database.";
    echo '<br />';
}

$curYear = date("y");
$logID = $curYear . '-P';

$searchName = $_GET['name'];

$recordFound = false;

if( !empty($searchName) )
{
    $sql_result = mysql_query("SELECT * FROM log_data");

    while( $row = mysql_fetch_array($sql_result) )
    {
        $information = $row['log_information'];
        $date = $row['log_date'];

        $record = get_record($information, $logID); //Edit out one record from information

        while( !empty($record)  )
        {
            $doesContainEntry = strpos( $record, $searchName );

            if( $doesContainEntry !== false )
            {
                $recordFound = true;
                echo "Found $searchName on $date!";
                echo "<br><br>";
                echo $record;
                echo "<br><br>";
            }

            #echo "STRLEN OF INFORMATION IS:";
            #echo strlen($information);
            $record = get_record( $information, $logID);
        }

    }
}

if( !$recordFound )
{
    echo "No entry found.";
}

mysql_close($db_connection);

function get_record(&$information, $logID)
{
    $endPos = strpos( $information, $logID, strlen($logID)); #Don't capture the very first log date, but grab where it is so we can skip by it!

    if( $endPos === false )
    {
        $record = "";
    }
    else
    {
        $record = substr($information, 0, $endPos);
        $information = substr($information, $endPos);
    }

    return $record;
}

?>