Manuel Pear

Niveau superieur
Sommaire

Create Database

Create Database -- Restoring a database from MDB2 XML

Create Database

When having a schema file, it is a breeze to create a database. Simply do the following:

  1. <?php
  2. require_once 'MDB2/Schema.php';  
  3.  
  4. $options = array( 
  5.    'log_line_break' => '<br>', 
  6.    'idxname_format' => '%s', 
  7.    'debug' => true, 
  8.    'quote_identifier' => true, 
  9.    'force_defaults' => false, 
  10.    'portability' => false  
  11. );  
  12. $dsn = 'mysql://root:@localhost/MDB2Example';  
  13.  
  14. $schema =& MDB2_Schema::factory($dsn, $options);  
  15.  
  16. if (PEAR::isError($schema)) { 
  17.    $error = $schema->getMessage();  
  18. } else { 
  19.    // first run with queries disabled to make sure everything is allright
  20.    $disable_query = true; 
  21.  
  22.    $definition = $schema->parseDatabaseDefinitionFile('example.xml'); 
  23.    if (PEAR::isError($definition)) { 
  24.    $error = $definition->getMessage(); 
  25.    } else { 
  26.    $op = $schema->createDatabase($definition, array(), $disable_query); 
  27.  
  28.    if (PEAR::isError($op)) { 
  29.       $error = $op->getMessage(); 
  30.    } 
  31.    }  
  32. }  
  33.  
  34. if (isset($error)) { 
  35.    var_dump($error);  
  36. }  
  37.  
  38. $schema->disconnect();  
  39.  
  40. ?> 
Niveau superieur
Sommaire

Remonter Remonter
L'éditeur javascript - CSS - Gentoo - Tutoriaux PHP - Tutoriels PHP - Bretagne - php - Moto - Kit graphique