PHP tx_t3devapi_database Examples

Example #1

File: class.tx_t3devapi_pibase.php Project: Apen/t3devapi

 /**
  * Get the current request with PageBrowser limit
  *
  * @return string SQL ressource
  */
 public function getListPageBrowser()
 {
     $this->conf['records']['pagebrowsernbrecords'] = $this->conf['pageBrowserNbRecords'];
     $this->conf['records']['nbpages'] = ceil(intval($this->conf['records']['nbrecordsall']) / intval($this->conf['pageBrowserNbRecords']));
     $this->conf['records']['offset'] = isset($this->piVars['page']) ? $this->piVars['page'] * $this->conf['pageBrowserNbRecords'] : 0;
     $this->conf['query']['LIMIT'] = $this->conf['records']['offset'] . ',' . $this->conf['pageBrowserNbRecords'];
     return tx_t3devapi_database::exec_SELECT_queryArray($this->conf['query'], $this->conf['debug']);
 }

Example #2

File: tx_t3devapi_templating_Test.php Project: Apen/t3devapi

 public function checkPageExist($uid)
 {
     $query = array();
     $query['SELECT'] = 'uid';
     $query['FROM'] = 'pages';
     $query['WHERE'] = 'uid=' . intval($uid) . ' AND deleted=0 AND hidden=0';
     $res = tx_t3devapi_database::exec_SELECT_queryArray($query);
     $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
     $GLOBALS['TYPO3_DB']->sql_free_result($res);
     return empty($row);
 }