Example #1
0
 public function save(Model\Tweet $tweet)
 {
     $tweets = array();
     foreach ($tweet as $item) {
         $tweets[] = array('name' => $item->getName(), 'message' => $item->getMessage(), 'timestamp' => $item->getTimeStamp());
     }
     if ($this->find($tweet->getId())) {
         $sql = 'UPDATE tweets SET tweets=:tweets WHERE id=:id';
         $statement = \Kernel\Registry::get('db')->prepare($sql);
         @$statement->bindParam('id', $tweet->getId(), \PDO::PARAM_STR, 32);
         @$statement->bindParam('tweets', serialize($tweets), \PDO::PARAM_STR);
         return $statement->execute();
     }
     $sql = 'INSERT INTO tweets(id, name, message, timestamp, tweets) VALUES(:id, :name, :message, :timestamp, :tweets)';
     $statement = \Kernel\Registry::get('db')->prepare($sql);
     @$statement->bindParam('id', $tweet->getId(), \PDO::PARAM_STR, 32);
     @$statement->bindParam('name', $tweet->getName(), \PDO::PARAM_STR, 32);
     @$statement->bindParam('message', $tweet->getMessage(), \PDO::PARAM_STR, 160);
     @$statement->bindParam('timestamp', $tweet->getTimeStamp(), \PDO::PARAM_INT);
     @$statement->bindParam('tweets', serialize($tweets), \PDO::PARAM_STR);
     return $statement->execute();
 }
Example #2
0
 protected function _initDB()
 {
     $options = $this->getOptions('db');
     Registry::set('db', new \PDO($options['dns'], $options['username'], $options['password']));
 }