doulan8846 2019-03-23 16:27
浏览 11

如何停止更新订户以更改用户角色

i am a new learner of php and sql i have two user roles, 1 is admin and another is subscribers, i want to stop subscribers to update user roles subscribes to admin. and other is how to allow them to change password, if i change the password from profile its not login again with the changed password code is download from "https://github.com/mindaras/PHP-custom-CMS-for-simple-blog"

          <?php
            if (isset($_SESSION['username'])) {
              $user_id = $_SESSION['user_id'];

              $query = "SELECT * FROM users WHERE user_id = '{$user_id}'";
              $result = mysqli_query($connection, $query);

              if (!$result) {
                die(mysqli_error($connection));
              }

              $row = mysqli_fetch_assoc($result);

              $username = $row['username'];
              $user_firstname = $row['user_firstname'];
              $user_lastname = $row['user_lastname'];
              $user_role = $row['user_role'];
              $user_password = $row['user_password'];
              $user_email = $row['user_email'];
              $user_image = $row['user_image'];
            }
          ?>
          <?php
            if (isset($_POST['update_profile'])) {
              $user_id = $_SESSION['user_id'];
              $username = $_POST['username'];
              $user_firstname = $_POST['user_firstname'];
              $user_lastname = $_POST['user_lastname'];
              $user_role = $_POST['user_role'];
              $user_password = $_POST['user_password'];
              $user_email = $_POST['user_email'];
              $user_image = $_FILES['image']['name'];
              $user_image_temp = $_FILES['image']['tmp_name'];

              move_uploaded_file($user_image_temp, "../images/{$user_image}");

              $query = "UPDATE `users` SET ";
              $query .="username = '{$username}', ";
              $query .="user_firstname = '{$user_firstname}', ";
              $query .="user_lastname = '{$user_lastname}', ";
              $query .="user_role = '{$user_role}', ";
              $query .="user_password = '{$user_password}', ";
              $query .="user_email = '{$user_email}', ";
              $query .="user_image = '{$user_image}' ";
              $query .="WHERE user_id = {$user_id}";

              $result = mysqli_query($connection, $query);

              if (!$result) {
                die(mysqli_error($connection));
              }
            }
          ?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值