createnotebook.php

很好用的PHP留言本

<?php
   echo "<meta http-equiv=\"Refresh\"Content=\"0; Url=liuyan.php\">";
	if($_POST['date'] == "")
	{
		$_POST['date'] = "2006-06-22";
	}
	if($_POST['name'] != "")
	{
		
		$connect = @mysql_connect("localhost", "root", "");
		mysql_select_db("NoteBook", $connect);
		
		//判断当前记录已经使用的ID的最大值
		$query = "select * from NoteBook";
		$result = mysql_query($query);

		$rows = @mysql_num_rows($result);
		
		$id = 0;
		for($i=0; $i<$rows; $i++)
		{
			@mysql_data_seek($result, $i);
			$data = @mysql_fetch_array($result);
			if ($data[ID] > $id)
			{
				$id = $data[ID];
			}
		}
		
		//向数据库中添加记录
		$id++;
		$query = "insert into NoteBook values('".$id."','".$_POST['name']."','".$_POST['date']."','".$_POST['content']."')";
		$result = mysql_query($query);
		mysql_close($connect);
	}
?>