Detailed explanation of simple interactive site development with PHP MYSQL

This article mainly introduces PHP MYSQL simple interactive site development in detail, which has certain reference value. Interested friends can refer to it

Purpose: Use PHP and MYSQL to simulate permission management Implementation of the system

The general user can only view other user information and cannot modify, add, and delete operations. The root user can complete the above three operations.

Implementation ideas

1. Create two data tables in the MySQL database. One data table stores usernames and passwords for login verification, and the other stores basic information such as user permissions.
2. When submitting the form to log in, first check whether the user exists in the database. If it does not exist, an error will be reported. If it exists, the password will be verified. If the password is incorrect, an error will be reported. If the password is correct, the login will display all the information stored in the database. User information and current login username.
3. When the user performs add or delete operations, first determine whether the permissions are sufficient. If there is permission, complete the corresponding operation and modify the database content. Otherwise, it will prompt that there is no permission.

Detailed implementation

1. Login page

<center>
 <form method="post" action="<?php echo $_SERVER[&#39;SCRIPT_NAME&#39;] ?>">
 用户名: <input type="text" name="user_name">
 密码: <input type="text" name="password">
 <input type="Submit" name="submit" value="登陆">
 </form>
</center>

The effect is as follows:

2 .Connect to the database to verify the login name and password

//登陆处理
 if (isset($_POST['submit'])) 
 {
  // 用户名输入为空
  if($_POST['user_name'] == '')
  // 调用javascript函数动态提醒
  echo "<script type=&#39;text/javascript&#39;>dis_alert(\"用户名\",1);</script>";// 密码输入为空
  if($_POST[&#39;password&#39;] == &#39;&#39;)
  // 调用javascript函数动态提醒
  echo "<script type=&#39;text/javascript&#39;>dis_alert(\"密码\",1);</script>";
  // 用户名与密码均不为空
  $user_name = $_POST[&#39;user_name&#39;];
  //链接数据库,从中读出用户名和密码
  $db = mysql_connect("localhost", "root", "123456");
  mysql_select_db("linyimin", $db);
  $result = mysql_query("select * from login where user_name = &#39;$user_name&#39;");
  $num = mysql_num_rows($result);
  //判断用户输入的用户名存在,验证密码
  if($num != 0)
  {
  $user_name = mysql_result($result,0,&#39;user_name&#39;);
  $password = mysql_result($result,0,&#39;password&#39;);
  if(strcmp($password,$_POST[&#39;password&#39;]) != 0)
  {
   echo "密码错误";
   //密码错误，报错
   $password = $_POST[&#39;password&#39;];
   echo "<script type=&#39;text/javascript&#39;>dis_alert(&#39;密码错误&#39;,3);</script>";
  }
  // 密码正确
  else
  {
   session_unset();
   session_start();
   $_SESSION[&#39;user_name&#39;] = $_POST[user_name];
   header("Location:http://localhost/display.php");
   exit;
  }
  }
  // 用户输入的用户名不存在，报错 
  else if($num == 0)
  {
  // 用户名不存在，报错
  $user_name = $_POST[&#39;user_name&#39;];
  echo "<script type=&#39;text/javascript&#39;>dis_alert(\"$user_name\",2);</script>";
  }
  mysql_close($db); 
 }//登陆处理结束

Input error reminder function

<script type="text/javascript">

// 登陆错误提醒
function dis_alert(var1, var2)
{
 // 用户名和密码不能为空提醒
 if(var2 == 1)
 {
 alert(var1 + " 不能为空,请重新输入");
 history.back(-1);
 }
 // 用户名不存在错误提醒
 if(var2 == 2)
 {
 alert("该用户名 " + var1 + " 不存在,请重新输入");
 history.back(-1);
 }
 // 密码错误提醒
 if(var2 == 3)
 {
 alert("密码错误，请重新输入");
 history.back(-1);
 }
}

</script>

Error reminder rendering:

3. After successful login, all user information in the database and the current login user name will be displayed

// 获取登陆名
session_start();
$NAME = $_SESSION['user_name'];
// 连接数据库，获取数据并显示
function display()
{
 global $NAME;
 $db = mysql_connect("localhost", "root", "123456");
 mysql_select_db("linyimin",$db);
 $sql = "select * from admin_info";
 $result = mysql_query($sql);
 // 显示信息表
 echo "<h3 align=right color=#FFFFFF> 当前用户:$NAME</h6>";
 echo "<table border = 0 align = center width = 1000></br>";
 // 添加超链接
 echo "<tr align = center><th> <a href =\"display.php?add=yes\">ADD</a></th><br>";
 // 修改添加超连接
 echo "<th> <a href =\"display.php?update=yes\">UPDATE</a></th><br>";
 // 删除超链接
 echo "<th> <a href =\"display.php?delete=yes\">DELETE</a></th></tr><br>";
 echo "</table>";
 echo "<table border = 2 align = center width = 1000></br>";
 // 表头
 echo "<tr><th colspan=\"3\">管理员权限表</th></tr><br>";
 echo "<tr align = center><td>姓名</td><td>权限</td><td>职务</td></tr><br>";
 while($row = mysql_fetch_row($result))
 {
 // 显示管理员信息并通过超链接调用处理函数
 echo "<tr align = center><td>$row[0]</td>";
 echo "<td>$row[1]</td>";
 echo "<td>$row[2]</td></tr>";
 }
 echo "</table>";
 mysql_close($db);
}

The display effect is as follows:

4. Implementation of modification, deletion and addition operations

Modify and add page

<center>
 <form method="post" action="<?php echo $_SERVER[&#39;URL&#39;] ?>">
 姓名: <input type="text" name="user_name">
 权限: <input type="text" name="pemission">
 职务: <input type="text" name="position">
 <input type="Submit" name="update" value="提交">
 </form>
</center>

The effect is as follows:

Delete page

 <center> 
 <form method="post" action="<?php echo $_SERVER[&#39;URL&#39;] ?>" onsubmit="return confirm(&#39;请确认删除&#39;);">
 姓名: <input type="text" name="user_name">
 <input type="submit" name="update" value="删除">
</center>

The rendering is as follows:

##Realization

// 调用修改函数
if ($_GET[update]) 
{
 modify("update");
}
// 调用添加函数
elseif($_GET[add])
{
 modify("add");
}
elseif($_GET[delete])
{
 modify("delete");
}

Implementation of modify() function

// 修改数据函数
/*
点击修改超链接，跳转到修改页面
表单中，名字项指定要修改记录
权限和职务项为可修改内容
*/
function modify($operation)
{
 if(isset($_POST['update']))
 {
 // 有root权限修改，修改
 if($operation == "update" && judge("update"))
 {
  $user_name = $_POST[user_name];
  $sql = "UPDATE admin_info SET pemission = '$_POST[pemission]', position ='$_POST[position]' WHERE user_name = '$user_name'";
  mysql_query($sql);
  mysql_close($db);
  display();
 }
 // 添加
 elseif(judge("add") && $operation == "add")
 {
  $user_name = $_POST[user_name];
  $sql = "insert into admin_info (user_name, pemission, position) values ('$_POST[user_name]','$_POST[pemission]','$_POST[position]')";
  mysql_query($sql);
  mysql_close($db);
  display();
 }
 // 删除
 elseif(judge("delete") && $operation == "delete")
 {
  $user_name = $_POST[user_name];
  // 获取确认情况
  $sql = "delete from admin_info where user_name = \"$user_name\"";
  mysql_query($sql);
  }
 }
}

Implementation of judge() function

// 判断修改用户名是否存在和该用户是否具有权限
function judge($operation)
{
 global $NAME;
 // 修改用户名
 $user_name = $_POST['user_name'];
 // 连接数据库，获取数据
 $db = mysql_connect("localhost", "root", "123456");
 mysql_select_db("linyimin",$db);
 // 该用户是否存在
 $sql = "select * from admin_info where user_name = \"$user_name\"";
 $result = mysql_query($sql);
 $num = mysql_num_rows($result);
 // 输入名称不存在
 if ($num == 0 && $operation != "add")
 {
  $user_name = $_POST['user_name'];
  echo "<script type=&#39;text/javascript&#39;>dis_alert(\"$user_name\",2);</script>";
  return 0;
 }
 else
 {
  // 判断有没有权限(只有root权限可以修改)
  $sql = "select * from admin_info where user_name = \"$NAME\"";
  $result = mysql_query($sql);
  $pemission = mysql_result($result,0,&#39;pemission&#39;);
  // 没有root权限，报错
  if(strcmp($pemission,"root") != 0)
  {
  $user_name = $_POST[&#39;user_name&#39;];
  echo "<script type=&#39;text/javascript&#39;>dis_alert(\"$user_name\",1);</script>";
  return 0;
  }
  else 
  return 1;
 } 
}

Common skills record

1. Use session to realize the method of using the same variable in multiple php files

In the text that defines the variable Open the session and store the value into the session

usersession_unset();
session_start();
$_SESSION['变量名'] = "值";

Open the session in the text that uses the variable and take out the variable

session_start();
$NAME = $_SESSION['变量名'];

2. PHP connects to the MYSQL database and performs search, add, and delete operations on the database

Connect to the database

// 连接数据库
$db = mysql_connect("url", "用户名", "密码");
// 选择数据库
mysql_select_db("数据库名称",$db);

Find

$sql = "select * from admin_info where 字段名 = \"查找值\"";
$result = mysql_query($sql);
// 对查找返回结果进行操作
// 获取查找返回记录数条数
$num = mysql_num_rows($result);
// 获取查找结果第一条记录的user_name字段值
$user_name = mysql_result($result,0,'user_name');
// 逐条取出查询记录
while($row = mysql_fetch_row($result))
{
 相关操作；
}

Insert

$sql = "insert into 数据表 (字段1, 字段2, 字段3) values ('值1','值2','值3')";
mysql_query($sql);

Delete

$sql = "delete from 数据表 where 字段名 = \"查找值\"";
mysql_query($sql);
// 关闭数据库
mysql_close($db);

3. Reminder before form submission

4. Call the javascript function in php

<?php
echo "<script type=&#39;text/javascript&#39;>javascript函数;</script>";
?>

The above is this article The entire content, I hope it will be helpful to everyone's study.

Related recommendations:

php framework CodeIgniterDatabaseDetailed configuration steps

PHP mysql implements the method of obtaining the drop-down tree function from database

PHP implements the use of mysqli to operate MySQLdatabase Methods

The above is the detailed content of Detailed explanation of simple interactive site development with PHP MYSQL. For more information, please follow other related articles on the PHP Chinese website!