Doubt on mySQL - Write, Update and Show Data

1

Talk the guys! I have a doubt. I've created a static page that will show some data. For example, I want to show the live score of a specific football game.
Example" Show Data "- Static Page

I thought about creating a static page with:

  • "Championship Name"
  • "Team A Name"
  • "Team A badge" (Image)
  • "Team B Name"
  • "Team B badge" (Image)
  • "Game result"

To facilitate data entry I thought about building a form to insert this information into a database. But I am in doubt if this is the best way to run.

1 - Can I create a "Insert Data" page, leave pre-registered teams / championships and select through a form with check box? For example:

Page"Insert Data" - Form

2 - When sending the form above does it always replace the row in the table? So the display page would always fetch the same data?

Thank you for your attention.

    
asked by anonymous 28.09.2015 / 16:28

1 answer

0

Only with HTML and MySQL do not - you'll need to have another technology in the middle - a backend programming language: be it Python, PHP, or another.

It may be possible to do something by directly connecting the html-5 Javascript to the database - however I do not see muta getne doing this, and would be something inherently insecure: if you try to do this the greater chance is that of unrestricted access to anyone in your entire database. (it's possible to do "right" but it will require a level of personalization of your database and data quite different from the common use of banks and would require far more expertise than, say, developing what you need in PHP or using a Python framework like Flask or Web2Py)

    
28.09.2015 / 16:55