PHP - Reading A Multi Dimensional Array

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

The code below is showing "undefined" and "OBJECT" errors   What am I doing wrong to build this multi-dimensional array?     And why can't I paste it to this page???????????????????????

I am validating a form, and if there are errors in the input, the error array is filled with appropriate mssg and the "sticky" form with right values is shown back, and errors on top.

Example:
first name, last name, email, date of birth.
each field is validated,and if  for example first name does not pass,i will nullify the value and populate error array like below:
$_SESSSION['error']['fname']="Please check the format of the name,can contain only alphabets!"
$_SESSSION['error']['email']="Please check the format of email!"

When I slap back the form, last name has passed, and so will have the previously entered value, but first name and email will be empty, and i need to know how to display the 2 errors on top of the form.
It uses post method, and posts to itself.

I have an Array and I am attempting to figure out how I can sort it by date.

Example of Said Array:
Code: [Select]
Array
(
    [0] => Array
        (
            [userComments0] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-01 23:51:43
                    [currentUserFromGroup] => MEMBER_ONE
                    [body] => We should all wear wooden clogs on Fridays. Who's with me? Huh? Anyone?
                )

        )

    [1] => Array
        (
            [userComments1] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-09 18:20:51
                    [currentUserFromGroup] => MEMBER_ONE
                    [body] => Test
                )

        )

    [2] => Array
        (
            [userComments2] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-11 21:02:23
                    [currentUserFromGroup] => MEMBER_ONE
                    [body] => TEst
                )

        )

    [3] => Array
        (
            [userComments3] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-12 17:02:31
                    [currentUserFromGroup] => MEMBER_ONE
                    [body] => Posting a new idea
                )

        )

    [4] => Array
        (
            [userComments4] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-13 23:32:19
                    [currentUserFromGroup] => MEMBER_ONE
                    [body] => Test Idea
                )

        )

    [5] => Array
        (
            [userComments5] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-10 01:50:34
                    [currentUserFromGroup] => MEMBER_TWO
                    [body] => Taco sauce is as good as French Toast!
                )

        )

    [6] => Array
        (
            [userComments6] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-10 01:51:03
                    [currentUserFromGroup] => MEMBER_TWO
                    [body] => Need to hire more engineers!
                )

        )

    [7] => Array
        (
            [userComments7] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-10 01:51:42
                    [currentUserFromGroup] => MEMBER_TWO
                    [body] => Golden Bears are all washed up
                )

        )

    [8] => Array
        (
            [userComments8] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-12 00:13:14
                    [currentUserFromGroup] => MEMBER_TWO
                    [body] => The JETS are going to kick ass!
                )

        )

    [9] => Array
        (
            [userComments9] => Array
                (
                    [bodyType] => 0
                    [created] => 2011-02-14 02:23:47
                    [currentUserFromGroup] => MEMBER_TWO
                    [body] => We are getting there!
                )

        )

)

But I have stumped myself on it, and cant wrap my mind around getting it sorted by datetime. I don't know where I should begin on this one fellas.

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?

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)

I have four different arrays and I want to place them into a multi dimensional array and
then I want to place it into a Session variable. This is what I have below.How do I do this?

when I print_r($_Session) I don't get anything just option[](2);


Code: [Select]

$_SESSION ['option']['green'] = array('name '=>'jeff');
$_SESSION ['option']['red'] = array('name '=>'mary');
$_SESSION ['option']['blue'] = array('name '=>'joe');
$_SESSION ['option']['brown'] = array('name '=>'ash');

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!

Hi guys,
I'm still stuck on making this multi-level drop down menu, so I figure that I'll listen to how you guys would do it. I don't necessarily need any code, but just ideas on how to code it.

Basically, I need it to store each item in a database.
It needs to:
be accessed, processed, and formatted with PHP end up returning either a multi-dimensional array, or the raw HTML. Examples: Code: [Select]
<?php
array(
  array(
    'label'=>'Test',
    'link'=>'index.php?r=test',
    'sort'=>0,
    'children'=>array(--blah blah blah--)
  ),
  array(--blah blah blah--)
); Code: [Select]
<div id="menu">
 <ul>
 <li><a href="index.php?r=test"><h2>Test</h2></a>
 <ul>
 <li><a href="blah">Blah</a>
 <ul>
 <li><a href="blah">Blah</a></li>
 </ul>
 </li>
 </ul>
 </li>
 </ul>
</div>
That's pretty much it. If you have any ideas or suggestions, please feel free to help me out. Thank you guys!

Does anyone know of a way I can natsort a multi-dimension array by a value nested in the array 2 keys deep?


I.e.




array(
   'test1' => array(
      'location' => '123 fake street',
      'time'     => 120
),
'test2' => array(
      'location' => '123 elm street',
      'time'     => 34
),
'test3' => array(
      'location' => '123 php street',
      'time'     => 133
)
);
// would become
array(
'test2' => array(
      'location' => '123 elm street',
      'time'     => 34
),
   'test1' => array(
      'location' => '123 fake street',
      'time'     => 120
),
'test3' => array(
      'location' => '123 php street',
      'time'     => 133
)
);



thanks for any help

Hello!   First of all, I'm new here. I've been working with PHP for a few months and am really enjoying its capabilities   A little background on the project I'm doing at the mo, I'm creating a small dashboard for grabbing Twitter stats via the API. The result will eventually output in a pretty table showing the daily followers, follower gains (or losses) etc. Here's an example of the table I eventually want to end up with.   So far I have two arrays of data:   $accounts_data is a list of all account names and their associated ID's $followers_data is a list of all follower counts, for a specific time of day, with an associated account ID (which matches the ID found in $accounts_data, thus pairing the follower count to a specific account)   I'm now trying to combine these two arrays into something more sensible that can then be used to output the table as shown in the link above.   $accounts_data:

array(4) {
  [0]=> array(2) {
    ["id"]=> string(4) "1279"
    ["name"]=> string(13) "AccountName1"
  }
  [1]=> array(2) {
    ["id"]=> string(4) "1280"
    ["name"]=> string(10) "AccountName2"
  }
  [2]=> array(2) {
    ["id"]=> string(4) "1281"
    ["name"]=> string(12) "AccountName3"
  }
  [3]=> array(2) {
    ["id"]=> string(4) "1283"
    ["name"]=> string(11) "AccountName4"
  }
}

$followers_data (truncated this data)  

array(12) {
  [0]=>
  array(3) {
    ["account_id"]=> string(4) "1279"
    ["date_time"]=> string(19) "2014-11-14 09:00:03"
    ["followers"]=> string(4) "1567"
  }
  [1]=>
  array(3) {
    ["account_id"]=> string(4) "1280"
    ["date_time"]=> string(19) "2014-11-14 09:00:29"
    ["followers"]=> string(4) "7688"
  }
  [4]=>
  array(3) {
    ["account_id"]=>
    string(4) "1279"
    ["date_time"]=>
    string(19) "2014-11-14 16:30:35"
    ["followers"]=>
    string(4) "1566"
  }
}

I have a stdClass Object Multi Dimensional Array that I need to dissassemble into variables but dont know how to pull the data. The array looks like this:
Code: [Select]
stdClass Object ( [results] => Array ( [0] => stdClass Object ( [address_components] => Array ( [0] => stdClass Object ( [long_name] => 1600 [short_name] => 1600 [types] => Array ( [0] => street_number ) ) [1] => stdClass Object ( [long_name] => Pennsylvania Ave NW [short_name] => Pennsylvania Ave NW [types] => Array ( [0] => route ) ) [2] => stdClass Object ( [long_name] => Northwest Washington [short_name] => Northwest Washington [types] => Array ( [0] => neighborhood [1] => political ) ) [3] => stdClass Object ( [long_name] => Washington [short_name] => Washington [types] => Array ( [0] => locality [1] => political ) ) [4] => stdClass Object ( [long_name] => District of Columbia [short_name] => DC [types] => Array ( [0] => administrative_area_level_1 [1] => political ) ) [5] => stdClass Object ( [long_name] => United States [short_name] => US [types] => Array ( [0] => country [1] => political ) ) [6] => stdClass Object ( [long_name] => 20500 [short_name] => 20500 [types] => Array ( [0] => postal_code ) ) ) [formatted_address] => 1600 Pennsylvania Ave NW, Washington, DC 20500, USA [geometry] => stdClass Object ( [location] => stdClass Object ( [lat] => 38.8987149 [lng] => -77.0376555 ) [location_type] => ROOFTOP [viewport] => stdClass Object ( [northeast] => stdClass Object ( [lat] => 38.900063880291 [lng] => -77.036306519708 ) [southwest] => stdClass Object ( [lat] => 38.897365919709 [lng] => -77.039004480291 ) ) ) [partial_match] => 1 [types] => Array ( [0] => street_address ) ) ) [status] => OK )
Really I need to start with pulling the lat and lng from the location. No clue how to get to this data.

Hello I have this multi dimensional array which needs to be inserted to the database table.

[business] => Array
        (
            [title] => Email Marketing
            [URL] => email-marketing
            [category] => 3
            [region] => 2
        )

    [description_] => Array
        (
            [text] => Some desc
        )
    [logo_] => Array
        (
            [blob] => mainlogo.png
        )

    [location_] => Array
        (
            [text] => Array
                (
                    [0] => Lemara Main Office
                    [1] => Themi branch
                    [2] => Sinoni branch
                )
            [priority] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                )

        )

    [photo_] => Array
        (
            [path] => Array
                (
                    [0] => lemaraphoto.png
                    [1] => themiphoto.png
                    [2] => sinoniphoto.png
                )
        )
    [video_] => Array
        (
            [path] => Array
                (
                    [0] => lemaravideo.mp4
                    [1] => themivideo.mp4
                    [2] => sinonivideo.mp4
                )

        )

    [product_] => Array
        (
            [p_id] => Array
                (
                    [0] => product photo
                    [1] => product 3 photo
                    [2] => Product 2 photo
                )
            [text] => Array
                (
                    [0] => product desc
                    [1] => product 3 desc
                    [2] => product 2 desc
                )

            [expire] => Array
                (
                    [0] => product expire
                    [1] => product 3 expire
                    [2] => Product 2 expire
                )
            [title] => Array
                (
                    [0] => product
                    [1] => Product 3
                    [2] => Product 2
                )

        )

    [service_] => Array
        (
            [p_id] => Array
                (
                    [0] => Service 2 photo
                    [1] => service 3 photo
                    [2] => service photo
                )
            [text] => Array
                (
                    [0] => service 2 desc
                    [1] => service 3 desc
                    [2] => service desc
                )

            [expire] => Array
                (
                    [0] => Service 2 expire
                    [1] => service 3 expire
                    [2] => service expire
                )
            [title] => Array
                (
                    [0] => Service 2
                    [1] => service 3
                    [2] => service
                )

        )

)

That's the data. The database table, the table field and the corresponding value to be inserted in to the database. I'm using CodeIgniter any help would be appreciated.  I have managed to make it wotk in this format

[[business] => Array
        (
            [title] => Email Marketing
            [URL] => email-marketing
            [category] => 3
            [region] => 2
        )

    [description_] => Array
        (
            [text] => Some desc
        )
    [logo_] => Array
        (
            [blob] => mainlogo.png
        )
]

I used this code to do it

function add_bz($data){
  $this->db->trans_start(); $er=0;
  foreach($data as $table => $sql){
   if($table==="business"){
    $this->db->insert($table, $sql);
    $id = $this->db->insert_id();
   } else {
   array_merge($sql, array('idd' => $id));
   $this->db->insert($table, $sql);}
  }
  $this->db->trans_complete();
  if ($this->db->trans_status() === FALSE){print "Transaction Fails";return FALSE;}
  return TRUE;
}

Thanks in advance.

I have a Q&A Form/script where registered Users can share there thoughts on 10 Questions.

On the backend I have these tables:  member, answer, question

Thanks to some help last night, I have been able to do a LEFT join and store the above data in a multi-dimensional array which always stoes the 10 Questions, and also any Answers that the User may have responded to.  (Questions are optional.)

I am having a hell of a time DISPLAYING this multi-dimensional array.

The key is that I want my PHP and array to stay at the top of my script and use minimal PHP in my HTML section.

Here is how I query the data and build my array...

// ********************
// Build Q&A Query. *
// ********************

// Build query.
$q7 = "SELECT q.id, q.question_no, q.question_text, a.answer_text
FROM bio_question AS q
LEFT JOIN bio_answer AS a
ON q.id=a.question_id
AND a.member_id =?
ORDER BY q.question_no";

// Prepare statement.
$stmt7 = mysqli_prepare($dbc, $q7);

// Bind variables to query.
mysqli_stmt_bind_param($stmt7, 'i', $memberID);

// Execute query.
mysqli_stmt_execute($stmt7);

// Store results.
mysqli_stmt_store_result($stmt7);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt7) > 0){
// Questions Found.

// Bind result-set to variable.
mysqli_stmt_bind_result($stmt7, $questionID, $questionNo, $questionText, $answerText);

// Populate PHP array with Questions & Answers.
$x=1;
while (mysqli_stmt_fetch($stmt7)){
$thoughtsArray[$x] = array('questionID' => $questionID,
'questionText' => $questionText,
'answerText' => $answerText);
$x=$x+1;
}

echo '<pre>';
print_r($thoughtsArray);
echo '</pre>';


// Close prepared statement.
mysqli_stmt_close($stmt7);



And in my HTML Form, here is how I am attempting to dynamically build the Q&A section...

<form id="changeAnswers" action="" method="post">
<fieldset>
<legend>Change Profile Answers</legend>

<?php
echo '<p>TEST: ' . $thoughtsArray[4]['answerText'] . '</p>';

foreach($thoughtsArray as $questionNo => $qaArray) {
echo '<label for="question' . $questionNo . '">' . $questionNo . '.) ' . $qaArray['questionText'] . '</label>';
echo '<textarea id="question' . $questionNo . '" name="thoughtsArray[' . $questionNo . '][\'answerText\']" cols="60" rows="2">' .
(isset($questionNo]) ? "htmlentities($thoughtsArray[$questionNo]['answerText'], ENT_QUOTES" : '') .
'</textarea>';
}
?>



I am able to retrieve and display the Questions from my multi-dimensional array as seen above, however, for the life of me, I cannot get the Input Fields (with any Answers) to work properly.  I either get compile errors, or the code runs but my Input Fields are blank even when an Answer should be displayed?!

 

I am hoping this is just a syntax and/or reference error.  I'm still new to arrays, so properly retrieving an Answer from a multi-dimensional array is really tricky for me!!

So close and yet so far away?!

Can someone please help me out??

Thanks,


Debbie

HI ! I have a table which captures how customers came to be customer ie 'advertisement', 'friend' etc etc.

So I want to be able to show / count that N number came from referral or advertisement.

My query is simple, I select all from the Media column.

This gives me a multi-dimensional array, where each table row, becomes a new sub array. I have 3000 customers ... that's a quite a few sub arrays ! So, a sample print_r of the array looks like this:

Code: [Select]
Array
(
    [0] => Array
        (
            [media] => friend
        )

    [1] => Array
        (
            [media] => friend
        )

    [2] => Array
        (
            [media] => friend
        )

    [3] => Array
        (
            [media] => Coming Over From Old Site


I have tried using a couple of array functions such as count(array,1) and (array_count_values($media)) but they both don't count the individual values out of the sub arrays.

I'm a bit stuck - Can anyone help me ?

Many Many Thanks !!