PHP Classes

File: create_test_db.php

Recommend this page to a friend!
  Classes of ian james   User Auth Mgr   create_test_db.php   Download  
File: create_test_db.php
Role: Auxiliary script
Content type: text/plain
Description: create test DB
Class: User Auth Mgr
Create and manage user records in a MySQL database
Author: By
Last change:
Date: 14 years ago
Size: 803 bytes
 

Contents

Class file image Download
<?php

require_once (dirname(__FILE__) . "/config.php");

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

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

/* DROP existing database
 */
$sql = "DROP DATABASE IF EXISTS $database";
if (mysql_query($sql, $link)) {
    echo "Database '$database' dropped successfully\n";
} else {
    echo 'Error dropping database: ' . mysql_error() . "\n";
}

/* CREATE database
 */
$sql = "CREATE DATABASE $database";
if (mysql_query($sql, $link)) {
    echo "Database '$database' created successfully\n";
} else {
    echo 'Error creating database: ' . mysql_error() . "\n";
}

mysql_close($link);

?>