page2.php

<?php

echo file_get_contents("page_top");

if(!isset($_POST['database_file'])) {

    $mysql_connect_id = mysql_connect($_POST['host'], $_POST['username'], $_POST['password']);

    // Check for connection and error if failed
    if(!$mysql_connect_id) {
?>
        <p>Sorry, the attempt to connect to the host has failed. MySQL reports the following error - 
             <?php echo mysql_errno($mysql_connect_id) . " - " . mysql_error($mysql_connect_id); ?></p>
<?php
    }

    $query = "create database if not exists " . $_POST['database_name'];

    $query_response = mysql_query($query);			

    if(!$query_response){
?>
    <p>Sorry, the attempt to create the database to the database has failed. MySQL reports the following error - 
<?php 
        echo mysql_errno($mysql_connect_id) . " - " . mysql_error($mysql_connect_id);?>
    </p>
<?php 
    }

    $query = "USE " . $_POST['database_name'];

    $query_response = mysql_query($query);			

    if(!$query_response){
?>
    <p>Sorry, the attempt to specify which database we need to work on (the MySQL keyword - USE) has failed. MySQL reports the following error - 
<?php 
        echo mysql_errno($mysql_connect_id) . " - " . mysql_error($mysql_connect_id); echo "The query response was " . $query_response . "<br></p>"; 
    }

    $temp = explode(";", file_get_contents("basic.sql")); 

    $x=0;

    while($x!=count($temp)){

        if($_POST['database_prefix']!=""){

            $query = str_replace("$",$_POST['database_prefix'],ltrim($temp[$x++]));

        }else{

            $query = str_replace("$","",ltrim($temp[$x++]));

        }

        if($query!=""){

            $query_response = mysql_query($query);			

        }

        if(!$query_response){
?>
        <p>Sorry, The query <?php echo $query;  ?> has failed. MySQL reports the following error - 
        <?php echo mysql_errno($mysql_connect_id) . " - " . mysql_error($mysql_connect_id); ?></p>
<?php 
        }
    }
    session_start();

    $_SESSION['DATABASE_HOST'] = $_POST['host'];
    $_SESSION['DATABASE_NAME'] = $_POST['database_name'];
    $_SESSION['DATABASE_PREFIX'] = $_POST['database_prefix'];
}

?>

<h2 style="margin-top:15px">
MySQL Database Account Set up page
</h2>
<p>
Your Xerte Online Toolkits database has been successfully created. When users are creating work on the site, the PHP will need a MySQL username with select,insert,update and delete privileges.
</p>
<p>
<form action="page_password.php" method="post" enctype="multipart/form-data">
    <label for="account">Database account name for users of the site. People following the XAMPP path / or testing locally should type in root.</label><br /><br /><input type="text" width="100" name="account" id="account" /><br /><br />
    <label for="password">Database password for the account above. People following the XAMPP path / or testing locally should leave this field blank.</label><br /><br /><input type="password" width="100" name="password" id="password"/><br /><br />
    <input type="image" src="next.gif" />
</form>
</p>
</div>
</body>
</html>