PHP Array filled with information form database

Question

This is how i put my information from the database in a array:

$sql = "SELECT city, read FROM location";
$info = mysql_query($sql);
$read = array();
while ($row = mysql_fetch_assoc($info)){
    $read[] = $row;
}

This is a piece of the output of $read (there are 40 city`s in the table):

Array ([0] => Array ([city] => New York [read] => false) [1] => Array ([city] => Paris [read] => true ))

Now I want to check if the read value of a city is true then echo something.

I don`t know how to do this do I need a for loop or just a if statement?

Can someone help?

Answer 1

function checkCityRead($city){
    foreach($read as $r){
        if($r['city']==$city){
            if($r['read']=='true'){
                //do something
            }
        }
    }
}

or if want it as a general loop for all cities

foreach($read as $r){
    if($r['read']=='true'){
        //do something
    }
}

EDIT:

As many recommendations in the comments, you should not use the deprecated library mysql, and also you should your query if it has been executed or not "Credits to @Fred-ii", so your code could be like this:

$con = mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno()){
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
} else{
    $sql = "SELECT city, `read` FROM location";
    $info = mysqli_query($sql, $con);
    if(!$info){
        echo mysqli_error($con);
    } else{
        $read = array();
        while($row = mysqli_fetch_assoc($info)){
              $read[] = $row;
        }
    }
}

Answer 2

You need a foreach statement :

foreach ($read as $value) {
    if ($value['read'] == true)
        echo 'something';
}

And, as stated by Magnus Eriksson in his comment, you should really refrain from using mysql_* functions.

EDIT (as caught and suggested by Fred -ii-) : read is a reserved mySQL keyword, thus your query should have failed if you didn't include backticks, as follows :

$sql = "SELECT city, `read` FROM location";

Side note : You might want to compare $value['read'] to 'true' instead of true (string and not bool) as I'm pretty sure mysql_fetch_assoc() always returns string-type values :

foreach ($read as $value) {
    if ($value['read'] == 'true')
        echo 'something';
}