[Resolved] Load an Array with a Loop

[busyguy78]

Say I have a set of variables that are set inside of a loop...

$a, $b, $c, $d

---

<?

If($myrow = mysql_fetch_array($results))
{

do
{

 $id = $myrow['ID'];

// Run $id through an include to get $new_var...

 include("new_var.php");

// Now $new_var is set based on the 'ID' field of the current row...

// Set variables from field data in the current row...
 $a = $myrow['Name'];
 $b = $myrow['Address'];
 $c = $myrow['Phone'];

}

// This is where I think the array should be loaded...

while ($myrow = mysql_fetch_array($results));

}
else
{
echo "Move along, nothing to see here.";
}

?>

---

Now what I want to do is create a new array that has $a, $b, $c, $d for each row of the original array...

So if the original $results array had 20 rows, $new_array will have 20 rows with a field/column for each variable ($a, $b, $c, $d)...

I know creating an array is probably child's play but I'm a newbie, have mercy...!

Any help would be appreciated...

[bubblenut]

Something like this? (restructured slightly to be more concise)

while($myrow=mysql_fetch_assoc($results)) {
  $id=$myrow['ID'];
  include('new_var.php');

  $output[]=array($myrow['Name'], $myrow['Address'], $myrow['Phone']);

}

if(!is_array($output) || count($output)==0) {
  echo('Move along here, nothing to see');
}

?> 

HTH
Bubble

[busyguy78]

Thanks for the help...!

Close, but I was looking around and found this on php.net...

---

$fruits = array (
"fruits" => array ("a"=>"orange", "b"=>"banana", "c"=>"apple"),
"numbers" => array (1, 2, 3, 4, 5, 6),
"holes" => array ("first", 5 => "second", "third")
);

---

What I need the array to look like, based on this, is...

---

$new_array = array (
"name" => array (Jim, Bob, Chucky),
"address" => array (add 1, add 2, add 3),
"phone" = > array (800, 900, 888),
"newvar" = > array (newvar1, newvar2, newvar3)
);

---

What needs to happen is each time the loop runs for a new row from the original query, it re-establishes the 4 variables and loads them into the new array as a new row...
Does this make sense...?

[busyguy78]

Maybe this will help...

$array_1 gives me 10 rows of results from a MySQL query...

The fields from the table called are 'A', 'B', 'C', 'D', and 'E'...

I run each row in $array_1 through a loop...

If ( $myrow = mysql_fetch_array ($array_1))
{

Inside the loop there is an included file that takes the value of $myrow['A'] and uses it in a bunch of logical 'if-else' statements to produce a value that populates $var...

Other needed data from $array_1 is loaded into other variables for no good reason...
$b = $myrow['B'];
$c = $myrow['C'];
$d = $myrow['D'];
$e = $myrow['E'];

I need the array to be populated like this...

---

[ 0 ] [ 1 ] [ 2 ] [ 3 ] [ 4 ] [ 5 ]
$a $b $c $d $e $var loop 1
$a $b $c $d $e $var loop 2
$a $b $c $d $e $var loop 3
$a $b $c $d $e $var loop 4

$a $b $c $d $e $var loop 5

Basically identical to the first array, but with the addition of the last column...

[bubblenut]

$new_array = array (
"name" => array (Jim, Bob, Chucky),
"address" => array (add 1, add 2, add 3),
"phone" = > array (800, 900, 888),
"newvar" = > array (newvar1, newvar2, newvar3)
); 

while($myrow=mysql_fetch_assoc($results)) {
  $id=$myrow['ID'];
  include('new_var.php');

  $output['Name'][]=$myrow['Name'];
  $output['Address'][]=$myrow['Address'];
  $output['Phone'][]=$myrow['Phone'];
}

See?

[busyguy78]

Thanks for giving me a hand on this...
It is my last hurdle to get this site up and running...

Here is the sample page I wrote to test your suggestions...

It just gives me a blank page when I run it...

Can you see what's wrong with it...
It might also help so show what I'm trying to accomplish...

---

<?php

// Connect to DB
include("Connect.php");

// Get results
$result = mysql_query("Select * from apartments");

// If there are results, add them to a new array with the new variable
if ($myrow = mysql_fetch_array($result))
	{
		do
		{
			$cheesy = "poofs";

			$output['ID'][]=$myrow['AptID'];
			$output['Address'][]=$myrow['AptAddress'];
			$output['Apt'][]=$myrow['AptApt'];
			$output['Cheesy'][]=$cheesy;
		}

		while($myrow = mysql_fetch_array($result));

	}
	else
	{
		echo "Sorry Charlie";

// Start table

?>

 		Table

		<table>

		<tr>
		<td>
			ID
		</td>
		<td>
			Address
		</td>
		<td>
			Apt
		</td>
		<td>
			Cheesy
		</td>	
		</tr>	

<?
// If there is anything in the new array, show it
if($myrow2 = mysql_fetch_array($output))
{
do
{
printf "<tr>

				<td>
					%s
				</td>
				<td>
					%s
				</td>
				<td>
					%s
				</td>
				<td>
					%s
				</td>
				</tr>",
				$myrow2['ID'],
				$myrow2['Address'],
				$myrow2['Apt'],
				$myrow2['Cheesy'];
		}				


		while($myrow2 = mysql_fetch_array($output));

		echo "</table>";

		}
		else
		{
			// If 2nd array has no information to list
			echo "Can't run 2nd Array";

		}		

}

else

{
	// If 1st array has nothing to list
	echo " Move along, nothing to see here.";

}	

?>

---

Again, thanks for your help...!!!

[bubblenut]

Please put your code in &#091;php&#093; &#091;/php&#093; tags, it makes reading it a lot easier.

 else
{
echo "Sorry Charlie"; 

You don't close the else condition.

 if($myrow2 = mysql_fetch_array($output))
{ 

$output is not a mysql resultset, it's an array, treat it as such. This is where your model becomes messy because you have to iterate one of the sub arrays to go through them all. The sceme for it should be
array([0] => array('name1'=> 'value1', 'name2'=>'value2'), [1] => array('name1' => 'value1', 'name2'=>'value2')) etc
rather than
array('name1'=> array([0] => 'value1', [2] => 'value2') ... etc

but anyway

for($i=0;$i<count($output['ID']); $i++) {
  echo($output['ID'][$i]."<br />\n");
  echo($output['Address'][$i]."<br />\n");
  ...
}

See? If you structure was different your code would look like

for($i=0;$i<count($output);$i++) {
  echo($output[$i]['ID']."<br />\n");
  echo($output[$i]['Address']."<br />\n");
  ... 
}

HTH
Bubble

[busyguy78]

I think I understand what you're saying now...

I'm at job #1 right now so I'll try it at lunch and let you know how it goes...

Thanks for the help...

Let my try this php thing real quick...

$var = "anything";

[busyguy78]

OK here is what I put together based on you're last post...

It still gives me a blank page...

I've got the initial loop working...

I'm not sure if the new array is loading up like it's supposed to...

Or maybe I'm not echoing the final array properly...

Let me know what you think...

    // Connect to DB
	include("dbConnect.php");

// Get results
$result = mysql_query("Select * from apartments");

// If there are results, add them to a new array with the new variable
if ($myrow = mysql_fetch_array($result))
	{
		do
		{
			$totalrows = mysql_num_rows($result);

			if(empty($i))
			{
			   $i = 0;
			}


			$a = $myrow['AptID'];
			$b = $myrow['AptAddress'];
			$c = $myrow['AptApt'];
		    $d = "new var";

// Here is the stuff I just can't get a grip on...
// I have $i set up to hold the current row #...


		        $output = array(
		             [$i]=>array ('ID'=>'$a', 'Address'=>'$b', 'Apt'=>'$c', 'Extra'=>'$d');

		        if($i<$totalrows)
		        {
		          $i = ($i+1);
		        }
		 }


		while ($myrow=mysql_fetch_array($result));

	}
	else
	{
		echo "Sorry Charlie";
	}

// This is where I would like to display a table with the rows from the $output array...

	  for($x=0;$x<count($output);$x++) 
	  { 
	    echo($output[$x]['ID']."<br />n"); 
	    echo($output[$x]['Address']."<br />n"); 
	    echo($output[$x]['Apt']."<br />n"); 
	    echo($output[$x]['Extra']."<br />n"); 
	  }

[busyguy78]

Maybe this will help...

If you go to the following URL you can see what I'm trying to accomplish...

http://www.bnrestaurants.com/test/search/search_form.php

Go ahead and look, I'll wait...

Ha!

---

Here is what I've accomplished so far...

The results that are returned are based on the min and max rent set in the form...

There is an include in the loop that takes the listing's ID and compares the values of the checkboxes in the form to each individual listing. This results in a percent match which is loaded into the variable $match_percent...

There should be 5 results per page...

Each listing should link to a detail page based on the ID...

---

Here are the last 2 problems I need to solve to complete this...

By adding the pagination, I lost the values for the checkboxes on the form for any page other than the first. This means that for every listing outside of page 1 the value for $match_percent will be 0...

I would like the results to be ordered by the 'Match Percent' column....

---

Here is the solution that would kill 2 birds with one stone...

Since I can display all of the information I'm looking for in an HTML table, why not load it all up into an array...?

Hopefully then, when I display the contents of the array, I can order it by the 'Match Percent' column. Also, the listings won't lose their $match_percent value during the pagination because it will be set before the new array is loaded...

Did I explain properly...?

It seems like it should be simple enough, but I just started using PHP 2 weeks ago...

Once I get this part done I can load all of the code into my HTML templates and have a working site...!!!!!

You said earlier how my structure was funky...

Are there any suggestions on how to fix it up...?

---

If this is giving you a headache, feel free to move on to the next thread...!

I'm going to try to set up a basic array and work my way up to what I need...

[busyguy78]

Hey...!
I figured it out...!

Here is the code to get the array loaded up like I was looking for...

In case it is helpful to anyone...
I'm now going to work on sorting it and putting in some pagination...

Thanks for the help bubblenut...

<?

// Hit up DB...

include("dbConnect.php");

// Set up query...

$results = mysql_query("SELECT * FROM apartments");

// Establish how many rows were returned...
	$totalrows = mysql_num_rows($results);


// Start moving rows through loop...

if($myrow = mysql_fetch_array($results))
{

	$i = 0;


	do
	{

		// Set outside variable
		$var = "work";

		// Load information from query and new variable into array
		$output[$i][0] = $myrow['AptID'];
		$output[$i][1] = $myrow['AptAddress'];
		$output[$i][2] = $myrow['AptApt'];
		$output[$i][3] = $myrow['AptCity'];
		$output[$i][4] = $i;


		if($i<$totalrows)
		{
			$i = ($i+1);
		}

	}

	while ($myrow = mysql_fetch_array($results));	

}

else

{

	echo "Sorry Charlie";

}


// Let's put this in a visible table...

$i = 0;

echo "Results";

echo "<table>";
echo "<tr>
		<td>
			ID
		</td>
		<td>
			Address
		</td>
		<td>
			Apt
		</td>
		<td>
			City
		</td>
		<td>
			Bonus
		</td>
	</tr>";

// Send array through the output loop thing

if (count($output) > 0)
{
	for ( $i = 0; $i < count($output); $i++ )
	{
		echo "<tr>";
		echo "<td>";
		echo $output[$i][0];
		echo "</td><td>";
		echo $output[$i][1];
		echo "</td><td>";
		echo $output[$i][2];
		echo "</td><td>";
		echo $output[$i][3];
		echo "</td><td>";
		echo $output[$i][4];
		echo "</td></tr>";
	}

}

else

{

	echo "Move along, nothing to see here";

}



?>