footer.php
</body>
</html>
navbar.php
<nav class="navbar navbar-default">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">PHPblog</a>
</div>
<div id="navbar" class="collapse navbar-collapse">
<ul class="nav navbar-nav">
<li><a href="<?php echo ROOT_URL; ?>">Home</a></li>
</ul>
</div><!--/.nav-collapse -->
</div>
</nav>
header.php
<!DOCTYPE html>
<html>
<head>
<title>PHP Blog</title>
<link rel="stylesheet" type="text/css" href="http://bootswatch.com/cerulean/bootstrap.min.css">
</head>
<body>
<?php include('navbar.php'); ?>
db.php
<?php
// Create Connection
$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
// Check Connection
if(mysqli_connect_errno()){
// Connection Failed
echo 'Failed to connect to MySQL '. mysqli_connect_errno();
}
config.php
<?php
define('ROOT_URL', 'http://localhost/phpsandbox/website8/');
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', '123456');
define('DB_NAME', 'phpblog');
post.php
<?php
require('config/config.php');
require('config/db.php');
// get ID
$id = mysqli_real_escape_string($conn, $_GET['id']);
// Create Query
$query = 'SELECT * FROM posts WHERE id = '.$id;
// Get Result
$result = mysqli_query($conn, $query);
// Fetch Data
$post = mysqli_fetch_assoc($result);
//var_dump($posts);
// Free Result
mysqli_free_result($result);
// Close Connection
mysqli_close($conn);
?>
<?php include('inc/header.php'); ?>
<div class="container">
<a href="<?php echo ROOT_URL; ?>" class="btn btn-default">Back</a>
<h1><?php echo $post['title']; ?></h1>
<small>Created on <?php echo $post['created_at']; ?> by <?php echo $post['author']; ?></small>
<p><?php echo $post['body']; ?></p>
</div>
<?php include('inc/footer.php'); ?>
index.php
<?php
require('config/config.php');
require('config/db.php');
// Create Query
$query = 'SELECT * FROM posts';
// Get Result
$result = mysqli_query($conn, $query);
// Fetch Data
$posts = mysqli_fetch_all($result, MYSQLI_ASSOC);
//var_dump($posts);
// Free Result
mysqli_free_result($result);
// Close Connection
mysqli_close($conn);
?>
<?php include('inc/header.php'); ?>
<div class="container">
<h1>Posts</h1>
<?php foreach($posts as $post) : ?>
<div class="well">
<h3><?php echo $post['title']; ?></h3>
<small>Created on <?php echo $post['created_at']; ?> by <?php echo $post['author']; ?></small>
<p><?php echo $post['body']; ?></p>
<a class="btn btn-default" href="<?php echo ROOT_URL; ?>post.php?id=<?php echo $post['id']; ?>">Read More</a>
</div>
<?php endforeach; ?>
</div>
<?php include('inc/footer.php'); ?>