[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 ‘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 ‘
First Name | Last Name | Position | Location | Phone | Ext. | |
---|---|---|---|---|---|---|
‘; 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]