PaulTsao

This project established the B/S mode Earthquake & Disasters Resistance Information Management System (EDRIMS) .

It based on CBR(Case-based Reasoning) theory and used several related programming languages and development tools, including PHP, HTML ,JavaScript, CSS, Dreamware, AppServ, NotePad++, Sublime text 2, etc. In the course of the project, the earthquake & disasters resistance case database(EDRCDB) based on MySQL had been constructed.

The tested system can be enabled to realize the main four functions of CBR: case retrieval, case reuse, case revise and case retaining, and can create, insert, select and delete specific case information via browsers.

AppServ 2.5.10

Apache 2.2.8

PHP 5.2.6

MySQL 5.0.51b

phpMyAdmin-2.10.3

Download Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.10.exe?download

MD5SUM : 279c0c39866fbecb8a3904969fd5d0f4

AppServ 2.6.0

Apache 2.2.8

PHP 6.0.0-dev

MySQL 6.0.4-alpha

phpMyAdmin-2.10.3

Download Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv-win32-2.6.0.exe?download

MD5SUM : e3a108c9b17f3572e53c07f52d236481

AppServe  Configuration：

gbk_simplified chinese

enabled：InnoDB ： 勾选（Yes）

MySQL & phpMyAdmin Configuration：

根用户：root

根密码：123

Other Configration:

[client]

port=3306

[mysql]

default-character-set = gbk

SHOW variables like "char_%";    # 在命令行查看字符集设置

show engines; 	# 在命令行查看插件或引擎

select @@version;  # 查看版本信息

IN CHINESE

Please refer to the detailed illustrate:

“网页中文乱码完美解决方案”

https://wenku.baidu.com/view/2d20321e852458fb760b5641

the key poit:

@所有HTML网页编码均为UTF-8

@所有php文件Header头都声明为UTF-8

header("Content-Type:text/html;charset=utf-8");	

@所有MySQL字符设置都为gbk,仅MySQL系统默认为UTF-8

@phpMyAdmin连接校对为gbk_ chinese_ci，整理为gbk_ chinese_ci

ALTER DATABASE `caoyong` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;

@所有php文件加上下面四句话

mysql_query("SET NAMES UTF8");   //设置中文字符集

mysql_query('set character_set_client = utf8');

mysql_query('set character_set_connection = GBK');

mysql_query('set character_set_results = utf8');

@数据库引擎为InnoDB，表的引擎也是InnoDB

[client]

port=3306

[mysql]

default-character-set = gbk

IN ENGLISH

SERVER SECTION

The following options will be read by the MySQL Server. Make sure that you have installed the server correctly (see above) so it reads this file.

[mysqld]

@ The TCP/IP Port the MySQL Server will listen on

port=3306

@ Path to installation directory. All paths are usually resolved relative to this.

basedir="A:\AppServ/MySQL"

@Path to the database root

datadir="A:\AppServ/MySQL/data/"

@The default character set that will be used when a new schema or table is created and no character set is defined

default-character-set = gbk

character-set-server = gbk

collation-server = gbk_chinese_ci

init_connect = 'SET collation_connection = gbk_chinese_ci'

init_connect = 'SET NAMES gbk'

@ The default storage engine that will be used when create new tables when

default-storage-engine=INNODB

[phpMyAdmin]

@ The default character set that will be used in phpMyAdmin

ALTER DATABASE `caoyong` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;