tagebuch db

rich1.0phorkiehttps://p.cweiske.de/tagebuch dbChristian Weiske86400900900 <link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/> <div class="phork" id="71"> <div class="phork-file"> <div class="phork-content"> <style type="text/css">/** * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann * (http://qbnz.com/highlighter/ and http://geshi.org/) */ .php .de1, .php .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;} .php {font-family:monospace;} .php .imp {font-weight: bold; color: red;} .php li, .php .li1 {color: #DDD;} .php .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;} .php .kw1 {color: #b1b100;} .php .kw2 {color: #000000; font-weight: bold;} .php .kw3 {color: #990000;} .php .kw4 {color: #009900; font-weight: bold;} .php .co1 {color: #666666; font-style: italic;} .php .co2 {color: #666666; font-style: italic;} .php .co3 {color: #0000cc; font-style: italic;} .php .co4 {color: #009933; font-style: italic;} .php .coMULTI {color: #666666; font-style: italic;} .php .es0 {color: #000099; font-weight: bold;} .php .es1 {color: #000099; font-weight: bold;} .php .es2 {color: #660099; font-weight: bold;} .php .es3 {color: #660099; font-weight: bold;} .php .es4 {color: #006699; font-weight: bold;} .php .es5 {color: #006699; font-weight: bold; font-style: italic;} .php .es6 {color: #009933; font-weight: bold;} .php .es_h {color: #000099; font-weight: bold;} .php .br0 {color: #009900;} .php .sy0 {color: #339933;} .php .sy1 {color: #000000; font-weight: bold;} .php .st0 {color: #0000ff;} .php .st_h {color: #0000ff;} .php .nu0 {color: #cc66cc;} .php .nu8 {color: #208080;} .php .nu12 {color: #208080;} .php .nu19 {color:#800080;} .php .me1 {color: #004000;} .php .me2 {color: #004000;} .php .re0 {color: #000088;} .php span.xtra { display:block; } </style><div class="code"><table class="php"><tbody><tr class="li1"><td class="ln"><pre class="de1">1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 </pre></td><td class="de1"><pre class="de1"><?php class Tagebuch_Db {     /**      * @var PDO      */     public $db = null;       protected $config = null;         public function __construct()     {         $this->config = Tagebuch_Config::get();         $this->prepare();         $this->loadFiles();     }           /**      * Returns a post object from the given file.      *      * @param string $file File name without path      *      * @return Tagebuch_Post or boolean false if not found      */     public function getPost($file)     {         $stmt = $this->db->prepare('SELECT * FROM posts WHERE file = ?');         $stmt->execute(<a href="http://www.php.net/array">array</a>($file));         return $stmt->fetchObject('Tagebuch_Post');     }           public function getPosts($tag = null, $limit = null)     {         if ($tag === null) {             $tag = '%';         } else {             $tag = '%,' . $tag . ',%';         }         $stmt = $this->db->prepare(             'SELECT * FROM posts'             . ' WHERE tags LIKE ?'             . ' ORDER BY modified DESC'             . ($limit !== null ? ' LIMIT ' . $limit : '')         );         $stmt->execute(<a href="http://www.php.net/array">array</a>($tag));         return $stmt->fetchAll(PDO::FETCH_CLASS, 'Tagebuch_Post');     }           /**      * Fetches the next and previous posts from the database.      *      * @param string $file Filename to fetch      * @param string $tag  Tag name that determines the file list      *                     - may be null for no tag      *      * @return array Array with prev and next keys, post objects      *               as value. NULL when empty      */     public function getPrevNext($file, $tag = null)     {         if ($tag === null) {             $tag = '%';         } else {             $tag = '%,' . $tag . ',%';         }         $qfile = $this->db->quote($file);         $qtag  = $this->db->quote($tag);         <a href="http://www.php.net/list">list</a>($date) = $this->db->query(             'SELECT modified FROM posts WHERE file LIKE '             . $qfile             . ' LIMIT 1'         )->fetch();         $qdate = $this->db->quote($date);           $prev = $this->db             ->query('SELECT * FROM posts'                     . ' WHERE modified < ' . $qdate                     . ' AND tags LIKE ' . $qtag                     . ' ORDER BY modified DESC LIMIT 1'             )->fetchObject('Tagebuch_Post');         $next = $this->db             ->query('SELECT * FROM posts'                     . ' WHERE modified > ' . $qdate                     . ' AND tags LIKE ' . $qtag                     . ' ORDER BY modified ASC LIMIT 1'             )->fetchObject('Tagebuch_Post');           return <a href="http://www.php.net/array">array</a>(             'prev' => $prev,             'next' => $next         );     }           /**      * Returns an array of all tags      */     public function getTags()     {         $stmt = $this->db->query('SELECT tags FROM posts');         $tags = <a href="http://www.php.net/array">array</a>();         while ($row = $stmt->fetch(PDO::FETCH_OBJ, PDO::FETCH_ORI_NEXT)) {             $rtags = <a href="http://www.php.net/array_flip">array_flip</a>(<a href="http://www.php.net/explode">explode</a>(',', <a href="http://www.php.net/substr">substr</a>($row->tags, 1, -1)));             $tags = <a href="http://www.php.net/array_merge">array_merge</a>($tags, $rtags);         }         <a href="http://www.php.net/unset">unset</a>($tags['']);           return <a href="http://www.php.net/array_keys">array_keys</a>($tags);     }             /**      * Prepares the table structure      *      * @return void      */     protected function prepare()     {         $this->db = new PDO('sqlite::memory:');         $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);         $this->db->exec("CREATE TABLE posts( title TEXT, file TEXT, size INTEGER, created DATE, modified DATE, tags TEXT, license TEXT )");             }           /**      * Loads raw files into database      *      * @return void      */     protected function loadFiles()     {         $query = $this->db->prepare(             'insert into posts (title,file,size,created,modified,tags,license)'             . ' VALUES(:title,:file,:size,:created,:modified,:tags,:license)'         );         $query->bindParam(':title', $title);         $query->bindParam(':file', $filename);         $query->bindParam(':size', $size);         $query->bindParam(':created', $crdate);         $query->bindParam(':modified', $mdate);         $query->bindParam(':tags', $tags);         $query->bindParam(':license', $license);           foreach ($this->getRawFiles() as $file) {             $hp = new Tagebuch_HtmlPost($file);             $crdate = $hp->getCreationDate();             $mdate  = $hp->getModificationDate();             $tags   = ',' . <a href="http://www.php.net/implode">implode</a>(                 ',',                 $hp->getTags()             ) . ',';             $title    = $hp->getTitle();             $filename = <a href="http://www.php.net/basename">basename</a>($file);             $size     = <a href="http://www.php.net/filesize">filesize</a>($file);             $license  = $hp->getLicense();             $query->execute();         }     }           /**      * Returns an array full of raw filename paths      *      * @return array Array of raw file names      */     protected function getRawFiles()     {         return <a href="http://www.php.net/glob">glob</a>($this->config->raw . '*.htm');     } }   ?></pre></td></tr></tbody></table></div> </div> <div class="phork-meta"> <a href="https://p.cweiske.de/71/rev-raw/786113230e2e99fc5d0fceb08e876bd6a8b8c9a5/Db.php" style="float: right">view raw source</a> <a href="https://p.cweiske.de/71#Db.php">Db.php</a> </div> </div> </div>