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


PHP ConnectionFactory::SelectAsStatementHandler方法代码示例

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


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

示例1: codeExist

 public function codeExist($code)
 {
     $statement = ConnectionFactory::SelectAsStatementHandler("SELECT * FROM soldier_code WHERE code = ?", array($code));
     $count = $statement->rowCount();
     if ($count == 0) {
         return false;
     } else {
         return true;
     }
 }
开发者ID:ng2k12,项目名称:MercInc,代码行数:10,代码来源:SoldierCode.php

示例2: getMissionRequiredItemsIDsToQuantity

 public static function getMissionRequiredItemsIDsToQuantity($missionID)
 {
     $query = "SELECT missions_itemreqs.item_quantity, items.id FROM missions_itemreqs JOIN items ON " . "(missions_itemreqs.item_id = items.id) WHERE missions_itemreqs.mission_id = ?";
     $itemSth = ConnectionFactory::SelectAsStatementHandler($query, array($missionID));
     $itemIDsToQuantity = array();
     while ($row = $itemSth->fetch(PDO::FETCH_ASSOC)) {
         $itemID = $row["id"];
         $itemIDsToQuantity[$itemID] = $row["item_quantity"];
     }
     return $itemIDsToQuantity;
 }
开发者ID:ng2k12,项目名称:MercenaryInc,代码行数:11,代码来源:Mission.php

示例3: invitePlayer

 public function invitePlayer($inviteeAgencyCode)
 {
     $userIDQuery = "SELECT id FROM users WHERE agency_code = ?";
     $userIDSth = ConnectionFactory::SelectAsStatementHandler($userIDQuery, array($inviteeAgencyCode));
     $userIDRow = $userIDSth->fetch(PDO::FETCH_ASSOC);
     if ($userIDRow) {
         $inviteeID = $userIDRow['id'];
         $success = ConnectionFactory::InsertIgnoreIntoTableBasic("agencies", array('user_one_id' => $this->id, 'user_two_id' => $inviteeID, 'accepted' => 0));
         if (!$success) {
             return "fail";
         } else {
             return "success";
         }
     } else {
         return "noUserWithAgencyCode";
     }
 }
开发者ID:ng2k12,项目名称:MercenaryInc,代码行数:17,代码来源:User.php

示例4: isUSerExists

 public static function isUSerExists($user_id)
 {
     $user_data = ConnectionFactory::SelectAsStatementHandler("SELECT user_id FROM user_timers WHERE user_id = ? ", array($user_id));
     if ($user_data->rowCount() > 0) {
         return true;
     } else {
         return false;
     }
 }
开发者ID:ng2k12,项目名称:MercInc,代码行数:9,代码来源:UserTimers.php

示例5: SelectRowAsAssociativeArray

 public static function SelectRowAsAssociativeArray($query, $values)
 {
     $sth = ConnectionFactory::SelectAsStatementHandler($query, $values);
     return $sth->fetch();
 }
开发者ID:ng2k12,项目名称:MercInc,代码行数:5,代码来源:ConnectionFactory.php

示例6: invitePlayerUsingLvl6id

 public function invitePlayerUsingLvl6id($lvl6id)
 {
     $userIDQuery = "SELECT id FROM users WHERE id = ?";
     $userIDSth = ConnectionFactory::SelectAsStatementHandler($userIDQuery, array($lvl6id));
     $userIDRow = $userIDSth->fetch(PDO::FETCH_ASSOC);
     if ($userIDRow) {
         $inviteeID = $userIDRow['id'];
         $already_existing_check = "Select count(0) as numrows FROM agencies WHERE user_one_id = {$this->id} AND user_two_id = {$inviteeID} OR user_one_id = {$inviteeID} AND user_two_id = {$this->id}";
         $counter = ConnectionFactory::executeQuerySimple($already_existing_check);
         if ($counter > 0) {
             return "alreadyExisting";
         }
         $success = ConnectionFactory::InsertIgnoreIntoTableBasic("agencies", array('user_one_id' => $this->id, 'user_two_id' => $inviteeID, 'accepted' => 0));
         if (!$success) {
             return "fail";
         } else {
             return "success";
         }
     } else {
         return "noUserWithLvl6id";
     }
 }
开发者ID:ng2k12,项目名称:MercInc,代码行数:22,代码来源:User.php


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