topical media & game development

talk show tell print

server-php-micro-db-installer-index.php / php

       Micro DB Installer
       ŠPhpToys 2007
       Released under the terms and conditions of the
       GNU General Public License (
       Revision: 1.0 
       Date: 2007/09/05 
       Author: PhpToys 
            Just copy the files to your webserver with a valid sql file.
            You can configure the sql file name by changing the sqlFileToExecute
  sqlErrorText = '';
  sqlErrorCode = 0;
  sqlStmt      = '';
  sqlFileToExecute = 'test.sql';
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
     <title>Micro DB Installer</title>
     <link href="style/style.css" rel="stylesheet" type="text/css" />
      <div id="main">
        <div class="caption">MICRO DB INSTALLER</div>
        <div id="icon">&nbsp;</div>
        <form action="<?php echo _SERVER['PHP_SELF']; ?>" method="post" name="dbdata">
          <table width="100%">
            <tr><td>Hostname:</td><td><input class="text" name="hostname" type="text" size="20" value="localhost" /></td></tr>
            <tr><td>Username:</td><td> <input class="text" name="username" type="text" size="20" value="" /></td></tr>
            <tr><td>Password:</td><td> <input class="text" name="password" type="password" size="20" value="" /></td></tr>
            <tr><td align="center" colspan="2"><br/><input class="text" type="submit" name="submitBtn" value="Install" /></td></tr>
      if (isset(_POST['submitBtn'])){
          host = isset(_POST['hostname']) ? _POST['hostname'] : '';
          user = isset(_POST['username']) ? _POST['username'] : '';
          pass = isset(_POST['password']) ? _POST['password'] : '';
          con = mysql_connect(host,user,pass);
          if (con !== false){
             // Load and explode the sql file
             f = fopen(sqlFileToExecute,"r+");
             sqlFile = fread(f,filesize(sqlFileToExecute));
             sqlArray = explode(';',sqlFile);
             //Process the sql file by statements
             foreach (sqlArray as stmt) {
                if (strlen(stmt)>3){
                          result = mysql_query(stmt);
                          if (!result){
                             sqlErrorCode = mysql_errno();
                             sqlErrorText = mysql_error();
                             sqlStmt      = stmt;
        <div class="caption">RESULT:</div>
        <div id="icon2">&nbsp;</div>
        <div id="result">
          <table width="100%">
          if (sqlErrorCode == 0){
             echo "<tr><td>Installation was finished succesfully!</td></tr>";
          } else {
             echo "<tr><td>An error occured during installation!</td></tr>";
             echo "<tr><td>Error code: sqlErrorCode</td></tr>";
             echo "<tr><td>Error text: sqlErrorText</td></tr>";
             echo "<tr><td>Statement:<br/> sqlStmt</td></tr>";
          <div id="source">Micro DB Installer 1.0</div>

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.