lmy
1
<?php
$con = mysql_connect("localhost","root","lmy");
//
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE my_db",$con))
{
}
/*else
{
echo "Error creating database: " . mysql_error();
}*/
//mysql_select_db() 函数选取数据库
mysql_select_db("my_db", $con);
//创建数据表
//$sql = "CREATE TABLE log3(l_title varchar(50),l_content longtext,l_data datetime)";
//mysql_query($sql,$con);
//将数据写入表中
mysql_query("INSERT INTO log3(l_content,l_title) VALUES ('".$_POST['editor1']."','".$_POST['title']."','".getdate()."')");
//将表中数据读取出来
$result = mysql_query("SELECT * FROM log3");
echo "";
while($row = mysql_fetch_array($result))
{
echo "";
echo "";
echo "";
}
echo "
| ".$row['l_title'] . " | " . $row['l_content'] ." | " . $row['l_data']." |
";
mysql_close($con);
?>