PHP tx_rnbase_util_DB::fullQuoteStr Exemples

Exemple #1

Fichier : class.tx_rnbase_util_TSDAM.php Projet : RocKordier/rn_base

 /**
  * Get picture count
  * @return int
  */
 public static function getImageCount($tableName, $fieldName, $itemId)
 {
     $options['where'] = 'tablenames=' . tx_rnbase_util_DB::fullQuoteStr($tableName, 'tx_dam_mm_ref');
     $options['where'] .= ' AND ident=' . tx_rnbase_util_DB::fullQuoteStr($fieldName, 'tx_dam_mm_ref');
     $options['where'] .= ' AND uid_foreign=' . (int) $itemId;
     $options['count'] = 1;
     $options['enablefieldsoff'] = 1;
     $ret = tx_rnbase_util_DB::doSelect('count(*) AS \'cnt\'', 'tx_dam_mm_ref', $options, 0);
     $cnt = count($ret) ? intval($ret[0]['cnt']) : 0;
     return $cnt;
 }

Exemple #2

Fichier : class.tx_rnbase_util_TSFAL.php Projet : RocKordier/rn_base

 /**
  * Get picture count
  * @return int
  */
 public static function getImageCount($tableName, $fieldName, $itemId)
 {
     $options['where'] = 'tablenames = ' . tx_rnbase_util_DB::fullQuoteStr($tableName, 'sys_file_reference');
     $options['where'] .= ' AND fieldname = ' . tx_rnbase_util_DB::fullQuoteStr($fieldName, 'sys_file_reference');
     $options['where'] .= ' AND uid_foreign = ' . (int) $itemId;
     $options['count'] = 1;
     $options['enablefieldsoff'] = 1;
     $ret = tx_rnbase_util_DB::doSelect('count(*) AS \'cnt\'', 'sys_file_reference', $options);
     return empty($ret) ? 0 : (int) $ret[0]['cnt'];
 }