本文整理匯總了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;
}
}示例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;
}示例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";
}
}示例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;
}
}示例5: SelectRowAsAssociativeArray
public static function SelectRowAsAssociativeArray($query, $values)
{
$sth = ConnectionFactory::SelectAsStatementHandler($query, $values);
return $sth->fetch();
}示例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";
}
}