$labArg





<?php

require_once '../mainfunctions.php';
$conn = createConn();

printHead("3", "Lab 3.7", "Create a new table");
?>

<form action="3.7.php" method="get">

<label for="delete">to delete the table click here</label>
<button type="submit" name="deletebutton">delete</button>
<br>
<label for="delete">to create the table click here</label>
<button type="submit" name="createbutton">create</button>

</form>

<?php

if (isset($_GET['deletebutton'])){

    $deletequery = "DROP TABLE BandMembers";

    if (mysqli_query($conn, $deletequery)) {
        echo "deleted ok";
    }

    else{
        echo "<p class='error'>Unable to delete BandMembers table: ".mysqli_error($conn)."</p>";
    }   
}


if (isset($_GET['createbutton'])){

    $createquery = "Create table BandMembers (MemberId INT(11) Primary Key auto_increment, LastName varchar(100) not null, FirstName varchar(100), BirthDate Date Not Null, DeathDate Date, ArtistId Int(11), YearJoined Int(4), YearLeft Int(4))";


    if (mysqli_query($conn, $createquery)) {

        $insertquery1 = "insert into BandMembers values(default,'McCartney','Paul','1942-06-18 00:00:00',null,8,1960,1970)";
        mysqli_query($conn, $insertquery1) or die(mysqli_error($conn));

        $insertquery2 = "insert into BandMembers values(default,'Lennon','John','1940-10-09 00:00:00','1980-12-08 00:00:00',8,1960,1970)";
        mysqli_query($conn, $insertquery2) or die(mysqli_error($conn));

        $result = mysqli_query($conn, "Select * from BandMembers");
    
        if (mysqli_num_rows($result)>0) {
            echo "<table><tr><th>ID</th><th>Name</th><th>Birth</th><th>Death</th><th>Artist Id</th><th>Joined</th><th>Left</th></tr>";
            while ($row = mysqli_fetch_assoc($result)) {
                echo "<tr><td>".$row['MemberId']."</td>";
                echo "<td>".$row['FirstName']." ".$row['LastName']."</td>";
                echo "<td>".$row['BirthDate']."</td>";
                echo "<td>".$row['DeathDate']."</td>";
                echo "<td>".$row['ArtistId']."</td>";
                echo "<td>".$row['YearJoined']."</td>";
                echo "<td>".$row['YearLeft']."</td>";               
            }
             echo "</table>";
        } else {
            echo "<p>No records to display</p>";
    }

    } else {
        // if the table was not created successfully, write out an error
        echo "<p class='error'>Unable to create BandMembers table: ".mysqli_error($conn)."</p>";
    }

}


printFootWithCodeExample('3.7code.php');

?>
Lab 3.7 - Code

-Create a new table
