Exemple #1
0
 public static function getAllCount($tableName)
 {
     $sql = "select count(*) from " . $tableName;
     $db = Pft_Dbx::getDbx();
     return $db->getOne($sql);
 }
Exemple #2
0
 /**
  * 创建ID存储的数据表
  *
  * @param String $managerName
  */
 private function _createIdManagerTable($managerName)
 {
     //MySql
     $sql = "\n\t\t\t\tcreate table {$managerName}\n\t\t\t\t(\n\t\t\t\t   sys_id               int(11) not null auto_increment,\n\t\t\t\t   gu_id                CHAR(36),\n\t\t\t\t   primary key (sys_id)\n\t\t\t\t)\n\t\t\t\ttype = MYISAM;\n\t\t\t\t\n\t\t\t\tcreate unique index Index_{$managerName}_GU_ID on {$managerName}\n\t\t\t\t(\n\t\t\t\t   gu_id\n\t\t\t\t);\n\t\t\t\t";
     $this->_db->execute($sql);
 }