<?php
require_once 'users/init.php';
require_once $abs_us_root.$us_url_root.'users/includes/template/prep.php';
$searched = 0;
$c = 0;
if(!empty($_POST['submit'])){
	$fname = htmlspecialchars(Input::get('fname'));
	$lname = htmlspecialchars(Input::get('lname'));
	$q = $db->query("SELECT fname,lname,username,email FROM users WHERE fname LIKE ? AND lname LIKE ?",["%$fname%","%$lname%"]);
	$c = $q->count();
	$r = $q->results();
	$searched = 1;
}

?>
<div id="page-wrapper">
	<div class="container">
		<div class="jumbotron">
			<form class="" action="" method="post">
				<input type="text" name="fname" value="" placeholder="first name">
				<input type="text" name="lname" value="" placeholder="last name">
				<input type="submit" name="submit" value="Go!">
			</form>
		</div>
		<div class="row">
			<div class="col-sm-12">
				<?php if($searched > 0){?>
					We found <?php echo $c ?> results.
					<table class="table table-striped">
						<?php foreach($r as $u){?>
							<tr>
								<td><?=$u->fname?></td><td><?=$u->lname?></td><td><?=$u->username?></td><td><?=$u->email?></td>
							</tr>
						<?php } ?>

					</table>
				<?php }?>
			</div>
		</div>
<?php languageSwitcher();?>
	</div>
</div>

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


<?php require_once $abs_us_root . $us_url_root . 'usersc/templates/' . $settings->template . '/footer.php'; //custom template footer ?>