+ 2

About creating database

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

23rd Dec 2017, 4:24 PM
Shivam Mirje
Shivam Mirje - avatar
10 Respostas
+ 2
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. ....... ....... .......
23rd Dec 2017, 4:53 PM
Daniel
Daniel - avatar
0
In PHPMyAdmin you only must to use interface to make database and next tables with fields
23rd Dec 2017, 4:33 PM
Daniel
Daniel - avatar
0
@Daniel then why is there ' import ' in phpmyadmin
23rd Dec 2017, 4:35 PM
Shivam Mirje
Shivam Mirje - avatar
0
Because you can do importing too
23rd Dec 2017, 4:36 PM
Daniel
Daniel - avatar
0
@Daniek that's my question we can import files for what? and what is their extension?
23rd Dec 2017, 4:37 PM
Shivam Mirje
Shivam Mirje - avatar
23rd Dec 2017, 4:38 PM
Daniel
Daniel - avatar
0
ok you could have a complete database in .sql file or only a table, procedures or even only values to insert rows
23rd Dec 2017, 4:39 PM
Daniel
Daniel - avatar
0
You could have a .sql file to update too
23rd Dec 2017, 4:39 PM
Daniel
Daniel - avatar
0
Anyway, any SQL code you could copy/paste in SQL option into PHPMyAdmin too
23rd Dec 2017, 4:40 PM
Daniel
Daniel - avatar
0
@ 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?
23rd Dec 2017, 4:44 PM
Shivam Mirje
Shivam Mirje - avatar