echoing arrays outside of loop?

claire

Hi there
I have the following loop:

foreach($people as $k => $v) {
$people[$k] = join(', ', $v);
}

How do I echo out the values of the $people array outside of the loop?

I have tried this, but it doesn't work:

foreach($people as $k => $v) {
$people[$k] = join(', ', $v);
}
$persons[] = array_values($people);
echo $persons;

edwardsbc

In general you would just loop again to output the array members individually with echo() or print(). I suppose if you're really lazy you can use print_r()

claire

I know it's easy to echo out the individual elements one at the time from within the loop.
However, for a specific script that I'm working on - I need to run the loop first and then further down in the script do the actual echo statement.

My problem is that I'm not getting any output the way I have typed it now.

crickettdt

You should be able to use:

echo $people[0];

using the index of the array to call each individual value.

claire

But if I don't know how many entries the loop will find, and I want to print the all out in a list, how do I write the statement?

crickettdt

Declare a variable $num = count($people);

then $num, now contains the number of elements in your array.

Hope that helps.

claire

I tried without luck:

foreach($people as $k => $v) {
$people[$k] = join(', ', $v);
}

$num=count($people);
echo $people[$num];

as well as putting the $num=count($people); within the foreach loop.

netizen

From what I see you are trying to output the array into a string, you wouldn't need to loop to do that.


$people = array('john','peter','mary','sue');

$people = join(",",$people);

echo $people;

output:

john,peter,mary,sue

or:

echo array_values($people);

output:

array
(
     [0] => john
     [1] => peter
     [2] => mary
     [3] => sue
)

I'm not sure this helped, but your code would not have accomplished your need. You were basically redeclaring each value and adding a comma. You would still would have to use the index to call the value.

crickettdt

Claire

The variable $num only contains the number of elements in your array.

You can then use this number, to individually echo the elements of your array.

Remember, that an array indexes from 0, so if you had 10 elements to your array, the 10th element, would be echo $people[9];

If all you wish to achieve is displaying each element in turn, you can just use a foreach() function.

If you are still having trouble, post a bit more of the code, and your requirements.

claire

Here's my code. I query two different databases, The first one provides names, which I group and later on in the foreach statement join together according to apartement numbers.
Second database search provides me with a special code for each apartement.

I want to display a table with names and codes,
The foreach statement provides the names correctly but I cant get the equivalent 'portkod' that I have from the while loop.

/search db1 for surnames and apartmentno (Andel)

initdb($db_1);
$sql = mysql_query("SELECT Andel, substring_index(Namn,' ',1) AS surname FROM Uppgifter WHERE Andel>=24 AND Andel <=48 GROUP BY Andel, surname ORDER BY surname ");
	while ($row = mysql_fetch_assoc ($sql)) {
		$people[$row['Andel']][] =$row['surname'];
		$andel=$row['Andel'];

	//search db2 for 'portkod'variable using aptno from previous search.	
	initdb($db_2);
	$result = mysql_query("SELECT Portkod FROM Uppgifter WHERE  Andel=$andel");

		while ($rowc = mysql_fetch_assoc($result)) {
		$portkod[] = $rowc['Portkod'];
		}
}

//echo out surnames (some joined together according to aptno) and 'portkod' in a nice table

echo "<table cellpadding=\"2\" border=\"1\">";

foreach($people as $k => $v) {
	echo "<tr>";
	echo "<td width=\"300\">";
	$people[$k] = join(', ',$v);
	echo $people[$k];
	echo "</td>"."<td>";
	echo $portkod;
	echo "</td>"."</tr>";
}
echo "</table>";

crickettdt

Are there an equal number of rows from each database query?

If so, you can echo each one out into its own table, next to each other, then use HTML to make the two tables (columns) align vertically.

So, if the two variables $people and $portkod, correspond, you can save yourself a lot of hassle.

If not, give me a little while, and im sure i'll figure it out.

crickettdt

Actually, looking at your SQL, it looks like you are only fetching the rows which will correspond.

Just use a foreach() for each $people and $portkod, put them into separate tables, and put these two separate tables, into an html table like this:

<table>
<tr>
<td>
enter the $people foreach() here.
</td>

	<td>
		enter the $portkod foreach() here.
	</td>
</tr>

</table>

Hope that works for you.

claire

Sigh, that's where I started before I entered the forum. The results? Check:

http://www.brfskalen11.org/claire/testlista.php

It's getting real late over here and I've got to get some sleep.
I'll check in tomorrow to see and test all suggestions. I'm really grateful for all help and ideas out there - hopefully we'll get it right in the end!

crickettdt

Claire

If you output the elements of each array, in a foreach() statement, so that each output, is included in a table row-table cell of its own, you should get a table inside each of your cells.

I have attached a txt file with a better explanation. Having seen the site you attached, i think what i have done should help, keep us posted.

crickettdt

That attachement didn't work, try this one:

crickettdt

Attachment don't seem to work, try this:

<table border=1>
<tr>
<td>
<table>
<?
$people = array ("Dave", "Sharon", "Kevin", "Tracey", "Paul");

			foreach($people as $key => $val)
			{
				echo "<tr>";
				echo "<td>";
				echo "$val";
				echo "</td>";
				echo "</tr>";
			}
			?>
		</table>
	</td>

	<td>
		<table>
			<?
			$people = array ("B001", "B002", "B003", "B004", "B005");

			foreach($people as $key => $val)
			{
				echo "<tr>";
				echo "<td>";
				echo "$val";
				echo "</td>";
				echo "</tr>";
			}
			?>
		</table>
	</td>
</tr>

</table>

claire

A table within a table - by golly, you're a genius!!

When I finally got it right I realized I have a bug in the underlying code. Have tried desperately to solve it...

If I search for names first, I get to many instances of apt no. The names are joined together, but the duplicated aptnumbers causes a duplication of the 'portkod' in the next search. It doesn't help to do $portkod = array_unique($portkod). Instead I tried to strip doubles out of the $andel array. But don't know how to call it in my next search.

/search db1 for surnames and apartmentno (Andel)

initdb($medlemmardb);
$sql = mysql_query("SELECT Andel, substring_index(Namn,' ',1) AS surname FROM Uppgifter WHERE Andel>=24 AND Andel <=48 GROUP BY Andel, surname ORDER BY surname ");
	while ($row = mysql_fetch_assoc ($sql)) {
		$people[$row['Andel']][] =$row['surname'];
		$andel[]=$row['Andel'];
	}
$andel = array_unique($andel);

//search db2 for 'portkod'variable using aptno from previous search.
initdb($andelardb);
$result = mysql_query("SELECT Portkod FROM Uppgifter WHERE  Andel='$andel[$i]'");
		while ($rowc = mysql_fetch_assoc($result)) {
		$portkod[] = $rowc['Portkod'];
		}

Then I tried to switch it around, and search for Andel and portkod first (since there is only one instance of andel/portkod in that db).

initdb($andelardb);

$resultat = mysql_query("SELECT  Andel, Portkod FROM Uppgifter WHERE  Andel>=24 AND Andel <=48 ");
	while ($rowc = mysql_fetch_assoc($resultat)) {
		$andel=$rowc['Andel'];
		$portkod[] = $rowc['Portkod'];

	initdb($medlemmardb);
	$svar = mysql_query("SELECT Andel, substring_index(Namn,' ',1) AS surname FROM Uppgifter WHERE Andel=$andel  GROUP BY Andel, surname ORDER BY surname ");
		while ($row = mysql_fetch_assoc($svar)) {
		$people[$row['Andel']][] =$row['surname'];
		}
}

That works fine! BUT I lose the sorting of the list. It should be sorted alpabetically, but the above script sorts according to the first search (which is by aptno). Doesn't seem to help that the second search has another ORDER BY statement.

Any good ideas on how to solve it?

crickettdt

Claire

I take it you are still running the tests on:

http://www.brfskalen11.org/claire/testlista.php

if so, what is on line 71 of the code?

As that is the cause of the error message.

Post it, or email it to me.

claire

Line 71 is just the foreach statement:
foreach($portkod as $k=>$v)
expecting an array to work with ($portkod[]).
Since the second search doesn't create that array, I get the error msg. (At least that is what I think)

You can also look at
http://www.brfskalen11.org/claire/testlista1.php

where I'm doing the search the other way. The sorting is by apt no (more or less the same as the portkod codes...) not surnames as in

http://www.brfskalen11.org/claire/testlista.php

crickettdt

I had a look at:

http://www.brfskalen11.org/claire/testlista1.php

is it working? Can't see any error messages.

Or is it not ouputing what you expected?