-
- - - prepare('SELECT COUNT(*) FROM Entries'); - $count_query->execute(); - $count = $count_query->fetch()[0]; - echo '

Entries (' . $count . ' total)

'; - // Prepare SELECT statement. - $select = "SELECT name, message, show_info, show_ip, ip, submitted, browser_info FROM Entries ORDER BY submitted DESC"; - $stmt = $db->prepare($select); - - // Execute statement. - $stmt->execute(); // ID between 1 and 3. - - // Get the results. - $results = $stmt->fetchAll(PDO::FETCH_ASSOC); - - foreach($results as $row) { - echo '

';
-		    $submittedRaw = $row['submitted'];
-		    $submittedDT = new DateTime("@$submittedRaw");
-		    $submitted = $submittedDT->format('H:i:s - Y-m-d');
-			
-			$browser = get_browser(null, true);
-			$sys = $browser['parent'] . ' (' . $browser['platform_description'] . ' ' . $browser['platform_version'] . ')';
-
-		    echo 'Name:	' . $row['name'] . PHP_EOL;
-			if ($row['show_ip']) echo 'IP:	' . $row['ip'] . PHP_EOL;
-			if ($row['show_info']) echo 'Sys:	' . $row['browser_info'] . PHP_EOL;
-			echo 'Date:	' . $submitted . PHP_EOL . PHP_EOL;
-			echo $row['message'];
-			echo '

'; - } - ?> - -