PHP - Import A Csv To A 2 Dimensional Array

I am trying to store all the elements of my tree in an array.My code produces multi dimensional array, but i want it to be one dimensional. How can i get it ?

Code:-
Code: [Select]
function tree_gather($node)   //Function to calculate count
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
   
    if(!empty($array['lchild']) || !empty($array['rchild']))
    {
   
      $child[] = $array['lchild'];
      $child[] = $array['rchild'];
      $child[] = tree_gather($array['lchild']);
      $child[] = tree_gather($array['rchild']);
     
    }
     return $child;
  }
Result:-
Code: [Select]
Array
(
    [0] => 2
    [1] => 3
    [2] => Array
        (
            [0] => 4
            [1] => 5
            [2] => Array
                (
                    [0] => 10
                    [1] => 11
                    [2] =>
                    [3] =>
                )

            [3] => Array
                (
                    [0] => 8
                    [1] => 9
                    [2] =>
                    [3] =>
                )

        )

    [3] => Array
        (
            [0] => 7
            [1] => 6
            [2] => Array
                (
                    [0] => 15
                    [1] => 14
                    [2] => Array
                        (
                            [0] => 16
                            [1] => 17
                            [2] =>
                            [3] =>
                        )

                    [3] =>
                )

            [3] => Array
                (
                    [0] => 13
                    [1] => 12
                    [2] =>
                    [3] =>
                )

        )

)

Table: -

Hello all -

Currently I have functions that will parse a csv file and insert the values into a database.  That code is working.  However, I want to take it a step further and ONLY insert selected fields from the csv file.  For example, I have 14 rows in the csv and of those I only want to import values into the database of the rows that I define. 

So, gName, fName and id -> take those and pump those values into the database.  I'm sure this a possible but not sure of the direction I should take.  Any help on my problem would be excellent!

Here's the code:

Code: [Select]
csv_file_to_mysql_table('tim 3.csv', 'growers');

function csv_file_to_mysql_table($source_file, $target_table, $max_line_length = 10000)
{
    if (($handle = fopen("$source_file", "r")) !== FALSE) {
        $columns = fgetcsv($handle, $max_line_length, ",");
        foreach ($columns as &$column) {
            $column = str_replace(".", "", $column);
        }

        $insert_query_prefix = "INSERT INTO $target_table (" . join(",", $columns) . ")\nVALUES";
        while (($data = fgetcsv($handle, $max_line_length, ",")) !== FALSE) {

            while (count($data) < count($columns))

                array_push($data, NULL);

            $query = "$insert_query_prefix (" . join(",", quote_all_array($data)) . ");";
            mysql_query($query) or die(mysql_error());

        }

        fclose($handle);
    }
}

function quote_all_array($values)
{
    foreach ($values as $key => $value)
        if (is_array($value))
            $values[$key] = quote_all_array($value);
        else
            $values[$key] = quote_all($value);
    return $values;
}

function quote_all($value)
{
    if (is_null($value))
        return "NULL";

    $value = "'" . mysql_real_escape_string($value) . "'";
    return $value;
}
 

Here's some sample data:

Code: [Select]
Long,Lat,id,gName,fId,fName,fldId,fldName,fldAcers,featureID,objID,fInsu,fFSA,fBid
-82.38306422,40.38439870,2,Norris| Tim,3,Hallinan,4,H1 - 10.0,9.900,1,1, , ,29
-82.22279060,40.42760230,2,Norris| Tim,4,Holt,5,Ho1,11.50,1,1, , ,30
-82.21917211,40.42838107,2,Norris| Tim,4,Holt,6,Ho2,15.10,1,1, , ,31
-82.21710436,40.42454375,2,Norris| Tim,4,Holt,7,Ho3,17.90,1,1, , ,32
-82.21833571,40.42367314,2,Norris| Tim,4,Holt,7,Ho3,17.90,2,2, , ,32
-82.21595345,40.42200315,2,Norris| Tim,4,Holt,9,Ho4,9.100,1,1, , ,34
-82.36538195,40.37711617,2,Norris| Tim,5,Home,10,H1 - 36.3A,36.20,1,1, , ,35
-82.36159625,40.37804250,2,Norris| Tim,5,Home,11,H2 - 3.9A,3.900,1,1, , ,36
-82.36196265,40.38085335,2,Norris| Tim,5,Home,12,H3 - 6A,7.000,1,1, , ,37
-82.41030962,40.38997625,2,Norris| Tim,2,Kenyon,13,K10-17A,17.00,1,1, , ,38
-82.38584288,40.35998635,2,Norris| Tim,2,Kenyon,14,K11-14A,14.52,1,1, , ,39
-82.41644710,40.37927258,2,Norris| Tim,2,Kenyon,15,K3 - 18.2A,18.20,1,1, , ,40
-82.40744700,40.37788250,2,Norris| Tim,2,Kenyon,16,K4 - 26.2A,26.12,1,1, , ,41
-82.40390048,40.37467350,2,Norris| Tim,2,Kenyon,17,K5 - 8.9A,8.874,1,1, , ,42
-82.38605720,40.36920760,2,Norris| Tim,2,Kenyon,18,K6 - 19.3A,18.22,1,1, , ,43
-82.39960597,40.38844915,2,Norris| Tim,2,Kenyon,19,K7 - 18.4A,18.37,1,1, , ,44
-82.39515150,40.39498212,2,Norris| Tim,2,Kenyon,20,K8 - 7.3A,7.324,1,1, , ,45
-82.38817795,40.39458225,2,Norris| Tim,2,Kenyon,21,K9 - 40.4A,40.28,1,1, , ,46
-82.38836722,40.39172487,2,Norris| Tim,2,Kenyon,21,K9 - 40.4A,40.28,2,2, , ,46
-82.40294059,40.35565598,2,Norris| Tim,10,Lane,2,1,6.900,1,1, , ,47
-82.40579843,40.35399913,2,Norris| Tim,10,Lane,22,2,7.200,1,1, , ,48
-82.38322795,40.37619695,2,Norris| Tim,6,Leach,23,L1 - 1.5,1.500,1,1, , ,49
-82.38334655,40.38060737,2,Norris| Tim,6,Leach,24,L2 - 17.6,17.60,1,1, , ,50
-82.38032235,40.38354262,2,Norris| Tim,7,Robinson,25,R1 - 7.5,7.400,1,1, , ,51
-82.39919331,40.35353322,2,Norris| Tim,9,Shorey,26,SH1,5.757,1,1, , ,52
-82.40033216,40.35715336,2,Norris| Tim,9,Shorey,28,SH2,13.39,1,1, , ,54
-82.37072642,40.31789197,2,Norris| Tim,8,Stream,27,S1,17.80,1,1, , ,53

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?

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???????????????????????

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 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.

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 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] => 
        )

)

My tree gather function gives me multidimensional array. However i want it to be one dimensional . I was getting one dimensional earlier however i forgot how i got it. Can someone please tell me my mistake

Code
Code: [Select]
<?php
include'config.php';
 function tree_gather($node)   
  {
     
 $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']) || !empty($array['rchild']))
    {
   
      $child[] = $array['lchild'];
      $child[] = $array['rchild'];
      $eh[] = tree_gather($array['lchild']);
      $child = array_merge($child, $eh);
      $eh1[] = tree_gather($array['rchild']);  
      $child =   array_merge($child, $eh1);
     
    } 
     return $child;
  }
$pair = tree_gather(1000000);
echo "<pre>";
print_r($pair);
echo "</pre>";  
?> 
Output
Code: [Select]
Array
(
    [0] => 3632873
    [1] => 5951538
    [2] => Array
        (
            [0] => 8930480
            [1] => 7563232
            [2] => Array
                (
                    [0] => 1144744
                    [1] => 4386810
                    [2] =>
                    [3] =>
                )

            [3] =>
        )

    [3] =>
)

Hi - I have an array which is created from a session variable I must have constructed my array wrong, as for the life of me I can not extract the individual values.  I have tried innumerable $key=>$value combinations. I must be doing something stupid, maybe it is obvious, but not to me.   I'll be darn grateful if you can help me !  Many  Thanks


MY array looks like this:

Code: [Select]
Array
(
    [quantity] => Array
        (
            [0] => 1
            [1] => 1
            [2] => 1
            [3] => 1
            [4] => 1
        )

    [name] => Array
        (
            [0] =>  Ribs Large pack 20 pieces
            [1] => 25 Piece Bag
            [2] => Sirloin Steak
            [3] => 50 piece bag of Scalops
            [4] => Sirloin Steak
        )

    [prodid] => Array
        (
            [0] => 17
            [1] => 28
            [2] => 27
            [3] => 25
            [4] => 27
        )

)




The CodeIgniter form which generated this array looks like this:

Code: [Select]

 <?php foreach ( $_SESSION['openorders'] as $key=>$value) {  ?>
<tr align="center">
<td width="30"><?php $data=array('name' =>'quantity[]','value'=>$value['quantity']); echo form_input($data); ?></td>
<td><?php echo $value['prodid']; ?></td>
    <td><?php echo $value['name'];?></td>
    <td><?php echo $value['ordervalue']; ?></td>
<td><?php echo $value['pricelb']; ?></td>
<td align="right"><?php echo form_checkbox('delete','delete',FALSE);
echo form_hidden('prodid[]', $value['prodid']);
echo form_hidden('name[]', $value['name']);
echo form_hidden('orderid', $value['orderid']);
   $totalordervalue += $value['ordervalue'];
} ?>

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

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 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!

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!

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