How to split string from commas(,) and store into separate variables in PHP

Question

I want to know how can I split a string and store that into separate variables. Suppose I have a string "healthy,foody,fitness,food" and now I want to store each value in separate variable. I already converted them into array with explode()

Now how can i store each value in separate variable like say

$health = "healthy";
$foody = "foody";
$fitness = "fitness";

and so on.

The main purpose of doing this is, I am trying to make an E commerce website with core PHP and I have a value called "tags" in database where i store tags in comma separated values and I have to use those tags for sorting "Similar Products" and that's why I need them in separate variable so that I can

"SELECT * FROM products WHERE tags='$health' OR tags='$foody'";

You get my point right? All helps appreciated! Have a great day!

where i store tags in comma separated values... The problems start here! never store values comma separated into db... think about normalization — B001ᛦ
– B001ᛦ, Commented Jul 13, 2018 at 10:35
@B001ᛦ, then how can i implement features like tags and cart? — Mann
– Mann, Commented Jul 13, 2018 at 10:46
then how can i implement features like tags and cart?... I think I already gave you the hint... normalization! — B001ᛦ
– B001ᛦ, Commented Jul 13, 2018 at 10:47
if you have already an array .. why you need the vars name ??? use the array by index — ScaisEdge
– ScaisEdge, Commented Jul 13, 2018 at 10:50

Script47 · Accepted Answer · 2018-07-13 10:55:32Z

2

If you want to find by tags from string, you can do that:

$string = "healthy,foody,fitness,food";
$tags = explode(",", $string);
$tags = array_map(function($v) {return "'".trim($v)."'"; }, $tags);
$sql = "SELECT * FROM products WHERE tags IN(".implode(",", $tags).")";

output is:

SELECT * FROM products WHERE tags IN('healthy','foody','fitness','food')

edited Jul 13, 2018 at 10:55

Script47

14.6k4 gold badges49 silver badges69 bronze badges

answered Jul 13, 2018 at 10:53

MrSmile

1,2332 gold badges13 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How to split string from commas(,) and store into separate variables in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related