PHP程序数据库操作集成实验手册.doc

PHP 程序数据库操作集成实验手册实验内容一、 phpMyAdmin 进行数据库操作?创建新的数据库 CREATE DATABASE `test` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; ?创建新的数据库表 CREATE TABLE IF NOT EXISTS `articles` ( `id` int(4) NOT NULL AUTO_INCREMENT, `title` varchar(200) CHARACTER SET gb2312 NOT NULL, `content` mediumtext CHARACTER SET gb2312 NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=64 ; ?往数据库表新增数据 INSERT INTO `articles` (`id`, `title`, `content`) VALUES (1, 'Happy Every Day!', 'Every day !I am getting better and better! great'); ?查询数据 Select ‘ course ’ where ‘ id’= 2; ?更改数据库表新增数据 UPDATE `test`.`articles` SET `content` = 'Hello Everyone! I am getting better and better! ' WHERE `articles`.`id` =1 LIMIT 1;?删除记录 Delete ‘ course ’ where ‘ id’= 1; ?删除数据库表 DROP TABLE `articles`; 二、通过 PHP 程序进行基本数据库操作通过 运行以下数据库操作语句。?创建新的数据库表 CREATE TABLE articles2 ( id int(4) NOT NULL AUTO_INCREMENT, title varchar(200) CHARACTER SET gb2312 NOT NULL, content mediumtext CHARACTER SET gb2312 NOT NULL, PRIMARY KEY (id), KEY id (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=64 ; ?往数据库表新增数据 INSERT INTO articles2 (id, title, content) VALUES (1, 'Happy Every Day!', 'Every day !I am getting better and better! great') ?查询数据 select * from articles2 where id=1 ; ?更改数据库表新增数据 UPDATE articles2 SET content = 'I am g