How do i store data from a form input to mySQL database?

Question

Haven't the slightest idea. Is php required for this?

Answer 1

Learn about HTML forms first, the most important attribute "action" in particular, as it is the one that defines where the data is to be transported/sent.

Next learn SQL basics, you will need that to command the database server, learn how to establish a connection to the server, execute SQL queries to create or alter database and/or tables, select, insert, update or delete records, and so on.

In a simple way, when the HTML form is submitted, the values in the form will be sent to a back-end code in the server, then the back-end code will process the request.

Note that modern web technology utilizes asynchronous operations, where data can be transferred to and from a server without having to reload a page, in order to reduce network transfer load, and better user experience, you will get there eventually, I'm not qualified to that yet, still learning : )

In the meantime, here are some resources to begin with:

[HTML forms]
https://www.w3schools.com/html/html_forms.asp

[PDO Tutorial for MySQL developers]
http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers

Hth, cmiiw

Answer 2

of course php is essential for this

Answer 3

can I learn python instead of php? For back end development.

Answer 4

Can anyone really answer my question?