PHP - Adding To A Multi Dimension Array

example structure of text database-  mytextfile.txt
10-11201|2010/09/01|Sam|Thurston
10-11307|2010/09/04|Tony|Piper
10-11405|2010/09/11|Sarah|Smith

<?php
$file2 = 'mytextfile.txt';

$openedfile =fopen($file2, "r") or die("ERROR- could not open file for editing.");
//
flock($openedfile, LOCK_EX) or die("Error!- Could not obtain exclusive lock on the file to edit.");
$hold[$record_count] = explode("|", trim(fgets($openedfile)));
 while(!feof($openedfile))
{
$record_count++;
$hold[$record_count] = explode("|", trim(fgets($openedfile)));
}
?>

What I need to do is loop through this and one by one- take any arrays that contain a date that is between $dateX and $dateY (which comes via a form input) and place it in a new array $matched.   I am stumped. 
1-Is there a way to do it inside the above while loop that I am not seeing?
2- Do I need to open the file in another manner? 
2- Would it be best to now loop through $hold[$record_count]

I am trying to keep the process short so as not to use up too much memory.  Point me in the right direction for this one please.

 

Hello,

I have the following function

function make_agent_drop($dropname,$parent=''){

$agents = mysql_query("SELECT * FROM ad_category WHERE cat_status='1'  AND parent_id='".(is_numeric($parent)?$parent:"0")."'") or die(mysql_error());

$anum = mysql_num_rows($agents);

if($anum>0){

$agentdrop='<select style="width:150px; height:20px; margin-left:100px; font-size:11px;" name="'.$dropname.'" id="'.$dropname.'" class="text" '.(is_numeric($parent)?'':'onchange="update_subcatdrop($(this).val());').'">

<option value="0">Select a Category</option>';

while($row= mysql_fetch_array($agents)){

$agentdrop.='<option value="'.$row['cat_id'].'">'.$row['cat_name'].'</option>';

}

$agentdrop.='</select>';

}else{

$agentdrop= 'No '.(is_numeric($parent)?'Sub':'').'Categories Found.';

} 

return $agentdrop;

 

;
}


I creates a drop down from database cats and sub cats..  I am trying to figure out how to add a submit button to dynamically appear when it displays the sub category...

Thanks!
Dan

I have a for loop which extracts info from a MySQL table, chooses something then needs to push each bit into an array:

for($i = 0 ; $i < $query_report_rows ; ++$i)
{
$row= mysql_fetch_row($query_names);
if($row[6] == 0)
{
$sName = $row[1];
}
elseif($row[6] == 1)
{
$sName = $row[2];
}

$name = "$row[0], $sName";
$print = nl2br($row[7]);
    }


What i need is a multidimensional array to hold $name and $print:

$name_print = array(
   array('name'=>$name
         'print'=>$print
   )
)


How do i array push into such an array from the above for loop? (multi-dimensional array are a very weak point at the moment, so any pointers here would be very much appreciated)

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 '['

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

How do I do this?

It only does the first nine records and wont cycle through the many records in the second dimension.

Thanks.

         // External Loop is 1 - 9
         // Internal Loop is 0 - whatever it is
   
         //$muarray_s[0]                        = $facility_id;
         //$muarray_d[$external_loop][$interal_loop]   = $objfields['139339_date'];
         //$muarray_t[$external_loop][$interal_loop]   = $objfields['139339_time'];
         //$muarray_i[$external_loop][$interal_loop]   = $objfields['139339_main_id'];
         
         //$array_of_mu[$external_loop][$interal_loop]    = $checklist_item_disc;
         
         echo "Begin Draw Runway Image Function <br>";
         echo "Establish Array Looping Procedure";
         
         for ($j=0; $j<10; $j=$j+1) {
               // External Loop
               // This is actually the Condition not the mu
               
               for ($k=0; $k<count($array_of_mu); $k=$k+1) {
                     // Internal Loop
                     // This is the Mu Value;
                     echo "Mu Value is ".$array_of_mu[$j][$k]."<br>";
               }
         }

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?

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?

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'];

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.

Whats the most efficient way of searching within a multi dimensional array?

My Array =

Array ( => Array ( => Item 1 [title] => Item 1 [1] => 2012-03-21 [eventDate] => 2012-03-21 [2] => 21 [eventDay] => 21 ) [1] => Array ( => Item 2 [title] => Item 2 [1] => 2012-03-21 [eventDate] => 2012-03-21 [2] => 21 [eventDay] => 21 ) )

String to find = '21'

If (MY ARRAY contains STRING TO FIND) {}

Clearly in this case there are several '21' (s) so if I only wanted to search the [eventDay] keys...would there be a fast effective and efficient manner?


Thoughts and help gratefully received.

Will

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 . "'')");
}

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

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 using a PHP framework someone built that allows for easier use of the Autotask ticketing/CRM system API. I have been able to navigate querying the database, but cannot seem to read through the data it returns. A var_dump of the results shows the following:

object(ATWS\AutotaskObjects\QueryResponse)[9]
  public 'queryResult' => 
    object(ATWS\AutotaskObjects\ATWSResponse)[10]
      public 'EntityResults' => 
        object(ATWS\AutotaskObjects\ArrayOfEntity)[11]
          public 'Entity' => 
            array (size=500)
              ...
      public 'EntityResultType' => string 'contact' (length=7)
      public 'EntityReturnInfoResults' => 
        object(ATWS\AutotaskObjects\ArrayOfEntityReturnInfo)[1028]
          public 'EntityReturnInfo' => 
            array (size=500)
              ...
          public 'Fields' => null
          public 'UserDefinedFields' => null
      public 'Errors' => 
        object(ATWS\AutotaskObjects\ArrayOfATWSError)[1027]
          public 'ATWSError' => null
          public 'Fields' => null
          public 'UserDefinedFields' => null
      public 'ReturnCode' => int 1

Can someone please give me guidance on how I can get to the data in this result. I'm trying to get my hands on the "EntityReturnInfo" data. A sample is as follows

 

Here is what a print_r returns


ATWS\AutotaskObjects\QueryResponse Object ( [queryResult] => ATWS\AutotaskObjects\ATWSResponse Object ( [EntityResults] => ATWS\AutotaskObjects\ArrayOfEntity Object ( 

**THIS IS WHERE THE GOOD DATA STARTS***

[Entity] => Array ( [0] => ATWS\AutotaskObjects\Contact Object ( [AccountID] => 174 [Active] => 1 [FirstName] => John [LastName] => Doe [AccountPhysicalLocationID] => [AdditionalAddressInformation] => [AddressLine] => 123 Fake Street [AddressLine1] => Suite 2 [AlternatePhone] => [BulkEmailOptOut] => [BulkEmailOptOutTime] => [City] => Fake City [Country] => United States [CountryID] => 237 [CreateDate] => 2016-09-28T10:17:57.34 [EMailAddress] => Fake@email.com [EMailAddress2] => [EMailAddress3] => [Extension] => [ExternalID] => [FacebookUrl] => [FaxNumber] => [LastActivityDate] => 2016-09-28T11:17:24 [LastModifiedDate] => 2016-09-28T11:17:24.68 [LinkedInUrl] => [MiddleInitial] => [MobilePhone] => [NamePrefix] => [NameSuffix] => [Note] => [Notification] => 1 [Phone] => 123-456-7890 [PrimaryContact] => [RoomNumber] => [SolicitationOptOut] => [SolicitationOptOutTime] => [State] => NY [SurveyOptOut] => [Title] => [TwitterUrl] => [ZipCode] => 12345 [Fields] => [UserDefinedFields] => ATWS\AutotaskObjects\ArrayOfUserDefinedField Object ( [UserDefinedField] => ) [id] => 30682885 ) 

***AND THE DATA CONTINUES WITH***

[1] => ATWS\AutotaskObjects\Contact Object ( [AccountID] => etc etc etc etc