Ejemplo n.º 1
0
 /**
  * this method performs both insert and update
  * this only runs a query if data has changed
  * this updates dbData through the orig refrence
  * saving behavior is determined by the contents of the orig array
  *	if empty orig insert else update
  * after a save all objects that refrence this orig data will be refcrenced to the new data
  *
  * @return bool or int affected rows
  */
 public function save()
 {
     $res = true;
     $changedData = $this->changedData();
     if (count($changedData)) {
         if (!empty($this->orig)) {
             $res = dbHelper::updateQry($this->tableName, $changedData, array($this->primaryKey => $this->data[$this->primaryKey])) ? true : false;
             $this->orig = $this->data;
         } else {
             //if this row has been deleted but someone else saves data to it this will automatically restore the row from $data
             $res = dbHelper::insertQry($this->tableName, $this->data) ? true : false;
             $this->data[$this->primaryKey] = db::insertID();
             dbData::addRow($this->tableName, $this->primaryKey, $this->data);
             $this->orig =& dbData::rowRefrence($this->tableName, $this->primaryKey, $this->data[$this->primaryKey]);
         }
     }
     return $res;
 }
Ejemplo n.º 2
0
 /**
  * delete all rows from this table matching where clause
  * @param array $where
  *	@see dbHelper::joinWhere() for $where formatting
  * @param mixed $andor
  * 	@see dbHelper::andOr() for more info on $setor formatting
  * @param string $bypasswhere this is a flag to prevent delete all if you pass an empty $where array
  *	@see dbHelper::deleteQry() for more info
  *
  * @return bool or int (affected rows)
  */
 public function deleteRowsWhere($where, $andor = 'AND', $bypassWhere = 'DONT_DELETE_EVERYTHING')
 {
     $ret = dbHelper::deleteQry($this->tableName, $where, $andor, $bypassWhere);
     if ($ret) {
         dbData::emptyTable($this->tableName);
     }
     return $ret;
 }
Ejemplo n.º 3
0
 /**
  * this is to remove all data from this obejct
  * @return true
  */
 public static function emptyData()
 {
     self::$data = array();
     return true;
 }
Ejemplo n.º 4
0
// PHPQuery examples :)
// you can write this code in the way you want, it is very flexible
// first define DEVELOPER MODE, if the constant get value true, the framework show errors and remake the cache of tpl always.
// if the constant get value false, the framework DON'T SHOW ERRORS, and don't remake cache of tpls (only if there are not or you delete old cache)
define('DEVMODE', true);
// this is obsolete after version 1.0.1
// converted in _::declare_component('searcher');
define('REQUIRE_SEARCHER', true);
// now, require the core of PHPQuery, this is only line necessary
require 'phpquery/core.php';
// this set new values for the default configuration of DB
// see default config in phpquery/default_config/dbData.php
dbData::$host = 'localhost';
dbData::$user = '******';
dbData::$pass = '';
dbData::$db = 'adminwp';
// if you don't like .tpl extension in views, you set do you want
// you see default config in phpquery/default_config/tplData.php
//tplData::$extension = '.html';
// initialize the framework using debug mode (you can change the constant if like)
_::init(DEVMODE);
// the important, you need declare the controllers that exist
// first declare file (example.php), later you declare the controllers in the file
_::declare_controller('example', 'example', 'example_2', 'example_3', 'example_4');
// en general.php el controlador home
_::declare_controller('real_example', 'home', 'login', 'login2', 'registro', 'registro2');
// if you like add others definitions and declarations in external file
// you can require or include others files and declare it
require 'others/headers.php';
// REQUERIMOS TODAS LAS FUNCIONES QUE SE EJECUTARAN EN EL FOOTER
require 'others/footer.php';