12-27-2008
PHP arrays in arrays
PHP question...
I have an SQL query that's pulled back user IDs as a set of columns. Rather than IDs, I want to use their names.
So I have an array of columns $col with values 1,7,3,12 etc and I've got an array $person with values "Fred", "Bert", "Tom" etc
So what I want to do is display the $col value but the person's name, not the id...
ie
$person[$col[1]] should display "Fred"
$person[$col[3]] should display "Tom"
etc
However, this doesn't want to parse correctly and I get errors, with or without quotes. I've verified that $col[1] is 1 and $person[1] is "Fred", for example. What syntax is required?
Any help appreciated.
Jerry
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all,
How can i unset arrays. I mean all the subscripts including the array after using them.
Could you direct me to some links of array memory handling in the korn shell.
Thanks (2 Replies)
Discussion started by: earlysame55
2 Replies
2. Shell Programming and Scripting
PHP question...I posted this on the Web Development forum, but maybe this is a better place!
I have an SQL query that's pulled back user IDs as a set of columns. Rather than IDs, I want to use their names.
So I have an array of columns $col with values 1,7,3,12 etc and I've got an array $person... (3 Replies)
Discussion started by: JerryHone
3 Replies
3. UNIX for Dummies Questions & Answers
Hello,
I am some what of a newbie to awk scripting and I seem to be struggling with this problem.
I know I need to use arrays but I can't figure out how to use them.
I have an input file that looks like this;
Name,Team,First Test, Second Test, Third Test
Crystal,Red,5,17,22... (1 Reply)
Discussion started by: vlopez
1 Replies
4. Shell Programming and Scripting
Hi,
I need an elegant solotion in php. I need to compare 2 arrays (array1 & array2), to find all instances of array 2 which is not in array1.
I don't want to see any instances of array1 wich is not in array2 (here "the")
Array1: This, is, the, data, of, array1
Array2: this, is, data, Of,... (2 Replies)
Discussion started by: lowmaster
2 Replies
5. Shell Programming and Scripting
Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP.
I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
Discussion started by: lowmaster
0 Replies
6. Programming
if i declare both but don't input any variables what values will the int array and file pointer array have on default, and if i want to reset any of the elements of both arrays to default, should i just set it to 0 or NULL or what? (1 Reply)
Discussion started by: omega666
1 Replies
7. Shell Programming and Scripting
Hi all,
I have a file test1.txt with the below contents
abc
def
ghj
xyz
I tried printing these values using arrays.
Script tried :
===========
set -A array1 `cat test1.txt`
count=${#array1
}
i=0
while
do
echo "element of array $array1"
done (1 Reply)
Discussion started by: dnam9917
1 Replies
8. Programming
I'm not very good at associative arrays; and working on this PHP code has got me a bit stumped. My goal is to populate a (multidimensional) associative array in a PHP while look after a MySQL query. The code fragment looks like this:
while($campaign_row = mysql_fetch_array($campaigninfo))
{
... (9 Replies)
Discussion started by: Neo
9 Replies
9. Programming
I've noticed something interesting in C++ programming. I've always done tricky stuff with pointers and references to have functions deal with arrays. Doing exercises again out of a C++ book has shown me an easier way, I didn't even know was there. It's weird to me.
When dealing with arrays, it... (4 Replies)
Discussion started by: John Tate
4 Replies
10. Shell Programming and Scripting
I have never used arrays before but I have a script like this:
var1=$(for i in $(cat /tmp/jobs.021013);do $LIST -job $i -all |
perl -ne 'print /.*(\bInfo.bptm\(pid=\d{3,5}).*/' | tr -d "(Info=regpid" | tr -d ')'; $LIST -job $i -all |
cut -f7 -d','| sed -e "s/^\(*\)\(*\)\(*\)\(.*\)/\1... (2 Replies)
Discussion started by: newbie2010
2 Replies
COMPACT(3) 1 COMPACT(3)
compact - Create array containing variables and their values
SYNOPSIS
array compact (mixed $varname1, [mixed $...])
DESCRIPTION
Creates an array containing variables and their values.
For each of these, compact(3) looks for a variable with that name in the current symbol table and adds it to the output array such that
the variable name becomes the key and the contents of the variable become the value for that key. In short, it does the opposite of
extract(3).
Any strings that are not set will simply be skipped.
PARAMETERS
o $varname1
-compact(3) takes a variable number of parameters. Each parameter can be either a string containing the name of the variable, or
an array of variable names. The array can contain other arrays of variable names inside it; compact(3) handles it recursively.
RETURN VALUES
Returns the output array with all the variables added to it.
EXAMPLES
Example #1
compact(3) example
<?php
$city = "San Francisco";
$state = "CA";
$event = "SIGGRAPH";
$location_vars = array("city", "state");
$result = compact("event", "nothing_here", $location_vars);
print_r($result);
?>
The above example will output:
Array
(
[event] => SIGGRAPH
[city] => San Francisco
[state] => CA
)
NOTES
Note
Gotcha
Because variable variables may not be used with PHP's Superglobal arrays within functions, the Superglobal arrays may not be passed
into compact(3).
SEE ALSO
extract(3).
PHP Documentation Group COMPACT(3)