当前位置: 首页>>代码示例>>PHP>>正文


PHP SQLQBuilder::countResultset方法代码示例

本文整理汇总了PHP中SQLQBuilder::countResultset方法的典型用法代码示例。如果您正苦于以下问题:PHP SQLQBuilder::countResultset方法的具体用法?PHP SQLQBuilder::countResultset怎么用?PHP SQLQBuilder::countResultset使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SQLQBuilder的用法示例。


在下文中一共展示了SQLQBuilder::countResultset方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: countCityInfo

 function countCityInfo($schStr, $mode)
 {
     $tableName = 'HS_HR_CITY';
     $arrFieldList[0] = 'ID';
     $arrFieldList[1] = 'NAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->countResultset($schStr, $mode);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $line = mysql_fetch_array($message2, MYSQL_NUM);
     return $line[0];
 }
开发者ID:rabbitdigital,项目名称:HRM,代码行数:17,代码来源:CityInfo.php

示例2: countMembershipInfo

 function countMembershipInfo($schStr, $mode)
 {
     $tableName = 'HS_HR_MEMBERSHIP a LEFT JOIN HS_HR_MEMBERSHIP_TYPE b ON (a.membtype_code = b.membtype_code)';
     $arrFieldList[0] = 'a.MEMBSHIP_CODE';
     $arrFieldList[1] = 'a.MEMBSHIP_NAME';
     $arrFieldList[2] = 'b.MEMBTYPE_NAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->countResultset($schStr, $mode);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $line = mysql_fetch_array($message2, MYSQL_NUM);
     return $line[0];
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:18,代码来源:MembershipInfo.php

示例3: countJobTitles

 function countJobTitles($schStr, $mode)
 {
     $tableName = 'HS_HR_JOB_TITLE';
     $arrFieldList[0] = 'JOBTIT_CODE';
     $arrFieldList[1] = 'JOBTIT_NAME';
     $arrFieldList[2] = 'IS_ACTIVE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     if (is_array($schStr)) {
         $schStr[] = 1;
         // To get only the active job titles
     }
     $sqlQString = $sql_builder->countResultset($schStr, $mode);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $line = mysql_fetch_array($message2, MYSQL_NUM);
     return $line[0];
 }
开发者ID:THM068,项目名称:orangehrm,代码行数:22,代码来源:JobTitle.php

示例4: countEducation

 function countEducation($schStr, $mode)
 {
     $tableName = 'HS_HR_EDUCATION';
     $arrFieldList[0] = 'EDU_CODE';
     $arrFieldList[1] = 'EDU_DEG';
     $arrFieldList[2] = 'EDU_UNI';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->countResultset($schStr, $mode);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $line = mysql_fetch_array($message2, MYSQL_NUM);
     return $line[0];
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:17,代码来源:Education.php

示例5: countprojectID

 /**
  * To get the number of projects
  */
 public function countprojectID($schStr, $schField)
 {
     $tableName = self::PROJECT_DB_TABLE;
     $arrFieldList[0] = self::PROJECT_DB_FIELD_PROJECT_ID;
     $arrFieldList[1] = self::PROJECT_DB_FIELD_DELETED;
     $arrFieldList[2] = self::PROJECT_DB_FIELD_CUSTOMER_ID;
     $arrFieldList[3] = self::PROJECT_DB_FIELD_NAME;
     $arrFieldList[4] = self::PROJECT_DB_FIELD_DESCRIPTION;
     $schField = 1;
     $schStr = 0;
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->countResultset($schStr, $schField);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $line = mysql_fetch_array($message2, MYSQL_NUM);
     return $line[0];
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:25,代码来源:Projects.php

示例6: getCount

 /**
  * Count job specs with given search conditions
  * @param string $schStr Search string
  * @param string $mode Integer giving which field to search on
  */
 public static function getCount($schStr = '', $mode = -1)
 {
     $count = 0;
     $arrFieldList[0] = self::DB_FIELD_ID;
     $arrFieldList[1] = self::DB_FIELD_NAME;
     $arrFieldList[2] = self::DB_FIELD_DESC;
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = self::TABLE_NAME;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->countResultset($schStr, $mode);
     $dbConnection = new DMLFunctions();
     $result = $dbConnection->executeQuery($sqlQString);
     if ($result) {
         $line = mysql_fetch_array($result, MYSQL_NUM);
         $count = $line[0];
     }
     return $count;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:24,代码来源:JobSpec.php

示例7: countSalaryGrades

 public function countSalaryGrades($schStr, $mode)
 {
     $tableName = 'HS_PR_SALARY_GRADE';
     $arrFieldList[0] = 'SAL_GRD_CODE';
     $arrFieldList[1] = 'SAL_GRD_NAME';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     $sqlQString = $sql_builder->countResultset($schStr, $mode);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $line = mysql_fetch_array($message2, MYSQL_NUM);
     return $line[0];
 }
开发者ID:THM068,项目名称:orangehrm,代码行数:16,代码来源:SalaryGrades.php

示例8: countUsers

 function countUsers($schStr, $mode, $isAdmin)
 {
     $arrFieldList[0] = 'id';
     $arrFieldList[1] = 'user_name';
     $arrFieldList[2] = 'is_admin';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $this->tableName;
     $sql_builder->flg_select = 'true';
     $sql_builder->arr_select = $arrFieldList;
     if ($isAdmin) {
         $isAdmin = 'Yes';
     } else {
         $isAdmin = 'No';
     }
     $schStr = array($schStr, $isAdmin);
     $mode = array($mode, 2);
     $sqlQString = $sql_builder->countResultset($schStr, $mode, true);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     $line = mysql_fetch_array($message2, MYSQL_NUM);
     return $line[0];
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:24,代码来源:Users.php


注:本文中的SQLQBuilder::countResultset方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。