Location: PHPKode > projects > TEMS -Time and Expense Management System > tems/install/CreateDatabase.php
<?php

/*********************************************************************************
 * TES is a Time and Expense Management program developed by
 * Initechs, LLC. Copyright (C) 2009 - 2010 Initechs LLC.
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY INITECHS, INITECHS DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
 * details.
 *
 * You should have received a copy of the GNU General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact Initechs headquarters at 1841 Piedmont Road, Suite 301,
 * Marietta, GA, USA. or at email address hide@address.com
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU General Public License version 3,
 * these Appropriate Legal Notices must retain the display od the "Initechs" logo.
 * If the display of the logo is not reasonably feasible for technical reasons,
 * the Appropriate Legal Notices must display the words "Powered by Initechs".

 ********************************************************************************/
$basedir = dirname(__FILE__) . '/..';
require_once("$basedir/install/DatabaseSQL.php");
require_once("$basedir/initialize.php");


class InstallDatabase
{
	public function CreateNewDatabase($db_server, $db_database, $db_admin_user, $db_admin_password, $db_user, $db_password)
	{
		
		try
		{
			$con = mysql_connect($db_server, $db_admin_user, $db_admin_password);		// Connect to database
			if (!$con)
			{
				throw new iBLError('nocategory', '',  mysql_error()."<br />Check database server name, Admin user id, and Admin password");
			}

			$db_selected = mysql_select_db($db_database, $con);
			if (!$db_selected)		// If database does not exist, create it and 
			{
				$querySuccessful = mysql_query("CREATE DATABASE $db_database", $con);	// Create database
				if (!$querySuccessful)
				{
					throw new iBLError('nocategory', '',  mysql_error($con)."<br />$db_admin_user may not have database create authority.");
				}
				
				$this->BuildNewDB($con, $db_database);			// Build new database
			}

			$this->GrantDatabaseAuthority($con, $db_server, $db_database, $db_admin_user, $db_admin_password, $db_user, $db_password);

			mysql_close($con);
		}

		catch (Exception $e)
		{
			throw $e;
		}
	}

	
	public function BuildNewDB($con, $db_database)
	{
		global $table, $view, $tableData;
		
		try
		{
			$db_selected = mysql_select_db($db_database, $con);			// Set current database
			if (!$db_selected)
			{
				throw new iBLError('nocategory', '',  mysql_error($con));
			}
			
			foreach ($table as $tablename => $sql)			// Create tables
			{
				mysql_query($sql, $con);
				if (mysql_error($con) <> null)
				{
					throw new iBLError('nocategory', '',  mysql_error($con));
				}
			}

			foreach ($view as $viewname => $sql)			// Create views
			{
				mysql_query($sql, $con);
				if (mysql_error($con) <> null)
				{
					throw new iBLError('nocategory', '',  mysql_error($con));
				}
			}

			foreach ($tableData as $tableName => $fieldnvalues)		// Insert records to the system tables.
			{
				$sql = "INSERT INTO $tableName ({$fieldnvalues['fields']}) VALUES {$fieldnvalues['values']}";
				mysql_query($sql, $con);
				if (mysql_error($con) <> null)
				{
					throw new iBLError('nocategory', '',  mysql_error($con)."<br/>".$sql);
				}
			}
		}

		catch (Exception $e)
		{
			throw $e;
		}
	}
	
	
	public function GrantDatabaseAuthority($connection, $db_server, $db_database, $db_admin_user, $db_admin_password, $db_user, $db_password)
	{
		try
		{
			// Grant appropriate authorities to the database admin user
			$authority = "GRANT ALL
						ON $db_database.*
						TO '$db_admin_user'@'$db_server'
						IDENTIFIED BY '$db_admin_password'";

			mysql_query($authority, $connection);

			if ($db_user <> null)
			{
				// Grant appropriate authorities to the normal database user
				$authority = "GRANT SELECT, UPDATE, INSERT, DELETE
							ON $db_database.*
							TO '$db_user'@'$db_server'
							IDENTIFIED BY '$db_password'";

				mysql_query($authority, $connection);		// Grant appropriate authorities to the database user
			}
		}

		catch (Exception $e)
		{
			throw $e;
		}
			
	}
}


?>
Return current item: TEMS -Time and Expense Management System