[insert_php]

error_reporting(E_ALL);
ini_set(‘display_errors’, 0);

require ‘dbconfig.php’;

$con = new PDO(“mysql:host=” .$db_host. “;dbname=staff” , $db_user, $db_password);
$con->setAttribute( PDO::ATTR_EMULATE_PREPARES, false );

echo ‘

‘;
echo ‘Search For:

‘;
// echo ‘Sort By: ‘;

echo ‘‘;
echo ‘

‘;
echo ‘View All‘;

if (isset($_POST[‘Search’])) {
$searchq = $_POST[‘Search’];
// $sortq = “Last Name”;
// $sortq = $_POST[‘Sort’]);
// echo ‘
Sorted By: ‘ . $sortq;

}

$stmt = $con->prepare(“SELECT * FROM staffdata WHERE LName LIKE :srch OR FName LIKE :srch_a ORDER BY LName ASC”);
$stmt->execute(array(‘:srch’ => “%”.$searchq.”%”, ‘:srch_a’ => “%”.$searchq.”%”));

echo ‘

‘;

// while ($record = $stmt->fetch(PDO::FETCH_ASSOC)) {
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $record) {

$count++;
if( $count % 2 == 0 ) {
$class = ” class=’odd'”;
} else {
$class = “class=’even'”;
}

echo ‘

‘;
}

echo ‘

First Name Last Name Position Location Phone Ext. Email
‘;
echo $record[‘FName’];
echo ‘
‘;
echo $record[‘LName’];
echo ‘
‘;
echo $record[‘Position’];
echo ‘
‘;
echo $record[‘Location’];
echo ‘
‘;
echo $record[‘Phone’];
echo ‘
‘;
echo $record[‘Ext’];
echo ‘
‘;
echo $record[‘Email’];
echo ‘

‘;

[/insert_php]