First SQL Project - HTML, Bootstrap, PHP enabling CRUD from web

Overview

DB-Project

First SQL Project with

HTML, Bootstrap, PHP enabling CRUD from web

Java for mocking data, enabling .csv input

Idea

This model corresponds to the idea of theatres as we know them in Vienna.

A theatre has a name, which is enough to be an unique identifier, since there is a very limited number of them. Furthermore, it has an adress, a seating capacity and is either privately or state-funded. A theatre has one or more box offices, which have defined opening hours, a name, a location within the theatre and a webshop for purchasing tickets online.

Performances take place in a theatre, with language, directors a date and name as attributes. There are specific performances, a dance-performance, with a genre, and a classic play, which can premiere. Audience members can experience these performances by buying tickets, with a seating category and an ID, either through the webshop, or physically at the box office.

An audience member can buy multiple tickets, for oneself, or invite along others. Even if he/she buys multiple tickets, if they are bought at the same time, they are part of one transaction. The transaction is defined by an ID, has a date, an amount and a payment method. Audience members can be identified by their automatically assignend customer ID and have a name and an age, aswell as a discount, which can apply if they have a Membership, or are a student or pensioneer.

Modelling

Initial Diagram

Final Diagram rendered by DataGrip based upon actual tables and relations

Implementation

I initially thought about hard coding values for my relations, or generating them from within the java application, but quickly realized that using file imports was a more modular approach. I (hope) the initial workload of configuring the inputs paid off in debugging and changing off table columns. While I handpicked some of the data, to make sense in this context, I let other entries be generated by https://mockaroo.com/. Testing of php was done via a docker-hosted instance. I chose bootstrap for the simplicity and way more elegant appearance.

Deployment

To configure the input of data from .csv(s) via the java application, the files path has to be corrected to the current dir, the csv(s) are contained in the java src dir

Simple Interface for reading and truncating table data is served via the Java main, best suited for large amounts of data, that can easily be configured by changing the .csv(s)

php(s) should run by its own, but certain IDEs might want to cache the bootstrap imports. Idea: enables more specific interaction with data

You might also like...
Symfony Bundle to create HTML tables with bootstrap-table for Doctrine Entities.

HelloBootstrapTableBundle This Bundle provides simple bootstrap-table configuration for your Doctrine Entities. Used bootstrap-table version 1.18.3. I

A first party module to integrate Elastic App Search in Magento 2.
A first party module to integrate Elastic App Search in Magento 2.

A first-party Magento integration for building excellent, relevant search experiences with Elastic App Search. ⚠️ This is a beta version of the client

Raspberry Pi wifi hotspot with an offline-first community portal. Optionally shares internet access over Tor.
Raspberry Pi wifi hotspot with an offline-first community portal. Optionally shares internet access over Tor.

Raspberry Pi wifi hotspot with an offline-first community portal. Optionally shares internet access over Tor.

html-sanitizer is a library aiming at handling, cleaning and sanitizing HTML sent by external users

html-sanitizer html-sanitizer is a library aiming at handling, cleaning and sanitizing HTML sent by external users (who you cannot trust), allowing yo

Sanitize untrustworthy HTML user input (Symfony integration for https://github.com/tgalopin/html-sanitizer)

html-sanitizer is a library aiming at handling, cleaning and sanitizing HTML sent by external users (who you cannot trust), allowing you to store it and display it safely. It has sensible defaults to provide a great developer experience while still being entierely configurable.

Roach-example-project - Example project to demonstrate how to use RoachPHP in a Laravel project.

Example repository to illustrate how to use roach-php/laravel in a Laravel app. Check app/Spiders/FussballdatenSpider.php for an example spider that c

A bot written in PHP which attempts to link IRC with SQL database, allowing for integration between platforms

Valeyard IRC-SQL-GateWay A bot written in PHP which attempts to link IRC with SQL database, allowing for integration between platforms. This bot is mo

A lightweight php class for formatting sql statements. Handles automatic indentation and syntax highlighting.

A lightweight php class for formatting sql statements. Handles automatic indentation and syntax highlighting.

PHP tool to scan ADOdb code for SQL Injections

PHP-Reaper PHP tool to scan ADOdb code for SQL Injections Why The main idea is to be able to detect problems as early as possible, when the code is fr

Owner
null
CRUD PHP, SQL PDO

PHP-Mastering CRUD em PHP usando MySQL PDO; Configure a ficheiro config.php de acordo com a sua configuração da base de dados PHP CRUD using PDO MySQL

BaltonCome 4 Jun 2, 2022
Sistema web para empresa de diseño "Disema", con operaciones básicas CRUD y uso de html, JQ, JS, php y css

Disema System Sistema web para empresa de diseño "Disema", con operaciones básicas CRUD y uso de html, JQ, JS, php y css Para su correcto uso, deberá

null 1 Jan 12, 2022
Learning about - Basic HTML & CSS, JSON, XML, Session & Cookies, CRUD Operations in Php using MySQL and Create MVC from scratch

This Project is based on course CSC 3215. Learning about - Basic HTML & CSS, JSON, XML, Session & Cookies, CRUD Operations in Php using MySQL and Create MVC (Model–View–Controller) from scratch. Just learning about web technologies, Not focusing on UI (Bootstrap or other 3rd-Party UI libraries or frameworks).

Alvi Hasan 5 Sep 21, 2022
This project processes a small database with php all on a web server. This project uses XAMPP to run the web server and the database.

PHP-introduction This project processes a small database with php all on a web server. This project uses XAMPP to run the web server and the database.

Tyler Jacques 1 Jan 6, 2022
Formulário de contato utilizando HTML, CSS, Bootstrap, PHP, Javascript e conexão ao banco de dados MySQL.

Formulário de Contato Tecnologias | Projeto | Licença | ?? Tecnologias Esse projeto foi desenvolvido com as seguintes tecnologias: HTML CSS PHP JavaSc

Douglas Duarte 3 Feb 10, 2022
Sistema de login usando PHP, MySQL(PDO),HTML,CSS e bootstrap

sistemalogin link para entrar no projeto: https://williamsistema.000webhostapp.com/ Sistema de login usando PHP, MySQL(PDO),HTML,CSS e bootstrap Requi

William Lima Alves 4 Oct 7, 2022
the examples of head first object oriented analysis & design - in PHP

Head First object oriented analysis & design in (PHP) after cloning the repository, you have to install the project's dependancies by running the foll

Muhammed ElFeqy 3 Oct 16, 2021
My first attempt at creating my own Rubik's Cube timing interface with PHP and JS!

Cubing Sessions My first attempt at creating my own Rubik's Cube timing interface with PHP and JS! I haved named it the PA Timer for fun, as I hail fr

Adam Gradess 0 Jan 12, 2022
LDAP-OSNAME-CHANGE-ALLOWER - This is my first php, hopefully last.

LDAP-OSNAME-CHANGE-ALLOWER This PHP script allows SELF user to read and write the 'Operating System' property on the target computer/s. How was it dev

Özgün Kültekin 5 Apr 9, 2022
First Data driver for the Omnipay PHP payment processing library

Omnipay: First Data First Data driver for the Omnipay PHP payment processing library Omnipay is a framework agnostic, multi-gateway payment processing

The League of Extraordinary Packages 20 Oct 23, 2022