Exemple #1
0
 public function __construct()
 {
     $select_sql = "SELECT * from pbglobal";
     if ($result = $GLOBALS['mysqli']->query($select_sql)) {
         $row = $result->fetch_assoc();
         $this->TemplateFolder = $row['templatefolder'];
         $this->PostTemplateName = $row['posttemplatename'];
         $this->PostFolder = $row['postfolder'];
         $this->PostUrl = $row['posturl'];
         $this->CategoryTemplateName = $row['categorytemplatename'];
         $this->IndexTemplateName = $row['indextemplatename'];
         $this->IndexFolder = $row['indexfolder'];
         $this->IndexFileName = $row['indexfilename'];
         $this->LightCarousel = $row['lightcarousel'];
         $this->DarkCarousel = $row['darkcarousel'];
     } else {
         glogg('something happened:' . $GLOBALS['mysqli']->error);
         glogg($insert_sql);
     }
 }
Exemple #2
0
 public static function assignpostcategories($blog)
 {
     if ($blog->Categories) {
         $delete_sql = "DELETE FROM pbpostcategory WHERE postid = {$blog->ID};";
         if ($GLOBALS['mysqli']->query($delete_sql)) {
             foreach ($blog->Categories as $category) {
                 $insert_sql = "INSERT INTO pbpostcategory (postid,categoryid) values ({$blog->ID},{$category->ID});";
                 if ($GLOBALS['mysqli']->query($insert_sql) == FALSE) {
                     glogg('something happened:' . $GLOBALS['mysqli']->error);
                     glogg($insert_sql);
                 }
             }
         } else {
             glogg('something happened:' . $GLOBALS['mysqli']->error);
             glogg($insert_sql);
         }
     }
 }
 public function Save()
 {
     if ($this->ID < 1) {
         //add new
         $insert_sql = function () {
             $col_list = '';
             $val_list = '';
             if (!empty($this->PostID)) {
                 $col_list .= 'postid,';
                 $val_list .= "'{$this->PostID}',";
             }
             if (!empty($this->Response)) {
                 $col_list .= 'response,';
                 $val_list .= "'{$this->Response}',";
             }
             if (!empty($this->Name)) {
                 $col_list .= 'name,';
                 $val_list .= "'{$this->Name}',";
             }
             if (!empty($this->Email)) {
                 $col_list .= 'email,';
                 $val_list .= "'{$this->Email}',";
             }
             $col_list .= 'responsedate';
             $val_list .= 'now()';
             $retval = 'insert into pbuserresponse (' . $col_list . ') values (' . $val_list . ');';
             return $retval;
         };
         if ($GLOBALS['mysqli']->query($insert_sql())) {
             $this->ID = $GLOBALS['mysqli']->insert_id;
         } else {
             glogg('something happened:' . $GLOBALS['mysqli']->error);
             glogg($insert_sql);
         }
     } else {
         //update isok
         if ($this->IsOK == TRUE) {
             $update_sql = "update pbuserresponse set isok = '' where id = {$this->ID};";
             if ($GLOBALS['mysqli']->query($update_sql())) {
             } else {
                 glogg('something happened--:' . $GLOBALS['mysqli']->error);
                 glogg($update_sql());
             }
         }
     }
 }