Learning PHP and MySQL

Example 13-6 Creating the users table to store login information

CREATE  TABLE  `users`  (
`user_id`  INT  NOT  NULL  AUTO_INCREMENT,
`first_name`  VARCHAR(100),
`last_name`  VARCHAR(100),
`username`  VARCHAR(45),
`password`  CHAR(32), PRIMARY  KEY  (`user_id`));

This code returns:

Query  OK,  0  rows  affected  (0.23  sec)

Posted by on 09/25 at 11:28 AM

Next entry: Example 13-7 Creating the entry in the database for a user with an encrypted password

Previous entry: Example 13-5 Checking the values returned from the authentication prompt

<< Back to main