Untitled

<!DOCTYPE html>
<html>
<body>

<?php
//Login details
$servername = "lochnagar.abertay.ac.uk";
$username = "sql1500457";
$password = "D7rS&#jV5rYO";
$dbname = "sql1500457";

//Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

//Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error()) . "<br>";
}
echo "Connected Successfully" . "<br>";

$sql = "CREATE TABLE musicThree (
    artistname VARCHAR(30) NOT NULL,
    shortbio VARCHAR(150) NOT NULL,
    yearsactive INT(2) NOT NULL,
    genre VARCHAR(30) NOT NULL,
    topalbum VARCHAR(30) NOT NULL)";

if (mysqli_query($conn, $sql)){
 echo " Table created successfully" . "<br>";
 } else {
 echo " Error creating table: " . mysqli_error($conn) . "<br>";
 }

?>

<?php

$sql = "INSERT INTO musicThree VALUES ('".$_POST['artistname']."','".htmlspecialchars($_POST['shortbio'])."','".$_POST['yearsactive']."','".$_POST['genre']."','".htmlspecialchars($_POST['topalbum'])."')";

if (mysqli_query($conn, $sql)){
    echo " New record created successfully" . "<br>";
} else {
    echo " Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

?>

</html>
</body>