php foreach with multidimensional array

Question

I m developing a php app that uses a database class to query mySQL   the class is here  http   net tutsplus com tutorials php real-world-oop-with-php-and-mysql   I made some tweaks on the class to fit my needs  but there is a problem  maybe a stupid one   When using select   it returns a multidimensional array like that for a table that has 3 cols  id  firstname  lastname     Array        0     Array                        id     1              firstname     Firstname one              lastname     Lastname one                 1     Array                        id     2              firstname     Firstname two              lastname     Lastname two                 2     Array                        id     3              firstname     Firstname three              lastname     Lastname three               Now I want this array to be used as a mysql result  mysql fetch assoc    I know that it may be used with foreach   but this is with simple arrays  so I think that I have to redeclare a new foreach   withing each foreach    but I think this could slow down or cause some higher server load   So how to apply foreach   with this multidimensional array the simplest way   Thanks

User · Accepted Answer

You can use foreach here just fine   foreach   rows as  row        echo  row  id        echo  row  firstname        echo  row  lastname        I think you are used to accessing the data with numerical indicies  such as  row 0    but this is not necessary   We can use associative arrays to get the data we re after

User · Answer

With arrays in php  the foreach loop is always a pretty solution  In this case it could be for example   foreach  my array as  number   gt   number array            foreach  number array as  data    gt   user data                        print  Array number   number  contains  data with  user data    lt br gt

User · Answer

If you need to do string manipulation on array elements  e g  then using callback function array walk recursive  or even array walk  works well  Both come in handy when dynamically writing SQL statements   In this usage  I have this array with each element needing an appended comma and newline    some array         data in  some array 0   Some string in an array  1   Another string in an array     Per php net     If callback needs to be working with the actual values of the array    specify the first parameter of callback as a reference  Then  any   changes made to those elements will be made in the original array   itself    array walk recursive  some array  function   amp  value   key         value       n         Result   Some string in an array  n   Another string in an array  n     Here s the same concept using array walk to prepend the database table name to the field    fields         data in  fields  0   FirstName  1   LastName      tbl    Employees   array walk  fields   prefixOnArray    tbl        function prefixOnArray  amp  value   key   prefix          value    prefix  value       Result   Employees FirstName   Employees LastName       I would be curious to know if performance is at issue over foreach  but for an array with a handful of elements  IMHO  it s hardly worth considering

User · Answer

To get detail out of each value in a multidimensional array is quite straightforward once you have your array in place  So this is the array    example array   array  array  1   John   Smith    array  2   Dave   Jones    array  3   Bob   Williams        Then use a foreach loop and have the array ran through like this   foreach   example array as  value    echo  value 0     this will echo 1 on first cycle  2 on second etc     echo  value 1     this will echo John on first cycle  Dave on second etc     echo  value 2     this will echo Smith on first cycle  Jones on second etc         You can echo whatever you like around it to  so to echo into a table   echo   lt table gt       foreach   example array as  value        echo   lt tr gt  lt td gt      value 0      lt  td gt        echo   lt td gt      value 1      lt  td gt        echo   lt td gt      value 2      lt  td gt  lt  tr gt          echo   lt  table gt      Should give you a table like this    1 John Smith      2 Dave Jones      3 Bob  Williams

User · Answer

Ideally a multidimensional array is usually an array of arrays so i figured declare an empty array  then create key and value pairs from the db result in a separate array  finally push each array created on iteration into the outer array  you can return the outer array in case this is a separate function call  Hope that helps   response   array        foreach   res as  result             elements   array  firstname    gt   result 0    subject name    gt   result 1            array push  response   elements

User · Answer

This would have been a comment under Brad s answer  but I don t have a high enough reputation   Recently I found that I needed the key of the multidimensional array too  i e   it wasn t just an index for the array  in the foreach loop   In order to achieve that  you could use something very similar to the accepted answer  but instead split the key and value as follows  foreach   mda as  mdaKey   gt   mdaData        echo  mdaKey           mdaData  value        Hope that helps someone

User · Answer

Example with mysql fetch assoc     while   row   mysql fetch assoc  result                your stuff           In your case with foreach  with the  result array you get from select     foreach   result as  row               your stuff           It s much like the same  with proper iteration

User · Answer

I know this is quite an old answer   Here is a faster solution without using foreach    Use array column  print r array column  array   firstname      returns the value associated with that key  firstname    Also you can check before executing the above operation  if array key exists  firstname    array       print r array column  array   firstname

User · Answer

Holla Hello   I got it  You can easily get the file name tmp name file size etc So I will show you how to get file name with a line of code   for   i   0    i  lt  count  files  name      i          echo  files  name    i    lt br  gt        It is tested on my PC

User · Answer

foreach   parsed as  key  gt   poke         insert   mysql query  insert into soal                             pertanyaan  a  b  c  d  e  jawaban                            values                              poke question                                poke options  A                                poke options  B                                poke options  C                                poke options  D                                poke options  E                                poke answer

User · Answer

You can use array walk recursive   array walk recursive  array  function   item   key        echo   key holds  item n

User · Answer

Wouldn t a normal foreach basically yield the same result as a mysql fetch assoc in your case   when using foreach on that array  you would get an array containing those three keys   id   firstname  and  lastname    That should be the same as mysql fetch assoc would give  in a loop  for each row

[php] php foreach with multidimensional array

Examples related to php

Examples related to arrays

Examples related to foreach