Mysql select statement using php array

Question

Suppose I have an array as following

$sql_column_headings = array("Week Period", "Comments Approved", "Comment Replies");

Number of items in the array is not fixed as they are selected from a 'select multiple lists'.

The list may consist more than 3 items and any number of items may be selected. Then submit button is pressed. How can I create a select statement where the column headings are taken from the array mentioned above. Thanks.

MySQL IN Clause https://www.tutorialspoint.com/mysql/mysql-in-clause.htm — Aman Rawat, Mar 29 '17 at 06:59
What's your target? You really want to have a these array values being the column header in the mysql result set or what? — Alex Odenthal, Mar 29 '17 at 06:59
Possible duplicate of [Select from mysql table WHERE field='$array'?](http://stackoverflow.com/questions/2382831/select-from-mysql-table-where-field-array) — Aman Rawat, Mar 29 '17 at 07:02
I want the array values as column header in the mysql result set @AlexOdenthal — Kripanath Aditya, Mar 29 '17 at 07:03

score 1 · Answer 1 · answered Mar 29 '17 at 07:02

1

Try this,

$sql_column_headings = array("Week Period", "Comments Approved", "Comment Replies");

    $itemStr = implode(",",$sql_column_headings);

    $qry = "SELECT * FROM table_name WHERE field_name IN('$itemStr')";

    $resSet = mysql_query($qry);

Check this, https://www.w3schools.com/php/func_string_implode.asp

answered Mar 29 '17 at 07:02

Sonal Khunt

1,876
12
20

In this case, you have to make sure that string will pass like in IN clause ('str1','str2','str3') – Sonal Khunt Mar 29 '17 at 07:05

score 1 · Accepted Answer · answered Mar 29 '17 at 07:11

1

$sql_column_headings = array("Week Period", "Comments Approved", "Comment Replies");

    $columns = implode(",",$sql_column_headings);

    $sql = "SELECT '$columns' FROM table_name";

    $result = mysql_query($sql);

answered Mar 29 '17 at 07:11

OfficialDtech

59
5

Mysql select statement using php array

2 Answers2