简单添加删除php源码,php源码--简单添加数据

include 'conn.php';

if(!empty($_POST['sub']))

{

$title=$_POST['title'];

$cont=$_POST['con'];

$sql="insert into `news` (`title`,`dates`,`contents`) values ('$title',now(),'$cont')";

mysql_query($sql);

$mysql="SELECT * FROM `news`";

$query=mysql_query($mysql);

while($rs=mysql_fetch_array($query)){

echo $rs['id']." ".$rs['title']." ".$rs['dates']." ".$rs['contents']."
";

}

mysql_close();

}

?>

标题

内容

sql文件

/*

Navicat MySQL Data Transfer

Source Server : mysql

Source Server Version : 50612

Source Host : localhost:3306

Source Database : blog

Target Server Type : MYSQL

Target Server Version : 50612

File Encoding : 65001

Date: 2014-05-22 14:31:21

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for `news`

-- ----------------------------

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`title` varchar(50) DEFAULT NULL,

`dates` date DEFAULT NULL,

`contents` text,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;

-- ----------------------------

-- Records of news

-- ----------------------------

INSERT INTO `news` VALUES ('1', '567', '2014-05-22', 'hh');

INSERT INTO `news` VALUES ('2', 'wererw', '2014-05-22', 'r2222');

INSERT INTO `news` VALUES ('3', '±ê??', '2014-05-22', '????');

INSERT INTO `news` VALUES ('4', '为任务', '2014-05-22', '34阿斯顿');

INSERT INTO `news` VALUES ('5', '为任务', '2014-05-22', '34阿斯顿');

INSERT INTO `news` VALUES ('6', '43345', '2014-05-22', '地方');

INSERT INTO `news` VALUES ('7', '43345', '2014-05-22', '地方');

INSERT INTO `news` VALUES ('8', '43345', '2014-05-22', '地方');