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: 4 years ago
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);

?>