<?php
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$places_records = $gui->select('places');
if (!empty($_POST)) {
$db->table('places');
if ($db->delete($_POST['id'])) {
$db->table('places_for_collections');
$db->deleteWhich($_POST['id'], 'place_id');
$db->table('places_for_events');
$db->deleteWhich($_POST['id'], 'place_id');
$db->table('places_for_exhibitions');
$db->deleteWhich($_POST['id'], 'place_id');
$db->table('places_for_institutions');
$db->deleteWhich($_POST['id'], 'place_id');
$db->table('places_for_prizes');
$db->deleteWhich($_POST['id'], 'place_id');
$db->table('places_for_projects');
$db->deleteWhich($_POST['id'], 'place_id');
$db->table('places_for_spaces');
$db->deleteWhich($_POST['id'], 'place_id');
header('Location: delete_places.php');
die;
}
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$institutions_records = $gui->select('institutions');
$places_records = $gui->joinThree('institutions', 'places_for_institutions', 'places', 'city', 'institution_id', 'place_id');
if (!empty($_POST)) {
$db->table('institutions');
if ($db->delete($_POST['id'])) {
$db->table('places_for_institutions');
$db->deleteWhich($_POST['id'], 'institution_id');
$db->table('institutions_for_collections');
$db->deleteWhich($_POST['id'], 'institution_id');
$db->table('institutions_for_exhibitions');
$db->deleteWhich($_POST['id'], 'institution_id');
$db->table('institutions_for_prizes');
$db->deleteWhich($_POST['id'], 'institution_id');
header('Location: delete_institutions.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<?php
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$techniques_records = $gui->select('techniques');
if (!empty($_POST)) {
$db->table('techniques');
if ($db->delete($_POST['id'])) {
$db->table('techniques_for_projects');
$db->deleteWhich($_POST['id'], 'technique_id');
$db->table('techniques_for_works');
$db->deleteWhich($_POST['id'], 'technique_id');
header('Location: delete_techniques.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Delete techniques</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
</head>
<body style="font-family:Helvetica;font-size:12px">
<?php
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$technologies_records = $gui->select('technologies');
if (!empty($_POST)) {
$db->table('technologies');
if ($db->delete($_POST['id'])) {
$db->table('technologies_for_projects');
$db->deleteWhich($_POST['id'], 'technology_id');
$db->table('technologies_for_works');
$db->deleteWhich($_POST['id'], 'technology_id');
header('Location: delete_technologies.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Delete technologies</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
</head>
<body style="font-family:Helvetica;font-size:12px">
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$categories_records = $gui->select('categories');
if (!empty($_POST)) {
// echo '<pre>',print_r($_POST['id']),'</pre>';
$db->table('categories');
if ($db->delete($_POST['id'])) {
$db->table('categories_for_projects');
$db->deleteWhich($_POST['id'], 'category_id');
$db->table('categories_for_works');
$db->deleteWhich($_POST['id'], 'category_id');
header('Location: delete_categories.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Delete categories</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
</head>
<body style="font-family:Helvetica;font-size:12px">
$exhibitions_records = $gui->select('exhibitions');
$exhibition_types_records = $gui->rightJoin('type', 'exhibition_types', 'exhibition_type');
$exhibition_kinds_records = $gui->rightJoin('kind', 'exhibition_kinds', 'exhibition_kind');
$events_records = $gui->joinThree('exhibitions', 'events_for_exhibitions', 'events', 'event', 'exhibition_id', 'event_id');
$spaces_records = $gui->joinThree('exhibitions', 'spaces_for_exhibitions', 'spaces', 'space', 'exhibition_id', 'space_id');
$places_records = $gui->joinThree('exhibitions', 'places_for_exhibitions', 'places', 'city', 'exhibition_id', 'place_id');
$projects_records = $gui->joinThree('exhibitions', 'exhibitions_for_projects', 'projects', 'project', 'exhibition_id', 'project_id');
$institutions_records = $gui->joinThree('exhibitions', 'institutions_for_exhibitions', 'institutions', 'institution', 'exhibition_id', 'institution_id');
$people_org_records = $gui->joinThree('exhibitions', 'people_for_exhibitions_org', 'people', 'name', 'exhibition_id', 'person_id');
$people_curatorship_records = $gui->joinThree('exhibitions', 'people_for_exhibitions_curatorship', 'people', 'name', 'exhibition_id', 'person_id');
$people_participants_records = $gui->joinThree('exhibitions', 'people_for_exhibitions_participants', 'people', 'name', 'exhibition_id', 'person_id');
if (!empty($_POST)) {
$db->table('exhibitions');
if ($db->delete($_POST['id'])) {
$db->table('events_for_exhibitions');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('spaces_for_exhibitions');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('places_for_exhibitions');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('projects_for_exhibitions');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('institutions_for_exhibitions');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('people_for_exhibitions_org');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('people_for_exhibitions_curatorship');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('people_for_exhibitions_participants');
$db->deleteWhich($_POST['id'], 'exhibition_id');
$db->table('exhibitions_for_projects');
$techniques_records = $gui->joinThree('projects', 'techniques_for_projects', 'techniques', 'technique', 'project_id', 'technique_id');
$technologies_records = $gui->joinThree('projects', 'technologies_for_projects', 'technologies', 'technology', 'project_id', 'technology_id');
$places_records = $gui->joinThree('projects', 'places_for_projects', 'places', 'city', 'project_id', 'place_id');
$media_records = $gui->joinThree('projects', 'media_for_projects', 'media', 'media_title', 'project_id', 'media_id');
$works_records = $gui->joinThree('projects', 'works_for_projects', 'works', 'work_title', 'project_id', 'work_id');
$functions_records = $gui->joinThree('projects', 'functions_for_projects', 'functions', 'function', 'project_id', 'function_id');
$people_authors_records = $gui->joinThree('projects', 'people_for_projects_author', 'people', 'name', 'project_id', 'person_id');
$people_collaborators_records = $gui->joinThree('projects', 'people_for_projects_collaboration', 'people', 'name', 'project_id', 'person_id');
$exhibitions_records = $gui->joinThree('projects', 'exhibitions_for_projects', 'exhibitions', 'exhibition', 'project_id', 'exhibition_id');
$prizes_records = $gui->joinThree('projects', 'prizes_for_projects', 'prizes', 'name', 'project_id', 'prize_id');
$collections_records = $gui->joinThree('projects', 'collections_for_projects', 'collections', 'collection', 'project_id', 'collection_id');
if (!empty($_POST)) {
$db->table('projects');
if ($db->delete($_POST['id'])) {
$db->table('categories_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('companies_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('techniques_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('technologies_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('places_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('media_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('works_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('functions_for_projects');
$db->deleteWhich($_POST['id'], 'project_id');
$db->table('people_for_projects_author');
<?php
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$people_records = $gui->select('people');
if (!empty($_POST)) {
$db->table('people');
if ($db->delete($_POST['id'])) {
$db->table('people_for_exhibitions_curatorship');
$db->deleteWhich($_POST['id'], 'person_id');
$db->table('people_for_exhibitions_org');
$db->deleteWhich($_POST['id'], 'person_id');
$db->table('people_for_exhibitions_participants');
$db->deleteWhich($_POST['id'], 'person_id');
$db->table('people_for_projects_author');
$db->deleteWhich($_POST['id'], 'person_id');
$db->table('people_for_projects_collaboration');
$db->deleteWhich($_POST['id'], 'person_id');
header('Location: delete_people.php');
die;
}
}
?>
<!doctype html>
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$works_records = $gui->select('works');
$media_records = $gui->joinThree('works', 'media_for_works', 'media', 'media_title', 'work_id', 'media_id');
$categories_records = $gui->joinThree('works', 'categories_for_works', 'categories', 'category', 'work_id', 'category_id');
$techniques_records = $gui->joinThree('works', 'techniques_for_works', 'techniques', 'technique', 'work_id', 'technique_id');
$technologies_records = $gui->joinThree('works', 'technologies_for_works', 'technologies', 'technology', 'work_id', 'technology_id');
if (!empty($_POST)) {
$db->table('works');
if ($db->delete($_POST['id'])) {
$db->table('media_for_works');
$db->deleteWhich($_POST['id'], 'work_id');
$db->table('categories_for_works');
$db->deleteWhich($_POST['id'], 'work_id');
$db->table('techniques_for_works');
$db->deleteWhich($_POST['id'], 'work_id');
$db->table('technologies_for_works');
$db->deleteWhich($_POST['id'], 'work_id');
$db->table('works_for_projects');
$db->deleteWhich($_POST['id'], 'work_id');
header('Location: delete_works.php');
die;
}
}
?>
<!doctype html>
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$events_records = $gui->select('events');
$places_records = $gui->joinThree('events', 'places_for_events', 'places', 'city', 'event_id', 'place_id');
if (!empty($_POST)) {
$db->table('events');
if ($db->delete($_POST['id'])) {
$db->table('places_for_events');
$db->deleteWhich($_POST['id'], 'event_id');
$db->table('events_for_exhibitions');
$db->deleteWhich($_POST['id'], 'event_id');
header('Location: delete_events.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Delete events</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
</head>
<body>
<?php
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$companies_records = $gui->select('companies');
if (!empty($_POST)) {
$db->table('companies');
if ($db->delete($_POST['id'])) {
$db->table('companies_for_projects');
$db->deleteWhich($_POST['id'], 'company_id');
header('Location: delete_companies.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Delete companies</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
</head>
<body style="font-family:Helvetica;font-size:12px">
<h3>Companies</h3>
<h4>Delete company</h4>
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$collections_records = $gui->select('collections');
$collection_types_records = $gui->rightJoin('type', 'collection_types', 'collection_type');
$places_records = $gui->joinThree('collections', 'places_for_collections', 'places', 'city', 'collection_id', 'place_id');
$institutions_records = $gui->joinThree('collections', 'institutions_for_collections', 'institutions', 'institution', 'collection_id', 'institution_id');
if (!empty($_POST)) {
$db->table('collections');
if ($db->delete($_POST['id'])) {
$db->table('places_for_collections');
$db->deleteWhich($_POST['id'], 'collection_id');
$db->table('institutions_for_collections');
$db->deleteWhich($_POST['id'], 'collection_id');
$db->table('collections_for_projects');
$db->deleteWhich($_POST['id'], 'collection_id');
header('Location: delete_collections.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Delete collections</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$prizes_records = $gui->select('prizes');
$prize_types_records = $gui->rightJoin('type', 'prize_types', 'prize_type');
$places_records = $gui->joinThree('prizes', 'places_for_prizes', 'places', 'city', 'prize_id', 'place_id');
$institutions_records = $gui->joinThree('prizes', 'institutions_for_prizes', 'institutions', 'institution', 'prize_id', 'institution_id');
if (!empty($_POST)) {
$db->table('prizes');
if ($db->delete($_POST['id'])) {
$db->table('places_for_prizes');
$db->deleteWhich($_POST['id'], 'prize_id');
$db->table('institutions_for_prizes');
$db->deleteWhich($_POST['id'], 'prize_id');
$db->table('prizes_for_projects');
$db->deleteWhich($_POST['id'], 'prize_id');
header('Location: delete_prizes.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Delete prizes</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
<?php
require '../../classes/Database.php';
require '../../classes/Validator.php';
require '../../classes/ErrorHandler.php';
require '../../classes/AdminGui.php';
require '../../functions/security.php';
$errorHandler = new ErrorHandler();
$db = new Database();
$gui = new AdminGui($db);
$functions_records = $gui->select('functions');
if (!empty($_POST)) {
$db->table('functions');
if ($db->delete($_POST['id'])) {
$db->table('functions_for_projects');
$db->deleteWhich($_POST['id'], 'function_id');
header('Location: delete_functions.php');
die;
}
}
?>
<!doctype html>
<html>
<head>
<title>Create functions</title>
<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
</head>
<body style="font-family:Helvetica;font-size:12px">
<h3>Functions</h3>
<h4>Delete function</h4>