<?php

    $servername = "db4free.net";
    $username = "name";
    $password = "pass";

    $dbcon = new mysqli($servername, $username, $password);

    if ($dbcon->connect-error)
    {
        die("Connection failed: " . $dbcon->connect_error);
    }
    else { echo "Connected"; }

    // Works up to here, printing the "connected" message.

    $sql = "CREATE DATABASE dbmpname";
    if ($dbcon->query($sql) === TRUE) {
        echo "Database created successfully";
    }
    else
    {
        echo "Error creating database: " . $dbcon->error;
    }

    $sql2 = "CREATE TABLE test1 (id INT)";

    if ($dbcon->query($sql2) === TRUE)
    {
        echo "Table created successfully";
    }
    else
    {
        echo "Error creating table: " . $dbcon->error;
    }

    $sql3 = "INSERT INTO test1 (id) VALUES (50)";

    if ($dbcon->query($sql3) === TRUE)
    {
        echo "New record created successfully";
    }
    else
    {
        echo "Error: " . $sql3 . "<br>" . $dbcon->error;
    }

    ?>