首页 > 后端开发 > php教程 > php删除用户

php删除用户

jacklove
发布: 2023-03-31 16:46:01
原创
3359 人浏览过

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

<?php # Script 10.2 - delete_user.php

// This page is for deleting a user record.

// This page is accessed through view_users.php.

$page_title = &#39;Delete a User&#39;;

echo &#39;<h1>Delete a User</h1>&#39;;

// Check for a valid user ID, through GET or POST:

if ( (isset($_GET[&#39;id&#39;])) && (is_numeric($_GET[&#39;id&#39;])) ) { // From view_users.php

$id = $_GET[&#39;id&#39;];

} elseif ( (isset($_POST[&#39;id&#39;])) && (is_numeric($_POST[&#39;id&#39;])) ) { // Form submission.

$id = $_POST[&#39;id&#39;];

} else { // No valid ID, kill the script.

echo &#39;<p class="error">This page has been accessed in error.</p>&#39;;

exit();

}

require (&#39;c.php&#39;);

// Check if the form has been submitted:

if ($_SERVER[&#39;REQUEST_METHOD&#39;] == &#39;POST&#39;) {

if ($_POST[&#39;sure&#39;] == &#39;Yes&#39;) { // Delete the record.

// Make the query:

$q = "DELETE FROM user WHERE user_id=$id LIMIT 1";$r = @mysqli_query ($dbc, $q);

if (mysqli_affected_rows($dbc) == 1) { // If it ran OK.

// Print a message:

echo &#39;<p>The user has been deleted.</p>&#39;;} else { // If the query did not run OK.

echo &#39;<p class="error">The user could not be deleted due to a system error.</p>&#39;; // Public message.

echo &#39;<p>&#39; . mysqli_error($dbc) . &#39;<br />Query: &#39; . $q . &#39;</p>&#39;; // Debugging message.

}

} else { // No confirmation of deletion.

echo &#39;<p>The user has NOT been deleted.</p>&#39;;}

} else { // Show the form.

// Retrieve the user&#39;s information:

$q = "SELECT CONCAT(last_name, &#39;, &#39;, first_name) FROM user WHERE user_id=$id";

$r = mysqli_query ($dbc, $q);

if (mysqli_num_rows($r) == 1) { // Valid user ID, show the form.

// Get the user&#39;s information:

$row = mysqli_fetch_array ($r, MYSQLI_NUM);

// Display the record being deleted:

echo "<h3>Name: $row[0]</h3>

Are you sure you want to delete this user?";

// Create the form:

echo &#39;<form action="delete_user.php" method="post">

<input type="radio" name="sure" value="Yes" /> Yes聽

<input type="radio" name="sure" value="No" checked="checked" /> No

<input type="submit" name="submit" value="Submit" />

<input type="hidden" name="id" value="&#39; . $id . &#39;" />

</form>&#39;;

} else { // Not a valid user ID.

echo &#39;<p class="error">This page has been accessed in error.</p>&#39;;

}

} // End of the main submission conditional.

mysqli_close($dbc);

?>

登录后复制

本文讲解了php删除用户的相关操作,更多内容清关注php中文网。

相关推荐:

MySQL数据库多表操作

MySQL数据库单表查询

Oracle数据库输出输入

以上是php删除用户的详细内容。更多信息请关注PHP中文网其他相关文章!

相关标签:
php
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
怎么学好php
来自于 1970-01-01 08:00:00
0
0
0
PHP扩展intl
来自于 1970-01-01 08:00:00
0
0
0
php数据获取?
来自于 1970-01-01 08:00:00
0
0
0
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板