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ù)庫(kù)中, 數(shù)據(jù)庫(kù)操作語(yǔ)句都是使用mysql_query
mysql_connect("localhost", "root", ""); // 連接到數(shù)據(jù)庫(kù)
mysql_select_db("test"); // 選擇使用數(shù)據(jù)庫(kù)中的表
// 取得從HTML表單中傳過(guò)來(lái)的數(shù)據(jù)
$firstName = $_POST["first_name"];
$lastName = $_POST["last_name"];
// 插入數(shù)據(jù)到數(shù)據(jù)庫(kù)中
mysql_query("INSERT INTO user(first_name, last_name) VALUES('{$firstName}', '{$lastName}')");
echo $firstName, "<br>", $lastName;
?>
</body>
</html>
<?php
// 從數(shù)據(jù)庫(kù)查詢數(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)) { // 每使用一次后,會(huì)自動(dòng)移向下一個(gè)游標(biāo)
// first_name和last_name是數(shù)據(jù)庫(kù)中列名
echo $row["first_name"], ", ", $row["last_name"], "<br>";
}
?>