Initialize array to use mysql output outside loop

Question

Why the print_r don't output any data?

 $host = array();
 while($row = mysqli_fetch_array($result))
  {
  $host = parse_url($row['url'], PHP_URL_HOST); 
  //echo $host;
  echo "<br>";
  }

print_r($host);

What is the correct way to do this. Thanks in advance.

Emilio Gort · Accepted Answer · 2013-08-22 03:21:01Z

up vote 1 down vote accepted

Change this:

$host = parse_url($row['url'], PHP_URL_HOST);

For this:

$host[] = parse_url($row['url'], PHP_URL_HOST);

http://php.net/manual/en/language.types.array.php

answered Aug 22 at 3:21

Emilio Gort
1,137217

asked	28 days ago
viewed	35 times
active	28 days ago

Initialize array to use mysql output outside loop

1 Answer

Your Answer

Not the answer you're looking for? Browse other questions tagged php mysql arrays initialization or ask your own question.

Initialize array to use mysql output outside loop

1 Answer

Your Answer

Sign up or login

Post as a guest

Not the answer you're looking for? Browse other questions tagged php mysql arrays initialization or ask your own question.

Related