pizza.php userspice

<?php

if(file_exists("install/index.php")){
    //perform redirect if installer files exist
    //this if{} block may be deleted once installed
    header("Location: install/index.php");
}

require_once 'users/init.php';
require_once $abs_us_root.$us_url_root.'users/includes/header.php';
require_once $abs_us_root.$us_url_root.'users/includes/navigation.php';

//This is what happens when someone clicks the checkin button
    if(!empty($_POST['check_in'])){
        $date = date('Y-m-d h:i:s');
        $fields = array(
            'user_id' => $user->data()->id,
            'username' => $user->data()->username,
            'timein' => $date
        );
        $db->insert('clicks',$fields);
        Redirect::to('pizza.php?err=You+have+been+checked+in');
    }

$date = date('m/d/Y h:i:s');

?>
<div id="page-wrapper">
<div class="container">
<div class="row">
    <div class="col-xs-12">
        <div class="jumbotron">
            <h1>Welcome to Pizza Monday!</h1>

        </div>
    </div>
</div>

<div class="row">   <div class="col-xs-4">
<form class="" action="pizza.php" method="post">
  <input class='btn btn-primary' type='submit' name='check_in' value='Check in!' />
</form>
<?php

$query = $db->query("SELECT * FROM clicks WHERE user_id = ?",array($user->data()->id));
$results = $query->results();
$count = $query->count();
if ($count > 0){
?>
<h3>You have previously checked in <?=$count?> times.</h3>
<h3>Here are your previous check ins...</h3>
<?php foreach ($results as $r){
    echo $r->timein;
    echo "<br>";
}
}
?>
</div>
</div><!-- /.row -->

</div> <!-- /container -->

</div> <!-- /#page-wrapper -->

<!-- footers -->
<?php require_once $abs_us_root.$us_url_root.'users/includes/page_footer.php'; // the final html footer copyright row + the external js calls ?>

<!-- Place any per-page javascript here -->


<?php require_once $abs_us_root.$us_url_root.'users/includes/html_footer.php'; // currently just the closing /body and /html ?>