protected function update(News $news)
 {
     $requete = $this->db->prepare('UPDATE news SET auteur = :auteur, titre = :titre, contenu = :contenu, dateModif = NOW() WHERE id = :id');
     $requete->bindValue(':titre', $news->titre());
     $requete->bindValue(':auteur', $news->auteur());
     $requete->bindValue(':contenu', $news->contenu());
     $requete->bindValue(':id', $news->id(), PDO::PARAM_INT);
     $requete->execute();
 }
Exemplo n.º 2
0
 public function commit()
 {
     if ($this->valid_origin) {
         $nv = new NewsValidate(array('writer' => $this->writer, 'target' => $this->target, 'image' => $this->image, 'origin' => $this->origin, 'title' => $this->title, 'content' => $this->content, 'begin' => $this->begin, 'end' => $this->end, 'comment' => $this->comment));
         $v = new Validate(array('writer' => $this->writer, 'group' => $this->target->group(), 'item' => $nv, 'type' => 'news'));
         $v->insert();
     } else {
         $n = new News();
         $n->insert();
         $n->writer($this->writer);
         $n->target($this->target);
         $n->image($this->image);
         $n->origin($this->origin);
         $n->title($this->title);
         $n->content($this->content);
         $n->begin($this->begin);
         $n->end($this->end);
         $n->comment($this->comment);
         $this->idIfValid = $n->id();
         // This code is used to post news on a newsgroup server
         //if ($this->target->rights()->isMe(Rights::everybody())) {
         //    $this->sendnewsgroupmail();
         //}
     }
     return true;
 }
 /**
  * @see NewsManager::update()
  */
 protected function update(News $news)
 {
     $requete = $this->db->prepare('UPDATE news SET auteur = ?, titre = ?, contenu = ?, dateModif = NOW() WHERE id = ?');
     $requete->bind_param('sssi', $news->auteur(), $news->titre(), $news->contenu(), $news->id());
     $requete->execute();
 }
Exemplo n.º 4
0
function viewTable($data, $count)
{
    $news = new News();
    $paginations = new Paginations();
    $paginations->setLimit(10);
    $paginations->setPage($_REQUEST['page']);
    $paginations->setJSCallback("viewNews");
    $paginations->setTotalPages($count);
    $paginations->makePagination();
    ?>
    <div class="mws-panel-header">
        <span class="mws-i-24 i-table-1">View News</span>
    </div>
<div class="mws-panel-body">
    <table cellpadding="0" cellspacing="0" border="0" class="mws-datatable-fn mws-table">
        <colgroup>
            <col class="con0"/>
            <col class="con1"/>
        </colgroup>
        <thead>
        <tr>
            <th class="head1">News Title</th>
            <th class="head0">&nbsp;</th>
            <th class="head0">&nbsp;</th>
            <th class="head1">&nbsp;</th>
        </tr>
        </thead>
        <tbody>
        <?php 
    if (count($data) > 0) {
        ?>

            <?php 
        for ($i = 0; $i < count($data); $i++) {
            $news->extractor($data, $i);
            ?>
                <tr id="row_<?php 
            echo $news->id();
            ?>
">
                    <td class="con1"><?php 
            echo $news->title();
            ?>
</td>
                    <td class="con0"><?php 
            //echo $news->image();
            ?>
</td>
                    <td class="con0"><?php 
            //echo $admins->username();
            ?>
</td>
                    <td class="center"><a onclick="loadGUIContent('news','edit','<?php 
            echo $news->id();
            ?>
')">Edit</a>
                        <a onclick="deleteNews(<?php 
            echo $news->id();
            ?>
)" class="toggle">Delete</a></td>
                </tr>
            <?php 
        }
        ?>

        <?php 
    }
    ?>
        </tbody>
    </table>
    <?php 
    $paginations->drawPagination();
}