PHP QueryExecutor::execute Examples

Example #1

File: TeamsMySqlExtDAO.class.php Project: rajnishp/teamroomV3

 protected function getListAllTeamDashboard($sqlQuery)
 {
     $tab = QueryExecutor::execute($sqlQuery);
     $ret = array();
     for ($i = 0; $i < count($tab); $i++) {
         $ret[$i] = $this->readRowAllTeamDashboard($tab[$i]);
     }
     return $ret;
 }

Example #2

File: ChallengeResponsesMySqlExtDAO.class.php Project: rajnishp/teamroomV3

 /**
  * Get row
  *
  * @return ChallengeResponsesMySql 
  */
 protected function getRowResponse($sqlQuery)
 {
     $tab = QueryExecutor::execute($sqlQuery);
     if (count($tab) == 0) {
         return null;
     }
     return $this->readRowResponse($tab[0]);
 }

Example #3

File: UserInfoMySqlExtDAO.class.php Project: rajnishp/teamroomV3

 protected function getListUsers($sqlQuery)
 {
     $tab = QueryExecutor::execute($sqlQuery);
     $ret = array();
     for ($i = 0; $i < count($tab); $i++) {
         $ret[$i] = $this->readUserRow($tab[$i]);
     }
     return $ret;
 }

Example #4

File: MyStudentDAO.php Project: seiran1944/slate

 protected function getStudentClassScoreList($sqlQuery)
 {
     $tab = QueryExecutor::execute($sqlQuery);
     $ret = array();
     for ($i = 0; $i < count($tab); $i++) {
         $ret[$i] = $this->readStudentClassScoreRow($tab[$i]);
     }
     return $ret;
 }

Example #5

File: VodMySqlExtDAO.class.php Project: roberto-pina/ventana-educativa

 public function getLastTemporadaOfSerie($idSerie)
 {
     $sql = 'SELECT MAX(temporada) temporada FROM vod WHERE id_serie = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->set($idSerie);
     $tab = QueryExecutor::execute($sqlQuery);
     if (count($tab) == 0) {
         return null;
     }
     return $tab[0]['temporada'];
 }

Example #6

File: BannersuperiorMySqlDAO.class.php Project: njr1466/akipom

 /**
  * Execute sql query
  */
 protected function execute($sqlQuery)
 {
     return QueryExecutor::execute($sqlQuery);
 }

Example #7

File: generate.php Project: renduples/alibtob

function getFields($table)
{
    $sql = 'DESC ' . $table;
    return QueryExecutor::execute(new SqlQuery($sql));
}

Example #8

File: StudentScoreDAO.php Project: seiran1944/slate

 protected function getStudentScoreList($sqlQuery)
 {
     $tab = QueryExecutor::execute($sqlQuery);
     return $tab;
 }

Example #9

File: generate.php Project: hkerem/JournaledPHPDAO

function getFields($table)
{
    $sql = 'DESC ' . $table;
    $rettab = array();
    $r = 0;
    $origtab = QueryExecutor::execute(new SqlQuery($sql));
    for ($i = 0; $i < count($origtab); $i++) {
        $fieldname = $origtab[$i][0];
        $row = $origtab[$i];
        switch ($fieldname) {
            case 'rid':
                break;
            case 'is_deleted':
                break;
            case 'create_epoch':
                break;
            case 'delete_epoch':
                break;
            default:
                $rettab[$r++] = $row;
                break;
        }
    }
    return $rettab;
}