Build a Website

Completado Publicado hace 7 años Pagado a la entrega
Completado Pagado a la entrega

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\[url removed, login to view] 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

[url removed, login to view] (int), [url removed, login to view] (int)

Diseño gráfico HTML MySQL PHP Diseño de sitios web

Nº del proyecto: #10279643

Sobre el proyecto

3 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

synapcs

Hey, Thank you for the job posting. Albert referred the link to me. I can develop a system where in you can add quotes in backend and they will show up on the front end. Can you please take a few mins to have a qui Más

$500 USD en 10 días
(75 comentarios)
7.5

3 freelancers están ofertando un promedio de $603 por este trabajo

tnavadiya

Hello Sir, I am having a good experience with PHP development and I would like to work on your project. Please let me know when can discuss about your requirement in detail? Tushar

$1058 USD en 20 días
(69 comentarios)
7.1
arslaanshaikh

Hi, i would love to do it for you. And would also assist you with all the possible issues, so in future if you ever wish to do it by yourself, you can happily do it. :) Please tell me about the timeframe and maximum bu Más

$250 USD en 1 día
(15 comentarios)
5.0