php arrays: how to print only array values but not keys

Question

This code loops through a mysql table and prints out empty/null fields. It however prints the array values and the keys like this

Array ( 
    [0] => Field "dob" on entry "1" is empty/null 
    [1] => Field "user_name" on entry "7" is empty/null
)

How do I print something like this field "dob" on entry "1" is empty/null

$sql = "SELECT * FROM userinfo";
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res)) {
    foreach($row as $key => $field) {
        if(empty($field)) {
            $emptyFields[] = sprintf('Field "%s" on entry "%d" is empty/null', $key,   $row['userid']);
         }
     }
}
print_r($emptyFields);

biakaveron · Accepted Answer · 2011-03-23 10:10:01Z

9

echo implode('<br>', $emptyFields);

answered Mar 23, 2011 at 10:10

biakaveron

5,4831 gold badge18 silver badges20 bronze badges

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

3 Comments

karto Over a year ago

it worked fine. It prints out Field "4" on entry "11" is empty/null Field "address" on entry "11" is empty/null. They are all the same. How do i avoid printing field "4" on entry "11" is empty/null.

biakaveron Over a year ago

I dont understand what do you need. You want to skip integer keys, am I right? Just use check if( ! is_integer($key) AND empty($field)).

karto Over a year ago

How do i avoid printing column headers repeatedly? eg. Field "name" on column "2" is empty, Field "name" on column "3" is empty. I just wanna print one field "name" and give details rather on a separate page.

Thorben · Accepted Answer · 2011-03-23 10:06:48Z

1

That is because you are using print_r to output that array. So the output is formatted readable for humans. To make it more pretty try to iterate through it like you did before with that field:

foreach($emptyFields as $key => $field) {
echo('Field "'.$field.'" on entry "'.$emptyField['userid'].'" is empty/null');
}

answered Mar 23, 2011 at 10:06

Thorben

6,9792 gold badges21 silver badges20 bronze badges

Comments

Imi Borbas · Accepted Answer · 2011-03-23 10:06:39Z

0

$sql = "SELECT * FROM userinfo";
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res)) {
  foreach($row as $key => $field) {
    if(empty($field)) {
      $emptyFields[] = sprintf('Field "%s" on entry "%d" is empty/null', $key,  $row['userid']);
    }
  }
}

answered Mar 23, 2011 at 10:06

Imi Borbas

3,7231 gold badge21 silver badges16 bronze badges

Comments

sharpner · Accepted Answer · 2011-03-23 10:06:46Z

0

i dont know if I get this correctly but I think the solution to your problem is:

change the last line to:

$emptyFields[] = sprintf('Field "%s" on entry "%d" is empty/null', $field, $row['userid']);}}}print_r($emptyFields);

answered Mar 23, 2011 at 10:06

sharpner

3,9773 gold badges21 silver badges28 bronze badges

Collectives™ on Stack Overflow

php arrays: how to print only array values but not keys

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