upload and download

require_once 'DB_info.php';

//DATABASE SETUP

//Create connection
$conn = new mysqli($servername, $username, $password);

//Check connecion
if ($conn->connect_error){
    die("<br> Connection failed" . $con->connect_error);
}
echo "<br> Connection successful";

// Create database
$sql = "CREATE DATABASE $dbname";
if ($conn->query($sql) === TRUE) {
    echo "<br> Database $dbname created successfully";
} else {
    echo "<br> Error creating database: " . $conn->error;
}

$conn->close();

//note that here I give the database name too
$conn = new mysqli($servername, $username, $password,
                   $dbname);

// sql to create the myAliens table
$sql = "CREATE TABLE $myAliens (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
alienname VARCHAR(30) NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "<br> Table $myAliens created successfully";
} else {
    echo "<br> Error creating table $myAliens: " . $conn->error;
}


$conn->close();



//FILE SYSTEM SETUP

//Create sub-directory for the alien pictures
if (mkdir($alienPicturesDir,040) == FALSE)
    die("<br> Could not create directory $alienPicturesDir");
echo "<br> Directory $alienPicturesDir created successfully";