Stuck at arrays

Rayman3_tk

Hi, I'm completely stuck at this, so I'd appreciate it if you could help.

What I'm trying to do is this: I get a series of ID's from a database, and use this line of code:

array(1 => $id[$i]-61, 2 => $id[$i]-60, 3 => $id[$i]-59, 4 =>
 $id[$i]-1, 5 => $id[$i], 6 => $id[$i]+1, 6 => $id[$i]+59 etc.

to calculate a new series of ID's. All these ID's are then put into an array again and the array is printed.

This works nice if the database query retreives only one ID, but once it retreives more, I end up with several arrays ($arr). I've spend the past 2 hours seeking for a way to merge all those ID's, but without any luck.

So, my question is:

How do I combine the different arrays that my script produces?

$query = mysql_query("SELECT territory.ID FROM territory WHERE UID=2")
or error("Sorry, there's a problem with our database, please try again later.");

while($result = mysql_fetch_array($query)){
$i = $i+1;
$id[$i] = $result["ID"];
}


foreach($id as $id[$i]){
$arr[$i] = array(1 => $id[$i]-61, 2 => $id[$i]-60, 3 => $id[$i]-59, 4 =>
 $id[$i]-1, 5 => $id[$i], 6 => $id[$i]+1, 6 => $id[$i]+59, 
8 => $id[$i]+60, 9 => $id[$i]+61);
}

print_r($arr);

ahundiak

I honestly have no idea what you are trying to do. You might try reading up on arrays in the manual.

This:
foreach($id as $id[$i]){
is bogus.

Maybe something like:
while($result = mysql_fetch_array($query)){
$ids[] = $result["ID"];
}
foreach($ids as $id) {
$arr[] = array(1 => $id -61, ...
}
But even here I don't really see the point.

Rayman3_tk

Sorry if I'm being vague, I'll try to be more specific next time. 😉.

Ik think I've solved the combine arrays thing: I've put the entire array stuff within the while loop of the select query...

But I've got another question. I'm using array_merge($array[1], $array[2]); to merge my arrays. But figuring that I can have up to 3000 arrays, I thought that typing all the $array[3], $array[4] would take centuries. So is there a way of automatically increase the number of arrays within the array_merge function, depending on the number of arrays I have?

Tnx.

leatherback

Hi,

Sure,

You car have a for-loop:

for($i=0; $i<numarrays; $i++)
{
}

But eh..

Are you sure you are tackling your problems in the right way? Do you need all these arrays?

Rayman3_tk

Hi,

Can you tell me what I should actually put in my for loop?

I've tried something like this:

for($i=0; $i<=$numarrays; $i++)
{
$arr = array_merge($arr[$i]);
}

But that didn't work.

Tnx!

leatherback

Hi,

I am sorry, but as posted earlier by ahundiak... It is very hard to grasp what you aretrying to achieve. So I suggest you think about what you are trying to do (! ACHIEVE), explain it a bit more clearly, and then we can perhaps help you.

But once more.. Are you sure you need all these arrays. I am 99% sure there is a better way of doing this (Since you need to print it to screen, you may be able to store your output in a stringvar, which you fill as you go, or you can print as you retreive the data?).

And again: If you can explain to us what you are actually trying to achieve, we can help you much beter!

Rayman3_tk

What I'm trying to achieve is getting ID's from a territory from a database and calculate some new ID's with those values, so I can query with those new ID's... That's it, basically. The reason I'm trying to do this is that I'm trying to build a map that displays the current location of a player, and, depending on that/those location(s) displays one extra field (id) of the map. And those extra fields is what I need al those arrays for...

leatherback

Hi,

Well, ok. Perhaps.. 😃

Anyway. Let me shar a piec of coding I used for variable multi-dimensional arrays. I use it to read specific dataformats from a file. Perhaps that helps?


$lines = sizeof($fcontents);

 for($x=0; $x<12; $x++)
   {
   $header .= $fcontents[$x] . "<br>";
   }

  $i = 12;
  $j = 0;
  while ($i < $lines)
   {
    $fcontents[$i] = ereg_replace(" {2,}", " ", $fcontents[$i]);
    $data[$j] = explode(' ', $fcontents[$i]);
    $data[$j][0] = 100*$data[$j][0];                // wavelength
    $data[$j][3] = 100*$data[$j][3];                // reflectance
    //echo $data[$i][0];
    $i++;
    $j++;
   }
 $data[0][4] = $header;
 break;

Data just grows with the variable, so no need for array_merge. I suppose you could do something like this? Using multi-dimensional arrays?

Rayman3_tk

$fcontents[$i] = ereg_replace(" {2,}", " ", $fcontents[$i]);

Where's this line exactly for? I don't understand the {2,} thing in there, or does it have nothing to do with my situation?

leatherback

Nope, it has nothing to do with your situation. It is a script to remove duplicate spaces from the data. I didn't clean the code.

As I said: I copied it from one of my scripts, to show you how you can fill multi-dimensional arrays using a loop.

ahundiak

I'll ask the same question as leatherback but from a different angle. Assume you have two territory id's, 27 and 94. What exactly do you need as the end result? Don't describe the process, just give the numbers.

Rayman3_tk

Well, the numbers would be: (I'll put them in the order as they could be displayed)

For 27:

-34 | -33 | -32
26 | 27 | 28
86 | 87 | 88

For 94:

33 | 34 | 35
93 | 94 | 95
153 | 154 | 155

Off course, negative numbers don't count :rolleyes:

leatherback

How is this?

$query = mysql_query("SELECT territory.ID FROM territory WHERE UID=2") 
or error("Sorry, there's a problem with our database, please try again later."); 

while($result = mysql_fetch_array($query)){ 
$i = $i+1; 
$id[$i] = $result["ID"]; 
} 

$a = 0;

foreach($id as $value)
  {   

  $output[$a] = array(value-61, $value-60, $value-59, 
 $value-1, $value, $value+1, $value+59,  

$value+60, $value+61); 
  $a++;
  } 

print_r($output);

ahundiak

I kind of gather that you don't need to maintain a link between the original id and the new calculated ones. At least, I guess that's why you are trying to merge the results. So:

<?php
// To allow later looping
$offsets = array(-61,-60,-59,-1,0,1,59,60,61);

// Initial test data, later read from a database
$ids = array(27,94);

// For the results
$idxs = array();

// Process each input id
foreach($ids as $id) {
  foreach($offsets as $offset) {
    $idx = $id + $offset;
    if ($idx > 0) {
        $idxs[$idx] = $idx;  // Use the value as the key to prevent dups
    }
  }
}
print_r($idxs);
?>

Rayman3_tk

Well, when changed into this: (in reply to leatherback)

while($result = mysql_fetch_array($query)){  

$i = $i+1;  

$id[$i] = $result["ID"];
$value[$i] = $result["ID"];
}  

$a = 0; 

foreach($id as $value) 
  {    

  $output[$a] = array($value-61, $value-60, $value-59,  

 $value-1, $value, $value+1, $value+59,   

$value+60, $value+61);  

  $a++; 
  }

print_r($output);

It gives the correct output, being:

Array (

[0] => Array ( [0] => -59 [1] => -58 [2] => -57 [3] => 1 [4] => 2 [5] => 3 [6] => 61 [7] => 62 [8] => 63 )

[1] => Array ( [0] => -58 [1] => -57 [2] => -56 [3] => 2 [4] => 3 [5] => 4 [6] => 62 [7] => 63 [8] => 64 ) )

Now the doubles have to be filtered out and I need to find a way to query for those ID's. I've already tried array_unique on $output, but that doesn't work as it only seems to be taking the first array.

(Oh, and did I tell you how much I appreciate you helping me guys? 🙂 )

leatherback

OK..
does it matter at all what the "original" ID number was? So the 27 or the 94?

Rayman3_tk

Yes, the original ID number does matter, because it can change dynamically.

Moonglobe

[edit]should really read whole thread first[/edit]

leatherback

yeah, I know that can change. But what I am beginning to see.. All you want is an overview of all id's right/ It doesn't matter what they came from?
Then you could just chunk everything in one huge array?

Sorry. Getting a bit confused & am trying to see wether there are more managable ways to do this.

As for moonglobe: [edit] THanx, I did read the whole thread first, [/edit] try to make some productive statements, ok?

LordShryku

Originally posted by leatherback
As for moonglobe: Once you get your out of your , try to make some productive statements, ok?

Is that neccesary? I've seen some stupid posts from you, but I don't make a point to demean you about them