<?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();
}
