PHP Classes

File: fwphp/glomodul/z_examples/book_video/gallery_powers/blog_limit.php

Recommend this page to a friend!
  Classes of Slavko Srakocic  >  B12 PHP FW  >  fwphp/glomodul/z_examples/book_video/gallery_powers/blog_limit.php  >  Download  
File: fwphp/glomodul/z_examples/book_video/gallery_powers/blog_limit.php
Role: Example script
Content type: text/plain
Description: Example script
Class: B12 PHP FW
Manage database records with a PDO CRUD interface
Author: By
Last change:
Date: 3 months ago
Size: 1,319 bytes
 

Contents

Class file image Download
<?php
include './includes/title.php';
require_once
'./includes/connection.php';
require_once
'./includes/utility_funcs.php';
// create database connection
$conn = dbConnect('read', 'pdo');
$sql = 'SELECT * FROM blog
        WHERE updated > DATE_SUB(NOW(), INTERVAL 1 WEEK)
        ORDER BY created DESC'
;
$result = $conn->query($sql);
$error = $conn->errorInfo()[2];
?>
<!DOCTYPE HTML>
<html>
<head>
    <meta charset="utf-8">
    <title>Japan Journey<?php if (isset($title)) {echo "&mdash;{$title}";} ?></title>
    <link href="styles/journey.css" rel="stylesheet" type="text/css">
</head>

<body>
<header>
    <h1>Japan Journey </h1>
</header>
<div id="wrapper">
    <?php require './includes/menu.php'; ?>
<main>
        <?php if (isset($error)) {
            echo
"<p>$error</p>";
        } else {
            while (
$row = $result->fetch()) {
                echo
"<h2>{$row['title']}</h2>";
               
$extract = getFirst($row['article']);
                echo
'<p>' . safe($extract[0]);
                if (
$extract[1]) {
                    echo
'<a href="details.php?article_id=' . $row['article_id'] . '">
                    More</a>'
;
                }
                echo
'</p>';
            }
        }
       
?>
</main>
    <?php include './includes/footer.php'; ?>
</div>
</body>
</html>

For more information send a message to info at phpclasses dot org.