PHP: SQL query to select columns provided by php array from any table

Question

I have array of columns which I want to search from table.

I am looking to use SQL something like :

$columns = array('a', 'b', 'c');
$sql = "select $columns from table";

Is this possible? How can we perform such action?

Jeff · Accepted Answer · 2015-07-28 23:27:15Z

2

A part of it is possible:

$columns = array('a','b','c');
$sql = "Select ".implode(",", $columns) . " from table....";

EDIT

I'm afraid, it is not possible to exclude the table-name! But you can query first all table names and then select from those.

answered Jul 28, 2015 at 23:27

Jeff

6,9611 gold badge19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1