【php开源代码栏目提醒】:网学会员在php开源代码频道为大家收集整理了CreateNoteBook.php提供大家参考,希望对大家有所帮助!
<?php
echo"<META HTTP-EQUIV=\"Refresh\" Content=\" 0;URL=exa10-2.php\">";
if($date == "")
{
$date = "2002-1-1";
}
if($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);
$a_row = @
mysql_affected_rows($result);
$id = 0;
for($i=0; $i<$rows; $i++)
{
@my
sql_data_seek($result, $i);
$data = @mysql_fetch_array($result);
if ($data[ID] > $id)
{
$id = $data[ID];
}
}
//向数据库中添加记录
$id++;
$query = "insert into NoteBook values('".$id."','".$name."','".$date."','".$content."')";
$result = mysql_query($query);
mysql_close($connect);
}
?>