Exemplos de CDataManager::ExercuseQuery em PHP

Exemplo n.º 1

Arquivo: CStatistic.php Projeto: NguyenThanhDung/Finance

 static function GetTotalMoney($filter)
 {
     $sql = "SELECT SUM(Amount) AS TotalMoney FROM detail ";
     $sql .= $filter->GetWhereClauseCommand();
     $result = CDataManager::ExercuseQuery($sql);
     $first_row = mysql_fetch_array($result);
     return $first_row['TotalMoney'];
 }

Exemplo n.º 2

Arquivo: CSettingManager.php Projeto: NguyenThanhDung/Finance

 static function DropTable()
 {
     $sql = "DROP TABLE IF EXISTS setting";
     return CDataManager::ExercuseQuery($sql);
 }