dsvyc66464 2017-05-05 16:28
浏览 17

PHP / MYSQL登录更新麻烦

I have been working on this Login script for awhile and everything works, except this update function. I have tried changing variable name and everything else. On UpdateUser.php, the code works if I insert variables instead of the $[POST] variables. I am at a loss. Any help would be greatly appreciated. Sorry for the messy code, this is a class assignment, so I wasn't worried about password security at the moment.

This is index4.php

<form id="form" action="index4.php" method="post">
     <h2>Update Your Login</h2>
          UserName:<br>
               <input type="text" id="useuserName"  required />
            <br>
          Password:<br>
                <input type="text" id="usepassWord"  required />
            <br>
          First Name:<br>
                <input type="text" id="usefirstName" required />
            <br>
          Last Name:<br>
                <input type="text" id="uselastName" required />
            <br> 
                <input id="updateuser" type ="submit" />
        </form>
        <script>
            $('#updateuser').click(function() {
                var useID = $_SESSION["id"];
                var useuserName = $("#useuserName").val();
                var usepassWord = $("#usepassWord").val();
                var usefirstName = $("#usefirstName").val();
                var uselastName = $("#uselastName").val();
                var usePermissions = $_SESSION["Permissions"];
               $.ajax({ 
                    type : 'POST',
                    url  : '', 
                    data :{action:'updateuser', useID:useID, useuserName:useuserName, uselastName:uselastName, usePermissions:usePermissions},           
                    error: function (html) {
                            alert( "What the duck" );
                          },
                        });
                });
        </script> 

This is the UpdateUser.php file

<?php
    //Update
        if($_POST['action'] == 'updateuser'){
            //Set Variables
            $servername = "localhost";
            $username = "root";
            $password = "";
            $db = "userdb";

        //Create connection
         $conn = new mysqli($servername, $username, $password, $db);
            // Check connection
                if ($conn->connect_error) {
                    die("Connection: Failed! " . $conn->connect_error);
                } 
        //Actual Code
                $useID = $_POST['useID'];
                $useuserName = $_POST['useuserName'];
                $usepassWord = $_POST['usePassword'];
                $usefirstName = $_POST['usefirstName'];
                $uselastName = $_POST['uselastName'];
                $usePermissions = $_POST['usePermissions'];

            //Create Query
            $sql = "UPDATE users SET userName = '$useuserName', Pass = '$usepassWord', firstName = '$usefirstName', lastname = '$uselastName', Permissions = '$usePermissions'  WHERE id =" . $useID ."";


                //Did it work Check
                if ($conn->query($sql) === TRUE) {
                    echo "Cool";
                } else {
                    echo "What " . $conn->error;
                }

        //Close Out
            $conn->close();
    }
    ?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 易康econgnition精度验证
    • ¥15 线程问题判断多次进入
    • ¥15 msix packaging tool打包问题
    • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致