The material takes deep into PHP and jquery development, and this book is actually about an activity calendar.
This article is suitable to go from other languages (such as Java,c++,python, etc.) to PHP, no system to learn PHP, or PHP beginners, has a deep understanding of the program friends
Above is the file directory structure, public is the program root directory, the goal is for the security aspect consideration, puts the core program in the outside Access place.
The local demo address is:http://localhost/index.php
The first is the database script:
/* Navicat MySQL Data Transfer source server:localhost_3306 source Server version:50130 Source host:127.0.0.1: 3306 Source database:php-jquery_example target server type:mysql target server version:50130 File encoding:65 001 date:2016-06-19 16:54:29 * * CREATE DATABASE <span style= "Color:rgb (0, 0, 255);" >IF</SPAN> not EXISTS ' php-jquery_example ' <span style= ' color:rgb (0, 0, 255); " >DEFAULT</SPAN> CHARACTER SET UTF8 COLLATE utf8_unicode_ci<span style= "Color:rgb (0, 128, 0);" >;</SPAN> SPAN style= "Color:rgb (0, 128, 0);" > </SPAN> SPAN style= "Color:rgb (0, 128, 0);" > </SPAN> SPAN style= "Color:rgb (0, 128, 0);" >set foreign_key_checks=0;</span>--------------------------------Table structure <span style= "Color:rg B (0, 0, 255); " >for</SPAN> Events------------------------------DROP TABLE <span style= "Color:rgb (0, 0, 255);" >IF</SPAN> EXISTS ' Events ' <span style="Color:rgb (0, 128, 0);" >;</SPAN> SPAN style= "Color:rgb (0, 128, 0);" >create TABLE ' Events ' (</SPAN> ' event_id ' int (one) not NULL auto_increment, ' event_title ' varchar Utf8_unicode_ci <span style= "Color:rgb (0, 0, 255);" >DEFAULT</SPAN> null, ' Event_desc ' text COLLATE utf8_unicode_ci, ' event_start ' timestamp not NULL <span St yle= "Color:rgb (0, 0, 255);" >DEFAULT</SPAN> ' 0000-00-00 00:00:00 ', ' event_end ' timestamp not NULL <span style= ' color:rgb (0, 0, 255); " >DEFAULT</SPAN> ' 0000-00-00 00:00:00 ', PRIMARY key (' event_id '), key ' Event_start ' (' Event_start ') engine= MyISAM auto_increment=3 <span style= "Color:rgb (0, 0, 255);" >DEFAULT</SPAN> Charset=utf8 collate=utf8_unicode_ci<span style= "Color:rgb (0, 128, 0);" >;</SPAN> SPAN style= "Color:rgb (0, 128, 0);" ></SPAN> SPAN style= "Color:rgb (0, 128, 0);" >------------------------------</SPAN>--Records of events------------------------------INSERT into ' Events ' VALUES (' 1 ', ' New year&<span style= "Color:rgb (0, 128, 0);" >; #039 S Day ', ' Happy New year! ', ' 2010-01-01 00:00:00 ', ' 2010-01-01 23:59:59 ');</span> inserts into ' events ' VAL UES (' 2 ', ' last day of January ', ' last day of the month! yay! ', ' 2010-01-31 00:00:00 ', ' 2010-01-31 23:59:59 ') <span style= "Color:rgb (0, 128, 0);"
>;</SPAN>
PHP Development make a simple calendar of events Calendar second, please click.
The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.