check array item's value by looping

Question

while ($row = $checkUser->fetch_assoc()) {
        $arr = $row['username'];
}

check like this just don't work

if($arr !="john"){

}else{

}

how can I check $row['username'] contain or not string "john"?

You mean `if($arr !="john"){` or is that `$arry` just a typo? — Funk Forty Niner, May 11 '14 at 13:58
Well, good luck to the person who put in an "answer" then @bwoebi seems like it was a typo from the OP's edit. — Funk Forty Niner, May 11 '14 at 14:02
@Fred-ii- see, the user did himself update the question. It really just was a typo in the question. — bwoebi, May 11 '14 at 14:03
That's what I wrote in my comment above @bwoebi Which is why I always like to comment first and not have to ask questions later ;-) — Funk Forty Niner, May 11 '14 at 14:04

Viscocent · Accepted Answer · 2014-05-11T14:09:15.497

0

presumming that you are getting this $row['username'] right. then

$arr = array();

while ($row = $checkUser->fetch_assoc()) {
        $arr[] = $row['username'];
}

if(in_array("john",$arr)){
    //there is a username john in the array
}else{
    //this is no john inside the array
}

edited May 11 '14 at 14:09

answered May 11 '14 at 14:02

Viscocent

2,024
2
19
26

I don't want to put into while, possible? coz if $arr = john, I want to do my another sql query execution. – user3522474 May 11 '14 at 14:03
aah i get it you mean to check if `$arr` contain the string `john`? – Viscocent May 11 '14 at 14:04
@user3522474 i updated my answer, please check it. – Viscocent May 11 '14 at 14:10
in_array() expects parameter 2 to be array – user3522474 May 11 '14 at 14:45

check array item's value by looping

1 Answers1