[RESOLVED] Not sure if an array is the answer

yanks6rule

So, I have been away from PHP for awhile and I am trying to get back into it. I am trying to call a MySQL db and put X,Y data into an array.

I have two fields x_coor and y_coor and I want to create a variable $plot[] that will go through the db and come out like this:

$plot[0]=(x_coor(0), y_coor(0));
$plot[1]=(x_coor(1), y_coor(1));

where 0 and 1 are the first two rows of my table. I don't know if this is possible with an array and i was wondering if someone could help me.

Thanks
Yanks

NogDog

You could define it in one command as:

$plot = array(
   0 => array('x' => 11, 'y' => 12),
   1 => array('x' => 21, 'y' => 22)
);

Or you can assign each element individually as:

$plot[0]['x'] = 11;
$plot[0]['y'] = 12;
$plot[1]['x'] = 21;
$plot[1]['y'] = 22;

yanks6rule

I did this and I was able to output an array of arrays, but now I am stuck trying to loop through this mess. I am sorry that I am leaning on this so heavily, but I have a hard time wrapping my mind around arrays. I have done some reading to break down the array, but I think mine is slightly more complicated. To get what I have I used this code:

while($row = mysql_fetch_array($sql))
{
$plot[] = array('x' => $row[1], 'y' => $row[2]);
}

and the output is this:

Array ( [0] => Array ( [x] => 160 [y] => 61 ) [1] => Array ( [x] => 91 [y] => 145 ) [2] => Array ( [x] => 83 [y] => 151 ) )

I was wondering how I can loop through this data to get $plot[0] = (160, 61)

I was trying foreach statements but not seemed to work.

Thanks,
Yanks

jernhenrik

<?php
//simulating plot array extracted from database
$plot[0] = array('x'=>25, 'y'=>50);
$plot[1] = array('x'=>35, 'y'=>56);
$plot[2] = array('x'=>100, 'y'=>10);
//etc.

//foreach example 1
foreach ($plot as $plotvalues) {
	echo "Plotvalue x: " . $plotvalues['x'] . " - Plotvalue y: " . $plotvalues['y'] . "<br/>";
}

echo "<hr/>";

//foreach example 2
foreach ($plot as $plotkey => $plotvalues) {
	echo "Plot#" . $plotkey . " is (" . $plotvalues['x'] . ", " . $plotvalues['y'] . ")<br/>";
}
?>

hth

yanks6rule

This was the first step of my program that I am trying to create. I am now just for learning sake trying to break down the complicated array into a simple one with the following code:

foreach ($plot as $plotkey => $plotvalues) {
$datax = array($plotvalues['x']);
$datay = array($plotvalues['y']);
}

What I don't understand is when you do this it only outputs the last value so I get an array with one value, why does it not just list the three digits I inputted from the simulated database?

I was expecting

$datax = array(25, 35, 100)

instead I got

$datax = array(100)

Thanks

NogDog

$datax = array();  // not strictly necessary, but I like to make sure I start clean
$datay = array();  // -- ditto --
foreach ($plot as $plotvalues) 
{
   $datax[] = $plotvalues['x'];
   $datay[] = $plotvalues['y'];
}