conn.php代碼<?php @mysql_connect("localhost:3306","root","")or die("mysql連接失敗"); @mysql_select_db("php100")or die("db連接失敗"); mysql_query("set names 'gbk'");?>add.php代碼<?php include("conn.php");if(!empty($_POST['sub'])){ $title=$_POST['title']; $con=$_POST['con']; $sql="insert into news(id,title,dates,contents)values(null,'$title',now(),'$con')"; mysql_query($sql); echo "插入成功";}?><form action="add.php" method="post">標題<input type="text" name="title"><br>內(nèi)容<textarea rows="5" cols="50" name="con"></textarea><br><input type="submit" name="sub" value="發(fā)表"></form>
1 回答
拉風的咖菲貓
TA貢獻1995條經(jīng)驗 獲得超2個贊
把你的new表刪除，然后運行下面的sql語句
CREATE TABLE IF NOT EXISTS `news` ( `id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `dates` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `contents` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `news` ADD PRIMARY KEY (`id`); ALTER TABLE `news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; |
運行后，數(shù)據(jù)效果圖如下：
然后，conn.php代碼
<?php $Conn = mysql_connect('localhost', 'root', '') or die( '數(shù)據(jù)庫服務器連接失敗:' .mysql_error() ); mysql_query('set names utf8'); mysql_select_db('php100') or die('數(shù)據(jù)庫連接失敗' . mysql_error()); |
add.php
<?php if ( !empty( $_POST['sub'] ) ) { $title = $_POST['title']; $con = $_POST['con']; echo msyql_query("insert into new (title, contents) values ('{$title}', '{$con}')") ? '插入成功' : '插入失?。?#39; .mysql_error(); } ?>//下面的表單自己寫 |
- 1 回答
- 0 關注
- 584 瀏覽
添加回答
舉報
0/150
提交
取消