使用oop php显示SELECT查询结果

Question

I am a total noob with performing OOP, and am currently looking to refactor a procedural PHP project. Currently, I am having issues trying to simply display my results from a SELECT query--ironically doing an INSERT query made sense instead. This is my Class file:

<?php
 class MadLibs {                
    private $noun;
    private $verb;
    private $adverb;
    private $adjective;
    private $story;

    // Getters
    public function getNoun() {
        return $this->noun;
    }
    public function getVerb() {
        return $this->verb;
    }
    public function getAdverb() {
        return $this->adverb;
    }
    public function getAdjective() {
        return $this->adjective;
    }
    public function getStory() {
        return $this->story;
    }        
    // Setters
    public function setNoun($noun) {
        $this->noun = $noun;
    }
    public function setVerb($verb) {
        $this->verb = $verb;
    }
    public function setAdverb($adverb) {
        $this->adverb = $adverb;
    }
    public function setAdjective($adjective) {
        $this->adjective = $adjective;
    }
    public function setStory($story) {
        $this->story = $story;
    }
    // Figured this one out
    public function insertStoryToDatabase() {
        date_default_timezone_set('America/Chicago');
        $submit_date    = date('Y-m-d' . " " . 'H:i:s');            
        $dbc = mysqli_connect('localhost','root','','mad_libs')
            or die('Error establishing connection');                        
        $query  = "INSERT INTO storyTime (noun, verb, adjective, adverb, createdDate, fullStory) " .
                "VALUES ('$this->noun','$this->verb','$this->adjective','$this->adverb','$submit_date','$this->story')";            
        mysqli_query($dbc,$query)
                or die('Error querying database');                    
        mysqli_close($dbc);
    }
    // method I am having trouble setting up
    public function displayAllStories() {
        $dbc = mysqli_connect('localhost','root','','mad_libs')
            or die('Error establishing connection');                
        $result      = "SELECT fullStory, createdDate FROM storyTime ORDER BY createdDate DESC";            
        $display    = mysqli_query($dbc,$result)
                or die('Error gathering data!');            
        while ($row = mysqli_fetch_array($display)) {
            echo $row['story'] . '<br/>';
        }
        return $display;
    }      
  }    
?>

And this is what I am doing in my other php file:

<?php
    require_once('MadLibs.php');
    // Instantiating instance of MadLibs()
    $foo = new MadLibs();

    // Playing around to see ensure getters/setters were correct
    $foo->setNoun('Bob');
    $foo->setVerb('jumps');
    $foo->setAdverb('quietly');
    $foo->setAdjective('ugly');
    $foo->setStory("The " .  $foo->getNoun() . " always "  . $foo->getVerb() . " at the " 
. $foo->getAdjective() . " strangers " . $foo->getAdverb() . ".");    
    echo $foo->getNoun();
    echo '<br />';
    echo $foo->getVerb();
    echo '<br />';
    echo $foo->getAdverb();
    echo '<br />';
    echo $foo->getAdjective();
    echo '<br />';
    echo $foo->getStory();

    $foo->insertStoryToDatabase();

    $foo->displayAllStories();    
?>    

I'm sure it's something simple, but for the life of me I can't figure out what I'm doing wrong.

Any and all feedback is most appreciated!

Answer 1

You trying to display wrong variable in displayAllStories() function . 'echo $row['story']should be change to$row['fullStory'];` or change your query to

SELECT fullStory as story, createdDate FROM storyTime ORDER BY createdDate DESC