/** * Gets the DB connection * @return PDO The DB Connection */ function getDatabase() { try { $db = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=utf8mb4', DB_USER, DB_PASS); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); return $db; } catch (Exception $e) { showDbError('connect', $e->getMessage()); } }
<?php /** * Redirects to the error handling page * @param string $type * @return void */ function showDbError($type, $msg) { file_put_contents(__DIR__ . '/error_log_mysql', PHP_EOL . (new DateTime())->format('Y-m-d H:i:s') . ' : ' . $msg, FILE_APPEND); header('location: error.php?type=db&detail=' . $type); exit; } // Include config require_once 'config.php'; // Make Connection try { $db = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME_FF . ';charset=utf8mb4', DB_USER, DB_PASS); } catch (Exception $e) { showDbError('connect', $e->getMessage()); } $stmt = $db->exec('DELETE FROM collections WHERE user_id = 10'); var_dump($stmt); // Handle result here .... //EOF
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); } catch (Exception $ex) { showDbError('connect', $ex->getMessage()); } /** * No action to handle: show our page itself * ---------------------------------------------------------------- */ // Fetch needed data from DB // @TODO get all items from databases $items = array(); try { if (isset($_GET['topic'])) { $resultSet = $db->prepare('SELECT books.id,books.title AS "booktitle",numpages,cover_extension,topics.id AS "topicid",topics.title AS "topictitle",username FROM `books` join users on user_id=users.id join topics on topic_id=topics.id WHERE topics.id=? ORDER BY booktitle ASC;'); $resultSet->execute(array($_GET['topic'])); } else { $resultSet = $db->query('SELECT books.id,books.title AS "booktitle",numpages,cover_extension,topics.id AS "topicid",topics.title AS "topictitle",username FROM `books` join users on user_id=users.id join topics on topic_id=topics.id ORDER BY booktitle ASC;'); } if ($resultSet) { foreach ($resultSet as $rij) { array_push($items, $rij); } } } catch (Exception $ex) { showDbError('get', $ex->getMessage()); } $loader = new Twig_Loader_Filesystem(__DIR__ . '/templates'); $twig = new Twig_Environment($loader, array('cache' => __DIR__ . '/cache', 'auto_reload' => true)); $tpl = $twig->loadTemplate('index.twig'); echo $tpl->render(array('pageTitle' => 'Index', 'books' => $items, 'user' => isset($_SESSION['user']) ? $_SESSION['user']['username'] : null));
<?php /** * Redirects to the error handling page * @param string $type * @return void */ function showDbError($type) { // The referrerd page will show a proper error based on the $_GET parameters header('location: error.php?type=db&detail=' . $type); exit; } // Include config require_once 'config.php'; // Make Connection try { $db = new PDO('mysql:host=' . DB_HOST . ';dbname=does_not_exist;charset=utf8mb4', DB_USER, DB_PASS); } catch (Exception $e) { showDbError('connect'); } echo 'Connected to the database'; // ... your query magic here //EOF
* Includes * ---------------------------------------------------------------- */ // config & functions require_once 'includes/config.php'; require_once 'includes/functions.php'; /** * Database Connection * ---------------------------------------------------------------- */ // @TODO try { $db = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=utf8mb4', DB_USER, DB_PASS); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (Exception $aight) { showDbError($aight->getMessage(), "database error"); } /** * Initial Values * ---------------------------------------------------------------- */ $priorities = array('low', 'normal', 'high'); // The possible priorities of a todo $formErrors = array(); // The encountered form errors $id = isset($_GET['id']) ? (int) $_GET['id'] : 0; // The passed in id of the todo $what = isset($_POST['what']) ? $_POST['what'] : ''; // The todo that was sent in via the form $priority = isset($_POST['priority']) ? $_POST['priority'] : 'low'; // The priority that was sent in via the form