$dsn = $cisConfig['db']['dsn'] . ":host=" . $cisConfig['db']['dbhost'] . ";dbname=" . $cisConfig['db']['dbname'];
try {
$dbh = new PDO($dsn, $cisConfig['db']['dbuser'], $cisConfig['db']['dbpasswd']);
} catch (PDOException $e) {
echo "Error: Could not connect. " . $e->getMessage();
}
// set error mode
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// We need to see if a command has been issued
$cmd = $_REQUEST['cmd'];
// attempt some queries
try {
// Set up our helper
$dbHelper = new DbHelper($dbh);
// Get categories and things...
$categories = $dbHelper->getCategories();
$products = $dbHelper->getProducts();
// close connection, clean up
#unset($dbh);
// define template directory location
$loader = new Twig_Loader_Filesystem('views');
// initialize Twig environment
$twig = new Twig_Environment($loader);
if ($cmd == "search_criteria") {
// load template
$template = $twig->loadTemplate('categories.tmpl');
// set template variables
// render template
echo $template->render(array('categories' => $categories, 'departments' => $departments, 'clients' => $clients));
} else {
if ($cmd == "blaha") {
