Login   Register  
PHP Classes
elePHPant
Icontem

File: create_user_auth_table.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of ian james  >  User Auth Mgr  >  create_user_auth_table.php  >  Download  
File: create_user_auth_table.php
Role: Auxiliary script
Content type: text/plain
Description: create main auth table
Class: User Auth Mgr
Create and manage user records in a MySQL database
Author: By
Last change:
Date: 2010-10-08 22:11
Size: 1,693 bytes
 

Contents

Class file image Download
<?php
// !!!!!!!!!!!! DO NOT TOUCH !!!!!!!!!!
// ask ian first
// mysql> describe users;
// +----------+--------------+------+-----+---------+----------------+
// | Field    | Type         | Null | Key | Default | Extra          |
// +----------+--------------+------+-----+---------+----------------+
// | uid      | bigint(20)   | NO   | PRI | NULL    | auto_increment |
// | fname    | varchar(100) | YES  |     | NULL    |                |
// | lname    | varchar(100) | YES  |     | NULL    |                |
// | email    | varchar(100) | NO   | UNI | NULL    |                |
// | password | varchar(45)  | YES  |     | NULL    |                |
// +----------+--------------+------+-----+---------+----------------+
// 
require_once (dirname(__FILE__) .  "/config.php");

$dbhost=$GLOBALS['dbhost'];
$dbuser=$GLOBALS['dbuser'];
$dbpass=$GLOBALS['dbpass'];
$database=$GLOBALS['dbname'];
$user_tbl = $GLOBALS['user_table'];

$link = mysql_connect($dbhost,$dbuser,$dbpass);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo "Connected successfully\n";

/* ------------------- 
 */
$sql = "CREATE  TABLE IF NOT EXISTS $database.$user_tbl (
  uid BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'uid' ,
  fname VARCHAR(100) NULL ,
  lname VARCHAR(100) NULL ,
  email VARCHAR(100) UNIQUE NOT NULL COMMENT 'real user name used for login credentials' ,
  password VARCHAR(45) NULL ,
  PRIMARY KEY (uid))
ENGINE = InnoDB";

if (mysql_query($sql, $link)) {
    echo "'$database' table '$user_tbl' created successfully\n";
} else {
    echo 'Error creating table : ' . mysql_error() . "\n";
}

echo "DONE: '$database' ALL tables created successfully\n";
mysql_close($link);

?>