本文整理汇总了PHP中ConnectionFactory::executeQuerySimple方法的典型用法代码示例。如果您正苦于以下问题:PHP ConnectionFactory::executeQuerySimple方法的具体用法?PHP ConnectionFactory::executeQuerySimple怎么用?PHP ConnectionFactory::executeQuerySimple使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ConnectionFactory
的用法示例。
在下文中一共展示了ConnectionFactory::executeQuerySimple方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: 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";
}
}