PHP 存取 MySQL 数据库的一个例子_php基础

PHP+MySQL 例子

请在文本区域输入数据并且确定

$connect_id=mysql_connect("localhost","username","password");
if(isset($txt)) {
$dbtime=date("Y-m-d H:i:s");
mysql_db_query("usernamedb","insert into test values (0,'$dbtime','$txt')");
}
?>

$result=mysql_db_query("usernamedb","select * from test");
while($userdb=mysql_fetch_row($result))
{
echo ": ".$userdb[1]." ".$userdb[2]."
n";
}
mysql_close($connect_id);
?>