$connection = new Database();
//Instance of Database Class
$connection->connectToDatabase();
//Connect to database
echo '<br>';
//Insert Query
$insertSQL = "INSERT INTO Customer( customerFname, customerLname, customerEmail, customerAddress, customerDOB, customerAccountCreation, \tcustomerPassword )VALUES ('John', 'Newman', '*****@*****.**', '133 Hilltown Lawn', '1935/11/18', NOW( ) , '2324')";
$connection->insertData($insertSQL);
//Select Query
$statement = "SELECT * FROM Customer";
$dataset = $connection->selectData($statement);
//Update Query
$update = "UPDATE Customer SET customerFname='Fart' WHERE customerId=3";
$connection->updateDatabase($update);
for ($i = 61; $i <= 67; $i++) {
//Delete Data
$delete = "DELETE FROM Customer\n\t\tWHERE customerId = " . $i;
$connection->deleteData($delete);
echo 'Record ' . $i . ' deleted';
}
//Close Connection
$connection->closeConnection();
//List all values
if ($dataset->num_rows > 0) {
// output data of each row
while ($row = $dataset->fetch_assoc()) {
echo "<br> id: " . $row["customerId"] . " - Name: " . $row["customerFname"] . " " . $row["customerLname"] . "<br>";
}
} else {
echo "0 results";
}
$game_id = "wk" . $gameWeek . "_" . ($id[0]['num'] + 1);
//
$newGame = $db->addData($game_id, $_POST['away_id'], $_POST['home_id'], $gameWeek, $_POST['game_date'], $_POST['game_time'], $_POST['facility'], $_POST['area']);
//
$school_name = 'All';
} elseif (isset($_POST['delete_game'])) {
// get the page that sent here
$referer = $_SERVER['HTTP_REFERER'];
//get game id
$game_id = $_POST['game_id'];
// get away team name
$away_team = $_POST['away_team'];
// get home team name
$home_team = $_POST['home_team'];
//delete game with that id
$deleteGame = $db->deleteData($game_id, $away_team, $home_team);
// send the page back where it came from
header("Location: {$referer}");
} else {
// get school id from form
$school = 'ccc_01';
// get school info
$getInfo = "CALL getInfo('{$school}')";
$team_info = $db->getData($getInfo);
// check if add button was pushed
// set school name based
if (isset($_POST['add'])) {
// set school name to all
$school_name = 'All';
} else {
// get school name from id info
