How can i replace table name in this query string with another string or table name with php
SELECT
Panel.Id as PanelId,Panel.Title as PanelTitle,Panel.Icon as PanelIcon,
SubPanel.Id as SubPanelId,SubPanel.Title as SubPanelTitle,
SubPanel.Icon as SubPanelIcon,SecurityAccess.Id as Access,SecurityAccess.Controller,
SecurityAccess.Action
FROM Panel
INNER JOIN SubPanel
INNER JOIN SecurityAccess
WHERE
Panel.Id > 0 AND SubPanel.Panel = Panel.Id AND SubPanel.Id = UsersAccess.Subpanel
and SubPanel.Id > 0
ORDER BY Panel._Order,SubPanel._Order
For example: replace "Panel" with "my_panel"
I do not want you to change my String. Just use this string as it exists.
I hope this helps you..
$sql = "SELECT
$table_1.Id as PanelId, $table_1.Title as PanelTitle, $table_1.Icon as PanelIcon,
$table_2.Id as SubPanelId, $table_2.Title as SubPanelTitle,
$table_2.Icon as SubPanelIcon, $table_3.Id as Access, $table_3.Controller,
$table_3.Action
FROM $table_1
INNER JOIN $table_2
INNER JOIN $table_3
WHERE
$table_1.Id > 0 AND $table_2.Panel = $table_1.Id AND $table_2.Id = UsersAccess.Subpanel
and $table_2.Id > 0
ORDER BY $table_1._Order, $table_2._Order";
for your current query it would be like..
$table_1 = "Panel";
$table_2 = "SubPanel";
$table_3 = "SecurityAccess";
If $table_ vars are user input than be careful to escape them before putting into query.