php 前后端分离

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>