Lesson 1: Basic SQL Commands (Run in SQL Terminal)

1. Create a Table:

CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT,
    email TEXT
);

2. Insert Data:

INSERT INTO users (username, email) VALUES ('Alex', 'alex@example.com');

3. Select Data:

SELECT * FROM users;
SELECT username FROM users WHERE id = 1;

4. Update & Delete:

UPDATE users SET username = 'Alex_New' WHERE id = 1;
DELETE FROM users WHERE id = 1;

Lesson 2: Basic PHP Syntax (Code Editor)

Write standard PHP logic in your files using open tags:

<?php
$name = "Developer";
$skills = ["PHP", "SQL", "HTML"];

echo "<h1>Welcome, " . $name . "</h1>";

foreach ($skills as $skill) {
    echo "<li>" . $skill . "</li>";
}
?>

Lesson 3: Connecting PHP to SQLite

Fetch records from your active database directly inside your workspace code:

<?php
// Connect to selected database file
$db = new PDO('sqlite:database.sqlite');

// Fetch rows into an associative array
$query = $db->query("SELECT * FROM users");
$users = $query->fetchAll(PDO::FETCH_ASSOC);

foreach ($users as $user) {
    echo "<p>" . $user['username'] . " - " . $user['email'] . "</p>";
}
?>