<body> <?php include "includes/dbInfo.php"; include "includes/articles.php"; session_start(); $conn = new mysqli("localhost", DBUSERNAME, DBPASSWORD, DB); //Esatblish database connection $articles = new articles($conn); //Initialised object $p = $_GET["p"]; //gets variable for page if ($p == "") { $p = 1; //If no page specified assume default value 1 } $articlesToShow = $articles->getArticlesFromDb($p); //Retrieves articles for page number for ($i = 0; $i < $articlesToShow->num_rows; $i++) { //Runs through the 5 articles $articlesToShow->data_seek($i); $article = $articlesToShow->fetch_assoc(); //Fetches relavent article echo "<h1><a href='post.php?id=" . $article["ID"] . "'>" . $article["Title"] . "</a></h1>"; //Title of article echo "<h3>By: " . $article["Author"] . "</h3>"; //Author of article $content = $article["Content"]; if (strlen($content) > 100) { $content = substr($article["Content"], 0, 1000) . "... <a href='post.php?id=" . $article["ID"] . "'>Read More</a>"; } echo "<p>" . $content . "</p>";