来源: http://hi.baidu.com/billows2006/item/435fae47c60540e2bcf45139
//连接数据库 <?php $dbhost = 'localhost'; $dbuser = 'username'; //你的mysql用户名 $dbpass = 'password'; //你的mysql密码 $dbname = 'dbname'; //你的mysql库名
$connect = mysql_connect($dbhost,$dbuser,$dbpass); if ($connect) { echo "连接成功!:)"; } else { echo "连接失败!"; } ?> //SELECT查询 <?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s<> ", mysql_result($result,0,"first"));
printf("Last Name: %s<> ", mysql_result($result,0,"last"));
printf("Address: %s<> ", mysql_result($result,0,"address"));
printf("Position: %s<> ", mysql_result($result,0,"position"));
?> //while循环 <?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
echo "< border=1> ";
echo "<><>姓名</td><>职位</td></tr> ";
while ($myrow = mysql_fetch_row($result)) {
printf("<><>%s %s</td><>%s</td></tr> ", $myro w[1], $myrow[2], $myrow[3]);
}
echo "</table> ";
?>
//if-else 判断 <?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
if ($myrow = mysql_fetch_array($result)) {
echo "< border=1> ";
echo "<><>姓名</td><>住址</td></tr> ";
do {
printf("<><>%s %s</td><>%s</tr> ", $myrow["first"], $myrow["last"], $myrow["address"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table> ";
} else {
echo "对不起,没有找到记录!";
}
?> //向服务器发送数据 首先,我们创建一个带有简单表格的网页。 <form method="post" action="<?php echo $PATH_INFO?>">
名:< type="Text" name="first"><>
姓:< type="Text" name="last"><>
住址:< type="Text" name="address"><>
职位:< type="Text" name="position"><>
< type="Submit" name="submit" value="输入信息">
</form> //处理数据 <?php
if ($submit) {
// 处理表格输入
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$sql = "INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position')";
$result = mysql_query($sql);
echo "Thank you! Information entered. ";
} else{
// 显示表格内容
?>
< method="post" action="<?php echo $PATH_INFO?>"> 名:< type="Text" name="first"><> 姓:< type="Text" name="last"><> 住址:< type="Text" name="address"><>
职位:< type="Text" name="position"><>
< type="Submit" name="submit" value="输入信息">
</form>
<?php
} // end if,if结束
?>