Mit MySQL Liedwunsch Website programmieren?

Hi Ich würde gerne mit MySQL eine Liedwunsch Website Bauen. Meine Mutter feiert eine Party und die Gäste sollen sich über die Website Lieder wünschen können. Ich habe einen apache 2 Webserver auf Ubuntu. Ich komme einfach nicht klar mit MySQL. Kann mir irgendjemand helfen? Danke

(2 votes)
Loading...

Similar Posts

Subscribe
Notify of
17 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Waldelb3
11 months ago

You need three components:

  • Database (do you already have – MySQL)
  • Backend (e.g. Python with flask)
  • Frontend (HTML + JS. Evtl. a framework such as React)

The idea is:

  1. the users interact with the front end
  2. the frontend sends the song wishes to the backend
  3. the backend saves everything in the database

The whole thing will probably be around the 300 lines code.

You could also replace the database with a simple text document, that would be a little easier. A database is actually overkill for the purpose. Except of course, you want to use a database.

Waldelb3
11 months ago

How’s that going?

Waldelb3
11 months ago

You need a backend.

Waldelb3
11 months ago

As I said, JS (JavaScript) is what you need to use for the frontend.

bycranix
11 months ago

MySQL is just a database that could store songs in Url’s.

With Javascript, you will then build a website that simultaneously stores the data on the MySQL or you will develop a backend that takes over the administration.

The complete implementation of commenting here would blow the frame.

It’s a cool idea. A friend of mine once made something similar in which he worked with the Spotify API and stored via Backend songs in a Spotify playlist, which were played on another device.

bycranix
11 months ago
Reply to  BoeseKatze5992

If you have any questions, make a decision. 😀

davegarten
11 months ago

Buy a good book on MySQL. Or ask ChatGPT. Or use Visual Studio Code with MS-Copilot Integration.

PHP, JavaScript, HTML and CSS should also be able to be halfway.

Sifadias
11 months ago

The whole thing can be easily implemented with something PHP and the idea is also interesting from the point of view of a hobby developer.

But how do you want to allow access? Do you have a web address that goes to this server? Are all guests on the same network? Are you providing a device?

However, I wonder if your mother’s guests are making the effort with the entry rather than just talking to the “DJ”.

Sifadias
11 months ago
Reply to  BoeseKatze5992

Well, it’s quite easy. In this case, do not even need to pay attention to the security of your source code.