AdminGui PHP Code Examples

Example #1

0

Show file

File: delete_media_types.php Project: pfv/folio

<?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);
$media_types_records = $gui->select('media_types');
if (!empty($_POST)) {
    $db->table('media_types');
    if ($db->delete($_POST['id'])) {
        header('Location: delete_media_types.php');
        die;
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Delete media types</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
	</head>
	<body style="font-family:Helvetica;font-size:12px">
		<h3>Media types</h3>
		<h4>Delete media type</h4>

		<?php

Example #2

0

Show file

File: delete_techniques.php Project: pfv/folio

<?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">

Example #3

0

Show file

File: create_media_types.php Project: pfv/folio

<?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);
$media_types_records = $gui->select('media_types');
if (!empty($_POST)) {
    $db->table('media_types');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['media_type' => ['required' => true]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_media_types.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create media types</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #4

0

Show file

File: delete_categories.php Project: pfv/folio

<?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);
$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>

Example #5

0

Show file

File: delete_institutions.php Project: pfv/folio

<?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);
$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>

Example #6

0

Show file

File: create_technologies.php Project: pfv/folio

<?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');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['technology' => ['required' => true]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_technologies.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create technologies</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #7

0

Show file

File: create_works.php Project: pfv/folio

<?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);
$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)) {
    $post_works = array_slice($_POST, 0, 2);
    $db->table('works');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($post_works, ['work_title' => ['required' => true], 'work_description' => ['required' => false]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($post_works)) {
            $last_id = $db->lastID();
            if ($_POST['media']) {
                $post_media = $_POST['media'];
                for ($m = 0; $m < count($post_media); $m++) {
                    $insert_media = ['media_id' => $post_media[$m], 'work_id' => $last_id];
                    $db->table('media_for_works')->insert($insert_media);
                }

Example #8

0

Show file

File: delete_prize_types.php Project: pfv/folio

<?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);
$prize_types_records = $gui->select('prize_types');
if (!empty($_POST)) {
    $db->table('prize_types');
    if ($db->delete($_POST['id'])) {
        header('Location: delete_prize_types.php');
        die;
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Delete prize types</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
	</head>
	<body style="font-family:Helvetica;font-size:12px">
		<h3>Prize types</h3>
		<h4>Delete prize type</h4>

		<?php

Example #9

0

Show file

File: delete_exhibition_kinds.php Project: pfv/folio

<?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);
$exhibition_kinds_records = $gui->select('exhibition_kinds');
if (!empty($_POST)) {
    $db->table('exhibition_kinds');
    if ($db->delete($_POST['id'])) {
        header('Location: delete_exhibition_kinds.php');
        die;
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Delete exhibition kinds</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
	</head>
	<body style="font-family:Helvetica;font-size:12px">
		<h3>Exhibition kinds</h3>
		<h4>Delete exhibition kind</h4>

		<?php

Example #10

0

Show file

File: create_collections.php Project: pfv/folio

<?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);
$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)) {
    $post_collections = array_slice($_POST, 0, 3);
    $db->table('collections');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($post_collections, ['type' => ['required' => false], 'collection' => ['required' => true], 'year' => ['required' => false]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($post_collections)) {
            $last_id = $db->lastID();
            if ($_POST['place']) {
                $post_place = $_POST['place'];
                for ($m = 0; $m < count($post_place); $m++) {
                    $insert_place = ['place_id' => $post_place[$m], 'collection_id' => $last_id];
                    $db->table('places_for_collections')->insert($insert_place);
                }
            }

Example #11

0

Show file

File: create_project_types.php Project: pfv/folio

<?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);
$project_types_records = $gui->select('project_types');
if (!empty($_POST)) {
    $db->table('project_types');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['name' => ['required' => true], 'given_name' => ['required' => true]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_project_types.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create project types</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #12

0

Show file

File: delete_events.php Project: pfv/folio

<?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);
$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>

Example #13

0

Show file

File: create_collection_types.php Project: pfv/folio

<?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);
$collection_types_records = $gui->select('collection_types');
if (!empty($_POST)) {
    $db->table('collection_types');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['collection_type' => ['required' => true]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_collection_types.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create collection types</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #14

0

Show file

File: delete_companies.php Project: pfv/folio

<?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>

Example #15

0

Show file

File: delete_projects.php Project: pfv/folio

<?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);
$projects_records = $gui->select('projects');
$project_types_records = $gui->rightJoin('type', 'project_types', 'given_name');
$categories_records = $gui->joinThree('projects', 'categories_for_projects', 'categories', 'category', 'project_id', 'category_id');
$companies_records = $gui->joinThree('projects', 'companies_for_projects', 'companies', 'company', 'project_id', 'company_id');
$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');

Example #16

0

Show file

File: delete_spaces.php Project: pfv/folio

<?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);
$spaces_records = $gui->select('spaces');
$places_records = $gui->joinThree('spaces', 'places_for_spaces', 'places', 'city', 'space_id', 'place_id');
if (!empty($_POST)) {
    $db->table('spaces');
    if ($db->delete($_POST['id'])) {
        $db->table('places_for_spaces');
        $db->deleteWhich($_POST['id'], 'space_id');
        $db->table('spaces_for_exhibitions');
        $db->deleteWhich($_POST['id'], 'space_id');
        header('Location: delete_spaces.php');
        die;
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Delete spaces</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
	</head>

Example #17

0

Show file

File: delete_collection_types.php Project: pfv/folio

<?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);
$collection_types_records = $gui->select('collection_types');
if (!empty($_POST)) {
    $db->table('collection_types');
    if ($db->delete($_POST['id'])) {
        header('Location: delete_collection_types.php');
        die;
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Delete collection types</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
	</head>
	<body style="font-family:Helvetica;font-size:12px">
		<h3>Collection types</h3>
		<h4>Delete collection type</h4>

		<?php

Example #18

0

Show file

File: delete_people.php Project: pfv/folio

<?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>

Example #19

0

Show file

File: update_categories.php Project: pfv/folio

<?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);
$categories_records = array();
if (!empty($_POST)) {
    $db->table('categories');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['category' => ['required' => true, 'unique' => 'categories']]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_categories.php');
            die;
        }
    }
}
if ($results = $db->table('categories')->select()) {
    foreach ($results as $row) {
        $categories_records[] = $row;
    }
}
?>

Example #20

0

Show file

File: create_categories.php Project: pfv/folio

<?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);
$categories_records = $gui->select('categories');
if (!empty($_POST)) {
    $db->table('categories');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['category' => ['required' => true, 'unique' => 'categories']]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_categories.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create categories</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #21

0

Show file

File: create_people.php Project: pfv/folio

<?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');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['name' => ['required' => true], 'website' => ['required' => false], 'description' => ['required' => false]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_people.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create people</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #22

0

Show file

File: create_companies.php Project: pfv/folio

<?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');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['company' => ['required' => true], 'website' => ['required' => false], 'description' => ['required' => false], 'year_start' => ['required' => true], 'year_end' => ['required' => false]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        echo '<pre>', print_r($_POST), '</pre>';
        if ($db->insert($_POST)) {
            header('Location: create_companies.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create companies</title>

Example #23

0

Show file

File: create_exhibition_kinds.php Project: pfv/folio

<?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);
$exhibition_kinds_records = $gui->select('exhibition_kinds');
if (!empty($_POST)) {
    $db->table('exhibition_kinds');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['exhibition_kind' => ['required' => true]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_exhibition_kinds.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create exhibition kinds</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #24

0

Show file

File: delete_works.php Project: pfv/folio

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

Example #25

0

Show file

File: create_functions.php Project: pfv/folio

<?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');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['function' => ['required' => true, 'unique' => 'functions']]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($_POST)) {
            header('Location: create_functions.php');
            die;
        }
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Create functions</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">

Example #26

0

Show file

File: delete_exhibitions.php Project: pfv/folio

<?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);
$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');

Example #27

0

Show file

File: delete_places.php Project: pfv/folio

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

Example #28

0

Show file

File: create_spaces.php Project: pfv/folio

<?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);
$spaces_records = $gui->select('spaces');
$places_records = $gui->joinThree('spaces', 'places_for_spaces', 'places', 'city', 'space_id', 'place_id');
if (!empty($_POST)) {
    $post_space = $_POST['space'];
    $db->table('spaces');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($_POST, ['space' => ['required' => true]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        $insert_space = ['space' => $post_space];
        if ($db->insert($insert_space)) {
            $last_id = $db->lastID();
            if ($_POST['place']) {
                $post_place = $_POST['place'];
                for ($m = 0; $m < count($post_place); $m++) {
                    $insert_place = ['place_id' => $post_place[$m], 'space_id' => $last_id];
                    $db->table('places_for_spaces')->insert($insert_place);
                }
            }
            header('Location: create_spaces.php');

Example #29

0

Show file

File: delete_exhibition_types.php Project: pfv/folio

<?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);
$exhibition_types_records = $gui->select('exhibition_types');
if (!empty($_POST)) {
    $db->table('exhibition_types');
    if ($db->delete($_POST['id'])) {
        header('Location: delete_exhibition_types.php');
        die;
    }
}
?>

<!doctype html>
	<html>
	<head>
		<title>Delete exhibition types</title>
		<link rel="stylesheet" type="text/css" href="../../public/front/css/admin.css">
	</head>
	<body style="font-family:Helvetica;font-size:12px">
		<h3>Exhibition types</h3>
		<h4>Delete exhibition type</h4>

		<?php

Example #30

0

Show file

File: create_projects.php Project: pfv/folio

<?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);
$projects_records = $gui->select('projects');
$project_types_records = $gui->rightJoin('type', 'project_types', 'given_name');
$categories_records = $gui->joinThree('projects', 'categories_for_projects', 'categories', 'category', 'project_id', 'category_id');
$companies_records = $gui->joinThree('projects', 'companies_for_projects', 'companies', 'company', 'project_id', 'company_id');
$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)) {
    $post_projects = array_slice($_POST, 0, 8);
    $db->table('projects');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($post_projects, ['type' => ['required' => true], 'project' => ['required' => true], 'short_description' => ['required' => false], 'long_description' => ['required' => false], 'year_start' => ['required' => true], 'year_end' => ['required' => false], 'priority' => ['required' => true], 'active' => ['required' => true]]);
    if ($validation->fails()) {

PHP AdminGui Examples