How to provide table name to select from a search text box like: SELECT * FROM $query
I cant find the answer anywhere, maybe someone could help me. I need to display my MySQL table, but I need to give the name of the table through search box.
Something like this:
$raw_results = mysql_query("SELECT * FROM $query") or die(mysql_error());
Your code already does that, only thing remaining is to pass the value to the variable $query
$query = "your search query"; $raw_results = mysql_query("SELECT * FROM $query") or die(mysql_error());
However, what you are doing is very vulnerable, you should not pass the table name from the text box to the code directly.
$query = $_POST['searchbox'];
Doing such will leave your code very vulnerable as I could type in
users and get all the details of the user.
Change your programming, whatever you are trying to do is wrong.