php连接mysql报500错_HTML+PHP+数据库操作 POST提示错误500(Internal Server Error)踩坑-数据库修改添加删除...

106 阅读 0 评论 70 点赞

我是靠谱客的博主幽默小松鼠，最近开发中收集的这篇文章主要介绍php连接mysql报500错_HTML+PHP+数据库操作 POST提示错误500(Internal Server Error)踩坑-数据库修改添加删除...，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

管理员系统

15 functionNO_Query(){16 vararg={};17 arg["TrCode"]= "NO_001";//设置交易码

18 arg["EM_Userid"]=document.getElementById("EM_Userid").value;19 arg["NO_Name"]=document.getElementById("NO_Name").value;20 $.ajax({21 type:"POST",22 url: FlieServer+"/staff.php",23 data: arg,24 dataType:'text',25 success:function(result) {26 varres=JSON.parse(result);27 if(!res.length){alert("暂无结果！")};28 varhtm= "";29 for(vari= 0;i

"+res[i].EM_Userid+""+res[i].EM_Name+""+res[i].EM_Branch+""+res[i].EM_Phone+"";31 htm=htm+tmp;32 }33 document.getElementById("tbody").innerHTML=htm;34 }35 });36

37 }38 functionNO_Reset(){39 varinput1=document.getElementById("EM_Userid");40 varinput2=document.getElementById("NO_Name");41 input1.value="";42 input2.value="";43 }44 functionNO_Sub(){45 if($("#tbody").children().length>0){//有内容

46 document.getElementById("modal-body").innerHTML="";47 varNO_id=check_radio("radio");48 vararg={};49 arg["TrCode"]= "NO_002";//设置交易码

50 arg["NO_id"]=NO_id;51 $.ajax({52 type:"POST",53 url: FlieServer+"/staff.php",54 data: arg,55 dataType:'text',56 success:function(result) {57 varres=JSON.parse(result);58 varhtm= "";59 htm=htm+ "

";60 htm=htm+ "

员工编号

";61 htm=htm+ "

登录密码

";62 htm=htm+ "

员工姓名

";63 htm=htm+ "

所在部门

";64 htm=htm+ "

联系方式

";65 htm=htm+ "

员工类型

";66 htm=htm+ "

";67 document.getElementById("modal-body").innerHTML=htm;68 }69 });70 $("#myModal").modal('show');71 }else{72 document.getElementById("modal-body1").innerHTML="请先选择员工信息行再进行编辑！";73 $("#myModal1").modal('show');74 }75 }76 functionNO_Submit(){77 vararg={};78 arg["TrCode"]= "NO_003";79 varNO_id=check_radio("radio");80 arg["NO_id"]=NO_id;81 arg["NO_EM_Userid"]=document.getElementById("NO_EM_Userid").value;82 arg["NO_EM_Password"]=document.getElementById("NO_EM_Password").value;83 arg["NO_EM_Name"]=document.getElementById("NO_EM_Name").value;84 arg["NO_EM_Branch"]=document.getElementById("NO_EM_Branch").value;85 arg["NO_EM_Phone"]=document.getElementById("NO_EM_Phone").value;86 arg["NO_EM_Type"]=document.getElementById("NO_EM_Type").value;87 $.ajax({88 type:"POST",89 url: FlieServer+"/staff.php",90 data: arg,91 dataType:'text',92 success:function(result) {93 $("#myModal").modal('hide');94 alert("修改成功！");95 location.reload(true);96 }97 });98 }99 functionNO_Addnew(){100 document.getElementById("modal-body2").innerHTML="";101 varhtm= "";102 htm=htm+ "

";103 htm=htm+ "

员工编号

";104 htm=htm+ "

登录密码

";105 htm=htm+ "

员工姓名

";106 htm=htm+ "

所在部门

";107 htm=htm+ "

联系方式

";108 htm=htm+ "

员工类型

";109 htm=htm+ "

";110 document.getElementById("modal-body2").innerHTML=htm;111 $("#myModal2").modal('show');112 }113 functionNO_Subadd(){114 vararg={};115 arg["TrCode"]= "NO_004";116 arg["NO_EM_Userid1"]=document.getElementById("NO_EM_Userid1").value;117 arg["NO_EM_Password1"]=document.getElementById("NO_EM_Password1").value;118 arg["NO_EM_Name1"]=document.getElementById("NO_EM_Name1").value;119 arg["NO_EM_Branch1"]=document.getElementById("NO_EM_Branch1").value;120 arg["NO_EM_Phone1"]=document.getElementById("NO_EM_Phone1").value;121 arg["NO_EM_Type1"]=document.getElementById("NO_EM_Type1").value;122 $.ajax({123 type:"POST",124 url: FlieServer+"/staff.php",125 data: arg,126 dataType:'text',127 success:function(result) {128 $("#myModal2").modal('hide');129 alert("添加成功！");130 location.reload(true);131 }132 });133 }134 functionNO_Delete(){135 document.getElementById("modal-body3").innerHTML="确认删除该行员工信息记录吗？";136 $("#myModal3").modal('show');137 }138 functionNO_Subdel(){139 $("#myModal3").modal('hide');140 vararg={};141 arg["TrCode"]= "NO_005";142 varNO_id=check_radio("radio");143 arg["NO_id"]=NO_id;144 $.ajax({145 type:"POST",146 url: FlieServer+"/staff.php",147 data: arg,148 dataType:'text',149 success:function(result) {150 alert("删除成功！");151 location.reload(true);152 }153 });154 }155 functionNO_Pass(){156 vararg={};157 arg["TrCode"]= "NO_006";158 arg["NO_EM_id"]=document.getElementById("NO_EM_id").value;159 arg["NO_EM_oldpass"]=document.getElementById("NO_EM_oldpass").value;160 arg["NO_EM_newpass"]=document.getElementById("NO_EM_newpass").value;161 if(arg["NO_EM_id"]==""){162 alert("请填写员工编号！");163 }164 else if(arg["NO_EM_oldpass"]==""){165 alert("请填写原密码！");166 }167 else if(arg["NO_EM_newpass"]==""){168 alert("请填写新密码！");169 }170 else{171 $.ajax({172 type:"POST",173 url: FlieServer+"/staff.php",174 data: arg,175 dataType:'text',176 success:function(result) {177 varres=JSON.parse(result);178 alert(res.Result);179 varinput1=document.getElementById("NO_EM_id");180 varinput2=document.getElementById("NO_EM_oldpass");181 varinput3=document.getElementById("NO_EM_newpass");182 input1.value="";183 input2.value="";184 input3.value="";185 }186 });187 }188 }189

190

191

192

199

200