Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    PHP


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Pushing Data Into A Multi-dimensional Array From Mysql Results


First, A result array I'd want to get could look like this:

$chart['chart_data'] = array (
array ( "Region A", 10,12,11,15,20,22,21,25,31,32,),
);

The first is "Region A" and the rest is just int's that I'd pull from the db, so to set it I'd do this:

$chart [ 'chart_data' ][ 0 ][ 0 ] = "Region A";

But the problem is when I want to insert the data in the while loop (like the 10,12,11,15...), I've tried array_push but it's not working, maybe it doesn't work with multi-dimensional arrays? Anyways, here.'s what I tried, the following inside the "while" to loop the mysql results with mysql_fetch_assoc:

while($r=mysql_fetch_assoc($res)) {
   
     $chart [ 'chart_data' ][ 0 ][ 0 ] = array_push($chart['chart_data'][0][0], $r['wght']);
     // the above line is where I have problems    ^^
}

What I want is on each loop to insert the fetched data inside the array so that it gives what I gave first at the top, but what I've written above doesn't work, it gives me a warning saying "first argument must be an array" which seems to be one, but anyway, anybody know how to do this?




View Complete Forum Thread with Replies

Related Forum Messages:
Processing Data From Multiple Multi-line Textareas Into A Multi-dimensional Array
I know that this sounds like something overly complex - because it is.
However, if I can keep the user interface the way it is, my users will
be ultra happy! That is the goal...

In general, this is an inventory receiving piece of an overall larger
web-based ERP system.

What I have is a form in which I have a dynamic number of multline
textareas for inputting (possibly barcode scanning in) many serial
numbers per line item recieved.

For example:
lineitem01 = widget01; qtyReceived = 2;
lineitem02 = widget02; qtyReceived = 3;
lineitem03 = widget03; qtyReceived = 10;

This would display a form that will generate 3 textarea elements (1
per lineitem received). Inside each textarea element will be input the
serial numbers for each of the widgets received per lineitem. i.e. 2
serial numbers will be entered for widget01; 3 for widget02; and 10
for widget03;

So, what I am trying to do is pass this data over, possibly as a multi-
dimensional array to another form ( or possibly $_SERVER['PHP_SELF'] ) to update a MySQL database to store the widget/serial numbers.

View Replies !
Multi-Dimensional Array - Get The Data In An Orderly Fashion From A DB
I am new to MD arrays and especially when trying to get the data in an orderly fashion from a DB with this. I need to retrieve the data into an array for my function as such

PHP Code:

$answer = array();
$answer[1] = array("A" => "Because a pencil is cheap", "B" => "Because everyone uses a pencil");
$answer[2] = array("A" => "Mining", "B" => "Logging");

View Replies !
MySQL Query Into Multi-dimensional Array
Basicly, What im trying to do is have it so I have a multi-dimensional array so like the first "Dimension" is the row and the second "Dimension" is the collumn. Code:

View Replies !
Making Mysql Result Into Multi-dimensional Array
My php problem is I want to make the result of 3 tables linked through foreign keys into a 3-dimensional array that reflects their relationship without repetition and without having to call the database more three times.

I know I'm doing a couple of things wrong, one thing for instance is initializing a variable at the end of the loop to remember the previous value s that it does not repeat itself, surely there must be a more elegant way to go about this, but I'm lost and I've been stuck on this all day. Code:

View Replies !
Multi Sorting Multi Dimensional Array?
I have been using usort to sort my multi dimensional arrays ...

function cmp($a, $b){
if($a[0] == $b[0]){
return 0;
}
return ($a[0] < $b[0]) ? -1 : 1;
}
usort($searchResults, 'cmp');

Which works fine, but I need to sort by one element in the array, then
another, preserving the previous sort.

lets say the array is as follows:

array[0] = array[0] = foo
[1] = 2
[1] = array[0] = foo
[1] = 0
[2] = array[0] = bar
[1] = 1
[3] = array[0] = bar
[1] = 0
[4] = array[0] = foo
[1] = 1
[5] = array[0] = bar
[1] = 2

Initially, I sort the array in to groups based on array[?][0] using
usort as above so the output is :

foo, 2
foo, 0
foo, 1
bar, 1
bar, 2
bar, 0

Next though, I would like to sort this output by number (array[?][1])
in the groups so that the output is :

foo, 0
foo, 1
foo, 2
bar, 0
bar, 1
bar, 2

Is this possible? I am completely at a loss as to how to do this ...

View Replies !
Assigning A Multi-dimensional Array To & From A Session Variable Loses The Array
I have created a multidimensional array and then assigned that array to a session variable so that I can use it easily on another page.  However, when I go to the array later, there's never anything in it. Code:

View Replies !
Does Php Have A Multi Dimensional Array?
Does php have a multi dimensional array?

So eg. $someData[i][j]

View Replies !
Multi-dimensional Array
I have a function that loops through email addresses and checking them to see if they are valid. if the email address is valid i want to add it to the $validEmails array, and if its invalid i want to add it to the $invalidEmails array. BUT, in order to return this data from a function it will need to be a multi-dimensional array.

View Replies !
Multi Dimensional Array
Here is my array. PHP Code:

$playerarray = Array ( [0] => Array ( [Player1] => jimmydee2 [Reg] => 1 [Rank] => 3 [Rating] => 1490 [Checkedin] => Checked In [Wins] => 0 [Losses] => 0 ) [1] => Array ( [Player1] => bob2 [Reg] => 2 [Rank] => 1 [Rating] => 1738 [Checkedin] => Checked In [Wins] => 0 [Losses] => 0 ) )

View Replies !
Sorting Multi-dimensional Array
Sorting multi-dimensional array

I have this array:

Array
(
[0] => Array
(
[account] => 263
[counter] => 1
)

[1] => Array
(
[account] => 324
[counter] => 5
)

[2] => Array
(
[account] => 972
[counter] => 3
)

[3] => Array
(
[account] => 1316
[counter] => 3
)

[4] => Array
(
[account] => 1380
[counter] => 1
)

[5] => Array
(
[account] => 1880
[counter] => 2
)
)

I need to sort by the key [counter], how can I do that?

View Replies !
Multi-dimensional Array For Checkbox
Can there be a multi-dimensional array for checkboxes?

View Replies !
How Can I Sort A Multi-dimensional Array?
How can I sort a multi-dimensional array?

For instance:
a[Name], a[adress], a[number of messages].

How to sort on the item of number of messages?

View Replies !
Multi-Dimensional Array Question
Can you have a multi-dimensional array like this?

$Test[0]['Fname'] = "John";
$Test[0]['Lname'] = "Doe";

Or do you have to use only numbers?

View Replies !
Building Multi Dimensional Array
I am trying to build a multi dimensional array from an unsorted array. I have an array made up of the lines in a text file, each line is a comma seperated set of fields. The first two fields are the lines id and it's parents id; eg Line ID, Parent ID, Data

1, 1 , one
2, 2, two
3, 3, three
4, 1, four
5, 4, five
6, 1, six
7, 2, seven

I am trying to build a multi dimensional array so that the final array would look like;

-- one
---- four
------ five
---- six
-- two
---- seven

View Replies !
Make A Multi-dimensional Array
I am trying to make a multi-dimensional array. I am having trouble adding to the array. What I mean by that is using the array_push() function. Does anyone know how to add to a multi-dimesional array?Ex.

$somearray = array("1" => array("This is one"));

#The line above works. how can I add

"2" = > array("This is two");

View Replies !
Sessions And A Multi-dimensional Array
I'm writing a shopping cart w/ Sessions and a multi-dimensional array. I am only storing product id and qty (for right now, but decided on the multi-dimensional array for expansion purposes - storing customer instructions, etc.) I have come up with two paths, but can't decide which is better.

1. storing info based on product id:
...[cart][$prod_id] = array("qty" => $qty)

This, of course would allow for easy product checks: if ([cart][$prod_id]) {...}, but unless I store the $prod_id in the prod_id array as well, I'd be forced to use foreach(array_expression as $key => $value) when displaying the cart (as I also want the product id displayed next to the product name)

2. storing info based on item number:
...[cart][] = array("id" => $prod_id, "qty" => $qty)

This makes for more code when checking if the product is already in the cart (multiple foreach statements), but should allow the cart to be displayed more easily and logical.

View Replies !
Printing From A Multi-dimensional Array
I have to create a multidimensional array that data for a bank will be stored in then from that array I will print it. My boss said to first program it like i am recieving the array. Then later he will have me create the array.

Order multidimensional Array I will recieve will be arranged in and the printed like this. Code:

View Replies !
Multi-dimensional Array Sorting
I need some help sorting an array, same in structure as:

Array
(
    [assoc1] => Array
        (
            [key1] => value
            [key2] => value
            [key3] => value
        )

    [assoc2] => Array
        (
            [key1] => value
            [key2] => value
            [key3] => value
        ))

What I want to do is sort the array by the value in say the key2 "column". Depending on input, the value to sort by may be key3 or some other key. 

I've looked at array_multisort(), but I'm not sure how I can specify what exact column I want to sort by, without affecting the rest.

View Replies !
Sorting A Multi-Dimensional Array
I have an array that prints like this:

Array (
[dist] => Array (
[0] => 1.0
[1] => 0.2
[2] => 0.9
[3] => 1.0
)
[loc] => Array (
[0] => Dean Playground Park
[1] => Eckhart Park
[2] => Pulaski Park
[3] => Skinner Park
))

I would like to sort this array by DIST but have the keys match up, IE Code:

View Replies !
Create Multi Dimensional Array
$miles_zip = array();

foreach ($subzip as $key => $value) { //3

$miles = $z->get_distance( $zipCode, $key);

$miles_zip[$i] = $miles ;
$i++;
} //3

$count = count($miles_zip) ;

for ($i = 0; $i < $count; $i++)
echo " $miles_zip[$i]<br> ";

I am trying to put $key and $miles in a multi dimensional array. I have tried different ways, it is not working. All I see online is syntax of creating static multidimensional arrays. Can somebody guide me how can I create a dynamic one.

View Replies !
Multi Dimensional Array Sort
I am trying to sort a multi dimensional array. I need all elements of the first dimension sorted in descending order based on the fourth element of the second dimension. The elements are not named(only 0-X), but what i need is array[x][4] to be sorted.

View Replies !
Sort Multi-dimensional Array
does anyone know how i can sort a multi-dimensional array by a specific field ?

for example i want to sort arr[m][n] where n=2,

but i need the data of every array to follow that order. Code:

View Replies !
Sorting Multi Dimensional Array
I have a multi dimensional array which has gone out of whack and I need to sort it, but am having trouble. I have an array $dateOrders as such: Code:

View Replies !
Sort A Very Big Multi-dimensional Array
I'm trying to sort a very big multi-dimensional array, up to 10 dimensions and having a heck of a time getting it to work.

I've tried using usort , creating a compare function and strcmp, but it just ends up being an even bigger mess.

Maybe I am making it more complicated than it really is, or maybe it's just too complicated. Code:

View Replies !
Searching Through A Multi-dimensional Array
I'm trying to do some searching through an array, and append one of the pieces. I am working creating one, complete array w/ all the information from two different databases. So when I query each table, I create a multi-dimensional array like this: Code:

View Replies !
Invert Multi Dimensional Array
I have a form that runs through a database and outputs values like this: PHP Code:

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
echo '<input type="hidden" value="'.$order->products[$i]['qty'].'" name="qty[]">'
   echo '<input type="hidden" value="'.$order->products[$i]['name'].'" name="name[]">'
   echo '<input type="hidden" value="'.$order->products[$i]['final_price'].'" name="price[]">'
}

I need to rearrange the posted result, after submitting the form, so that I have an array containing "qty, name, price" for each line, instead of "qty, qty, qty, qty, qty" and "name, name.etc".

View Replies !
Finding Elements Of An Array In Another Multi-dimensional Array
So I have 2 arrays:
one contains userids. It may look like:
user_id[0] =12,
user_id[1] =30,
user_id[2] =43

The other is a multi-dimensional array with fields like:
user_info [0] = Array
(
[user_id] =13
[user_flag] =1
[url] =http://www.example.com?index,0
)
user_info[1] =Array
{
Array
(
[user_id] =120
[user_flag] =1
[address] =1234 Main St, Anytown, USA
[url] =http://www.yahoo.com
)
user_info[2] =Array
{
Array
(
[user_id] =130
[user_flag] =1
[address] =134 Main St, Anytown, USA
[url] =http://www.google.com
)

View Replies !
Multi-dimensional Array Not Working Correctly???
I know this is going to be something totally stupid that I just can't see. I have a two dimensional arrray. The first index is a 0 based incremented int, and the other index is either an 'l' or a 'w'. Look what's happening:

View Replies !
Multi-Dimensional Array - Using Array_search Or Array_keys
Let's say I have the following multidimensional array:

$foodtypes = array (
"Fruit" => array ("Apple", "Pear"),
"Vegetable" => array ("Lettuce", "Eggplant", "Pepper"),
"Meat" => array ("Beef", "Pork"));

Assuming that $food = 'Eggplant', How do I find what foodtype it belongs to? I know the following works, but I know there must be a better way to do this, like using array_search or array_keys. I can't get anything other the following to work though. Code:

View Replies !
Parsing All Multi-Dimensional Array Combinations
I am trying to build a dynamic table structure with multi-dimensional arrays. The first dimension is being pulled from the databse and can be refferred to as an attribute. The second dimension is also created on the fly by db, and can be reffered to as variations. I have tried using array_walk as well as using a recursive function that allows me to step through each of the various array combinations.

For example I may have 2 attributes; Color & Size. Color has 3 variations (Red, Green, Blue). Size has 4 varitions (Small, Medium Large, X-Large). Basically I am trying to build something like this:

Color Size
Red Small
Red Medium
Red Large
Red X-Large
Green Small
Green Medium
Green Large
Green X-Large
Blue Small
Blue Medium
Blue Large
Blue X-Large

The biggest problem with this, however, is that it needs to be dynamic enough that an attribute (like sleeve length: Short sleeve - Lon sleeve, etc...) can be added without changing the code.

View Replies !
Sorting An Associative Multi-Dimensional Array
I would like to sort array below using the last array of a multi-dimensional array. PHP Code:

View Replies !
Filtering The Elements Of A Multi-dimensional Array
I would like to be able to filter every element of a multi-dimensional array
using htmlspecialchars() and to retain the structure of the array. I can't
see how to do this when I don't know how many dimensions the array has.

View Replies !
Adding A Entry Into A Multi-dimensional Array
I make an SQL call to a DB and gather some info. In the following case, I have 2 elements in the array (HERO_ID #1 and #2) I then want to add a third element to to the array, but I just cant seem to grasp the concept. I always seemed to have trouble grasping the concept of arrays in programming classes for some reason. Code:

View Replies !
How To Declare A Global Multi Dimensional Array?
i cant figure this one out... this code declares a 1d array global. however i need a multid array to be global.... global $list_U001;

since i need a maximum of only 99 arrays...i could decklare those like that and construct the variable from counter ...but i dont know how to construct a "dynamic variable"....

global $list_U001;
global $list_U002;
global $list_U003;
etc...

for(i++)

$list_U00.'$i'.[]

View Replies !
Selecting 1 Field From A Multi-Dimensional Array
I want to know how do I select just 1 field from a Multi-Dimensional Array.
I know how to select all the fields, by using the following format:

<?php
foreach($fields as $key => $val){
echo $val;
}

But how can I do a similar thing, but to just select 1 specific field, not all of them?

View Replies !
Return All Possible Combinations For A Multi-dimensional Array
I need a function that will return all possible combinations for a multi-dimensional array. For example, PHP Code:

$elements = array();
$elements[] = array(11,12,13);
$elements[] = array(14,15,16);
$elements[] = array(17,18,19);

I need the function to return an array that looks this this: PHP Code:

$arrReturn = array(
   0 => array(11,14,17),
   1 => array(11,14,18),
   2 => array(11,14,19),
   3 => array(11,15,17),
   4 => array(11,15,18) ... etc

View Replies !
Populating Multi Dimensional Array From Queries
I am trying to populate a multidimensional array with a simple (categories > sub_categories) I get the categories into the array just fine but I can't figure out how to populate the sub_categories as array belonging to the first categories array; I am close. Code:

View Replies !
Multi-dimensional Array: Order Does Matter?
I have a multi-dimensional array (stored in a cookie) containing the sort values for different categories: Code:

View Replies !
Multi-dimensional Arrays - Use Foreach() To Access The Data?
If I have a 2-dimensional array where the top key is year numbers (e.g. "2003"), the second key is month numbers (e.g. "8" to represent August), and the data stored is some cardinal number, how can I use foreach() (or anything else) to access the data?
I want to write one line of HTML for each year, along the lines of:

2003 [ 8(23) ]

assuming that 23 would be the cardinal number stored at $array[2003][8].
I s'pose what I'm trying to do is use the key, which is an array, as a string to print out. Or maybe I'm just confused? PHP Code:

View Replies !
Turn Array Into Multi-dimensional Array?
How can I take an existing array and turn it into a multi-dimensional array? I want to get a single row out of a MySQL table and have it in an array, but have along side the values the true field (column) length for each of the fields from the table. Here's my stab at it:

$userDetails = mysql_fetch_array($resultID);
$i = 0;
while ($i < mysql_num_fields($resultID))
{
    $userDetails[$i][2] = mysql_field_len($resultID, $i);
    $i++;
}

And I guess the follow up question (if this is indeed possible) is will this work with a multi-row return from the DB also?

View Replies !
Encoding / Decoding Multi Dimensional Session Array
Can you encode and decode multi-dimensional arrays? I think encoding them works just fine using session_encode(), however, session_decode is only capable of decoding the single dimensional arrays stored in the encoded string...

View Replies !
Multi-dimensional Array Search/replace Function
I am trying to write a search/replace function to go through a multi-dimensional array. Code:

View Replies !
Cannot Change Values Of A Multi-dimensional Session Array
Big problem I've been struggling with for almost 2 days:

I'm trying to build a "blind" validation routine that will take any kind of form elements and validate them for empty as well as varying content. This routine is called on submit and is based upon data stored in a number of multi-dimensional $_Session arrays like this: Code:

View Replies !
Multi-Dimensional Arrays - Arrray That Holds An Array Of 2 Different Id Numbers
okay, i need to make a arrray that holds an array of 2 different id numbers, $catagory_id and $subcatagor_id are both variables inside a loop that take on a different number each loop. I want to put those number inside an array, each one being it's on array, but I need those numbers to be inside another array that I can call to find another array that will be inside that same array: sounds confusing, but basically, I have a table with ID's each id is assigned a catagory and and a sub catagory, each id is unique but there could be multiple id's under the same sub_cat and cat. So, i need the array to be set up so that I could call all id's that have a certain cat and subcat number:

echo ("$idnumber[$cat_id][$subcat_id]");

something like that, can anyone help?

View Replies !
Multi-Dimensional Array - Using NuSoap To Make A WSDL Request
I am using NuSoap to make a WSDL request to a server (that I don't own). Code:

View Replies !
Trouble Getting The Sort Function For Arrays To Work Correctly On My Multi-dimensional Array.
I am having trouble getting the sort function for arrays to work correctly on my multi-dimensional array.

array[0][]=&#391;'
array[1][]='bob'
array[2][]='age'

array[0][]=&#395;'
array[1][]='bill'
array[2][]='age'

I then do sort($array[0]) But only array[0][] gets sorted, the names do not follow. Does anyone see any error on my part or have a clue for me to follow to solve this?

View Replies !
"Array To String Conversion" Error When Constructing A Multi-dimensional Array
I'm a bit stumped as I am getting a "Notice: Array to String
Conversion" error when trying to do something that on the surface
should be a very simple task - create an array, and write a set of
values to them based on data submitted from POST Fields.

Code below:

$_SESSION["increment"] = array();
$x = 0 // Counter - This will be
incremented

$_SESSION["increment"][$x] = array("increment_bond" =>
$_POST["increment_bond"],
"increment_amount" = $_POST["increment_amount"],
"increment_comm_date1" = $_POST["increment_comm_date1"],
"increment_comm_date2" =$_POST["increment_comm_date2"],
"increment_comm_date3" = $_POST["increment_comm_date3"]);

It keeps throwing out that error, and does not write any of the POST
Values to the array (the POST values are definitely getting sent, so
that is not the problem).

If I dump out the value of $_SESSION["increment"], I get "1A" ?!?

I'm sure that there is a pretty simple mistake lurking somewhere - I
just can't seem to figure it out.

View Replies !
Getting Data Out Of Three Dimensional Array
I want to extract data from 3-dimensional array into one dimensional array here's example of two arrays that i add into one: PHP Code:

View Replies !
'Pushing' Data Down Thru A Table?
Each section asks for the basics: Employer name, address, supervisor, etc., etc. But, let's say Johnny goes in and fills it out. He has his most recent employer and three others.

Months go by, and Johnny wants to update his app and he's got a new 'recent employer'. I'd like to be able to "push" the data down in the table. One table for all six employers.

When Johnny gets six past employers, I want him to be able to go in, add a new most recent employer, and the "seventh" one disappear from the table. Maximum six. I don't want applicants to have to re-type each one. Code:

View Replies !
Pushing Elements On Array With Indices
I try to push elements on an array but without succes. I have a for loop and
need to do something like this array_push ($doelpunten, "$myrow[0]" =>
"$myrowDoelpunten[0]"); where myrow[0] is de indice and $myrowDoelpunten[0]
the value. $doelpunten is the array Someone can help me out?

View Replies !
Multi-dimensional
Is there a limit on how many variables a multi-dimensional array can hold? Can a multi-dimensional array hold 5000 values and above? I mean, is there an 'x' limit?

View Replies !
Multi-dimensional In Php3
Hi,
I was using php4 on my test area and setup a 3d array like below....

<input type="text" name="col[<?echo $i1; ?>][<?echo $i; ?>]" value="<?
/* if begin is yes then get input value from db */
if (($begin=="yes")| |($new_setnum == $setnum))
{
echo $row_payele[$item2];
}
/* else print current input box value */
else
{
echo trim($col[$i1][$i]);
}?>" maxlength="8" size="4">

then i reference the value in the same way...
$col[$i2][$i] etc..

This all worked fine on my own machine which is using php4. but when I go to the live server which is using php3 the variable is not picked up. Even if I try using $col[1][1] it doesn't work. Does anyone know why and a work around to it in php3??? Thanks in advance.

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved