PHP rex_sql::getRow 예제들

getRow() 공개 메소드

Gibt den Wert der aktuellen Zeile im ResultSet zurueck und bewegt den internen Zeiger auf die naechste Zeile.

public getRow ( $fetch_type = PDO::FETCH_ASSOC )

예제 #1

파일: rex_asd_news_language.php 프로젝트: Sysix/asd_news

function asd_news_addClang($params)
{
    global $REX;
    $id = $params['id'];
    $name = $params['name'];
    $now = new DateTime();
    $error = false;
    $sql = new rex_sql();
    $sql->setQuery('SELECT * FROM `' . rex_asd_news_config::getTable() . '` WHERE `clang` = ' . $REX['START_CLANG_ID']);
    for ($i = 1; $i <= $sql->getRows(); $i++) {
        $save = new rex_sql();
        $save->setTable(rex_asd_news_config::getTable());
        $save->setValues($sql->getRow());
        $save->setValue('clang', $id);
        $save->setValue('createdAt', $now->format('Y-m-d H:i:s'));
        $save->setValue('updatedAt', $now->format('Y-m-d H:i:s'));
        $save->setValue('publishedAt', '0000-00-00 00:00:00');
        $save->setValue('createdBy', $REX['USER']->getValue('user_id'));
        $save->setValue('updatedBy', $REX['USER']->getValue('user_id'));
        $save->setValue('publishedBy', 0);
        $save->setValue('status', 0);
        unset($save->values['news_id']);
        if (!$save->insert()) {
            $error = $save->getError();
        }
    }
    if ($error) {
        echo rex_warning('ASD News: Neuigkeiten in der Sprache "' . $name . '" konnten nicht angelegt werden<br />' . $error);
    } else {
        echo rex_info('ASD News: Neuigkeiten in der Sprache "' . $name . '" wurden angelegt');
    }
}

예제 #2

파일: rex_asd_news_utils.php 프로젝트: Sysix/asd_news

 /**
  * @param array $params
  * @return array
  */
 public static function isImageInUse($params)
 {
     /** @var i18n $I18N */
     global $I18N;
     $sql = new rex_sql();
     $sqlCols = rex_asd_news_config::getConfig('sql');
     $sql->setQuery('SELECT `id`, `title` FROM `' . rex_asd_news_config::getTable() . '` WHERE `' . $sqlCols['picture'] . '` = "' . $params['filename'] . '"');
     if ($sql->getRows()) {
         $message = $I18N->msg('asd_news') . '<br /><ul>';
         for ($i = 1; $i <= $sql->getRow(); $i++) {
             $message .= '
 <li>
     <a href="index.php?page=' . rex_asd_news_config::getName() . '&amp;func=edit&amp;id=' . $sql->getValue('id') . '">
         ' . $sql->getValue('title') . '
     </a>
 </li>';
         }
         $message .= '</ul>';
         $params['subject'][] = $message;
     }
     return $params['subject'];
 }

예제 #3

파일: class.rex_global_settings_language.php 프로젝트: olien/global_settings

 /**
  * @param $from
  * @param $to
  * @return bool
  */
 public static function copyLanguageData($from, $to)
 {
     global $REX;
     $sql = new rex_sql();
     $sql->setQuery('SELECT * FROM `' . $REX['TABLE_PREFIX'] . 'global_settings` WHERE `clang` = ' . (int) $from);
     for ($i = 1; $i <= $sql->getRows(); $i++) {
         $save = new rex_sql();
         $save->setTable($REX['TABLE_PREFIX'] . 'global_settings');
         $save->setValues($sql->getRow());
         $save->setValue('clang', $to);
         return $save->insert();
     }
     return false;
 }