Login   Register  
PHP Classes
elePHPant
Icontem

File: installdb.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Voznyak Nazar  >  MVC Membership System  >  installdb.php  >  Download  
File: installdb.php
Role: Configuration script
Content type: text/plain
Description: installation script
Class: MVC Membership System
Membership system using the MVC design pattern
Author: By
Last change:
Date: 2003-12-30 00:04
Size: 1,911 bytes
 

Contents

Class file image Download
<?php 

// Install MySQL tables

/*** ADOdb library path */
  
define('LIB_ADODB''../../adodb/');

/*** include ADOdb database access class *
 * {@link http://php.weblogs.com/ADOdb/ php.weblogs.com/ADOdb} */
  
require_once LIB_ADODB.'adodb.inc.php';

  
define('DB''../db/');
  require_once 
DB.'dbsetup.inc';
  require_once 
'installdb.inc';

  if (
$result $go_conn->Execute(DROP_ADMINS_TABLE))
      print 
'Admins table were droped successfully<br>';
  else 
    
trigger_error($go_conn->ErrorMsg());

  if (
$result $go_conn->Execute(CREATE_ADMINS_TABLE))
      print 
'Admins table were created successfully<br>';
  else 
    
trigger_error($go_conn->ErrorMsg());

  if (
$result $go_conn->Execute(DROP_MEMBERS_TABLE))
      print 
'Members table were droped successfully<br>';
  else 
    
trigger_error($go_conn->ErrorMsg());

  if (
$result $go_conn->Execute(CREATE_MEMBERS_TABLE))
      print 
'Members table were created successfully<br>';
  else 
    
trigger_error($go_conn->ErrorMsg());

  if (
$result $go_conn->Execute(DROP_PARTNERS_TABLE))
      print 
'Partners table were droped successfully<br>';
  else 
    
trigger_error($go_conn->ErrorMsg());

  if (
$result $go_conn->Execute(CREATE_PARTNERS_TABLE))
      print 
'Partners table were created successfully<br>';
  else 
    
trigger_error($go_conn->ErrorMsg());
 
// test data
  
$result $go_conn->Execute("DELETE FROM admins");
  
$result $go_conn->Execute("INSERT INTO admins VALUES ('root','1')");
  
$result $go_conn->Execute("DELETE FROM partners");
  
$result $go_conn->Execute("INSERT INTO partners VALUES ('narkoza','narkoza',0)");
  
$result $go_conn->Execute("DELETE FROM members");
  
$result $go_conn->Execute("INSERT INTO members VALUES ('narko','narko',0)");

  if (
$result)
      echo 
'Database and tables were created succefully<br>';
  else 
    
trigger_error($go_conn->ErrorMsg());

  echo 
'Done';
?>