对于初学者来说，这是我公司的一个内部网站，运行sql-serv。这是我第一次使用AJAX做任何事情。我已经花了一个月的时间学习PHP、SQL、Javascript。。我已经很久没有搞过jQuery了，我所知道的是来自代码学院。。lol.
下面我有jQuery脚本、HTML和SQL。这个问题存在于jQuery的EDIT/UPDATE部分。我放了HTML和SQL作为参考。
交易是……如果我在User1上单击"编辑"，它将存储EeNumberID（1）以及来自隐藏输入的所有数据（有什么更好的方法建议吗？），然后我单击User2，它将保存他的EeNumberID2。然后，当我更新User2时，它也会用他的信息更新User1，即使他的EeNumberID不同。。这就像是将两行updateData传递给management-queries.php，并调用数据库中的两行进行更新。。但为什么呢？
当我选择第二个用户进行编辑时，它是否会将EeNumberID创建到数组中？它是否在本地多次存储此变量？我尝试了各种方法来显示变量，它显示为应该如何将其发送到SQL更新。
救命！：（
查询
$(document).ready(function(){
//LETS HIDE WHAT WE DON'T INITIALLY NEED TO SEE
$("#updateuser, #canceledit").hide();
//BY DEFAULT WHEN THE PAGE LOADS SHOW ALL USERS
//WE ALSO PASS LOCATION AND PERMISSION SO BY DEFAULT USER CAN ONLY SEE WHAT THEY'RE ALLOWED TO
function showUsers(){
$.ajax({
type: "post",
url: "admin/management-queries.php",
data: "action=showusers&location=<?php echo $location?>&permission=<?php echo $permission?>",
success:function(data){
$("#userlist").html(data);
//EVERY TIME A LIST OF USERS IS GENERATED WE NEED TO HIDE CANCEL EDIT BUTTONS
$(".cancel-button").hide();
}
});
}
showUsers();
//ADD USER
$("#adduser").click(function(){
//EVERYTIME 'ADD USER' IS CLICKED WE NEED TO CLEAR ANY PREVIOUS ERROR MESSAGES
$("#UserFullName,#UserPassword,#UserPassword2,#UserEmail,#UserLocation,#UserPermission").removeClass("form-error");
$("span.label").remove();
var fullname = $("#UserFullName").val();
var password = $("#UserPassword").val();
var password2 = $("#UserPassword2").val();
var email = $("#UserEmail").val();
var location = $("#UserLocation").val();
var permission = $("#UserPermission").val();
//BEFORE WE PASS THE DATA WE NEED TO CHECK IF IT'S ALL THERE
if (fullname == "" || password != password2 || email == "" || location == null || permission == null) {
if (fullname == "") {
$("#UserFullName").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
if (password != password2) {
$("#UserPassword").addClass("form-error");
$("#UserPassword2").addClass("form-error").after("<span class='label label-danger'>Passwords do not match.</span>");
} else if (password == "" || password2 == "") {
$("#UserPassword").addClass("form-error");
$("#UserPassword2").addClass("form-error").after("<span class='label label-danger'>These fields are required.</span>");
};
if (email == "") {
$("#UserEmail").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
if (location == null) {
$("#UserLocation").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
if (permission == null) {
$("#UserPermission").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
} else {
var addData = "UserEmail="+email+"&UserPassword="+password+"&UserLocation="+location+"&UserFullName="+fullname+"&UserPermission="+permission+"&action=adduser";
$.ajax({
type: "post",
url: "admin/management-queries.php",
data: addData,
success:function(data){
//IF THE DATA IS ADDED WE NEED TO CLEAR THE INPUT FIELDS
$("#UserFullName, #UserPassword, #UserPassword2, #UserEmail, #UserLocation, #UserPermission").val('');
showUsers();
}
});
};
});
//DELETE USER
$("body").on("click", "#userlist .delete-button", function(e) {
e.preventDefault();
var clickedID = this.id.split('-');
var DbNumberID = clickedID[1];
var delData = 'deleteuser='+ DbNumberID;
jQuery.ajax({
type: "post",
url: "admin/management-queries.php",
data: delData,
success:function(data){
showUsers();
}
});
});
//EDIT USER
$("body").on("click", "#userlist .edit-button", function(e) {
$(".edit-button").show();
var EeNumberID = $(this).attr('name');
//GET ALL THE VARIABLES VIA HIDDEN INPUTS POPULATED BY SQL
var EditName = $("#Name-"+EeNumberID).val();
var EditPassword = $("#Password-"+EeNumberID).val();
var EditEmail = $("#Email-"+EeNumberID).val();
var EditLocation = $("#Location-"+EeNumberID).val();
var EditPermission = $("#Permission-"+EeNumberID).val();
//LETS ADJUST VISUALS AS WE ARE IN EDIT MODE
$("#adduser, .cancel-button, #edit-"+ EeNumberID).hide();
$("#canceledit, #updateuser, #cancel-"+ EeNumberID).show();
$(".row").removeClass("sel-edit");
$("#user-"+ EeNumberID).addClass("sel-edit");
//PASS VARIABLE VALUES TO INPUT FIELDS
$("#UserFullName").val(EditName);
$("#UserPassword, #UserPassword2").val(EditPassword);
$("#UserEmail").val(EditEmail);
$("#UserLocation").val(EditLocation);
$("#UserPermission").val(EditPermission);
//CANCEL EDIT (FROM WITHIN ROW)
$("#cancel-"+ EeNumberID).click(function(){
//ADJUST VISUALS FOR CANCEL
$("#canceledit, #updateuser, .cancel-button").hide();
$("#adduser, .edit-button").show();
$(".row").removeClass("sel-edit");
//CLEAR INPUT FIELDS
$("#UserFullName, #UserPassword, #UserPassword2, #UserEmail, #UserLocation, #UserPermission").val('');
});
//UPDATE USER (THIS MUST BE NESTED WITHIN 'EDIT USER' SO WE KNOW THE ROW CURRENTLY OPENED)
$("#updateuser").click(function(){
//EVERYTIME 'UPDATE USER' IS CLICKED WE NEED TO CLEAR ANY PREVIOUS ERROR MESSAGES
$("#UserFullName,#UserPassword,#UserPassword2,#UserEmail,#UserLocation,#UserPermission").removeClass("form-error");
$("span.label").remove();
var ID = EeNumberID;
var fullname = $("#UserFullName").val();
var password = $("#UserPassword").val();
var password2 = $("#UserPassword2").val();
var email = $("#UserEmail").val();
var location = $("#UserLocation").val();
var permission = $("#UserPermission").val();
//BEFORE WE PASS THE DATA WE NEED TO CHECK IF IT'S ALL THERE
if (fullname == "" || password != password2 || email == "" || location == null || permission == null) {
if (fullname == "") {
$("#UserFullName").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
if (password != password2) {
$("#UserPassword").addClass("form-error");
$("#UserPassword2").addClass("form-error").after("<span class='label label-danger'>Passwords do not match.</span>");
} else if (password == "" || password2 == "") {
$("#UserPassword").addClass("form-error");
$("#UserPassword2").addClass("form-error").after("<span class='label label-danger'>These fields are required.</span>");
};
if (email == "") {
$("#UserEmail").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
if (location == null) {
$("#UserLocation").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
if (permission == null) {
$("#UserPermission").addClass("form-error").after("<span class='label label-danger'>This field is required.</span>");
};
} else {
var updateData = "ID="+ID+"&UserEmail="+email+"&UserPassword="+password+"&UserLocation="+location+"&UserFullName="+fullname+"&UserPermission="+permission+"&action=updateuser";
$.ajax({
type: "post",
url: "admin/management-queries.php",
data: updateData,
success: function(data){
$("#UserFullName, #UserPassword, #UserPassword2, #UserEmail, #UserLocation, #UserPermission").val('');
$("#canceledit, #updateuser, .cancel-button").hide();
$("#adduser, .edit-button").show();
showUsers();
}
});
};
});
});
//CANCEL EDIT (GLOBAL)
$("#canceledit").click(function(){
//ADJUST VISUALS FOR CANCEL
$("#canceledit, #updateuser, .cancel-button").hide();
$("#adduser, .edit-button").show();
$(".row").removeClass("sel-edit");
//CLEAR INPUT FIELDS
$("#UserFullName, #UserPassword, #UserPassword2, #UserEmail,#UserLocation, #UserPermission").val('');
});
});
HTML INCLUDE（引导程序驱动）
<div class="container-fluid">
<div class="row">
<div class="col-xs-4 panel-container">
<div class="panel panel-default">
<div class="panel-heading"> </div>
<div class="panel-body">
<form>
<div class="row input-padding">
<div class="col-xs-12"><input class="form-control" type="text" name="UserFullName" id="UserFullName" placeholder="Full Name"></input></div>
</div>
<div class="row input-padding">
<div class="col-xs-12"><input class="form-control" type="password" name="UserPassword" id="UserPassword" placeholder="Password"></input></div>
</div>
<div class="row input-padding">
<div class="col-xs-12"><input class="form-control" type="password" name="UserPassword2" id="UserPassword2" placeholder="Confirm Password"></input></div>
</div>
<div class="row input-padding">
<div class="col-xs-12"><input class="form-control" type="text" name="UserEmail" id="UserEmail" placeholder="E-Mail"></input></div>
</div>
<div class="row input-padding">
<div class="col-xs-12">
<select name="UserLocation" id="UserLocation" class="form-control">
<?php
$sqlresult = sqlsrv_query($connection, "SELECT * FROM MESCO_locations");
echo '<option value="" disabled'; if(!isset($VALLocation)) {echo' selected';} echo ' hidden>Select User Location</option>';
while($row = sqlsrv_fetch_array($sqlresult)) {
echo '<option value="'.$row['location_id'].'">'.$row['location_name'].'</option>';
}
?>
</select>
</div>
</div>
<div class="row input-padding">
<div class="col-xs-12">
<select name="UserPermission" id="UserPermission" class="form-control">
<option value="" disabled selected hidden>Select User Permission</option>
<option value="0">Disabled</option>
<?php
if ($_SESSION['Permission'] == 1) {
echo ' <option value="1">Administrator</option>';
}
if ($_SESSION['Permission'] <= 2) {
echo ' <option value="2">Branch Manager</option>';
}
if ($_SESSION['Permission'] <= 3) {
echo ' <option value="3">Warehouse Manager</option>
<option value="4">Warehouse Employee</option>
';
}
if ($_SESSION['Permission'] <= 2) {
echo ' <option value="5">Purchasing</option>
<option value="6">Inside Sales</option>
<option value="7">Outside Sales</option>
<option value="8">Accounts Receivable</option>';
}
?>
</select>
</div>
</div>
<div class="row input-padding input-button">
<div class="col-xs-12">
<button type="button" class="btn btn-sm btn-info" id="updateuser">UPDATE USER</button>
<button type="button" class="btn btn-sm btn-warning" id="canceledit">CANCEL</button>
<button type="button" class="btn btn-sm btn-success" id="adduser">ADD USER</button>
</div>
</div>
</form>
</div>
</div>
</div>
<div class="col-xs-8 panel-container">
<div class="panel panel-default">
<div class="panel-heading">
<strong><i class="fa fa-users"></i> User Management</strong>
</div>
<div class="panel-body">
<div class="row row-heading error-data">
<div class="col-xs-2">Full Name</div>
<div class="col-xs-4 center">E-Mail</div>
<div class="col-xs-1 center">Location</div>
<div class="col-xs-3 center">Permission</div>
<div class="col-xs-2 center">EDIT / DEL</div>
</div>
<hr class="margin-reset" />
<div class="row row-data error-data">
<div class="col-xs-12" id="userlist"></div>
</div>
</div>
</div>
</div>
</div>
</div>
PHP/SQL
////----------------------- INITIATE -----------------------////
set_time_limit(0); //SETS TIME LIMIT FOR SCRIPT EXECUTION - 0 = UNLIMITED
require_once('C:'inetpub'wwwroot'connection.php'); //CUSTOM ROOT FOR AJAX QUERIED CONNECTIONS
$connectionInfo = array("UID" => $myUser, "PWD" => $myPass, "Database" => $myDB, "ReturnDatesAsStrings" => true);
$connection = sqlsrv_connect($myServer, $connectionInfo);
//IF CONNECTION IS NOT ESTABLISHED THROW MESSAGE AND END SCRIPT
if( !$connection ) {
die("Connection to MS SQL could not be established.'n");
}
//AJAX POST ON WHAT QUERY ACTION TO TAKE (Example: ?action=showusers)
$action = $_POST["action"];
//CURRENT USER PERMISSION AND LOCATION
$permission = $_POST["permission"];
$location = $_POST["location"];
////----------------------- USER MANAGEMENT -----------------------////
//USER MANAGEMENT - DISPLAY FOR WHAT THEY USER ALWAYS SEES
if($action == "showusers") {
//WE NEED TO ASSESS WHAT THE USER HAS THE ABILITY TO SEE
if ($permission == 1) {
//BY DEFAULT ADMINISTRATORS CAN SEE ALL USERS FOR ALL BRANCHES
$sqlresult = sqlsrv_query($connection, "SELECT * FROM MESCO_logins ORDER BY Location ASC, Name ASC");
} else if ($permission == 3) {
//BY DEFAULT WAREHOUSE MANAGERS CAN ONLY SEE DISABLED USERS, WAREHOUSE MANAGERS, AND WAREHOUSE EMPLOYEES FOR THEIR BRANCH
$sqlresult = sqlsrv_query($connection, "SELECT * FROM MESCO_logins WHERE Location = '$location' AND Permission_Level in (3,4,0) ORDER BY Location ASC, Name ASC");
} else {
//ALL OTHER USERS CAN SEE ALL USERS FOR THEIR BRANCH (TEMPORARY)
$sqlresult = sqlsrv_query($connection, "SELECT * FROM MESCO_logins WHERE Location = '$location' ORDER BY Location ASC, Name ASC");
}
while($row = sqlsrv_fetch_array($sqlresult)) {
echo '
<div class="row row-data" id="user-'.$row[ID].'">
<div class="col-xs-2"><input type="hidden" id="Name-'.$row[ID].'" value="'.$row[Name].'">'.$row['Name'].'</div>
<div class="col-xs-4 center"><input type="hidden" id="Email-'.$row[ID].'" value="'.$row[Email].'">'.$row['Email'].'</div>
<div class="col-xs-1 center"><input type="hidden" id="Location-'.$row[ID].'" value="'.$row[Location].'">'.$row['Location'].'</div>
<div class="col-xs-3 center"><input type="hidden" id="Permission-'.$row[ID].'" value="'.$row[Permission_Level].'">';
//LETS CONVERT PERMISSION NUMERICS TO TEXT
//THIS IS TEMPORARY - IDEALLY WE CAN HAVE A JOINED TABLE OR STORE THE TEXT DIRECTLY IN THE USER LOGIN TABLE FOR LESS CODE
if ($row['Permission'] == '0') {
echo 'Disabled / Inactive';
} else if ($row['Permission_Level'] == '1') {
echo 'Administrator';
} else if ($row['Permission_Level'] == '2') {
echo 'Branch Manager';
} else if ($row['Permission_Level'] == '3') {
echo 'Warehouse Manager';
} else if ($row['Permission_Level'] == '4') {
echo 'Warehouse Employee';
} else if ($row['Permission_Level'] == '5') {
echo 'Purchasing';
} else if ($row['Permission_Level'] == '6') {
echo 'Inside Sales';
} else if ($row['Permission_Level'] == '7') {
echo 'Outside Sales';
} else if ($row['Permission_Level'] == '8') {
echo 'Accounts Receivable';
}
echo'
</div>
<div class="col-xs-2 center action-buttons">
<input type="hidden" id="Password-'.$row[ID].'" value="'.$row[Password].'">
<button type="button" class="btn btn-xs btn-warning cancel-button" name="Cancel Edit" id="cancel-'.$row['ID'].'"><i class="fa fa-ban"></i></button>
<button type="button" class="btn btn-xs btn-info edit-button" name="'.$row['ID'].'" id="edit-'.$row['ID'].'"><i class="fa fa-pencil"></i></button>
<button type="button" class="btn btn-xs btn-danger delete-button" name="Delete User" id="delete-'.$row['ID'].'"><i class="fa fa-times"></i></button>
</div>
</div>';
}
}
//USER MANAGEMENT - ADD USER
if($action == "adduser") {
$ADDEmail = $_POST['UserEmail'];
$ADDPassword = $_POST['UserPassword'];
$ADDLocation = $_POST['UserLocation'];
$ADDFullName = $_POST['UserFullName'];
$ADDPermission = $_POST['UserPermission'];
$sqlquery = "INSERT INTO MESCO_logins (Email, Password, Location, Name, Permission_Level) VALUES ('$ADDEmail', '$ADDPassword', '$ADDLocation', '$ADDFullName', '$ADDPermission')";
$sqlresult = sqlsrv_query($connection, $sqlquery);
}
//USER MANAGEMENT - DELETE USER
if (isset($_POST["deleteuser"])) {
$DELID = $_POST["deleteuser"];
$sqlquery = "DELETE FROM MESCO_logins WHERE ID = '$DELID'";
$sqlresult = sqlsrv_query($connection, $sqlquery);
}
//USER MANAGEMENT - UPDATE USER
if($action == "updateuser") {
$ID = $_POST["ID"];
$UPDATEEmail = $_POST['UserEmail'];
$UPDATEPassword = $_POST['UserPassword'];
$UPDATELocation = $_POST['UserLocation'];
$UPDATEFullName = $_POST['UserFullName'];
$UPDATEPermission = $_POST['UserPermission'];
$sqlquery = "UPDATE MESCO_logins SET Email = '$UPDATEEmail', Password = '$UPDATEPassword', Location = '$UPDATELocation', Name = '$UPDATEFullName', Permission_Level = '$UPDATEPermission' WHERE ID = '$ID'";
$sqlresult = sqlsrv_query($connection, $sqlquery);
}
?>
在PHP/SQL文件中，引用数组元素时出现系统性问题，例如：
while($row = sqlsrv_fetch_array($sqlresult)) {
echo '
<div class="row row-data" id="user-'.$row[ID].'">
<div class="col-xs-2"><input type="hidden" id="Name-'.$row[ID].'" value="'.$row[Name].'">'.$row['Name'].'</div>
每个CCD_ 1都需要被校正为CCD_。我还建议打开错误报告，如果它还没有打开的话。可能会有一系列级联错误影响整个脚本。
此外，我强烈建议您查看jQuery的.data，它允许在DOM元素上轻松存储数据。
天哪！我修好了
不知道它为什么会这样做。。但这是因为我在"编辑"中嵌套了"更新"。为了修复OP，我做了以下操作：
声明了一个全局变量：
var EditID = {};
然后我修改了最初的编辑脚本：
var EeNumberID = $(this).attr('name');
至
EeNumberID = $(this).attr('name');
EditID.EeNumberID = EeNumberID;
现在我有了用于获取编辑信息的本地ID，然后我将其全局存储，这样更新就可以准确地知道目标是什么。我认为出于某种原因，因为它是嵌套的，页面不一定"刷新"，所以它记得之前告诉它"编辑"的内容。。并将其全部传递给更新功能。
更新是从EDIT中取消嵌套的，我更改了以下行：
var ID = EeNumberID;
至
var ID = EditID.EeNumberID;
工作！：）如果其他人对如何编写更干净的php/javascript/jquery/sql有意见，请告诉我！我仍在学习，感谢所有的投入！