Build a Website

Quotations Database Requires PHP, MariaDB I wish to have a program that allows me to enter quotes, authors, and also to 'tag' the quotes into categories (can be multiple tags per quotation). (Eventually, I would like to have the quote database on one server and call an output page on another website to display a quote, but this is not part of the current project.) There should be an administration page that allows me to add, edit, delete quotations, quote authors, and tags (quote categories) There should be a display page that will display a random quotation or a random quotation based on a tag. For example: loading the page <website>\quotes\[login to view URL] would load a random quote based on whatever category 1 is. The display page does not need to be 'fancy' or templated. Can simply 'echo' a quote to the screen from a small php script. An example output page would be: The most beautiful thing we can experience is the mysterious. It is the source of all true art and science. - Albert Einstein The script should handle the error if a non-numerical tag is used or if a number is used that is unassigned. I request a join table be used to associate quotes with tags unless you can explain a better way to associate a quote with multiple tags prior to accepting the work. Adding a quote should allow me to associate the new quote with 0 to all of the available tags (categories), preferably using check boxes Editing a quote should allow me to change the quote, the author, and which tags the quotation is associated with. Please ensure good coding standards are used, please use (at least minimal) descriptions in functions that are not self-explanatory, please do not directly output html from php and do not include php inside an html file. Also, please escape out variables before writing them to the database. Deliverables include full php script, html, and specific installation instructions. Please feel free to ask questions. Please let me know in your bid that you've read the requirements. Let me know if you have suggestions or ideas for improvement. I prefer the authors be kept in a separate table, as opposed to being entered each time a quote is entered, so that a little bit of information can be entered on the author. (The following is given more as explanation) Database: Quotes Table 1: Quote .id (int), quotetext (text), author (small text) Table 2: Author .id (int), Authorname (small text), Author Info (text) Table 3: Tags .id (int), tagname (small text) [ Example: 1 : Inspirational 2 : Educational 3 : Humor 4 : Political 5 : Satire ] Table 4: quote_tag [login to view URL] (int), [login to view URL] (int)