php后端代码
<?php
//列表集合数据获取
include('../conn.php');
header("Content-Type: text/html; charset=utf-8");
if ($_SERVER["REQUEST_METHOD"] == "GET") {
if (!isset($_GET["name"]) || empty($_GET["name"])) {
echo '{"success":false,"msg":"参数错误"}';
return;
}
$name=$_GET["name"];
$sql="SELECT e.id,e.name FROM table_equipment AS e LEFT JOIN table_user AS u ON e.user_id = u.id WHERE u.name='$name'";
$rs=$conn->query($sql);
$rows=array();
//$row = $rs->fetch_array(MYSQL_ASSOC);
while($row = mysqli_fetch_assoc($rs))
{
$rows[$row['id']]=$row['name'];
}
echo json_encode($rows);
}
else
{
echo json_encode( array(
'success'=>false,
'msg'=>"请求类型错误"
));
return;
}
?>
html前端代码
<script type="text/javascript">
var user_name="value";
$.ajax({
type: "get",
url: "./php/selectTableData/equipmentSelectParameter.php?name="+user_name,
async:false,
dataType:"json",
success: function(arr){
//标题;
var menu="<a><i class=\"mdi mdi-home\"></i> 设备</a>";
var title=$("<li class=\"nav-item active\" style=\"background:#e1e3e6;\"></i>").append(menu);
$("#nav-equiment").append(title); //拿到ul标签并插入数据;
$.each(arr, function(id,name) {
var submenu_li="<li class=\"nav-item nav-item-has-subnav\" id=\"subnav_"+name+"\"></li>";
var submenu_a="<a href=\"#!\" onclick=\"onDeviceParameters('"+id+"','"+name+"')\">"+name+"</a>";
var submenu_ul="<ul class=\"nav nav-subnav\"></ul>";
$("#nav-equiment").append(submenu_li);
$("#subnav_"+name).append(submenu_a);
$("#subnav_"+name).append(submenu_ul);
});
},
error:function(xhr){
console.log(xhr.status);
}
});
</script>