获取信息的php函数[关闭]

Question

I'm trying to make it so it shows the latest announcements in a link with the title. I've tried doing it and now I'm just trying to get it to even return the variable and it won't...

Functions.php

<?php
    require("common.php");
    function getAnnouncements() {
        $query = "SELECT * FROM announcements";

        try {
            global $db;
            // Execute the query against the database
            $stmt = $db->prepare($query); 
            $result = $stmt->execute();
            echo $result['title'];
        }
        catch(PDOException $ex) { 
            // Note: On a production website, you should not output $ex->getMessage(). 
            // It may provide an attacker with helpful information about your code.  
            die("Failed to run query: " . $ex->getMessage()); 
        } 

    }

?>

index.php

    <div class="announcement">
        <div class="container">
            Latest Announcements: <?php getAnnouncements(); echo "<a href=''></a>" ?>
        </div>
    </div>

Yes, I am including the file at the top and there's no spelling errors in it.

Answer 1

First, make sure that $db is initialized with:

 $db = new PDO("mysql:host=[host here];dbname=[dbname]e;charset=utf8",[username],[password]);

You're going to want to fetch an associative array and loop through it like this:

$result = $result->fetchAll(PDO::FETCH_ASSOC);
for($result as $a_result)
    echo '<a href="'.$a_result['link'].'">'.$a_result['title'].'</a>';

This is assuming there is a link column on your database