PHP find string in array

Question

I have a column profile in MySql

firstset=one;two;three|secondset=blue;yellow;red;|thirdset=width;height;|

(expample) I need to get: yellow from secondset to variable

What i wrote:

... MySql query etc ...
...
if ($r_select['profile'] != null)
{       
    $resultSelect = $r_select['profile']; 

    $resultArray = explode('|', $resultSelect);

So now i have:

resultArray (

[1] firstset=one;two;three
[2] secondset=blue;yellow;red;
[3] thirdset=width;height;

)

I need to find where in resultArray[] is secondset= then save this in variable- i want to get

 $found = "secondset=blue;yellow;red;"

I know how to explode variable but i cant find string in array[]

Doesn't in_array() do what you want to find a string in an array? — Barmar
– Barmar, Commented Apr 25, 2016 at 16:21
Things would be so much easier if you normalized your database instead of storing everything in one column. — Barmar
– Barmar, Commented Apr 25, 2016 at 16:22
Loop through $resultArray. Split the element first on =, then split the second part of that on ;. Then use in_array() to search that array for "yellow". — Barmar
– Barmar, Commented Apr 25, 2016 at 16:24
Barmar- First: i can create new table in database only with profie but there will be about 40 kolumns. It is still ok ? just asking. Second: but if yellow will be in firstset too ? So what will be better? create new table or playing around with it? — Kafus
– Kafus, Commented Apr 25, 2016 at 16:28

Indrasis Datta · Accepted Answer · 2016-04-25 16:30:36Z

1

Try this:

if ($r_select['profile'] != null) {

    $resultSelect = $r_select['profile']; 
    $resultArray  = explode('|', $resultSelect); 

    foreach ($resultArray as $data) {

        if (strpos($data, 'secondset') !== FALSE) {
            $found = $data;
            break;
        }
    }
}
echo $found;

Result:

secondset=blue;yellow;red;

answered Apr 25, 2016 at 16:30

Indrasis Datta

8,6182 gold badges18 silver badges32 bronze badges

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

3 Comments

Death-is-the-real-truth Over a year ago

because of break don't you think if next indexes also have yellow that will ignored?

Death-is-the-real-truth Over a year ago

@kafus if your array have more than one time same value then only first one will come and others will skip. Check once. for example:-

resultArray (  [1] firstset=one;two;three [2] secondset=blue;yellow;red; [3] thirdset=width;height; [4] thirdset=width;height;yellow; )

Kafus Over a year ago

yes but first of all i'll get variable with secondset=blue;yellow;red; then i can look for my 'yellow'. There is no option that i can get 2x secondset

Sk_ · Accepted Answer · 2016-04-25 16:39:07Z

0

Are you looking something like this.

$result = Array (

'1' =>'firstset=one;two;three',
'2' =>'secondset=blue;yellow;red;',
'3' =>'thirdset=width;height;'

);
foreach($result as $key=>$value){
    if(strpos($value,'yellow')){
        $secondset = $value;
        break;

    }

}

$result1 = explode('=', $secondset);
$result2 = explode(';', $result1[1]);
list($a,$b,$c) = $result2;
echo $b;

answered Apr 25, 2016 at 16:39

Sk_

1,2219 silver badges18 bronze badges

Comments

olibiaz · Accepted Answer · 2016-04-25 16:41:12Z

0

Another solution without foreach:

$resultArray =  [
    'firstset=one;two;three',
    'secondset=blue;yellow;red;',
    'thirdset=width;height;',
];

// all the results matching secondset
$result = preg_grep('/.*secondset.*/', $resultArray);
// if you have only one result
$resultString = reset($result);

Then you can apply your explode on $resultString. If you have several results, like many string in your array with "secondset" on it, you will be able to process them in the array $result.

$result -> array(1) {
  [1] =>
  string(26) "secondset=blue;yellow;red;"
}

$resultString -> string(26) "secondset=blue;yellow;red;"

answered Apr 25, 2016 at 16:41

olibiaz

2,6034 gold badges31 silver badges33 bronze badges

Comments

Borna · Accepted Answer · 2016-04-25 17:34:43Z

0

You can use array_filter function with custom anonymous function.

$resultArray  = array("firstset=one;two;three", "secondset=blue;yellow;red;", "thirdset=width;height;");  

$matches = array_filter($resultArray, function ($haystack) {
    return strpos($haystack, 'secondset=') !== false ? true : false;
});

   // output => Array ( [1] => secondset=blue;yellow;red; )
print_r($matches);

To obtain all array keys (in your case only one):

// output => Array ( [0] => 1 )
print_r(array_keys($matches));

answered Apr 25, 2016 at 17:34

Borna

1,1992 gold badges12 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP find string in array

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related