public function create($content, $idAuthor, Topic $Topic, SCategory $SCategory) { $post = new Post($this->db); try { $post->setContent($content); $post->setIdAuthor($idAuthor); $post->setTopic($Topic); $post->setSCategory($SCategory); } catch (Exception $e) { $errors = $e->getMessage(); echo $errors; } if (!isset($err)) { $content = $this->db->quote($post->getContent()); $idAuthor = $post->getIdAuthor(); $idTopic = $post->getIdTopic(); $idSCategory = $post->getIdSCategory(); $query = 'INSERT INTO post(content, id_author, id_topic, id_sCategory) VALUE (' . $content . ',' . $idAuthor . ', ' . $idTopic . ', ' . $idSCategory . ')'; } $res = $this->db->exec($query); if ($res) { $id = $this->db->lastInsertId(); if ($id) { return $this->findById($id); } else { throw new Exception('Database error'); } } else { throw new Exception($errors); } }
/** */ public function testGetContent() { $expected = "It's that time in the week when 'A foreign affair' goes to the quiz-night at the Grands. We usually ends up at the bottom half in the results. This might be the result of the lack of knowledge we have in things not categorized in either technology, movies or music.\n\nSometimes we've been lucky enough to hit the second to last place, that given us a whopping \$20 bar tab. Split that money on 4-5 people and we can almost get half a beer each.\n\nUsually it's three europeans and one kiwi, but tonight we're getting some help from the french nation."; $this->assertEquals($expected, $this->object->getContent()); $this->object->setContent('This is the new content'); $this->assertEquals('This is the new content', $this->object->getContent()); }
public function insert(Post $post) { $this->conn->beginTransaction(); try { $stmt = $this->conn->prepare('INSERT INTO posts (title, content) VALUES (:title, :content)'); $stmt->bindValue(':title', $post->getTitle()); $stmt->bindValue(':content', $post->getContent()); $stmt->execute(); $this->conn->commit(); } catch (Exception $e) { $this->conn->rollback(); } }
function view_post($post) { require_once ROOT . '/application/models/Post.php'; $app = \Slim\Slim::getInstance(); // get the posts directory, and post filename $dir = POST::POST_PATH; $post = new Post($path, $dir); $post->createPostFromFile(); $post_metadata = $post->getMetadata(); // parse the markdown portion into HTML $post_html = $app->config('md')->text($post->getContent()); // build the final post object $post_result = array('title' => $post_metadata['title'], 'date' => $post_metadata['date'], 'desc' => $post_metadata['desc'], 'html' => $post_html); // render the post view $app->render('blog_post.php', array('post' => $post_result)); }
public static function getLastPosts() { $session_id = '1000004'; $connexion = new PDO(PDO_DSN, USER, PASSWD); $connexion->exec("set names utf8"); $query = "SELECT p.post_id, p.post_user, m.mbr_name, m.mbr_birthdate, m.mbr_inscription, p.post_content, p.post_date, p.post_picture FROM post AS p JOIN member m ON p.post_user = m.mbr_id WHERE p.post_user IN ( SELECT frs_a FROM friendship WHERE frs_b = ? UNION SELECT frs_b FROM friendship WHERE frs_a = ? ) ORDER BY post_date DESC"; $stmt = $connexion->prepare($query); $stmt->bindParam(1, $session_id, PDO::PARAM_INT); $stmt->bindParam(2, $session_id, PDO::PARAM_INT); $stmt->execute(); if ($stmt->rowCount()) { while ($ligne = $stmt->fetch(PDO::FETCH_OBJ)) { $member = new User($ligne->post_user, $ligne->mbr_name, $ligne->mbr_birthdate, $ligne->mbr_inscription); $post = new Post($ligne->post_id, $member, $ligne->post_content, $ligne->post_date, $ligne->post_picture); echo $member->getName() . ":" . $post->getContent() . "<br>"; // SHOW POSTS HERE } } else { echo 404; } }
/*$client = new IXR_Client('http://localhost/exercises/php_exercises/chapter4/server.php'); if (!$client->query('time.getGMTTime')) { die("Something went wrong - " . $client->getErrorCode() . $client->getErrorMessage()); } echo($client->getResponse());*/ /*---------- Design Patterns: Decorator Pattern ----------*/ print "<br/><br/>"; $bbcode_enabled = 0; $emoticon_enabled = 1; $post = new Post(); $comment = new Comment(); $post->filter("Test Title: A Test", "Lorem Ipsum Amet"); $comment->filter("Dolot avenus persina olatus"); if ($bbcode_enabled == false && $emoticon_enabled == false) { $postcontent = $post->getContent(); $commentcontent = $comment->getContent(); } elseif ($bbcode_enabled == true && $emoticon_enabled == false) { $bb = new BBCodeParser($post); // Passing the Post() object to BBCodeParser() $postcontent = $bb->getContent(); $bb = new BBCodeParser($comment); $commentcontent = $bb->getContent(); } elseif ($bbcode_enabled == false && $emoticon_enabled == true) { $em = new EmoticonParser($post); $postcontent = $em->getContent(); $em = new EmoticonParser($comment); $commentcontent = $em->getContent(); } /*---------- Design Patterns: Facade Pattern ----------*/ $F = new Facade();
public function create($idTopic, $content) { $post = new Post(); $set = $post->setContent($content); if ($set === true) { $manager = new TopicManager($this->db); $topic = $manager->findById($idTopic); $set = $post->setIdTopic($topic); if ($set === true) { if (isset($_SESSION['id'])) { $manager = new UserManager($this->db); $user = $manager->getCurrent(); $set = $post->setIdAuthor($user); if ($set === true) { $idAuthor = intval($user->getId()); $idTopic = intval($post->getIdTopic()); $content = mysqli_real_escape_string($this->db, $post->getContent()); $query = "INSERT INTO post (id_author, id_topic, content) VALUES (" . $idAuthor . ", " . $idTopic . ", '" . $content . "')"; $result = mysqli_query($this->db, $query); if ($result) { $id = mysqli_insert_id($this->db); if ($id) { return $this->findById($id); } else { return "Erreur serveur."; } } else { return mysqli_error(); } } else { return $set; } } else { return "Utilisateur déconnecté."; } } else { return $set; } } else { return $set; } }
/** * Updates a Post in the database * * @param Post $post The post to be updated * @throws PDOException if a database error occurs * @return void */ public function update(Post $post) { $stmt = $this->db->prepare("UPDATE posts set title=?, content=? where id=?"); $stmt->execute(array($post->getTitle(), $post->getContent(), $post->getId())); }
private static function showEditVideoReportageForm($post, $error, $new = false) { $name = "Edit"; $caption = "Modifica"; if ($new) { $post = new Post($post); $name = "New"; $caption = "Nuovo"; } ?> <div class="title"><?php echo $caption; ?> Videoreportage</div> <?php if (is_array($error)) { ?> <div class="error"><?php foreach ($error as $err) { ?> <p><?php echo $err; ?> </p> <?php } ?> </div> <?php } if (!isset($_GET["phase"]) || count($error) != 0) { ?> <form name="<?php echo $name; ?> Post" action="?type=videoreportage" method="post"> <!--<p class="post_headline"><label>Occhiello:</label><br /> <input class="post_headline" name="headline" value="<?php echo Filter::decodeFilteredText($post->getHeadline()); ?> "/></p>--> <p class="title"><label>Titolo:</label><br/> <input class="post_title" name="title" value="<?php echo Filter::decodeFilteredText($post->getTitle()); ?> "/></p> <p class="post_subtitle"><label>Sottotilolo:</label><br /> <input class="post_subtitle" name="subtitle" value="<?php echo Filter::decodeFilteredText($post->getSubtitle()); ?> "/></p> <p class="content"><?php if ($post->getContent() != "") { echo youtubeManager::getVideoPlayer($post->getContent()); } ?> <fieldset><legend>Video:</legend> <label>Inserisci l'URL del video: </label><input type="text" name="userUrl" value="<?php echo youtubeManager::getUrl($post->getContent()); ?> "> </fieldset> </p> <p class="tags"><label>Tags:</label> <input class="tags" id="post_tags_input" name="tags" value="<?php echo Filter::decodeFilteredText($post->getTags()); ?> "/></p> <p class="categories"><label>Categorie:</label><br/><?php $cat = array(); if (trim($post->getCategories()) != "") { $cat = explode(", ", Filter::decodeFilteredText($post->getCategories())); } self::showCategoryTree($cat); ?> </p> <p class="<?php echo trim($post->getPlace()) == "" ? "hidden" : ""; ?> "><label id="place_label">Posizione: <?php echo $post->getPlace(); ?> </label></p> <input type="hidden" name="phase" value="<?php if (isset($_POST["phase"]) == 2) { echo '2'; } else { echo '1'; } ?> "> <input id="post_place" name="place" type="hidden" value="<?php echo $post->getPlace(); ?> " /> <input name="visible" type="hidden" value="true" /> <input name="type" type="hidden" value="videoreportage" /> <p class="submit"><input type="submit" value="Pubblica" /> <input type="button" onclick="javascript:save();" value="Salva come bozza"/></p> <script type="text/javascript"> function save() { document.<?php echo $name; ?> Post.visible.value = false; document.<?php echo $name; ?> Post.submit(); } </script> <?php require_once 'manager/MapManager.php'; MapManager::setCenterToMap($post->getPlace(), "map_canvas"); ?> </form> <?php } }
/** * Get post * * This function retrieves an existing post from the server. * * @param array $args (in appkey string, in blogid string, in postid string, * in username string, in password string) * @return string Upon success this will return the content of the post. Upon * failure, the fault will be returned. * @link http://docs.openlinksw.com/virtuoso/fn_blogger.getPost.html */ function getPost($args) { global $server, $site; $postid = $args[1] + 0; $password = $args[3]; if ($password === $site->ad_pass) { $post = new Post($site); $post->fetch_from_db($postid); // error occured? if ($post->postid <= 0) { $server->error(8003, 'No post found.'); } $content = '<title>' . $post->getTitle() . '</title>' . $post->getContent(); $content .= '<template>' . $post->getAttribute('template') . '</template>'; $content .= '<allow_comments>' . $post->getAttribute('allow_comments') . '</allow_comments>'; $content .= '<comment_alert>' . $post->getAttribute('comment_alert') . '</comment_alert>'; $return = array('dateCreated' => $post->time, 'userid' => 1, 'blogid' => 1, 'content' => $content); return $return; } else { $server->error(8000, 'Wrong password given.'); } }
private static function showEditNewsForm($post, $error, $new = false) { $name = "Edit"; $caption = "Modifica"; if ($new) { $post = new Post($post); $name = "New"; $caption = "Nuova"; } ?> <div class="title"><?php echo $caption; ?> Notizia</div> <?php if (is_array($error)) { ?> <div class="error"><?php foreach ($error as $err) { ?> <p><?php echo $err; ?> </p> <?php } ?> </div> <?php } ?> <form name="<?php echo $name; ?> Post" action="?type=News" method="post"> <p class="post_headline"><label>Occhiello:</label><br /> <input class="post_headline" name="headline" value="<?php echo $post->getHeadline(); ?> "/></p> <p class="title"><label>Titolo:</label><br/> <input class="post_title" name="title" value="<?php echo $post->getTitle(); ?> "/></p> <p class="post_subtitle"><label>Sottotilolo:</label><br /> <input class="post_subtitle" name="subtitle" value="<?php echo $post->getSubtitle(); ?> "/></p> <p class="content"><label>Contenuto:</label><br/> <textarea name="content" id="post_content"><?php echo $post->getContent(); ?> </textarea> <!-- sostituisco textarea standard con ckeditor --> <script type="text/javascript"> CKEDITOR.replace( 'post_content', { toolbar : 'edited'}); </script> </p> <p class="tags"><label>Tags:</label> <input class="tags" id="post_tags_input" name="tags" value="<?php echo $post->getTags(); ?> "/></p> <p class="categories"><label>Categorie:</label><br/><?php $cat = array(); if (trim($post->getCategories()) != "") { $cat = explode(", ", Filter::decodeFilteredText($post->getCategories())); } self::showCategoryTree($cat); ?> </p> <p class="<?php echo trim($post->getPlace()) == "" ? "hidden" : ""; ?> "><label id="place_label">Posizione: <?php echo $post->getPlace(); ?> </label></p> <input id="post_place" name="place" type="hidden" value="<?php echo $post->getPlace(); ?> " /> <input name="visible" type="hidden" value="true" /> <input name="type" type="hidden" value="news" /> <p class="submit"><input type="submit" value="Pubblica" /> <input type="button" onclick="javascript:save();" value="Salva come bozza"/></p> <script type="text/javascript"> function save() { document.<?php echo $name; ?> Post.visible.value = false; document.<?php echo $name; ?> Post.submit(); } </script> <?php require_once 'maps/geolocate.php'; MapManager::setCenterToMap($post->getPlace(), "map_canvas"); ?> </form> <?php }
public function testPost() { $date = new \DateTime(); $post = new Post(123, 1, 'A post', 'Some content', 2, $date, 1, 0); $this->assertEquals(123, $post->getID()); $this->assertEquals('A post', $post->getTitle()); $this->assertEquals('Some content', $post->getContent()); $this->assertEquals(2, $post->getVisibility()); $this->assertEquals($date, $post->getDate()); }