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 tutorialspoint.com/mysql/mysql-in-clause.htm — Aman Rawat
– Aman Rawat, Commented Mar 29, 2017 at 6: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
– Alex Odenthal, Commented Mar 29, 2017 at 6:59
Possible duplicate of Select from mysql table WHERE field='$array'? — Aman Rawat
– Aman Rawat, Commented Mar 29, 2017 at 7:02
I want the array values as column header in the mysql result set @AlexOdenthal — Kripanath Aditya
– Kripanath Aditya, Commented Mar 29, 2017 at 7:03

OfficialDtech · Accepted Answer · 2017-03-29 07:11:37Z

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, 2017 at 7:11

OfficialDtech

595 bronze badges

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

Comments

Sonal Khunt · Accepted Answer · 2017-03-29 07:02:28Z

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, 2017 at 7:02

Sonal Khunt

1,89612 silver badges20 bronze badges

1 Comment

Sonal Khunt Over a year ago

In this case, you have to make sure that string will pass like in IN clause ('str1','str2','str3')

Collectives™ on Stack Overflow

Mysql select statement using php array

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related