delete.php

<?php

$servername = "aropawoz.mysql.db.internal";
$username = "aropawoz_tobilu";
$password = "WTp5g3bsVA8HfC-*f3+N";
$name = "aropawoz_financialplanning";
//$servername = "localhost";
//$username = "root";
//$password = "root";
//$name ="ef5_webproj";

//Establish connection with database
try{
    $conn = new PDO("mysql:host=$servername;dbname=$name", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e){
    echo "<p style='color:rgb(87, 119, 143)'>Connection failed.<br></p>". $e->getMessage();
}

//Droping Database and creating it again in order to enshure no items are accidentaly in the Database twice at initiation

try{
    $conn->exec("DROP DATABASE ef5_webproj");
    $conn->exec("CREATE DATABASE ef5_webproj");
    echo "<p style='color:rgb(87, 119, 143)'>Database flushed.<br></p>";
} catch(PDOException $e){
    echo "<p style='color:rgb(87, 119, 143)'>Action failed: ".$e->getMessage()."<br></p>";
}



?>