做了个简单留言本到MySQL

准备好提交表单  数据库中创建好表字段

/* 简单留言本 to mysql  */
$conn = mysql_connect('localhost' ,'root' ,'');  //连接数据库
//print_r($conn);
mysql_query('use test',$conn);                  //默认当前数据库
mysql_query('set names gbk',$conn);            //指定编码  汉子需要utf8


//print_r($_POST);         
$title = $_POST['title'];                    //接收的数据
$content = $_POST['content'];

//$sql = mysql_query("insert into msg (title,content) values ('$title','$content')";    
if (mysql_query("insert into msg (title,content) values ('$title','$content')")) {   //执行sqly语句
 	echo 'OK';
 }

/*多加一步*/ 

<pre name="code" class="php">//最后把数据从数据库查询显示出来
$sql = mysql_query('select * from msg');
//$row = mysql_fetch_row($sql);             //单行显示
while ($row = mysql_fetch_array($sql)) {               //用while显示都显示出来 或其它
	echo $row['title'],'=>',$row['content'],'<br />';
}

验证直接select * from msg;