本文整理汇总了PHP中Members::setDB方法的典型用法代码示例。如果您正苦于以下问题:PHP Members::setDB方法的具体用法?PHP Members::setDB怎么用?PHP Members::setDB使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Members
的用法示例。
在下文中一共展示了Members::setDB方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: selectAppointment
function selectAppointment()
{
if (!empty($_GET['type']) && !empty($_GET['of'])) {
$type = $_GET['type'];
$of = $_GET['of'];
$do = $type === "confirm" ? 'confirmed' : 'canceled';
$query = " SELECT `id`,`current_user` FROM `appointment` WHERE `id` = '" . $of . "' AND `doctor`= '" . $this->getFirstName() . " " . $this->getLastName() . "'";
$result = $this->getDB()->query($query);
$this->fetchData($this->getSessionUser());
if ($result->num_rows >= 0) {
$row = $result->fetch_assoc();
$user = $row['current_user'];
$tempmem = new Members();
$tempmem->setDB($this->getDB());
$tempmem->fetchData($user);
echo $user;
echo $tempmem->getEmail();
if ($type === 'confirm') {
$query = "UPDATE `appointment` SET `is_approved` = '1' WHERE `id` ='" . $of . "' AND `doctor`='" . $this->getFirstName() . " " . $this->getLastName() . "'";
Members::sendMail($tempmem->getEmail(), "Your appointment has been approvedd");
} else {
$query = "UPDATE `appointment` SET `is_approved` = '0' WHERE `id` ='" . $of . "' AND `doctor`='" . $this->getFirstName() . " " . $this->getLastName() . "'";
Members::sendMail($tempmem->getEmail(), "Your appointment has been canceled");
}
$result = $this->getDB()->query($query);
if ($this->getDB()->affected_rows > 0) {
$msg = "Appointment has been " . $do;
self::setMessage($msg);
} else {
$msg = "You are not allowed to " . $do . " this appointmnet";
self::setMessage($msg);
}
} else {
$msg = "You are not allowed to " . $do . " this appointmnet";
self::setMessage($msg);
}
}
}
示例2: Members
<?php
include 'src/Members.php';
$members = new Members();
$members->setDB();
$members->redirect();
$members->fetchData($members->getSessionUser());