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层基类
*/
