public function index() { echo 'zzzzzzzzzzz 1'; if ($this->findGroupId() > 0) { header('Location: ' . __SITE_CONTEXT . 'admin/dashboard/'); return; } if ($_SERVER['REQUEST_METHOD'] == 'POST') { $username = remove_slashes($_POST['username']); $password = remove_slashes($_POST['password']); $memberDAO = new MemberDAO(DataSource::getInstance()); $group_id = $memberDAO->checkLogin($username, $password); if ($group_id == 0) { // login failed $message = 'Sai username hoặc password!'; $this->registry->template->message = $message; $this->registry->template->username = $username; } else { $_SESSION['member'] = array('group_id' => $group_id); header('Location: ' . __SITE_CONTEXT . 'admin/dashboard/'); return; } } $categoryDAO = new CatDAO(DataSource::getInstance()); $categories_list = $categoryDAO->findByAll_Navigation(); $promoDAO = new PromoDAO(DataSource::getInstance()); $this->registry->template->promo_seo_url_newest = $promoDAO->findNewestSeoUrl(); $cart = getCart(); $this->registry->template->categories_list = $categories_list; $this->registry->template->cart = $cart; $this->registry->template->tile_title = 'Login'; $this->registry->template->body_class = 'page-template'; $this->registry->template->tile_content = 'login.php'; $this->registry->template->tile_footer = 'footer.php'; $this->registry->template->show('layout/user.php'); }
<?php require_once "MemberDAO.php"; echo "["; try { $memberDAO = new MemberDAO(); $members = $memberDAO->getAll(); $x = 0; foreach ($members as $member) { if ($x > 0) { echo ","; } $code = trim($member->code); $name = trim($member->name); $roleName = trim($member->roleName); $roleCode = trim($member->role); $dateOfBirth = trim($member->dateOfBirth); $gender = trim($member->gender); $departmentCode = trim($member->department); $departmentName = trim($member->departmentName); $address = trim($member->address); $email = trim($member->email); $phone = $member->phone; $institution = $member->institution; echo '{"code":' . $code . ',"name":"' . $name . '","roleName":"' . $roleName . '","dateOfBirth":"' . $dateOfBirth . '", "gender":"' . $gender . '","departmentName":"' . $departmentName . '","address":"' . $address . '","email":"' . $email . '", "phone":"' . $phone . '","institution":"' . $institution . '","roleCode":' . $roleCode . ',"departmentCode":' . $departmentCode . '}'; $x++; } } catch (Exception $exception) { // echo $exception->getMessage();
<?php require_once "MemberDAO.php"; $code = trim($_GET["code"]); $name = str_replace('"', "'", trim($_GET["name"])); $email = str_replace('"', "'", trim($_GET["email"])); $phone = str_replace('"', "'", trim($_GET["phone"])); $address = str_replace('"', "'", trim($_GET["address"])); $department = str_replace('"', "'", trim($_GET["department"])); $institution = str_replace('"', "'", trim($_GET["institution"])); $gender = str_replace('"', "'", trim($_GET["gender"])); $role = str_replace('"', "'", trim($_GET["role"])); $dob = str_replace('"', "'", trim($_GET["dob"])); try { $member = new Member(); $member->code = $code; $member->name = $name; $member->email = $email; $member->phone = $phone; $member->address = $address; $member->department = $department; $member->institution = $institution; $member->gender = $gender; $member->role = $role; $member->dateOfBirth = $dob; $memberDAO = new MemberDAO(); $members = $memberDAO->update($member); echo "Updated Successfully"; } catch (Exception $exception) { echo $exception->getMessage(); }
<?php require_once "MemberDAO.php"; $name = str_replace('"', "'", trim($_GET["name"])); $email = str_replace('"', "'", trim($_GET["email"])); $phone = str_replace('"', "'", trim($_GET["phone"])); $address = str_replace('"', "'", trim($_GET["address"])); $department = str_replace('"', "'", trim($_GET["department"])); $institution = str_replace('"', "'", trim($_GET["institution"])); $gender = str_replace('"', "'", trim($_GET["gender"])); $role = str_replace('"', "'", trim($_GET["role"])); $dob = str_replace('"', "'", trim($_GET["dob"])); try { $member = new Member(); $member->name = $name; $member->email = $email; $member->phone = $phone; $member->address = $address; $member->department = $department; $member->institution = $institution; $member->gender = $gender; $member->role = $role; $member->dateOfBirth = $dob; $memberDAO = new MemberDAO(); $members = $memberDAO->add($member); echo "Added"; } catch (Exception $exception) { echo $exception->getMessage(); }
public function delete($code) { try { $c = DatabaseConnection::getConnection(); if (self::exists($code) == false) { throw new DAOException("DepartmentDAO : delete : Invalid code " . $code); } $memberDAO = new MemberDAO(); if ($memberDAO->getCountByDepartment($code) > 0) { throw new DAOException("DepartmentDAO : delete : Department used against some member(s) " . $code); } $ps = $c->prepare("delete from tbl_department where code = ?"); $ps->bindParam(1, $code); $ps->execute(); $ps = null; $c = null; } catch (Exception $exception) { throw new DAOException("DepartmentDAO : delete : " . $exception->getMessage()); } }
<?php require_once "MemberDAO.php"; $code = $_GET["code"]; try { $memberDAO = new MemberDAO(); $memberDAO->delete($code); echo "Successfully Deleted"; } catch (Exception $exception) { echo $exception->getMessage(); }
* * @param array $filter // 过滤条件 * @param string $field // 获取字段 * @param int $page // 当前页 * @param int $limit // 页数 */ function fetch($filter = array(), $field = "*", $page = 1, $limit = null) { $this->_db->select($filed)->from($this->_table)->where($filter)->limit($page, $limit); return $this->_db->execute(); } function update() { } function delete() { } function insert() { } } class MemberDAO extends BaseDAO { var $_table = "member"; } $oMember = new MemberDAO(); $oMember->fetch(); /** * 常用到的地方: * MVC中model层基类 */