HTML:
<html>
<body>
<form action="sf.php" method="POST">
First Name: <input type="text" name="first_name" />
Last Name: <input type="text" name="last_name" />
<input type="submit" />
</form>
</body>
</html>
PHP:
<html>
<head></head>
<body>
<?php
// 插入數(shù)據(jù)到數(shù)據(jù)庫中, 數(shù)據(jù)庫操作語句都是使用mysql_query
mysql_connect("localhost", "root", ""); // 連接到數(shù)據(jù)庫
mysql_select_db("test"); // 選擇使用數(shù)據(jù)庫中的表
// 取得從HTML表單中傳過來的數(shù)據(jù)
$firstName = $_POST["first_name"];
$lastName = $_POST["last_name"];
// 插入數(shù)據(jù)到數(shù)據(jù)庫中
mysql_query("INSERT INTO user(first_name, last_name) VALUES('{$firstName}', '{$lastName}')");
echo $firstName, "<br>", $lastName;
?>
</body>
</html>
<?php
// 從數(shù)據(jù)庫查詢數(shù)據(jù)
mysql_connect("localhost", "root", "");
mysql_select_db("test");
$result = mysql_query("SELECT first_name, last_name FROM user");
while ($row = mysql_fetch_array($result)) { // 每使用一次后，會自動移向下一個游標(biāo)
// first_name和last_name是數(shù)據(jù)庫中列名
echo $row["first_name"], ", ", $row["last_name"], "<br>";
}
?>