php学习，一个简单的Calendar(2) 一个简单的活动页面
有了前面的基础，后面就是将页面展示出来。
预览图如下：1号和31号分别有活动，会一并显示出来
这里需要搞定几个问题，一个就是数据库的连接，我们用\sys\class\class.db_connect.inc.php
<?php
/*
* 数据库操作（数据库访问，认证等）
*/
class DB_Connect
{
/**
* Stores a database object
*
* @var object A database object
*/
protected $db;
/**
* Checks for a DB object or creates one if one isn't found
*
* @param object $dbo A database object
*/
protected function __construct($db = NULL)
{
if (is_object($db)) {
$this->db = $db;
} else {
// Constants are defined in /sys/config/db-cred.inc.php
$dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME;
try {
$this->db = new PDO($dsn, DB_USER, DB_PASS, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES ' . DB_ENCODE));
} catch (Exception $e) {
// If the DB connection fails, output the error
die ($e->getMessage());
}
}
}
}
?>
程序中需要引入DB_USER等的定义文件：db-cred.inc.php
<?php
/*
* Created on 2012-4-24 by xiongxuebing
*/
/*
* Create an empty array to store constants
*/
$C = array();
/*
* The database host URL
*/
$C['DB_HOST'] = 'localhost';
/*
* The database username
*/
$C['DB_USER'] = 'root';
/*
* The database password
*/
$C['DB_PASS'] = 'root';
/*
* The name of the database to work with
*/
$C['DB_NAME'] = 'php-jquery_example';
$C['DB_ENCODE'] = 'UTF8';
?>
需要注意的是,类似DB_HOST的常量并没有直接定义，而是通过在/sys/core/init.inc.php中进行定义：
foreach ($C as $name => $val) {
define($name, $val);
}
原文件如下的示：
<?php
/*
* Created on 2016-6-19 by luhx
*/
session_start();
/*
* Generate an anti-CSRF token if one doesn't exist
*/
if (!isset($_SESSION['token'])) {
$_SESSION['token'] = sha1(uniqid(mt_rand(), TRUE));
}
/*
* Include the necessary configuration info
*/
include_once '../sys/config/db-cred.inc.php';
/*
* Define constants for configuration info
*/
foreach ($C as $name => $val) {
define($name, $val);
}
/*
* Create a PDO object
*/
$dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME;
$dbo = new PDO($dsn, DB_USER, DB_PASS);
/*
* Define the auto-load function for classes
*/
function __autoload($class)
{
$filename = "../sys/class/class." . $class . ".inc.php";
if (file_exists($filename)) {
include_once $filename;
}
}
?>
接下来需显示日历:index.php
<?php
/*
* Created on 2012-4-24 by xiongxuebing
*/
/*
* 包含必须的文件
*/
include_once '../sys/core/init.inc.php';
/*
* 载入日历
*/
$cal = new Calendar($dbo, "2010-01-01 12:00:00");
/**
* 初始化标题和样式文件
*/
$page_title = "Events Calendar";
$css_files = array('style.css');
include_once 'assets/common/header.inc.php';
?>
<?php
/*
* 包含尾页
*/
include_once 'assets/common/footer.inc.php';
?>
首先需要创建一个Calendar
/sys/class/class.calendar.inc.php
<?php
/*
* Created on 2012-4-24 by xiongxuebing
*/
class Calendar extends DB_Connect
{
/**
* 日历根据此日期构建
* YYYY-MM-DD HH:MM:SS
* @var string
*/
private $_useDate;
/**
* 日历显示月份
* @var int
*/
private $_m;
/**
* 年
* @var int
*/
private $_y;
/**
* 这个月有多少天
* @var int
*/
private $_daysInMonth;
/**
* 这个月从周几开始
* @var int
*/
private $_startDay;
public function __construct($dbo = NULL, $useDate = NULL)
{
parent::__construct($dbo);
/*
* Gather and store data relevant to the month
*/
if (isset($useDate)) {
$this->_useDate = $useDate;
} else {
$this->_useDate = date('Y-m-d H:i:s');
}
$ts = strtotime($this->_useDate);
$this->_m = date('m', $ts);
$this->_y = date('Y', $ts);
$this->_daysInMonth = cal_days_in_month(
CAL_GREGORIAN,
$this->_m,
$this->_y
);
$ts = mktime(0, 0, 0, $this->_m, 1, $this->_y);
$this->_startDay = date('w', $ts);
}
/**
* 生成用于显示日历和活动的HTML标记
*
* 使用储存在类属性中的数据，截入给定月份的活动数据，生成并返回完整的日历HTML标记
* @return string 日历HTML标记
*/
public function buildCalendar()
{
/**
* 确定日历显示月份并创建一个用于标识日历每列星期几的缩写数组
*/
$cal_month = date('F Y', strtotime($this->_useDate));
$cal_id = date('Y-m', strtotime($this->_useDate));
$weekdays = array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');
/**
* 给日历标记添加一个标题
*/
$html = "\n\t<h2 id=\"month-$cal_id\">$cal_month</h2>";
for ($d = 0, $labels = NULL; $d < 7; ++$d) {
$labels .= "\n\t\t<li>" . $weekdays[$d] . "</li>";
}
$html .= "\n\t<ul class=\"weekdays\">" . $labels . "\n\t</ul>";
/*
* Load events data
*/
$events = $this->_createEventObj();
/*
* 生成日历HTML标记
*/
$html .= "\n\t<ul>"; // 开始一个新的<ul>
for ($i = 1, $c = 1, $t = date('j'), $m = date('m'), $y = date('Y'); $c <= $this->_daysInMonth; ++$i) {
$event_info = NULL; // clear the variable
//为该月的之前几天添加填充项
$class = $i <= $this->_startDay ? "fill" : NULL;
//如果当前处理日期是今天，则为他添加class today
if ($c == $t && $m == $this->_m && $y == $this->_y) {
$class = "today";
}
$ls = sprintf("\n\t\t<li class=\"%s\">", $class);
$le = "\n\t\t</li>";
if ($this->_startDay < $i && $this->_daysInMonth >= $c) {
if (isset($events[$c])) {
foreach ($events[$c] as $event) {
$link = '<a href="view.php?event_id=' . $event->id . '">' . $event->title . '</a>';
$event_info = "\n\t\t\t$link";
}
}
$date = sprintf("\n\t\t\t<strong>%02d</strong>", $c++);
} else {
$date = " ";
}
//如果赶上星期六，就新起一行
$wrap = $i != 0 && $i % 7 == 0 ? "\n\t</ul>\n\t<ul>" : NULL;
//Assemble the pieces into a finished item
$html .= $ls . $date . $event_info . $le . $wrap;
}
//Add filler to finish out the last week
while ($i % 7 != 1) {
$html .= "\n\t\t<li class=\"fill\"> </li>";
++$i;
}
//Close the final unordered list
$html .= "\n\t</ul>\n\n";
$admin = $this->_adminGeneralOptions();
/**
* 返回用于输出的HTML标记
*/
return $html . $admin;
}
/**
* 得到活动信息HTML
* @param int $id 活动ID
* @return string 用于显示活动信息的基本HTML标记
*/
public function displayEvent($id)
{
/**
* Make sure an ID was passed
* */
if (empty($id)) {
return NULL;
}
/**
* Make sure the ID is an integer
**/
$id = preg_replace('/[^0-9]/', '', $id);
/**
* Load the event data from the DB
**/
$event = $this->_loadEventById($id);
/**
* Generate strings for the date, start, and end time
* */
$ts = strtotime($event->start);
$date = date('F d, Y', $ts);
$start = date('g:ia', $ts);
$end = date('g:ia', strtotime($event->end));
/*
* Load admin options if the user is logged in
*/
$admin = $this->_adminEntryOptions($id);
return "<h2>$event->title</h2>\n\t<p class=\"dates\">$date, $start—$end</p>" .
"\n\t<p>$event->description</p>$admin";
}
public function displayForm()
{
if (isset($_POST['event_id'])) {
$id = (int)$_POST['event_id'];
// Force integer type to sanitize data
} else {
$id = NULL;
}
/*
* Instantiate the headline/submit button text
*/
$submit = "Create new!";
/*
* If an ID is passed, loads the associated event
*/
if (!empty($id)) {
$event = $this->_loadEventById($id);
if (!is_object($event)) {
return NULL;
}
$submit = "Edit event!";
}
return <<<FORM_MARKUP
<form action="assets/inc/process.inc.php" method="post">
<fieldset>
<legend>$submit</legend>
<label for="event_title">Event Title</label>
<input type="text" name="event_title" id="event_title" value="$event->title" />
<label for="event_start">Start Time</label>
<input type="text" name="event_start" id="event_start" value="$event->start" />
<label for="event_end">End Time</label>
<input type="text" name="event_end" id="event_end" value="$event->end" />
<label for="event_description">Event Description</label>
<textarea name="event_description" id="event_description">$event->description</textarea>
<input type="hidden" name="event_id" value="$event->id" />
<input type="hidden" name="token" value="$_SESSION[token]" />
<input type="hidden" name="action" value="event_edit" />
<input type="submit" name="event_submit" value="$submit" /> or <a href="./" class = "link">cancel</a>
</fieldset>
</form>
FORM_MARKUP;
}
public function processForm()
{
if ($_POST['action'] != 'event_edit') {
return "The method processForm was accessed incorrectly";
}
$title = htmlentities($_POST['event_title'], ENT_QUOTES, "UTF-8");
$desc = htmlentities($_POST['event_description'], ENT_QUOTES, "UTF-8");
$start = htmlentities($_POST['event_start'], ENT_QUOTES, "UTF-8");
$end = htmlentities($_POST['event_end'], ENT_QUOTES, "UTF-8");
if (!$this->_validDate($start) || !$this->_validDate($end)) {
return "Invalid date format! Use YYYY-MM-DD HH:MM:SS.";
}
/*
* If no event ID passed, create a new event
*/
if (empty($_POST['event_id'])) {
$sql = "INSERT INTO `events` (`event_title`, `event_desc`, `event_start`, `event_end`)" .
" VALUES (:title, :description, :start, :end)";
} else {
$id = (int)$_POST['event_id'];
$sql = "UPDATE `events` SET `event_title`=:title,`event_desc`=:description,`event_start`=:start,`event_end`=:end WHERE `event_id`=$id";
}
try {
$stmt = $this->db->prepare($sql);
$stmt->bindParam(":title", $title, PDO::PARAM_STR);
$stmt->bindParam(":description", $desc, PDO::PARAM_STR);
$stmt->bindParam(":start", $start, PDO::PARAM_STR);
$stmt->bindParam(":end", $end, PDO::PARAM_STR);
$stmt->execute();
$stmt->closeCursor();
return $this->db->lastInsertId();
} catch (Exception $e) {
return $e->getMessage();
}
}
public function confirmDelete($id)
{
if (empty($id)) {
return NULL;
}
$id = preg_replace('/[^0-9]/', '', $id);
/*
* If the confirmation form was submitted and the form.
* has a valid token, check the form submission
*/
if (isset($_POST['confirm_delete']) && $_POST['token'] == $_SESSION['token']) {
/*
* If the deletion is confirmed,
* remove the event from the database
*/
if ($_POST['confirm_delete'] == "删除") {
$sql = "DELETE FROM `events` WHERE `event_id`=:id LIMIT 1";
try {
$stmt = $this->db->prepare($sql);
$stmt->bindParam(":id", $id, PDO::PARAM_INT);
$stmt->execute();
$stmt->closeCursor();
header("Location: ./");
return;
} catch (Exception $e) {
return $e->getMessage();
}
} /*
* If not confirmed,
* sends the user to the main view
*/
else {
header("Location: ./");
return;
}
}
/*
* If the confirmation form hasn't been submitted, display it
* */
$event = $this->_loadEventById($id);
/*
* If no object is returned, return to the main view
* */
if (!is_object($event)) {
header("Location: ./");
}
return <<<CONFIRM_DELETE
<form action="confirmdelete.php" method="post">
<h2>确定要删除 "$event->title" 吗?</h2>
<p>删除后将<strong>不能恢复</strong>！</p>
<p>
<input type="submit" name="confirm_delete" value="删除" />
<input type="submit" name="confirm_delete" value="取消" />
<input type="hidden" name="event_id" value="$event->id" />
<input type="hidden" name="token" value="$_SESSION[token]" />
</p>
</form>
CONFIRM_DELETE;
}
private function _validDate($date)
{
$pattern = '/^(\d{4}(-\d{2}){2} (\d{2})(:\d{2}){2})$/';
/*
* If a match is found, return TRUE. FALSE otherwise.
*/
return preg_match($pattern, $date) == 1 ? TRUE : FALSE;
}
private function _loadEventData($id = NULL)
{
$sql = "SELECT `event_id`, `event_title`, `event_desc`,`event_start`, `event_end` FROM `events`";
if (!empty($id)) {
$sql .= "WHERE `event_id`=:id LIMIT 1";
} else {
$start_ts = mktime(0, 0, 0, $this->_m, 1, $this->_y);
$end_ts = mktime(23, 59, 59, $this->_m + 1, 0, $this->_y);
$start_date = date('Y-m-d H:i:s', $start_ts);
$end_date = date('Y-m-d H:i:s', $end_ts);
$sql .= "WHERE `event_start` BETWEEN '$start_date' AND '$end_date' ORDER BY `event_start`";
}
try {
$stmt = $this->db->prepare($sql);
/*
* Bind the parameter if an ID was passed
*/
if (!empty($id)) {
$stmt->bindParam(":id", $id, PDO::PARAM_INT);
}
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
$stmt->closeCursor();
return $results;
} catch (Exception $e) {
die ($e->getMessage());
}
}
/**
* 载入该月全部活动信息到一个数组
* @return array 活动信息
*/
private function _createEventObj()
{
/*
* Load the events array
*/
$arr = $this->_loadEventData();
/**
* Create a new array, then organize the events* by the day of the monthon which they occur
* */
$events = array();
foreach ($arr as $event) {
$day = date('j', strtotime($event['event_start']));
try {
$events[$day][] = new Event($event);
} catch (Exception $e) {
die ($e->getMessage());
}
}
return $events;
}
private function _loadEventById($id)
{
/**
* 如果id为空，返回NULL
*/
if (empty($id)) {
return NULL;
}
/**
* 载入活动信息数组
*/
$event = $this->_loadEventData($id);
/**
* 返回event对象
*/
if (isset($event[0])) {
return new Event($event[0]);
} else {
return NULL;
}
}
private function _adminGeneralOptions()
{
if (isset($_SESSION['user'])) {
return <<<ADMIN_OPTIONS
<a href="admin.php" class="admin">+ 新 建 活 动</a>
<form action="assets/inc/process.inc.php" method="post">
<div>
<input type="submit" value="登 出" class="link" />
<input type="hidden" name="token" value="$_SESSION[token]" />
<input type="hidden" name="action" value="user_logout" />
</div>
</form>
ADMIN_OPTIONS;
} else {
return <<<ADMIN_OPTIONS
<a href="login.php" class="link">登 录</a>
ADMIN_OPTIONS;
}
}
private function _adminEntryOptions($id)
{
if (isset($_SESSION['user'])) {
return <<<ADMIN_OPTIONS
<div class="admin-options">
<form action="admin.php" method="post">
<p>
<input type="submit" name="edit_event" value="编 辑" />
<input type="hidden" name="event_id" value="$id" />
</p>
</form>
<form action="confirmdelete.php" method="post">
<p>
<input type="submit" name="delete_event" value="删 除" />
<input type="hidden" name="event_id" value="$id" />
</p>
</form>
</div>
<!-- end .admin-options -->
ADMIN_OPTIONS;
} else {
return NULL;
}
}
}
?>
然后在目录/public/assets/common/中 加入页头文件header.inc.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta htp-equiv="Content-Type" content="text/html;charset=utf-8" />
<title><?php echo $page_title; ?></title>
<?php foreach ($css_files as $css): ?>
<link rel="stylesheet" type="text/css" media="screen,projection"
href="assets/css/<?php echo $css; ?>" />
<?php endforeach; ?>
</head>
<body>
页尾文件footer.inc.php
</body>
</html>
加入css文件：public/assets/css/style.css
body{
background-color:#789;
font-famly:georgia,serif;
font-size:13px;
}
#content {
display:block;
width:812px;
margin:40px auto 10px;
padding:10px;
background-color:#FFF;
-moz-border-radius:6px;
-webkit-border-radius:6px;
border-radius:6px;
border:2px solid black;
-moz-box-shadow:0 0 14px #123;
-webkit-box-shadow:0 0 14px #123;
box-shadow:0 0 14px #123;
}
h2,p{
margin:0 auto 14px;
text-align:center;
}
ul{
display:block;
clear:left;
height:82px;
width:812px;
margin:0 auto;
padding: 0;
list-style:none;
background-color:#FFF;
text-align:center;
border:1px solid black;
border-top: 0;
border-bottom: 2px solid black;
}
li {
position:relative;
float:left;
margin:0;
padding:20px 2px 2px;
border-left:1px solid black;
border-right:1px solid black;
width: 110px;
height: 60px;
overflow:hidden;
background-color:white;
}
li:hover{
background-color:#FCB;
z-index:1;
-moz-box-shadow: 0 0 10px #789;
-webkit-box-shadow: 0 0 10px #789;
box-shadow:0 0 10px #789;
}
.weekdays{
height: 20px;
border-top: 2px solid black;
}
.weekdays li{
height: 16px;
padding: 2px 2px;
background-color: #BCF;
}
.fill{
background-color:#BCD;
}
.weekdays li:hover,li.fill:hover{
background-color:#BCD;
-moz-box-shadow: none;
-webkit-box-shadow: none;
box-shadow: none;
}
.weekdays li:hover,.today{
background-color: #BCF;
}
li strong {
position:absolute;
top: 2px;
right:2px;
}
li a {
position: relative;
display:block;
border: 1px dotted black;
margin:2px;
padding:2px;
font-size:11px;
background-color:#BEF;
text-align:left;
-moz-border-radius: 6px;
-webkit-border-radius:6px;
border-radius:6px;
z-index:1;
text-decoration:none;
color:black;
font-weight:bold;
font-style:italic;
}
li a:hover {
background-color:#BCF;
z-index:2;
-moz-box-shadow: 0 0 6px #789;
-webkit-box-shadow: 0 0 6px #789;
box-shadow: 0 0 6px #789;
}
