php learning, a simple Calendar(1), php learning calendar
The material is taken from in-depth PHP and JQuery development. This book actually tells an activity schedule.
This article is suitable for those who have switched from other languages (such as java, C, python, etc.) to PHP, who have not systematically learned PHP, or who are PHP beginners and already have a deep understanding of the program
/*
1 | Navicat MySQL Data Transfer
|
Copy after login
1 | Source Server : localhost_3306
|
Copy after login
1 | Source Server Version : 50130
|
Copy after login
1 | Source Host : 127.0.0.1:3306
|
Copy after login
1 | Source Database : php-jquery_example
|
Copy after login
1 | Target Server Type : MYSQL
|
Copy after login
1 | Target Server Version : 50130
|
Copy after login
1 | Date : 2016-06-19 16:54:29
|
Copy after login
1 | CREATE DATABASE <span>IF</span> NOT EXISTS `php-jquery_example`
|
Copy after login
1 | <span>DEFAULT</span> CHARACTER SET utf8
|
Copy after login
1 | COLLATE utf8_unicode_ci<span>;</span>
|
Copy after login
1 | <span>SET FOREIGN_KEY_CHECKS=0;</span>
|
Copy after login
1 | -- ----------------------------
|
Copy after login
Copy after login
Copy after login
1 | -- Table structure <span> for </span> events
|
Copy after login
1 | -- ----------------------------
|
Copy after login
Copy after login
Copy after login
1 | DROP TABLE <span>IF</span> EXISTS `events`<span>;</span>
|
Copy after login
1 | <span>CREATE TABLE `events` (</span>
|
Copy after login
1 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
Copy after login
1 | `event_title` varchar(80) COLLATE utf8_unicode_ci <span>DEFAULT</span> NULL,
|
Copy after login
1 | `event_desc` text COLLATE utf8_unicode_ci,
|
Copy after login
1 | `event_start` timestamp NOT NULL <span>DEFAULT</span> '0000-00-00 00:00:00' ,
|
Copy after login
1 | `event_end` timestamp NOT NULL <span>DEFAULT</span> '0000-00-00 00:00:00' ,
|
Copy after login
1 | PRIMARY KEY (`event_id`),
|
Copy after login
1 | KEY `event_start` (`event_start`)
|
Copy after login
1 | ) ENGINE=MyISAM AUTO_INCREMENT=3 <span>DEFAULT</span> CHARSET=utf8 COLLATE=utf8_unicode_ci<span>;</span>
|
Copy after login
1 | <span>-- ----------------------------</span>
|
Copy after login
1 | -- ----------------------------
|
Copy after login
Copy after login
Copy after login
1 | INSERT INTO `events` VALUES ( '1' , 'New Year&<span>;#039;s Day' , 'Happy New Year!' , '2010-01-01 00:00:00' , '2010-01-01 23:59:59' );</span>
|
Copy after login
1 | INSERT INTO `events` VALUES ( '2' , 'Last Day of January' , 'Last day of the month!Yay!' , '2010-01-31 00:00:00' , '2010-01-31 23:59:59' )<span>;</span>
|
Copy after login
http://www.bkjia.com/PHPjc/1135181.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1135181.htmlTechArticlephp learning, a simple Calendar (1), php learning calendar materials are taken in-depth PHP and JQuery development, this This book is actually about a calendar of events. This article is suitable for reading from other languages...