Розробка середовища для управління сайтами на основі HTML5

            static function getInstance()

            {

                  if (!self::$instance)

                        self::$instance = new self();

                  return self::$instance;

            } 
 

            public function getPages()

            {

                  return DB::getInstance()->select("SELECT * FROM `pages`");

            } 

            public function getPage($id)

            {

                  $id = (int)$id;

                  if ($id)

                  {

                        $result = DB::getInstance()->select("SELECT * FROM `pages` WHERE `id`={$id} LIMIT 1");

                        if ($result[0])

                        {

                              return $result[0];

                        }

                  }

                  return false;

            } 

            public function setPage($data,$id=null)

            {

                  $set_sql = "SET ";

                  $set_data = array();

                  foreach ($data as $key=>$val)

                  {

                        switch ($key)

                        {

                        case 'id':

                        case 'url':

                        case 'content':

                              $val = str_replace("'", "\\'", stripslashes($val));

                              $set_data[] = "`$key` = '$val'";

                        break;

                        }

                  }

                  if ($set_data)

                  {

                        $set_sql .= implode(',',$set_data);

                        $id = (int)$id;

                        if ($id)

                        {

                              DB::getInstance()->update("UPDATE `pages` {$set_sql} WHERE `id`='{$id}'");

                              return true;

                        }

                        else

                        {

                              return DB::getInstance()->insert("INSERT INTO `pages` {$set_sql}");

                        }

                  } 

                  return false;

            } 

            public function deletePage($id)

            {

                  $id = (int)$id;

                  if ($id)

                  {

                        DB::getInstance()->update("DELETE FROM `pages` WHERE `id`='{$id}'");

                  }

                  return false;

            }

      }

models\ Settings.php

<?php

      class Settings

      {

            static $instance; 

            /**

             *

             * @return Settings

             */

            static function getInstance()

            {

                  if (!self::$instance)

                        self::$instance = new self();

                  return self::$instance;

            } 

            protected $cache = array(); 

            protected function __construct()

            {

            } 

            public function __get($setting)

            {

                  if (!isset($this->cache[$setting]))

                  {

                        $result = DB::getInstance()->select("SELECT `value` FROM `settings` WHERE `name`='{$setting}' LIMIT 1");

                        if ($result[0])

                        {

                              $this->cache[$setting] = $result[0]['value'];

                        }

                  }

                  return $this->cache[$setting]; 

            } 

            public function __set($setting,$value)

            {

                  //Экранирование кавычек  для нормальной работы с любыми  значениями и для защиты от  SQL-инъекций

                  $setting = str_replace("'", "\\'", $setting);

                  $value = str_replace("'", "\\'", stripslashes($value)); 

                  $result = DB::getInstance()->select("SELECT `value` FROM `settings` WHERE `name`='{$setting}' LIMIT 1");

                  if ($result[0])

                  {

                        DB::getInstance()->update("UPDATE `settings` SET `value`='{$value}' WHERE `name`='{$setting}'");

                  }

                  else

                  {

                        DB::getInstance()->insert("INSERT INTO `settings` (`name`,`value`) VALUES ('{$setting}','{$value}')");

                  }

                  return $this;

            }

      }

configs\ access.ini 

users[] = "admin;secretpassword" 

configs\db.ini

host = localhost

database = cms

user = cms

pass = cms