COMP3512

winter 2024

lec-php-06

Future Future

RECALL-01

<?php
if ($_SERVER['REQUEST_METHOD'] === "GET") {
    if (isset($_COOKIE['first-name']) && $_COOKIE['first-name'] !== "n/a") {
        $msg = "Welcome back, {$_COOKIE['first-name']}!";
    } else {
        $msg = "Hi there!";
        setcookie('first-name', 'n/a');
    }
}

require 'hello.view.php';

A user goes to hello.php for the first time.

<body>
    <h1><?= $msg ?></h1>
</body>

hello.php

hello.view.php

What special thing will be in the response from the web server?
What will be displayed in the browser?

<?php
if ($_SERVER['REQUEST_METHOD'] === "GET") {
    if (isset($_COOKIE['first-name']) && $_COOKIE['first-name'] !== "n/a") {
        $msg = "Welcome back, {$_COOKIE['first-name']}!";
    } else {
        $msg = "Hi there!";
        setcookie('first-name', 'n/a');
    }
}

require 'hello.view.php';

A user comes BACK to hello.php.

<body>
    <h1><?= $msg ?></h1>
</body>

hello.php

hello.view.php

What special thing will be in the request from their browser?
What could they do in their browser's devtools to make the message "Welcome back, doofus!" appear in the browser?

RECALL-01, cont

<?php

session_start();

$_SESSION['user'] = $_GET['user'] ?? 'unknown';

if ($_SESSION['user'] === "betty") {
    header("Location: here.php");
} else {
    header("Location: there.php");
}

exit();

RECALL-02

landing.php

A user goes to landing.php?user=bobby for the first time.

What special thing will be in the response from the web server?
What special thing will be in the /tmp directory of the web server computer?
What page will the user by redirected to?

Currently, we're using hard-coded arrays to hold important info for our admin pages in The Project.

What 3 arrays did we have again?

Obviously, that's not gonna cut it for our final product!

... and we need our PHP code to "talk" to that database to get data from the tables.

...which means that we need a database to hold those tables...

We're going to need the data in those arrays to be in database tables...

Sounds like we need a Plan!

Here's The Plan

We're going to briefly talk about class/object syntax in PHP, because our Project code will use objects to "talk" to the database. Rabbits will be involved.
Then I'll show you how to use the Database Client extension that's on our Codespace to create the database, tables, and data we need for the project.
Finally, we'll play around with the extension a bit and see how to view and alter the data in our tables.

Next week, we'll actually start writing DB code...just in time for Milestone 4 folks to use it the week after.

let's talk about these things today:

◉ We're gonna make rabbits. How exciting!

Classes

◉ Wait...my Codespace has a database server on it?!?
◉ How do I connect to that server?
◉ How do I create a database, tables, and data on the server?
◉ How do I add/delete/modify data from tables?