CODEWITHSUNDEEP
phpmysqlfunctionpdo
Chris
Chris

Reputation: 282

Returning multiple rows from a function -- MySQL Database -- PDO

I'm working on a blog site, and over the past few days I've been cleaning it up so it uses a lot more included functions rather than inline php. So far it's been really helpful.

Right now I'm trying to use a function to get all the blogposts in the database, which are stored like this:

enter image description here

Previously I was doing this right in my main blog.php file, which includes all the html. That looked like this: 

$stmt = $db->prepare("SELECT * FROM blog_posts ORDER BY id DESC");
$stmt->execute();
foreach($stmt as $blogPost)
{
    $dateTime = date("j F, Y g:i a", (strtotime($blogPost['date_posted'])));

    echo "<div class='blog-main-preview'>";
    echo "<p class='blog-preview-title'>" . $blogPost['title'] . "</p>";
    echo "<p id='blog-preview-date'>" . $dateTime . "</p><br>";
    $post = $blogPost['post'];
    $post = strip_tags($post);
    $post = substr($post, 0, 200);
    echo "<p id='blog-preview-post'>" . $post . "...</p><br>";
    echo "<a href='blog-post.php?postid=" . $blogPost['id'] . "' id='read-more'><p>Read More</p></a><br>";
    echo "</div>";

}

This worked great but I was looking to move it to a function too. I realize I could just move the whole thing to a function, I was just hoping there was a solution where I didn't have to have any of the html in the function, and it could return something with which I could run the foreach loop in the main blog.php file. Can I do this?

Edit: So to clarify, what I'm looking for is to have my blog.php page look like: 

$blogPosts = getBlogPosts($db);
foreach($blogPosts as $blogPost)
{
    $dateTime = date("j F, Y g:i a", (strtotime($blogPost['date_posted'])));

    echo "<div class='blog-main-preview'>";
    echo "<p class='blog-preview-title'>" . $blogPost['title'] . "</p>";
    echo "<p id='blog-preview-date'>" . $dateTime . "</p><br>";
    $post = $blogPost['post'];
    $post = strip_tags($post);
    $post = substr($post, 0, 200);
    echo "<p id='blog-preview-post'>" . $post . "...</p><br>";
    echo "<a href='blog-post.php?postid=" . $blogPost['id'] . "' id='read-more'><p>Read More</p></a><br>";
    echo "</div>";

}

And the functions file will contain the function which retrieves and returns the blogPosts.

Upvotes: 0

Views: 90

Answers (3)

bd808
bd808

Reputation: 1803

<?php
function getBlogPosts($db) {
    $stmt = $db->prepare("SELECT * FROM blog_posts ORDER BY id DESC");
    $stmt->execute();

    // Get all results from the query as an array of associative arrays
    $rows = $sth->fetchAll();

    // Post-process results
    // Use `&` to get a reference to each row to prevent the default 
    // "copy on write" behavior of PHP's arrays from detaching our 
    // changes from the $rows array. Without this, the updated $row[X]
    // values would only be visible inside the foreach loop.
    foreach ($rows as &$row) {
      $row['date_posted'] = date("j F, Y g:i a", strtotime($row['date_posted']));
      $row['post'] = strip_tags($row['post']);
      $row['post'] = substr($row['post'], 0, 200);
    }

    return $rows;
}

$blogPosts = getBlogPosts($db);
foreach($blogPosts as $blogPost)
{ ?>

<div class="blog-main-preview">
  <p class="blog-preview-title"><?= htmlspecialchars($blogPost['title']) ?></p>
  <p id="blog-preview-date"><?= htmlspecialchars($blogPost['date_posted']) ?></p><br>
  <p id="blog-preview-post"><?= htmlspecialchars($blogPost['post']) ?>...</p><br>
  <a href="blog-post.php?postid=<?= urlencode($blogPost['id']) ?>" id="read-more"><p>Read More</p></a><br>
</div>

<?php } ?>

Upvotes: 2

Barmar
Barmar

Reputation: 781300

You can simply return $stmt from the function.

function getBlogPosts($db) {
    $stmt = $db->prepare("SELECT * FROM blog_posts ORDER BY id DESC");
    $stmt->execute();
    return $stmt;
}

Upvotes: 1

user557846
user557846

Reputation: 

function getBlogPosts($db){
$stmt = $db->prepare("SELECT * FROM blog_posts ORDER BY id DESC");
$stmt->execute();
return $stmt->fetchAll();
}

Upvotes: 0

Related Questions