PHP - Search Multi Dim Array

I am having a hell of a time getting this to work. I need the keys in an array to be specific, not a sequential number or a row in my database. I need to add to the array through each loop of my while() statement. This code does it, but does not use the keys I specify, after the first entry, it starts assigning numbers to keys. Any guidance would be great.

<?php
require_once ('includes/config.php');
require_once ('includes/connect.php');

$echoarray = array();
$resultsql = mysql_query("SELECT * FROM clients")or die(mysql_error());
while($row = mysql_fetch_array($resultsql)){
    if(empty($echoarray)){
$echoarray = array(
'id' => $row['ID'],
'name' => $row['First_Name'] . " " . $row['Last_Name'],
'price' => $row['Status'],
'number' => $row['Sex'],
'address' => $row['Phys_Street'],
'company' => $row['Agency'],
'desc' => $row['Notes'],
'age' => $row['Date_Birth'],
'title' => $row['Occupation'],
'phone' => $row['Phone'],
'email' => $row['Email'],
'zip' => $row['Phys_Zip'],
'country' => $row['Phys_City']
);
}
else
{
array_push($echoarray,
$echoarray['id'] = $row['ID'],
$echoarray['name'] = $row['First_Name'] . " " . $row['Last_Name'],
$echoarray['price'] = $row['Status'],
$echoarray['number'] = $row['Sex'],
$echoarray['address'] = $row['Phys_Street'],
$echoarray['company'] = $row['Agency'],
$echoarray['desc'] = $row['Notes'],
$echoarray['age'] = $row['Date_Birth'],
$echoarray['title'] = $row['Occupation'],
$echoarray['phone'] = $row['Phone'],
$echoarray['email'] = $row['Email'],
$echoarray['zip'] = $row['Phys_Zip'],
$echoarray['country'] = $row['Phys_City']
);
    
}

Any Ideas?

i want to edit a product and allocate industries to a product

refer following link to view

http://meriwebsite.net/envytech/admin/industryallocate.php?pageNum=1SELECT%20a.products_id,%20a.products_image,%20b.language_id,%20b.products_description,%20b.products_name%20%20%20FROM%20products%20a%20,%20products_description%20b%20WHERE%20a.products_id%20=%20b.products_id%20and%20language_id=1%20and%201%20order%20by%20%20b.products_id,%20%20b.products_description

I can update prouct name and serial number

but cannot get values for industries

the do while loop for industry display  is given below (displaying industry id before check box here)

 $iquery="SELECT * from industry  ";
 

mysql_select_db($database_DBconnect, $DBconnect);

$iResult = mysql_query($iquery, $DBconnect) or die(mysql_error());

$irows = mysql_fetch_assoc($iResult);

$itotalrows=mysql_num_rows($iResult);

$j=-1;

do { $j++; ?>

<br /><?php echo "id=". $irows['id'];?><input name="ind[$i][$j]" type="checkbox" class="vardana12" id="ind[$i][$j]" value="<?php echo $irows['id'];?>" />

<?php echo $irows['name'];?>

 

<?php } while (

$irows = mysql_fetch_assoc($iResult)

);

 

?>  


I am trying to display values using following code

if ( (isset($_POST['sub'] )) or (isset($srno['sub'] ))) {

   echo "<br> count=".count($_POST['srno']);

for($i=0; $i< 

count($_POST['srno']); $i++){

echo "on 'save' clicked   <br>";

echo "<br> products ".$_POST['products_id'][$i];

echo "<br>srno ". $_POST['srno'][$i];

echo "<br>industry ".print_r($_POST['ind'][$i]);

echo "<br>product name ". $_POST['products_name'][$i];
 

Updateindustry($_POST['products_id'][$i], $_POST['srno'][$i],$_POST['industry'][$i],$_POST['products_name'][$i]); }
        $update=1; $alert= "udation done";
 }

I am not getting correct values for $_POST['industry'][$i]

please help

I have been trying to solve this problem for a few days now and can't seem to work it out. I'm sure i'm missing some simple point..
I am using a mysql PDO fetch to return 2 fields in each row and then put them into an array of their own:
foreach ($st->fetchAll() as $row){
$subs[] = array($row['subscriber'],$row['plant']);
Some of the rows share the same $row[0], which is the 'subscriber' field. What I want to do is make up another array with each smaller array having a single, unique $row[0] and any number of added 'plant' fields following (e.g $row[1],$row[2] etc).
I've tried all sorts of ways to achieve this but am at a loss. Would someone be able to point me in the right direction ? Thanks.

What am I missing here?

The array:
protected $form_bonus = array(
"Attacker" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38), 
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array( 
"normal" => 1.195,
"rps" => 1.494),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
),
"Defender" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38), 
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.15,
"rps" => 1.38),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
)
);

accessing it:
$bonus *= form_bonus[$this->role][$this->race]['rps'];

error:
PHP Parse error:  syntax error, unexpected '['

Code: [Select]
$i=1;
$selected=0;
$uservalue=20;
$numCols = 3;
$numPerCol = ceil(20 / $numCols);
echo "<table class=tuble><tr>";
for($col = 1; $col <= $numCols; $col++) {
   echo "<td>";
   for($row = 0; $row < $numPerCol; $row++) {
      $resultRow = 20;
       if ($i<=$uservalue) {
if ($i == $selected) {
   $checked = 'checked';
  }else{
  $checked = '';
  }
 $styles = array(
 
'Blue Essense' => array('#2B8EFF', '#63CBFF', '50 Forum Gold'),
'veggie' => array('carrot', 'collard', 'pea')
 
 
  );
 
 
 
    echo '<input type="radio" value="'.$i.'" name="form[color]">Blue Essence <b><a style="color:#2B8EFF;text-shadow:#63CBFF 2px 1px 1px" href="u.php?id='.$pun_user['id'].'">'.$pun_user['username'].'</a></b><br>';
  }
  else {
    echo '<label for="s'.$i.'"><input type="radio" value="'.$i.'" name="form[star]" disabled><b><a href="u.php?id='.$pun_user['id'].'">'.$pun_user['username'].'</a></b><br>';
  }
  $i++;
   }
   echo "</td>";
}
echo "</tr></table>";
Okay,  see the $styles array?

Code: [Select]
$styles = array(
 
'Blue Essense' => array('#2B8EFF', '#63CBFF', '50 Forum Gold'),
'veggie' => array('carrot', 'collard', 'pea')
 
 
  );
The first is hex code, background, and 2nd is #63CBFF (Front color) and the 3rd is how much it costs

I need those arrays to echo out correspondent with my

Code: [Select]
echo '<input type="radio" value="'.$i.'" name="form[color]">Blue Essense<b><a style="color:#2B8EFF;text-shadow:#63CBFF 2px 1px 1px" href="u.php?id='.$pun_user['id'].'">'.$pun_user['username'].'</a></b> (50 Forum Gold)<br>';
See how the style="color etc/etc" I need to grab the data from $styles to go into the correct spots, Is this feasable?

Long story short, I need to explode those arrays out somehow, any idea?

Hi people

I need a way to loop through an array where $imgid is some random number assigned to each array element and there are 4 fields id, url, tnurl, caption per array element. I need to extract these 4 fields in the same loop iteration. Thanks

Code: [Select]
$_SESSION['imagegallery'][$imgid]['id'];
$_SESSION['imagegallery'][$imgid]['url'];
$_SESSION['imagegallery'][$imgid]['tnurl'];
$_SESSION['imagegallery'][$imgid]['caption'];
example:
Code: [Select]
$_SESSION['imagegallery'][347]['id'];
$_SESSION['imagegallery'][347]['url'];
$_SESSION['imagegallery'][347]['tnurl'];
$_SESSION['imagegallery'][347]['caption'];
$_SESSION['imagegallery'][892]['id'];
$_SESSION['imagegallery'][892]['url'];
$_SESSION['imagegallery'][892]['tnurl'];
$_SESSION['imagegallery'][892]['caption'];

Hi can anybody help me out with the following problem I am having? I need to populate the key values in the multi-dimentional array structure shown below and the values will be used later in the following way:

<tr>
  <td><?php echo $sm_array[1]['col_1']; ?></td>
  <td><?php echo $sm_array[1]['col_2']; ?></td>
  <td><?php echo $sm_array[1]['col_3']; ?></td>
  <td><?php echo $sm_array[1]['col_4']; ?></td>
  //and so on, up to 10
</tr>
<tr>
  <td><?php echo $sm_array[2]['col_1']; ?></td>
  <td><?php echo $sm_array[2]['col_2']; ?></td>
  <td><?php echo $sm_array[2]['col_3']; ?></td>
  <td><?php echo $sm_array[2]['col_4']; ?></td>
  //and so on, up to 10
</tr>

This is the array structure, $td->innertext is just a different value each time and is not important for this example, it could essentially be anything:

sm_array[$row] = array( "col_1" => $td->innertext,
                        "col_2" => $td->innertext,
                        "col_3" => $td->innertext,
                        "col_4" => $td->innertext,
                        "col_5" => $td->innertext,
                        "col_6" => $td->innertext,
                        "col_7" => $td->innertext,
                        "col_8" => $td->innertext,
                        "col_9" => $td->innertext,
                        "col_10" => $td->innertext,
);

But I need to add the values inside a loop, like this:

while($row=0; $row<=10; $row++) {
  $sm_array[$row] = array( "col_".$row => $td->innertext);
}

But this doesn't allow me to change the key name inside the loop, so for $sm_array[1] there will be 10 keys and their values, and the same for $sm_array[2], it will also have 10 keys and different values for each key and so on! But for some reason the key value will not work this way inside a loop, it doesn't allow "col_".$row and I even tried to echo the key name, like this:

while($row=0; $row<=10; $row++) {
  $sm_array[$row] = array( "<?php echo $row; ?>" => $td->innertext);
}

It only seems to accept a fixed string or integer as the key, like this:

while($row=0; $row<=10; $row++) {
  $sm_array[$row] = array( "col_1" => $td->innertext);
  // or like this
  $sm_array[$row] = array( 1 => $td->innertext);
}

But then I have a problem, I can't change the key name dynamically! I have tried doing this with conditional staments like this, but it only accepts the first key name and the 2nd, 3rd etc, etc all fail:

while($row=0; $row<=10; $row++) {
  if($row==1){
     $sm_array[$row] = array( "col_1" => $td->innertext);
  }else if($row==2){
     $sm_array[$row] = array( "col_2" => $td->innertext);
  } //and so on
}

Can somebody please tell me what I am doing wrong or can't this be done or is their some other way of doing this?

Thanks in advance
Grant

$form_bonus = array(
"Attacker" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.195,
"rps" => 1.494),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
),
"Defender" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38),
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.15,
"rps" => 1.38),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
)
);
echo "<pre>".print_r($form_bonus)."</pre>";

output: 1

what am i missing here?

Hello , i am trying to sort a 2d dimensional array by the first column(id) and i havent find anything till now

This is my code for the 2d array:

$username = $_SESSION['username'];
$c = 0;

$row=1;
$col=1;
$users_array = array();
$get_from = mysql_query("SELECT id FROM my_activity WHERE from_user='$username'");
while($fetch1 = mysql_fetch_array($get_from)){
$id[$c] = $fetch1[0];
$get_from_user = mysql_query("SELECT * FROM my_activity WHERE id='$id[$c]'");
$get_user_rows = mysql_num_rows($get_from_user);
while($guser = mysql_fetch_array($get_from_user)){
$user[$c] = $guser['to_user'];
$users_array[$id[$c]][$user[$c]]= $id[$c].".".$user[$c];
$c++;
}


}

$get_to = mysql_query("SELECT * FROM my_activity WHERE to_user='$username'");
while($fetch2 = mysql_fetch_array($get_to)){
$id[$c] = $fetch2[0];
$get_to_user = mysql_query("SELECT from_user FROM my_activity WHERE id='$id[$c]'");
while($tuser = mysql_fetch_array($get_to_user)){
$user[$c] = $tuser[0];
$users_array[$id[$c]][$user[$c]]= $id[$c].".".$user[$c];
$c++;
}


}


This is what i get if i simply loop the array to get the result:

Code: [Select]
Array
(
    [6] => Array
        (
            [checkdate] => 6.checkdate
        )

    [25] => Array
        (
            [asdsadsad] => 25.asdsadsad
        )

    [7] => Array
        (
            [webuser] => 7.webuser
        )

    [9] => Array
        (
            [newuser] => 9.newuser
        )

    [10] => Array
        (
            [bot77un] => 10.bot77un
        )
)

I am trying to sort it by the ids 6,25,7,9,10 in DESC

I have a pipe delimited file with this sample content:

INV8004199|01/26/2012|Next door|648.00
SPT803487|01/25/2012|This and That|3360.00
INV8004193|01/25/2012|Where is it|756.00
INV8004133|01/05/2012|snowy winter|6750.00

I open the file to read it:
Code: [Select]
     $CPfile = "sample.DEL";

      $ft = fopen( $CPfile, "r");
$content1 = fread($ft, filesize($CPfile));
fclose($ft);



Then I loop thru it:

Code: [Select]
$out = explode("\n",  $content1);
$total = 0;
   
   foreach($out as $var) {

$tmp = explode("|", $var);

for($i=0;$i<count($tmp);$i++){
                            echo $tmp[$i] . "<BR>";
               }
   }


What I would like to get is the total of all prices (last column) in all lines of the file.  Can someone help please?. Thanks!

Hey everyone. I'm in the final stage of my thingeee (yay). The last thing I need is to prepare a report, but I'm slightly lost on how to do it. Essentially, I have a query that returns some financial records and need to aggregate the data manually (in PHP).  I'm familiar with the foreach($assoc_array as $array) function, and I'd like to use it to manipulate the output as follows:
For the first key (instType), this will mark the start of a new table element For a second key (paymentID), this will mark the start of a new table row element For a third key, (instrumentID), this will mark a new column (<td>) Then, I need to sort by two other keys - deptID, userID, accountID How do I accomplish this? Pseudo-code is acceptable (my array is called $data and contains all the keys I listed above)

Hello, I have been at this for awhile now and cant seem to figure it out.  I have 2 separate arrays like shown below and I am trying to insert each value into my database using one update query. I have tried a for loop inside each array, but only one column populates.  I have tried breaking the values outside their for loop, etc, etc.

Does anyone know a way this can be done?

Code: [Select]

//Cars
$cars = array('ford', 'toyota', 'bmw');

//Places
$places =arrray('Orlando','California','Texas');

 foreach ($cars as $car){
          foreach ($places as $place){
          $place .=$place;
         }
 mysql_query("INSERT INTO vehicles  (cars, places) VALUES ('" . $car. "', '" . $place . "'')");
}

HI - Pulling my hair out ..  I'm trying to extract from a 3 dimensional array the data for insert to MySql. It  is looping correctly however, and it is inserting, however for some reason I am not getting values for price and quantity, just 0.    The array is contained within

Code: [Select]
$prod_details = ($_SESSION['cart']);
if you do a print_r on the the session, you get :

Code: [Select]
Array
(
    [22] => Array
        (
            [name] => Turkey Jumbo Pack
            [price] => 155.25
            [count] => 1
        )

    [20] => Array
        (
            [name] => Chicken Variety Pack
            [price] => 120.35
            [count] => 1
        )

)

I am using a nested foreach loop to traverse the array:

Code: [Select]
$prod_details = ($_SESSION['cart']);
 
  foreach ($prod_details as $keyOne=> $value){
$prodID = $keyOne;
   foreach($value as $keytwo=>$row) {
   $price = $keytwo['price'];
   $quantity = $keytwo['count'];
   }
But I all I get out of $price and $quantity when I do an insert is 0.

What am I doing wrong ?

MANY MANY thanks for all your help ! !

I'm not entirely sure how to phrase the title, so I hope it's appropriate...

I have an array which looks like the following..
Code: [Select]
Array
(
    [contact] => Array
        (
            [0] => Array
                (
                    [name] => Someone Cool
                    [number] => 1234567890
                )

        )

    [messages] => Array
        (
            [0] => Array
                (
                    [message] => A message that was recieved
                    [date] => 1234567890
                    [type] => 1
                )

            [1] => Array
                (
                    [message] => A message which was sent
                    [date] => 1322175702616
                    [type] => 2
                )
        )
    [calls] => Array
        (
            [0] => Array
                (
                    [datetime] => 1320674980836
                    [type] => 1
                    [duration] => 7
                    [number] => 1234567890
                )

            [1] => Array
                (
                    [datetime] => 1320675327541
                    [type] => 2
                    [duration] => 638
                    [number] => 1234567890
                )
       )

)


[messages] can have anywhere between 40 and 3000 children
[calls] can have anywhere from 0 to 200ish children
** These are generals, but realistically, either can have any number.

What I'm trying to do is dump all messages and calls.

The catch is this: When dumping a call, a check needs to be run against datestamps and only dump the next call coming out where the datestamp of the call is NEWER than the LAST message dumped, AND OLDER than the message that is to be dump in this cycle of the loop.  What I have so far is the following...
Code: [Select]
foreach($vardump['messages'] as $message) {

// So we have a reference point for the first call we're going to dump
if(!is_numeric($last_message_stamp)) { $last_message_stamp = $message['date']; }

            if( trim($vardump['calls'][$calls_counter]['datetime']) > trim($last_message_stamp) &&
trim($vardump['calls'][$calls_counter]['datetime']) < trim($message['date'])) {

// Dump the calls row!
echo("
<div class=\"chatbubble-call\">
            <div class=\"chatbubble-person\">".$vardump['contact'][0]['name']."</div>
            <p>".$vardump['calls'][$calls_counter]['number']."</p>
<p>".date("h:i:s", $vardump['calls'][$calls_counter]['number'])."</p>
            <div class=\"chatbubble-datetime\">".date("l, j F, Y -- h:i:s", $vardump['calls'][$calls_counter]['datetime'] / 1000)."</div>
        </div>
");

// Increase our calls index
$calls_counter++;


}


// Begin dumping Texts out :D
// Let's see which style type we're dumping out...
if($message['type'] == 2) { // Message Sent

echo("
<div class=\"chatbubble-sent\">
<div class=\"chatbubble-person\">Pat Litke</div>
<p>".$message['message']."</p>
<div class=\"chatbubble-datetime\">".date("l, j F, Y -- h:i:s", $message['date'] / 1000)."</div>
</div>
");


} else { // Message Recieved

echo("
<div class=\"chatbubble-recieved\">
<div class=\"chatbubble-person\">".$vardump['contact'][0]['name']."</div>
<p>".$message['message']."</p>
<div class=\"chatbubble-datetime\">".date("l, j F, Y -- h:i:s", $message['date'] / 1000)."</div>
</div>
");

}

// Reset our $last_messge_stamp variable
$last_message_stamp = $message['date'];




}

I should also add that I am using the following queries to pull this date out of my database...
Code: [Select]
$sql_get_messages = "SELECT * FROM messages
WHERE thread_number LIKE '%$the_thread%'
ORDER BY epoch_date ASC";

$sql_get_calls = "SELECT * FROM calls
WHERE number LIKE '%$the_thread%'
ORDER BY datetime ASC";

$sql_get_contact = "SELECT * FROM contacts
WHERE number LIKE '%$the_thread%'
LIMIT 1";

But, I feel that this is horribly inefficient, and it doesn't work right... I only ever get a single call dumped.  What am I doing wrong?

I have an array which will be below. The array is being built from an XML file, the problem is I need to extrapolate data from it.   I am having trouble with looping through the array properly.   The output should be something like this:   Beth's state is 0   (Where Beth's is the name and 0 is the state) Clint's state is 0

Array
(
    [0] => Array
        (
            [did] => 216616014153767704
            [known] => 1
            [lock] => 0
            [state] => 0
            [level] => 100
            [node] => 30
            [port] => 0
            [nodetype] => 16386
            [name] => Beth's
            [desc] => LED
            [colorid] => 1
            [type] => multilevel
            [rangemin] => 0
            [rangemax] => 99
            [power] => 0
            [poweravg] => 0
            [energy] => 0
            [score] => 0
            [productid] => 1
            [prodbrand] => TCP
            [prodmodel] => LED A19 11W
            [prodtype] => LED
            [prodtypeid] => 78
            [classid] => 2
            [class] => 
            [subclassid] => 1
            [subclass] => 
            [other] => 
        )

    [1] => Array
        (
            [did] => 216616014154116936
            [known] => 1
            [lock] => 0
            [state] => 0
            [level] => 100
            [node] => 30
            [port] => 0
            [nodetype] => 16386
            [name] => Clint's
            [desc] => LED
            [colorid] => 1
            [type] => multilevel
            [rangemin] => 0
            [rangemax] => 99
            [power] => 0
            [poweravg] => 0
            [energy] => 0
            [score] => 0
            [productid] => 1
            [prodbrand] => TCP
            [prodmodel] => LED A19 11W
            [prodtype] => LED
            [prodtypeid] => 78
            [classid] => 2
            [class] => 
            [subclassid] => 1
            [subclass] => 
            [other] => 
        )

)