About creating database

Question

How to create database in PHPmyadmin and direct our php files to our database?
Answer me with an example.

Answer 1

You must to begin to practice and learn very much.

You can use HTML and CSS for design, PHP and SQL for operation with database.

1 - Design with HTML and CSS (you can use others like Javascript and/or Jquery). You must to prepare a small form to login.

2 - Make a database for example with a table user: ID, email, name, username, password, etc

3 - Insert some users by PHPMyAdmin and encrypt for example password with MD5.

4 - Prepare PHP to connect to database and check input login from user with user table.
.......
.......
.......

Answer 2

In PHPMyAdmin you only must to use interface to make database and next tables with fields

Answer 3

@Daniel then why is there ' import ' in phpmyadmin

Answer 4

Because you can do importing too

Answer 5

@Daniek that's my question we can import files for what? and what is their extension?

Answer 6

and by PHP please check it
https://www.w3schools.com/PhP/php_mysql_create.asp

Answer 7

ok you could have a complete database in .sql file or only a table, procedures or even only values to insert rows

Answer 8

You could have a .sql file to update too

Answer 9

Anyway, any SQL code you could copy/paste in SQL option into PHPMyAdmin too

Answer 10

@ Daniel sry for asking again :)
So if we want to create a website like facebook then what do we have to do to get our user's names passwords saved in our tables of DB? How do we attach our html file ,php file, database altogether?