PHP Zend\Db\ResultSet\ResultSet::currentの例

コード例 #1

ファイル: FacebookColl.php プロジェクト: caiofior/cercaziende

 /**
  * Count items
  * @return int
  */
 public function countAll($criteria = array())
 {
     $select = $this->content->getTable()->getSql()->select()->columns(array(new \Zend\Db\Sql\Expression('COUNT(*)')));
     $select = $this->setFilter($select, $criteria);
     $statement = $this->content->getTable()->getSql()->prepareStatementForSqlObject($select);
     $results = $statement->execute();
     $resultSet = new \Zend\Db\ResultSet\ResultSet();
     $resultSet->initialize($results);
     $data = $resultSet->current()->getArrayCopy();
     return intval(array_pop($data));
 }

コード例 #2

ファイル: PersonColl.php プロジェクト: caiofior/cercaziende

 /**
  * Count items
  * @return int
  */
 public function countAll($criteria = array())
 {
     $select = $this->content->getTable()->getSql()->select()->columns(array(new \Zend\Db\Sql\Expression('COUNT(*)')));
     if (array_key_exists('filter', $criteria) && is_array($criteria['filter'])) {
         foreach ($criteria['filter'] as $field => $word) {
             if (is_string($word)) {
                 $select->where($field . ' LIKE"' . addslashes($word) . '%"');
             }
         }
     }
     $select = $this->setFilter($select, $criteria);
     $statement = $this->content->getTable()->getSql()->prepareStatementForSqlObject($select);
     $results = $statement->execute();
     $resultSet = new \Zend\Db\ResultSet\ResultSet();
     $resultSet->initialize($results);
     $data = $resultSet->current()->getArrayCopy();
     return intval(array_pop($data));
 }

コード例 #3

ファイル: export_person.php プロジェクト: caiofior/cercaziende

<?php

require __DIR__ . '/../include/pageboot.php';
$fName = 'php://stdout';
if (is_array($argv) && array_key_exists('1', $argv)) {
    $fName = $argv[1];
}
$fh = fopen($fName, 'w');
$statement = $GLOBALS['db']->query(' SELECT * FROM `person_to_person` WHERE or_codFisc <> "" AND codFisc <> ""');
$resultSet = new \Zend\Db\ResultSet\ResultSet();
$resultSet->initialize($statement->execute());
fwrite($fh, '"OR","DEST"' . PHP_EOL);
while ($resultSet->valid()) {
    $row = $resultSet->current();
    fwrite($fh, '"' . $row['or_codFisc'] . '","' . $row['codFisc'] . '"' . PHP_EOL);
    $resultSet->next();
}
fclose($fh);

コード例 #4

ファイル: export_company.php プロジェクト: caiofior/cercaziende

<?php

require __DIR__ . '/../include/pageboot.php';
$fName = 'php://stdout';
if (is_array($argv) && array_key_exists('1', $argv)) {
    $fName = $argv[1];
}
$fh = fopen($fName, 'w');
$statement = $GLOBALS['db']->query(' SELECT * FROM `company_to_company` WHERE or_partIVA <> 0 AND dest_partIVA != ""');
$resultSet = new \Zend\Db\ResultSet\ResultSet();
$resultSet->initialize($statement->execute());
fwrite($fh, '"OR","DEST"' . PHP_EOL);
while ($resultSet->valid()) {
    $row = $resultSet->current();
    if (is_array($argv) && array_key_exists('2', $argv)) {
        $statement1 = $GLOBALS['db']->query(' SELECT COUNT(*) FROM `company` WHERE 
            ( partIVA = "' . $row['or_partIVA'] . '" OR partIVA = "' . $row['dest_partIVA'] . '" )
            AND ' . $argv[2]);
        $resultSet1 = new \Zend\Db\ResultSet\ResultSet();
        $resultSet1->initialize($statement1->execute());
        $c = $resultSet1->current();
        if (current($c) == 0) {
            $resultSet->next();
            continue;
        }
    }
    fwrite($fh, '"' . $row['or_partIVA'] . '","' . $row['dest_partIVA'] . '"' . PHP_EOL);
    $resultSet->next();
}
fclose($fh);