public static function loadAll() { $dbWrapper = new DBWrapper(); $connection = $dbWrapper->getConnection(); $query = "SELECT * FROM topics"; $topics = array(); foreach ($connection->query($query) as $row) { $topic = new Topic($row['id'], $row['name'], $row['post_date'], $row['comment_count'], $connection); $topic->setComments(); $topics[] = $topic; } return $topics; }
public function __construct($id = null, $topicID = null, $comment = null, $date = null, $author = null, $connection = null) { $this->id = $id; $this->topicID = $topicID; $this->comment = $comment; $this->date = $date; $this->author = $author; if (!isset($connection)) { $dbWrapper = new DBWrapper(); $this->connection = $dbWrapper->getConnection(); } else { $this->connection = $connection; } }
public function __construct() { $dbWrapper = new DBWrapper(); $this->connection = $dbWrapper->getConnection(); }
<?php namespace ActiveRecord; require_once 'Comment.php'; require_once '../DBWrapper.php'; use DBWrapper\DBWrapper; $dbWrapper = new DBWrapper(); $connection = $dbWrapper->getConnection(); $topicIds = array(); foreach ($connection->query('SELECT id FROM topics') as $row) { $topicIds[] = $row['id']; } $bla = "blablablabla"; $comment = new Comment($connection); $comment->setAuthor('Author' . rand(0, 1000)); $comment->setTopicID($topicIds[rand(0, sizeof($topicIds) - 1)]); $comment->setComment(substr($bla, 0, rand(12, strlen($bla)))); $comment->save(); echo "<div>" . $comment->getTopicID() . "</div>"; echo "<div>" . $comment->getAuthor() . "</div>"; echo "<div>" . $comment->getComment() . "</div>";