<?php ob_start(); date_default_timezone_set('UTC'); ini_set('session.gc_maxlifetime', 3600); ini_set('session.cookie_lifetime', 3600); use Phonebook\Component\NamespaceAutoLoader, Phonebook\Component\Registry, Phonebook\Component\DB, PhoneBook\Component\Router; require $_SERVER['DOCUMENT_ROOT'] . '/private/vendor/PhoneBook/Component/NamespaceAutoLoader.php'; $namespaceAutoLoader = new NamespaceAutoLoader(); $namespaceAutoLoader->setVendorPath($_SERVER['DOCUMENT_ROOT'] . '/private/vendor/'); $namespaceAutoLoader->register(); Registry::addArray(['db-host' => 'localhost', 'db-user' => 'root', 'db-pass' => '', 'db-name' => 'phonebook', 'router' => new Router($_SERVER['REQUEST_URI']), 'route-map' => ['/' => ['action' => 'index'], '/search/(.+)' => ['action' => 'search'], '/add/record/' => ['action' => 'add.record'], '/post/add/record/' => ['action' => 'post.add.record'], '/edit/record/([0-9]+)/' => ['action' => 'edit.record.[id]'], '/post/edit/record/([0-9]+)/' => ['action' => 'post.edit.record.[id]'], '/remove/record/([0-9]+)/' => ['action' => 'remove.record.[id]']]]); $db = new DB(); $db->connectionSetup(['db-driver' => 'mysql', 'db-host' => Registry::get('db-host'), 'db-name' => Registry::get('db-name'), 'db-user' => Registry::get('db-user'), 'db-pass' => Registry::get('db-pass')]); Registry::add('db', $db);
<?php use PhoneBook\Component\Registry, PhoneBook\DataSource\PhoneBook as PhoneBookDataSource; $recordID = Registry::get('router')->getSegmentByID(3); PhoneBookDataSource::removeRecordByID($recordID); $location = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '/'; header('location: ' . $location);
public static function removeRecordByID($userID) { /** @var $dbInstance PDO */ $dbInstance = Registry::get('db')->getInstance(); $sth = $dbInstance->prepare(' DELETE FROM `user-list` WHERE id = :userID; DELETE FROM `phone-list` WHERE user_id = :userID; '); $sth->bindParam(':userID', $userID, PDO::PARAM_INT); $sth->execute(); }