PHP CL_MySQL Examples

Example #1

File: CL_MySQL.back.php Project: stefda/pocketsail

 /**
  * @return CL_MySQL
  */
 public static function get_instance()
 {
     if (self::$instance === NULL) {
         self::$instance = new CL_MySQL();
     }
     return self::$instance;
 }

Example #2

File: UserModel.php Project: stefda/pocketsail

 public static function loadById($id)
 {
     $mysql = CL_MySQL::getInstance();
     $mysql->select('user', '*', ['id' => $id]);
     $o = $mysql->fetchObject();
     if ($o === NULL) {
         return NULL;
     }
     return new UserModel($o);
 }

Example #3

File: contextmanager.php Project: stefda/decimill-web-frontend

 function __construct()
 {
     parent::CL_Controller();
     $this->load->model('ModelModel');
     $this->load->model('ScenarioModel');
     $this->load->model('ContextModel');
     $this->load->model('QueryModel');
     $this->load->model('TempModel');
     $this->db = CL_MySQL::getInstance();
 }

Example #4

File: StudyModel.php Project: stefda/decimill-web-frontend

 public static function loadByUser($userId)
 {
     $db = CL_MySQL::getInstance();
     $db->select('study', '*', ['study_to_user' => ['studyId' => 'id']], ['study_to_user.userId' => $userId]);
     //        echo $db->getQuery();
     //        exit();
     $studies = [];
     while ($o = $db->fetchObject()) {
         $studies[] = self::fromObject($o);
     }
     return $studies;
 }

Example #5

File: editor.php Project: stefda/decimill-web-frontend

 function __construct()
 {
     parent::CL_Controller();
     $this->load->model('CaseModel');
     $this->load->model('ModelModel');
     $this->load->model('ScenarioModel');
     $this->load->model('QueryModel');
     $this->load->model('ContextModel');
     $this->db = CL_MySQL::getInstance();
     if (!$this->session->is_set('caseId')) {
         $this->location('/');
     }
 }

Example #6

File: Common.php Project: stefda/pocketsail

/**
 * @return CL_Database
 */
function get_mysql()
{
    return CL_MySQL::get_instance();
}

Example #7

File: CL_Meta.php Project: stefda/pocketsail

 public static function set_page($type, $pageId, $value)
 {
     $value = mysqli_escape_string($value);
     $mysql = CL_MySQL::get_instance();
     $mysql->query("INSERT INTO sb_meta (page_id, level, type, value) VALUES ({$pageId}, 3, '{$type}', '{$value}') ON DUPLICATE KEY UPDATE value = '{$value}'");
 }

Example #8

File: blog.php Project: stefda/pocketsail

 function log($url, $id)
 {
     $mysql = CL_MySQL::getInstance();
     $mysql->insert('blog', ['url' => $url, 'id' => $id]);
 }

Example #9

File: Common.php Project: stefda/decimill-web-frontend

/**
 * Shortcut for instantiating mysql.
 * 
 * @return CL_MySQL
 */
function cl_mysql()
{
    return CL_MySQL::getInstance();
}

Example #10

File: TempModel.php Project: stefda/decimill-web-frontend

 public static function remove($id, $caseId)
 {
     $db = CL_MySQL::getInstance();
     $db->query("DELETE FROM `temp` WHERE `id` = '{$id}' AND `caseId` = {$caseId}");
 }