PHP/MySQL Three-Day Pass - Day Two (Thursday)_PHP Tutorial-PHP Tutorial-php.cn

PHP/MySQL Three-Day Pass - Day Two (Thursday)_PHP Tutorial

WBOY

Release： 2016-07-13 17:20:05

Original

834 people have browsed it

六、完整的程序

　　在本课结束前，我们要把所有东西加入到一个程序中，使它具有增加、编辑修改、删除记录的功能。这是前面所有内容的一个延伸，也可以作为极好的复习方法。看看下面的程序。

$#@60;html$#@62;

$#@60;body$#@62;

$#@60;?php

$db = mysql_connect("localhost", "root");

mysql_select_db("mydb",$db);

if ($submit) {

// 如果没有ID，则我们是在增加记录，否则我们是在修改记录

if ($id) {

$sql = "UPDATE employees SET first=$first,last=$last,
address=$address,position=$position WHERE id=$id";

} else {

$sql = "INSERT INTO employees (first,last,address,position)
VALUES ($first,$last,$address,$position)";

}

// 向数据库发出SQL命令

$result = mysql_query($sql);

echo "记录修改成功！$#@60;p$#@62;";

} elseif ($delete) {

// 删除一条记录

$sql = "DELETE FROM employees WHERE id=$id";

$result = mysql_query($sql);

echo "记录删除成功！$#@60;p$#@62;";

} else {

// 如果我们还没有按submit按钮，那么执行下面这部分程序

if (!$id) {

// 如果不是修改状态，则显示员工列表

$result = mysql_query("SELECT * FROM employees",$db);

while ($myrow = mysql_fetch_array($result)) {

printf("$#@60;a f="%s?id=%s"$#@62;%s %s$#@60;/a$#@62; ",
$PATH_INFO, $myrow["id"], $myrow["first"], $myrow["last"]);

printf("$#@60;a href="%s?id=%s&delete=yes"$#@62;(DELETE)$#@60;/a$#@62;$#@60;
br$#@62;", $PATH_INFO, $myrow["id"]);

}

}

?$#@62;

$#@60;P$#@62;

$#@60;a href="$#@60;?php echo $PATH_INFO?$#@62;"$#@62;ADD A RECORD$#@60;/a$#@62;

$#@60;P$#@62;

$#@60;form method="post" action="$#@60;?php echo $PATH_INFO?$#@62;"$#@62;

$#@60;?php

if ($id) {

// 我们是在编辑修改状态，因些选择一条记录

$sql = "SELECT * FROM employees WHERE id=$id";

$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);

$id = $myrow["id"];

$first = $myrow["first"];

$last = $myrow["last"];

$address = $myrow["address"];

$position = $myrow["position"];

// 显示id，供用户编辑修改

?$#@62;

$#@60;input type=hidden name="id" value="$#@60;?php echo $id ?$#@62;"$#@62;

$#@60;?php

}

?$#@62;

名：$#@60;input type="Text" name="first" value="$#@60;?php echo $first ?$#@62;"$#@62;$#@60;br$#@62;

姓：$#@60;input type="Text" name="last" value="$#@60;?php echo $last ?$#@62;"$#@62;$#@60;br$#@62;

住址：$#@60;input type="Text" name="address" value="$#@60;?php echo $address ?$#@62;"$#@62;$#@60;br$#@62;

职位：$#@60;input type="Text" name="position" value="$#@60;?php echo $position ?$#@62;"$#@62;$#@60;br$#@62;

$#@60;input type="Submit" name="submit" value="输入信息"$#@62;

$#@60;/form$#@62;

$#@60;?php

}

?$#@62;

$#@60;/body$#@62;

$#@60;`/html$#@62;

This procedure looks complicated, but it is actually not difficult. The program has three main parts. The first if() statement checks whether we have pressed the "Enter Information" data submit button. If so, the program then checks whether $id exists. If it does not exist, then we are adding record status, otherwise, we are modifying record status.

Next we check whether the variable $delete exists. If it exists, we want to delete the record. Note that the first if() statement checked the variables sent using the POST method, but this time we checked the variables passed in the GET method.

Finally, the default action of the program is to display employee lists and tables. Likewise, we want to check if the variable $id exists. If it exists, we retrieve the corresponding record based on its value and display it. Otherwise, we display an empty table.

Now, we have put everything we have learned into one program. We used while() loops, used if() statements, and performed all the basic SQL operations - SELECT, INSERT, UPDATE, and DELETE. In addition, we also know how to pass information between different web pages through URLs and form inputs.

In the third lesson, we will learn how to add intelligent processing capabilities to web pages.