php学习,一个简单的Calendar(2) 一个简单的活动页面
程序员文章站
2024-01-25 11:33:47
...
有了前面的基础,后面就是将页面展示出来。
分享
预览图如下:1号和31号分别有活动,会一并显示出来
这里需要搞定几个问题,一个就是数据库的连接,我们用\sys\class\class.db_connect.inc.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
/*
* 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);
}
原文件如下的示:
/*
* 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
/*
* 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';?>/*
微信
声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。
相关文章
相关视频
上一篇: 这个界面如何做
下一篇: 一段php加密解密的代码_php技巧