Untitled

<?php include 'inc/dbh.php';

// PDO QUERY
$stmt = $pdo->query("SELECT * FROM article ORDER BY article_created_at DESC");

?>
<!DOCTYPE html>
<html>
<head>
    <title></title>
    <link rel="stylesheet" type="text/css" href="https://bootswatch.com/readable/bootstrap.min.css">
</head>
<body>

    <nav class="navbar navbar-inverse">
      <a class="navbar-brand" href="#">Blog</a>
       <ul class="nav navbar-nav">
        <li class=""><a href="#">Home</a></li>
        <li><a href="#">Add Article</a></li>
      </ul>
    </nav>
    <div class="container">
        <?php while($row = $stmt->fetch()): ?>
            <div class="well">
                <h5>Title: <?php echo $row->article_title; ?></h5>
                <small>by <?php echo $row->article_author ?><span class="pull-right"><?php echo $row->article_created_at; ?></span></small>
                <p><?php echo $row->article_body; ?></p>
                <a class="btn btn-primary" href="post.php?id=<?php echo $row->article_id; ?>">Read More</a>
            </div>
        <?php endwhile; ?>
    </div>
</body>
</html>

<?php include 'inc/dbh.php';

$id = $_GET['id'];


// PDO QUERY
$sql = "SELECT * FROM article WHERE article_id = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$id]);
$post = $stmt->fetch();

?>
<!DOCTYPE html>
<html>
<head>
    <title></title>
    <link rel="stylesheet" type="text/css" href="https://bootswatch.com/readable/bootstrap.min.css">
</head>
<body>
    <nav class="navbar navbar-inverse">
      <a class="navbar-brand" href="">Blog</a>
       <ul class="nav navbar-nav">
        <li class=""><a href="/blog/">Home</a></li>
        <li><a href="/blog/add_article.php">Add Article</a></li>
      </ul>
    </nav>
    <div class="container">
                <h5>Title: <?php echo $post->article_title; ?></h5>
                <small>by <?php echo $post->article_author ?><span class="pull-right"><?php echo $post->article_created_at; ?></span></small>
                <p><?php echo $post->article_body; ?></p>
                <a href="edit.php?id=<?php echo $post->article_id; ?>" class="btn btn-primary">Edit</a>
                <a href="delete.php?id=<?php echo $post->article_id; ?>" class="btn btn-danger">Delete</a>
    </div>
</body>
</html>

<?php
include 'inc/dbh.php';

$id = '';
if(isset( $_GET['id'])) {
    $id = $_GET['id'];
}


// PDO QUERY
$sql = "SELECT * FROM article WHERE article_id = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$id]);
$post = $stmt->fetch(PDO::FETCH_OBJ);


// UPDATE

if(isset($_POST['submit'])) {


    $article_title = $_POST['article_title'];
    $article_author = $_POST['article_author'];
    $article_body = $_POST['article_body'];
    $update_article = $_POST['update_article'];

    $sql = "UPDATE `article` SET `article_title` = :article_title,
                              `article_author` = :article_author,
                              `article_body` = :article_body
                              WHERE `article_id` = :article_id ";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':article_title',$article_title, PDO::PARAM_STR);
    $stmt->bindParam(':article_author',$article_author, PDO::PARAM_STR);
    $stmt->bindParam(':article_body',$article_body, PDO::PARAM_STR);
    $stmt->bindParam(':article_id', $update_article, PDO::PARAM_INT);
    $stmt->execute();

}
?>
<!DOCTYPE html>
<html>
<head>
    <title></title>
    <link rel="stylesheet" type="text/css" href="https://bootswatch.com/readable/bootstrap.min.css">
</head>
<body>
        <nav class="navbar navbar-inverse">
          <a class="navbar-brand" href="">Blog</a>
           <ul class="nav navbar-nav">
            <li class=""><a href="/blog/">Home</a></li>
            <li><a href="/blog/add_article.php">Add Article</a></li>
          </ul>
        </nav>
        <div class="container">
            <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
                <div class="form-group">
                    <label>Title</label>
                    <input type="text" name="article_title" value="<?php echo $post->article_title; ?>" class="form-control">
                </div>
                <div class="form-group">
                    <label>Author</label>
                    <input type="text" name="article_author" value="<?php echo $post->article_author; ?>" class="form-control">
                </div>
                <div class="form-group">
                    <label>Content</label>
                    <textarea name="article_body" class="form-control"><?php echo $post->article_body; ?></textarea>
                </div>
                <div class="form-group">
                    <label>Created At</label>
                    <input type="text"  title="date" value="<?php echo $post->article_created_at; ?>" class="form-control" disabled>
                </div>
                <input type="hidden" name="update_article" value="<?php echo $post->article_id; ?>">
                <input type="submit" name="submit" value="Edit Article" class="btn btn-primary">
            </form>
        </div>
</body>
</html>

<?php

    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = 'blog';

        try {
        $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username,$password);
        // set the PDO error mode to exception
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
        }
        catch(PDOException $e)
    {
        echo "Connection failed: " . $e->getMessage();
    }


?>