PHP - creating database and connection

29/3

site name: projek2 - letak di c:/xampp/htdocs/
database: info - letak di c:/xampp/mysql/data/

1.       Stop IIS

2.       Start xamp

3.       Check //localhost

4.       Change password for root

a.       Default root pasword – none

b.      Set password according to the previous activity

5.       Restart localhost

6.       Set database

phpmyadmin

7.       Point to your database

8.       Rule of thumb for field  (+1)  (for primary key)

a.       Autoincrement id (automatic)

b.      Unique key (not automatic)

Varchar – need to set the length

Null – depends whether can be blank or not

9.       Browse table for structure

1.       Create database

 

c. create site

1.       Name the site

 

  

D. Create a connection