mysql

Login and Sign up System (PHP, SQL)

2023.05.06

I made login and sign up page using PHP and MySQL. I skip the entire html code this time. Here is the method to pass the data to php files. Let's take a look at Sign up system first. Sign up I checked the email and password confirm first. For connecting this php file to our database we use the code: require_once("config.php"); So, we call the config.php for connecting current php file to databas..

Web Programming 🌏/Database 👩🏻‍🌾

MySQL Command

2023.04.13

User Search at root (루트에서 사용자 조회) USE mysql; SELECT host, user FROM user; Give Privileges at root (루트에서 사용자 권한 부여) GRANT ALL PRIVILEGES on testdb.* TO ‘testuser’@‘localhost’; Check User (현재 사용자확인) SELECT USER(); Check current DB (현재 DB 확인) SELECT DATABASE(); Check the data of sepecific table (특정 TABLE 데이터 확인) SELECT * from (name of table); Check column (Column 확인) EXPLAIN (name of table); OR DES..

Login and Sign up System (PHP, SQL)

MySQL Command

티스토리툴바