homework-solution.php

<?php

// Connect to the MySQL database.
$dsn = "mysql:host=localhost;port=3306;dbname=myapp;user=root;charset=utf8mb4";

// Tip: This should be wrapped in a try-catch. We'll learn how, soon.
$pdo = new PDO($dsn);

$statement = $pdo->prepare("select * from posts where id = 1");
$statement->execute();

$post = $statement->fetch(PDO::FETCH_ASSOC);

echo "<li>" . $post['title'] . "</li>";

index.php

<?php

require 'functions.php';

// Connect to the MySQL database.
$dsn = "mysql:host=localhost;port=3306;dbname=myapp;user=root;charset=utf8mb4";

// Tip: This should be wrapped in a try-catch. We'll learn how, soon.
$pdo = new PDO($dsn);

$statement = $pdo->prepare("select * from posts");
$statement->execute();

$posts = $statement->fetchAll(PDO::FETCH_ASSOC);

foreach ($posts as $post) {
    echo "<li>" . $post['title'] . "</li>";
}

require 'functions.php';

// require 'router.php';

//connect to our MySQL database

// Created a prepared statement to fetch data in test(test is my db table name) that has an id of 1. Then, experimented with calling fetch() instead of fetchAll()

$dsn = "mysql:host=localhost;port=3306;user=root;dbname=firstphp;charset=utf8mb4";
$pdo = new PDO($dsn);

$statement = $pdo->prepare("SELECT * From test WHERE id = 1");
$statement->execute();

$test = $statement->fetch(PDO::FETCH_ASSOC);

echo "<li>" . $test['user_name'] . " " . $test['email'] . "</li>";

//connection with mysql
$dns = "mysql:host=localhost;dbname=myapp;user=root;charset=utf8mb4";

$pdo = new PDO($dns);

$statement = $pdo->prepare("select * from posts where id=1");
$statement->execute();
$post = $statement->fetch(PDO::FETCH_ASSOC);

echo "

".$post['title']."

";