Create dynamic sites with PHP & MySQL - Your first database
(Page 7 of 16 )
Now that we have PHP running properly and have created our first script, let's create our first database and see what we can do with it. Drop to console and type in the following command:
mysqladmin -uroot create learndb
This creates a database named "learndb" for us to use. Here we have assumed that you are root user. If you are logged in as another user, just use the command mysqladmin -uusername -pyourpassword create learndb, replacing username and yourpassword with your username and password respectively. If you are hosting your site through a hosting company, you probably don't have permission to run mysqladmin. In this case, you have to ask your server administrator to create the database for you.
Next we will create tables in this database and enter some information. Go to the console. Type:
mysql
You should see something like:
Welcome to MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version 3.22.34 Type 'help' for help.
Type:
CONNECT learndb CREATE TABLE personnel ( id int NOT NULL AUTO_INCREMENT, firstname varchar(25), lastname varchar(20), nick varchar(12), email varchar(35), salary int, PRIMARY KEY (id), UNIQUE id (id) ); INSERT INTO personnel VALUES ('1', 'John', 'Lever', 'John', 'john@everywhere.net', '75000'); INSERT INTO personnel VALUES ('2', 'Camilla', 'Anderson', 'Rose', 'rose@flower.com', '66000');
This creates a table with 5 fields and puts some information in it.
/ 54 