使用where子句创建自定义视图时出现的问题

Question

我已经创建了一个页面，使用PHP作为数据库的前端。

我需要这个查询，因为我希望最终用户输入团队名称以获得他们想要的团队的列表。但在PHP上，我无法做到这一点。

我使用PHP Maker来创建前端。

下面是我的查询的SQL代码

SELECT
emp_details_ees.Employee_Code,
emp_details_ees.Employee_Name,
post.Emp_Post,
designation.Employee_Designation,
team.Emp_Team,
base_station.Base_Station,
region.Region,
zone.Zone,
emp_details_ees.Employee_Company_Number,
emp_details_ees.Employee_Comapny_Email,
`status`.Emp_Status,
emp_details_ees.Employee_Personal_Address
FROM
base_station
INNER JOIN emp_details_ees ON emp_details_ees.Employee_Base_Station = base_station.basestation_id
INNER JOIN post ON emp_details_ees.Employee_Post = post.emppost_id
INNER JOIN designation ON emp_details_ees.Employee_Designation = designation.empdesignation_id
INNER JOIN region ON emp_details_ees.Employee_Region = region.region_id
INNER JOIN `status` ON emp_details_ees.Employee_Status = `status`.empstatus_id
INNER JOIN team ON emp_details_ees.Employee_Team = team.empteam_id
INNER JOIN zone ON emp_details_ees.Employee_Zone = zone.zone_id
WHERE
`status`.Emp_Status = 'Active' AND team.Emp_Team = [$Emp_Team]
ORDER BY
base_station.station_sortid ASC,
designation.designation_sortdid ASC;

如果你能帮我理清头绪。

Answer 1

在WHERE子句中将$Emp_Team更改为{$Emp_Team