PHP操作MySQL数据库实例

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);
?>