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