Subversion Repositories php_guestbook

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

  1. #!/usr/bin/php
  2. <?php
  3.  
  4. if (php_sapi_name() != 'cli') {
  5.         echo "Please run in CLI mode\n";
  6.         exit(1);
  7. }
  8.  
  9. require_once __DIR__ . '/../includes/database.inc.php';
  10. verbinden();
  11.  
  12. $cont = file_get_contents(__DIR__ . '/install.sql');
  13.  
  14. $queries = preg_split('@;\s*\n@ismU', $cont);
  15.  
  16. foreach ($queries as $query) {
  17.         $query = trim($query);
  18.         if ($query == '') continue;
  19.         if (substr($query, 0, 2) == '--') continue;
  20.         $query .= ';';
  21.  
  22.         mysql_query($query);
  23.  
  24.         $err = mysql_error();
  25.         if ($err) {
  26.                 fwrite(STDERR, "mySQL error $err at query $query\n\n");
  27.         }
  28. }
  29.