PHP+Mysql+jQuery+fullcalendar实现公司内部订餐系统

•2010-06-11 10:51:36•网站建设

本文涉及到的插件: jQuery, jQuery.UI, fullcalendar

数据库创建:

CREATE TABLE USER
(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(100)
);

CREATE TABLE ITEM
(
ID INT PRIMARY KEY AUTO_INCREMENT,
USER_ID INT,
FOOD TINYBOLB,
ORDER_TIME TIMESTAMP
);

ALTER TABLE ITEM ADD FOREIGN KEY(USER_ID) REFERENCES USER(ID) ON DELETE CASCADE;

一个实体的基类, 封装: Entity.php

<?php
/**
* 实体基类
* @author selfimpr
* @blog http://blog.csdn.net/lgg201
* @email lgg860911@yahoo.com.cn
*
*/
class Entity {
    protected static $_mapping = array();
    public static function getField($column_name) {
        return self::$_mapping[$column_name] ? self::$_mapping[$column_name] : $column_name;
    }
    public function set($field, $value) {
        $method = 'set'.ucwords($field);
        return $this->$method($value);
    }
    public function get() {
        $method = 'get'.ucwords($field);
        return $this->$method();
    }
}
?>

本文关键词: PHP,Mysql,jQuery,公司内部订餐系统,订餐系统