<?php
$DbHost = $_POST['Database_HAddr'];
$DbUserName = $_POST['Database_UName'];
$DbPass = $_POST['Database_UPass'];
$DbName = "[".$_POST['Database_Name']."]";

if(isset($_POST['submit']))
{
$result = mssql_connect($DbHost,$DbUserName,$DbPass);

if(!$result)
{
    die(mssql_get_last_message());
}
else
{
    echo "Successfully Connected to $DbHost<br>";
}

$dbget = mssql_select_db($DbName);

if(!$dbget)
{
    //die(mssql_error($result));
    echo "Error Occurred!";
    //mssql_error($dbget);
}
else
{
    echo "$DbName was selected!<br>";
}

 mssql_select_db($DbName);

$query = mssql_query('SELECT * FROM sysobjects WHERE type = \'U\' ORDER BY NAME');

if(!$query)
{
    echo "Could not run query to list tables";
}
else
{
    while($row = mssql_fetch_row($query))
    {
        echo "Table: ".$row[0]."<br>";
    }
}

$dbclose=mssql_close($result);

if(!$dbclose)
{
    //die(mssql_error());
    echo "Error Occurred!";
}
else
{
    echo "db closed!<br>";
}

}
else
{
    form();
}

?>

<?php
    function form()
    {
        ?>
        <form action='' method="post">
        Database Name:<br>
        <input type="text" name="Database_Name">
        <br>
        Database Username:<br>
        <input type="text" name="Database_UName">
        <br>
        Database User Password:<br>
        <input type="text" name="Database_UPass">
        <br>
        Database Host Address:<br>
        <input type="text" name="Database_HAddr">
        <br>
        <input type="submit" value="Submit" name="submit">
        <input type="button" value="Reset" name="reset">
        </form>
        <?php
    }
    ?>