Can I Put A Mysql Query Result Directly Into A Multidimensional Array?
I have two joined tables:
Departments - which contains the department description and a key
Positions - which contains position data
What I'm attempting to achieve is to display the department title in one table cell and then list all the positions associated with that department in the cell under neither the title. I need to generate a table two column table with as many rows as required, depending on the number of departments, which is dynamic.
Do this I'm trying to turn the result of my SQL query into multidimensional array e.g. dept = VioP positions = "designer", "engineer" etc, which I can do then use to generate the table.
I've done a search on the forum and looked around the manual and I'm stumped on how to achieve this, a point in the right direction would be greatly appreciated. The query I'm using is below. PHP Code:
View Complete Forum Thread with Replies
Related Forum Messages:
Arrange Query Table Into Multidimensional Array
I have 3 tables: a list of articles, a list of authors, and a table joining the two via the article and author IDs. The join table looks like this: art_id auth_id ord 1 1 1 2 1 1 2 4 2 So author 1 contributed to both articles 1 and 2. The "ord" field is the order in which the author appears in the citation. Code:
View Replies !
Query Result To Array
i have a table with two field ID and CAPACITY. i want the ID to point to the capacity on an array $top = "SELECT * from topics"; $db = new mysqli('localhost','root',?'); $db -> select_db('testing'); $res_top = $db->query($top); $topics = array(); while ($row = $res_top->fetch_row()) { $topics[$row['id']] = $row['capacity']; }
View Replies !
Multidimensional Array In To A MySQL Table
Trying to load an multidimensional array into a MySQL table with columns as follows, level1,level2,level3,illust,item,description,partN o,qua,price,remarks,weight ,size,mass the array first line is $input[0][level1]Engine the array secondline is $input[0][level2]Cylinder Head etc.. A 'foreach' inside a 'foreach' echo of the array gives the following, which is correct. 0, level1, Engine 0, level2, Cylinder Head 0, level3, 0, illust, 001.pdf 0, item, 1 0, description, Casting 0, partNo, 238356 0, qua, 1 0, price, 1,245.00 0, remarks, This is for the Z350 series 0, weight, 5 0, size, 5x5x5 0, mass, 37 1, level1, Engine 1, level2, Cylinder Head 1, level3, 1, illust, 001.pdf 1, item, 2 1, description, Valve, inlet 1, partNo, 452790 1, qua, 4 1, price, 5.46 1, remarks, This is for the Z350 series 1, weight, 5 1, size, 5x5x5 1, mass, 37 2, level1, Engine 2, level2, Cylinder Head 2, level3, 2, illust, 001.pdf 2, item, 3 2, description, Valve, exhaust 2, partNo, 345436 2, qua, 4 2, price, 5.99 2, remarks, This is for the Z350 series 2, weight, 5 2, size, 5x5x5 2, mass, 37
View Replies !
Retrieve Multidimensional Array From Mysql?
I am developing a site to sell dvds. Each dvd can have multiple actors, I have created a select query that returns the film information and if there is more than 1 actor associated, more than 1 row is returned. I have tried to use the mysqli_fetch_array function to retrieve all the rows but this only seems to retrieve the first row. I assumed it would create a multidimensional array but I cannot find a second row. I have tried such things as $row[0][actor_name], $row[1][actor_name] but this does not work.
View Replies !
Moving A Query Result Into An Array
I have read all the array stuff done searches for examples, but am still not clear if there is a way to do a query from a MySQL table and move those vaules into an arry. I am sure it can be done, but I thought I would find a function that would do it. Am I just overlooking something? $resultID = mysql_query("SELECT DISTINCT slot FROM items"); while(list ($slot) = mysql_fetch_row($resultID)){echo"$slot";} So anyone have a good way to move the result into some array?
View Replies !
Query Giving Array As Result
I just started PHP and getting the following error when trying to read and echo something from my DB. I get Array as an result of a working SQL query (I tested it in PHPMyAdmin SQL Query) and it should be something else. Array doesnt return in the database i selected, but still it's here. <? $host="localhost"; $user="xxxxxxxxx"; $password="xxxxxxxxxxx"; $dbname="mohaaleague"; $connection = mysql_connect($host, $user, $password) or die ("Kan niet verbinden"); $clan = "Belgian Fun Clan"; $db = mysql_select_db ($dbname,$connection) or die("Je Stinkt"); //SELECT clan FROM clan WHERE clan='Belgian Fun Clan' $query = "SELECT clan FROM clan" or die("Query Mislukt"); $result = mysql_query($query) or die("Query Mislukt1"); $row = mysql_fetch_array($result, MYSQL_ASSOC) or die("Query Mislukt2"); extract($row); echo($row. "<br>"); if ( $clan == $row ) { echo "het werkt"; } else { echo "het werkt niet"; } $disconnect = "mysql_close"; ?>
View Replies !
Mysql Query Result
I have successfully selected 4 rows using a mysql SELECT query. However, I would like to random pick a row from this result so that every page refresh will yield something different.
View Replies !
Same Mysql Query Doesn't Always Return A Result
We have no access to a mysql NG on my provider's server, so we ask here: We have a long query (long in text) with a UNION between 2 select. We have been informed that some times the query doesn't return any result. We have tried on our server and we always get a result. BUT, trying on the hosting server, many times the query doesn't return any result and doesn't get any error. Any idea ? does Union have any problem ? how to check if the query failed ? My hoster said that sometimes the table can be locked (if the server is overloaded) and then mysql doesn't return any result, but this seems to me an aberration. the query takes about 0.0050 sec to execute when it doesn't return any result, and 0.030 when I get results
View Replies !
MySQL Query Result Rows
Still learning the ropes of PHP/MySQL here so pardon if this is something from a 101 class. I am wanting to know if/how I can query a MySQL database, pull two rows of information and assign them individual variable names. I know this isn't too clear. Let me try to explain what I want to do. Let's say I have something similar to this: Code: $query = mysql_fetch_assoc(mysql_query("SELECT entry_id, user_id, date FROM my_entries WHERE user_id = '$user_info[user_id]' ORDER BY date DESC LIMIT 2")); What I would like to be able to do is assign separate variables for the info on the two rows returned by the query. I want to have the following variables: $first_date = $query[date]; <= from the first row $second_date = $query[date]; <= from the second row I can then use the two variables to compare to each other, etc. Can this be done with a single query? Or are two queries required (if so how)?
View Replies !
Processing MySQL Query Result
after executing the query, say it returns 1000 results. if i just want to do some sampling and like to have a look on 4 of them, how can i refer to these 4 random records out of 1000? i'm working on processing the result of $res_array which has 1000 records. query = select * from test; result = mysql_query(query); records1000 = db_result_to_array($result); //how to select/remove records1000 to get say, records4? function db_result_to_array($result) { $res_array = array(); for ($count=0; $row = $result->fetch_assoc(); $count++) { $res_array[$count] = $row; } return $res_array; }
View Replies !
How To Get Mysql Query Result Into Temp. Txt File
I did a lite search in the archive but didn't find anything specific to my problem. Here is what I am trying to do: I've got a table with about 25k entries of company addresses. I need to be able to pull specific data out of the table and put it in a temporary text file and then display the result in the browser for the user to save locally. The query part and the format of the data is all simple enough but I am having trouble figuring out how to get the data from the query into a temporary text file and then displaying that file. here is what I whipped up but it obviously doesn't work: Code: <? $tmpfname = tempnam("/path/to/file/", "FOO"); $list = mysql_query("select * from FH_LIST where State='AK'"); while ($list_results = mysql_fetch_array($list)) { $data = blah blah blah; fwrite($tmpfname, ".$data "); } fopen($tmpfname, "r"); fpassthru($tmpfname); ?> I get an error message saying: Warning: Supplied argument is not a valid File-Handle resource (referring to $data).
View Replies !
Send Mysql Query Result Displayed In A Table
I have just created a shopping cart and I would like to send my user the receipt of there order by email. The receipt is generated by a mysql query and is displayed within a table. I have worked out how to send a html using simple HTML code as my “$message� variable: $success = mail($to, $subject, $message, $headers); But I can not get it to send my mysql query result displayed in a table. How can i create the result of my mysql query and make it a simple variable i.e $message.
View Replies !
Mysql Result Into Array?
I have a shopping cart script sending info to a processor. I need to send the qty's and item name's in some sort of string via a single variable to the process form. i.e. (3) Hipster Turnips, (6) Butter Milk Baby Brains, (2) Super Freaks Code:
View Replies !
Mysql Result Set As An Array
the question is, is there a way of assigning each value returned from the sql query and assinging them to a single array. for example i have a a query like so; $table = "sales_table";         $query = "select treatments from $table where date between  ད/08/2006' and ཕ/08/2006'"; $result = mysql_query($query); because the values stored in the treatments field are imploded as a single string when the user submits the form the value looks like; 1, 22, 33. Code:
View Replies !
MySQL Result As Array
$db= new MySQL($host,$dbUser,$dbPass,$dbName); $sql=("SELECT * FROM sticker_files WHERE sticker_cat_id=Ǝ'"); $catdirs = $db->query($sql); $dirs=$catdirs->fetch() and I need a for each loop (i think) to insert that data below: $params = array( 'mode' => 'Jumping', 'perPage' => 3, 'delta' => 2, 'itemData' => array(****RESULTS HERE AS COMMA SEPARATED string) );
View Replies !
Mysql Result To Array
I have this query, it gives the suspected information in myphpadmin: select listid, count(*) from table1 group by listid How do I put this the result into an array in php? I have problems with the count(*) field
View Replies !
Array With MySQL Result
//MAIN FLOW $counter = 0; $sql[$counter] = "SELECT * FROM category WHERE parent = 0 ORDER BY parent"; $result[$counter] = mysql_query($sql) or die(display_and_log_error("SQL ERROR: ".__LINE__)); while($myrow[$counter] = mysql_fetch_assoc($result[$counter])){ echo $myrow[$counter][category_name]; ...
View Replies !
Replacing Array With Mysql Result
I wanted to repalce the following line of code $data = array(40,21,17,14,23); with for($i=0;$i<$numrows;$i++) { //print(mysql_result($result,$i,2));print("<br>"); array_push($data,mysql_result($result,$i,2));} where mysql_result($result,$i,2) is the value and when i print it displays the values. But $data array is the Y axis value for drawing a chart. Here I wanted to replace the hard coded value with values from mysql but the second code does not function. Does anybody have idea how can I replace the $data array or what may be the problem with my coding The first one works but the second one does not work but in both cases it does not display any error.
View Replies !
Sort A Mysql Result According To A Php Array
Hi everybody ! I have a question for the gurus ;+) I have to arrays : PHP Code: $id = array(45,9,21); $pos = array(3,1,2); I select in my mysql table using the ids : PHP Code: $sql = "SELECT * FROM MyTable WHERE id IN(".implode("",$id).")"; and I now want to sort the result according to the $pos array. Is there a way to do this directly in mysql ? If not, what would be the smartest way to do it in PHP ? Because I would prefer NOT to do the following : PHP Code: while ($t = mysql_fetch_array($ret)) { Â Â Â Â $a_field1[] = $t["field1"]; Â Â Â Â $a_field2[] = $t["field2"]; Â Â Â Â $a_field3[] = $t["field3"]; Â Â Â Â $a_field4[] = $t["field4"]; ... } array_multisort($pos,$a_field1,$a_field2,$a_field3,$a_field4) I fear it could be a very time consuming process when there is a lot of results and a lot of fields. But may be the no other solution... Thanks
View Replies !
MySQL Result To Real Array In Function
I'd like to create a function which input is the result of a mySQL query. The output should be exactly the same, only not a mySQL result array, but a 'real' array. So it should also get the fieldnames returned by mySQL and use those as keys. I can't get things to work properly: it should return a multidimensional array, like $result_array[1] = array( [field1] => field1 value, [field2] => field2 value, etc. ) somehow my result is (with code below) $result_array[1] = array( [0] => field1 value, [field1] => field1 value, [1] => field2 value, [field2] => field2 value, etc. ) +++++ code ++++++ $get_res= mysql_query(QUERY); if( $res = mysql_fetch_array( $get_res ) ) { do{ $result[] = $res; }while( $res = mysql_fetch_array( $get_res ) ); }; foreach( $result as $key => $value ){ print_r($value); };
View Replies !
Changing Array Format From Result Of MySQL
here is what MySQL returns in a visual way.. game_id | team_id | stat_id 1 | 1 | 1 1 | 2 | 3 1 | 3 | 7 1 | 3 | 6 2 | 1 | 1 2 | 4 | 3 in records with the same game_id, there will be no repeating team_id in records with the same team_id, there will be no repeating stat_id so, after I got the query, I made them into this format PHP Code:
View Replies !
Array Directly Into A Table
I have been doing some thinking and am trying to find a shortcut. I have an array that I would like to add directly to my db. This array contains 122 - 125 string values. My data base will have 125 fields. Is there a way to insert the array into mysql without doing the obvious which would be to make a single insert query that would name all of the fields and then somehow make a foreach to loop through the individual elements of the array. $fields = explode(" ", $record); //separates each tab separated value in array $record and puts it in $fields //Time to insert into database $query = "INSERT INTO residential(//definitely do not want to declare 125 fields here) VALUES(//$fields array)"; $result = mysql_query($query); //Run the query.
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 !
Multidimensional Array Syntaxt For Preg_split Array Using Submitted Textarea
I have two textarea's called textarea1 and textarea2. What i did was use preg_split to split the textarea into seperate rows that i could use for analysis like so $array = preg_split("/[ ]?[ ]/", $_POST['textarea2'], -1,PREG_SPLIT_NO_EMPTY); $array2 = preg_split("/[ ]?[ ]/", $_POST['textarea1'], -1, PREG_SPLIT_NO_EMPTY); then i used a function created for me by a nice guy on here called get_ending($filepath) which basically stripped off of each peice of text the "http://www" from every URL i put into the textareas finishing off i wanted to create an array that would input an expression such as: echo "<a href='$array[1]' target='_blank'><img src='$array2[1]' border='0'>"; into a text area on the next page. ALL of this works, except that i dont know how to properly loop throught he array so it'll properly insert the text into the textarea on the next page. For now, all it does is place the array information in the page, rather statically, i would like to run some kind of if then statement that says "while $array has some kind of text in it, keep running this operation of echoing the following expression adding 1 to the end of the array number" I hope that makes sense Any ideas? Code:
View Replies !
Accessing Array Values Inside A Multidimensional Array
I need to access a value which is inside in a multidimensional array... Suppose there is a form and where I takes all the form values inside an array named access..and I post the values into a different array. $registrationArray = $_POST['access']; Now I need to loop through this registration array and get values printed to the new variables... Suppose this is the array $access = array (fname,lname,date,year,month) How do I print the date,year,month values into different variable by looping through registration array..
View Replies !
Passing Array Of Multidimensional Array To Function
How do I pass a part of a multidimensional array to a function. I have the following (in pseudo): $arrays[m][n]; // filled with values $chosen = 3; function doSomething($array) { // do something with 1D array } This fails: doSomething($arrays[$chosen]); Can someone explain to me why? And how to do this right?
View Replies !
Stream From FTP Directly To MySQL While Parsing CSV
I have some files that sit on a FTP server. These files contain data stored in a tab-separated format. I need to download these files and insert/update them in a MySQL database. My current basic strategy is to do the following: 1) Login to the ftp server using the FTP library in PHP 2) Create a variable that acts like a file handle using Stream_Var in PEAR. 3) Use ftp_fget() to read a remote file into this variable (this is so I don't have to write it to disk). 4) Parse that data now stored in memory using fgetcsv() (again treating that variable as a file handle using Stream_Var). This produces an array. 4) Insert/Update the data in the array using DB in PEAR. This all seems to work and it means I don't have to write anything to disk. Everything is handled in memory so not temp files are needed. The downside is that some of these files are very large so the program can consume large amounts of memory. I want to see what I can do to reduce this memory usage. In a perfect world I don't need to keep the entire file in memory. As soon as a single line is read via FTP I should be able to pass that line off to the CSV parsing code and the MySQL insert/update should be able to take place as each line is parsed by the CSV library. I.E. I should have more than a buffer worth of data in memory at a time. A buffer would need to be able to store at least a entire line but my memory requirements would drop significantly. My problem is that I can't seem to be able to figure out how to do this with the current PHP libraries. It seems that most functions in PHP are not designed around the idea of piping streams of information together. The other restriction I have is that I am limited to just PHP 4.3. Any ideas or is holding the entire file in memory the best way (other than writing my own libraries).
View Replies !
Turn Select Query Result Into Hyperlink To Other Query
I have a query which gives results of selecting coursenames from a table called trainingtopics but this does so in a continuous bulk of text without any breaks between each record. my question how do I create line breaks between each record and also how can I force each query result to become a hyperlink which when clicked runs another query that gives details of that course. <?php $user = "root"; $host = "localhost"; $password = ""; $connection = mysql_connect($host, $root, $password) or die ("Couldn't connect to server."); $database = "courses"; $db = mysql_select_db($database) or die ("Couldn't select database."); $sql = "SELECT coursename FROM trainingtopics"; echo $sql."=sql<br>"; $result = mysql_query($sql) or die(mysql_error()); echo $result."=result<br>"; while($row=mysql_fetch_array($result)) { // NOTE this one ABOVE the echo echo "result found!"; echo $row[0]; } ?>
View Replies !
Multidimensional Array: See If 1st Key Is Available
I've got an multidimensional array $ret = $country_code[$countryCode][$langCode]; Now I want to see if $countryCode is even in that array, because if it's not, it doesn't make many sense to look further for $langCode. Eg. $country_code = array('BE' => array ('en' => 'Belgium', 'nl' => 'België'), 'NL' => array ('en' => 'Netherlands', 'nl' => 'Nederland'), ); Searching for 'BE' would make sense, but 'LP' wouldn't. I already tried: $arr = array($country_code['LP']); if (sizeof($arr) == 0) print "LP not found!" But that doesn't seem to work :-s.
View Replies !
Multidimensional Associated Array
I try to construct an array such that each element of it is another array returned by the fetch_array_function: for ( $i = 1; $i<=$n; $i++ ) { $ar[$i] = mysql_fetch_array( $result ); print "$ar[$i][fieldname] "; It prints "Array[fieldname]". If I replace $ar[$i] by $ar everything works fine! Could you pleas...
View Replies !
2 Multidimensional Array
I have a multidimensional matrix: C1 C2 C3 C4 R1[] [] [] [] R2[] [] [] [] R3[] [] [] [] R4[] [] [] [] R5[] [] [] [] R6[] [] [] [] R7[] [] [] [] R8[] [] [] [] 1. Is it possible to search in a specific column? eg: only search for a value in in C2 and get the rownumber as result? 2. Copy one or more rows and put them in between other rows? eg: move row 5 and 6 between row 1 and row 2. C1 C2 C3 C4 R1[] [] [] [] R5[] [] [] [] R6[] [] [] [] R2[] [] [] [] R3[] [] [] [] R4[] [] [] [] R7[] [] [] [] R8[] [] [] []
View Replies !
Multidimensional Array
I am trying to build a random card generator and once a card is chosen it gets taken out of the array. this is what i have so far which is far away from where I need to be. $suites = array("Spade","Clubs","Diamonds","Hearts"); $numbers= array(2,3,4,5,6,7,8,9,10,"Jack","Queen","King","Ace");
View Replies !
MySql Query Into Array
A bit of a newb question here; I'm building a little application using PHP and MySql and have a question on how best to perform a specific function... I need to select the last 20 records form a table, and with those 20 records I need to take the 10 with the lowest value and add them together to come out wiht a single number. My table only has 2 columns: ID and Number. I can easily get the 20 lowest using: $query_rsLimited = "SELECT * FROM test ORDER BY testID DESC LIMIT 20"; $rsLimited = mysql_query($query_rsLimited, $ConnClub) or die(mysql_error()); $row_rsLimited = mysql_fetch_assoc($rsLimited); $totalRows_rsLimited = mysql_num_rows($rsLimited); My question is how best to get the 10 highest 'Number' values out of the 20 records and sum them.
View Replies !
Array In Mysql Query
I have file extension loaded in a DB and if they are active i call them in a mysql_query. the way i will call all active files is PHP Code: in_array($getf,$image_ext); PHP Code: $query = "select * from ".$prefix."search WHERE (type = 'jpg' OR type = 'png' OR type = 'gif' OR type = 'jpe' OR type = 'jpeg') AND (file_name LIKE '%$res%' OR name LIKE '%$res%') ORDER BY name ASC";
View Replies !
Speeding Up Query/code (query Within Result Set)
I'm looking for ideas on how to speed up this script. Basically it finds all the zip codes in a zipcode table, then looks for all the records in another table with those zip codes. Right now it finds all the zips then within that WHILE, it looks for a record in another table with that zip: PHP Code:
View Replies !
How To Reference An Array In Multidimensional Array?
How do I reference an array within an array? $mapped_array = array_map(null, $data_array, $counter_array); // okay, so now I have an array of 2 arrays - but how do I reference each array? // the next two lines fail to give an accurate count echo "Starting with ".count($mapped_array[0])." elements in data_array<br>"; echo "Starting with ".count($mapped_array[1])." elements in counter_array<br><br>"; // now I want to start at the bottom and look for an IP in each line of data_array // which I assume is mapped_array[0] for ( $i=count($mapped_array[0]); $i > 0; $i-- ) { $data_line = $mapped_array[0][$i]; $data = explode("|", $data_line); if( in_array($ip, $data) ) { // if there's a match, element[$i] of both arrays needs to be spliced out array_splice($mapped_array,$i,1); } } // again, these next two lines fail to return an accurate count echo "Ending with ".count($mapped_array[0])." elements in data_array<br>"; echo "Ending with ".count($mapped_array[1])." elements in counter_array<br><br>"; Is there something about array_map that prevents me from referencing the arrays within the array?
View Replies !
Problems Using Multidimensional Array
I am trying to understand multidimensional arrays within PHP, and am trying to do the following: $x[1][1]="test"; $x[1][2]="test2"; $x[2][1]="test3"; $x[2][2]="test4"; print ("$x[1][1] $x[1][2] $x[2][1] $x[2][2]"); but instead of getting the result: test test2 test3 test4 I am getting: Array[1] Array[2] Array[1] Array[2] Can someone please explain why this is happening.
View Replies !
Break Down Multidimensional Array
I have a multidimensional array and was wondering how it can be broken down... Array ( [0] => Array ( [0] => Array ( [0] => 1 [intsch_id] => 1 ) [1] => Array ( [0] => 2 [intsch_id] => 2 ) ) ) And I want to break it down to Array ( [0] => 1 [intsch_id] => 1, [1] => 2 [intsch_id] => 2) And this is in a dynamic query, so the results won't always be this simple. It will have the same structure as the above multidimensional array.
View Replies !
Create A Multidimensional Array From XML Doc
Currently I have the following XML document: <Programs> <Program> <ProductTypeName>30 Yr Fixed</ProductTypeName> <Rate>6.250</Rate> <APR>6.274</APR> <InvestorName>Helos</InvestorName> <Payment>2832.298</Payment> </Program> <Program> <ProductTypeName>30 Yr Fixed</ProductTypeName> <Rate>9.250</Rate> <APR>9.293</APR> <InvestorName>Avalon</InvestorName> <Payment>3784.306</Payment> </Program> <Program> <ProductTypeName>5/1 Arm</ProductTypeName> <Rate>6.375</Rate> <APR>6.399</APR> <InvestorName>Carl1</InvestorName> <Payment>2869.802</Payment> </Program> </Programs> I load it up in a domdocument and iterate through it with the following: $returns = array(); for($i = 0; $i < $xmlproducttype->length; $i++) { $returns[$i]['ProductTypeName'] = $xmlproducttype->item($i)->nodeValue; $returns[$i]['InvestorName'] = $xmlinvestorname->item($i)->nodeValue; $returns[$i]['Rate'] = $xmlrate->item($i)->nodeValue; $returns[$i]['APR'] = $xmlapr->item($i)->nodeValue; $returns[$i]['Payment'] = $xmlpayment->item($i)->nodeValue; } Giving me the following style array:
View Replies !
Passing Multidimensional Array Thru The URL
I have an issue with an array that I would to pass to a second php script; please note that I cannot use session. I have been looking at the functions : rawurlencode / rawurldecode urlencode / urldecode but it does not seems to work for my variable here is an example of variable: <? $x=0; $data[$x][title]="My title"; $data[$x][label]=array("label1","label2","label3"); $data[$x][data]=array(100,150,145); ?> How can I pass this variable thru an URL?
View Replies !
How To Return A 'sub-array' Of A Multidimensional One
I have a multi-dimensional associative array, and I'm interested in searching the array for a given key, and returning the 'sub-array' or value associated with this key. for example: Code: $array = array( 'A'=>1, 'B'=>2, 'C'=>ARRAY( 'A2' => 'FRUIT', 'B2' => 'VEGGIE', 'C2' => ARRAY( 'MEAT1' => 'BEEF', 'MEAT2' => 'CHICKEN' ) ) ); I want to retrieve the array under the key 'C2'. I have tried to 'search' the array so that its internal pointer is pointing at this element, then using 'current', but that doens't work: Code: array_key_exists( 'C2', $array ); var_dump( current( $array ) ); I've also tried a small variation of the above in order to get the reference to C2 rather than a deep copy: Code: array_key_exists( 'C2', $array ); var_dump( $array[key($array)] ); I would actually prefer to get a reference into the array rather than a copy.. I guess I'm really stuck on the 'search' part of the mutlidimensional array.. Surely there's a better way (built-in function) than iterating every element and comparing the key?
View Replies !
Single Array To Multidimensional
I have a string, comma separated, with links and their respective URLs in it. Example: Google,http://www.google.com,Yahoo!,http://www.yahoo.com,WikiPedia,http://www.wikipedia.org etc, etc. i make an array of this with explode( ',', $string ); now what i wonder is how can i turn this array into something like this: $array[0]['name'] = Google $array[0]['url'] = http://www.google.com $array[1]['name'] = Yahoo! $array[1]['url'] = http://www.yahoo.com $array[2]['name'] = WikiPedia $array[2]['url'] = http://www.wikipedia.org I hope/think this is all clear ...
View Replies !
Define The Multidimensional Array
I won't post my exact code since the project I'm working on is HUGE and I'd have to explain it all anyways, but I'll provide examples. Basically, I'm using OOP PHP to build this project... and at one point I have the constructor of 'Class1', calling another method of the same class. In that method, I want to add to a multidimensional array defined in the class itself... in the first position I want to store a string, in the next position, I want to store an instance of another class. Now, the problem I'm having is that when I try and define the multidimensional array, it takes FOREVER!!!! Literally 25 seconds! All I'm doing is this: PHP Code:
View Replies !
Multidimensional Array Loop
I am trying to loop through a multidimensional array shopping cart stored in a session. I can loop through it ok but the problem is that when the page displays I have two each of the items in the cart. I am looping through with a double foreach. If I do print "$key: $value"; inside of the second foreach I get the correct display of the items in my cart but then the actual display of the items gives me two of each. Code:
View Replies !
|
TRACKER
