Databases
StackOverflow2013
Postsdbo
POCalculations on multidimensional array
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCalculations on multidimensional array
    primarykey
    data
    text
    <p>I'm working on a project and I can't wrap my head around on a calculation that needs to be done on a multidimensional array. Quick background, it's a hotel benchmarking tool and I need to calculate the market penetration index (MPI). I have an array with 3 main arrays. First 2 are the hotels which are being compared and the last one is the MPI array.</p> <p>Each array contains an array for every month the user selects. Inside THAT array is data that needs to be used for calculations. Here is an example:</p> <pre><code>Array ( [Competitive set] =&gt; Array ( [Sep 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-09-01 [maxmonth] =&gt; 2011-09-01 [nrcheck] =&gt; 13 [data] =&gt; 67.6 ) ) [Oct 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-10-01 [maxmonth] =&gt; 2011-10-01 [nrcheck] =&gt; 13 [data] =&gt; 63.6 ) ) [Nov 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-11-01 [maxmonth] =&gt; 2011-11-01 [nrcheck] =&gt; 13 [data] =&gt; 59.2 ) ) [Dec 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-12-01 [maxmonth] =&gt; 2011-12-01 [nrcheck] =&gt; 13 [data] =&gt; 54.6 ) ) ) [Test] =&gt; Array ( [Sep 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-09-01 [maxmonth] =&gt; 2011-09-01 [nrcheck] =&gt; 89 [data] =&gt; 71.5 ) ) [Oct 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-10-01 [maxmonth] =&gt; 2011-10-01 [nrcheck] =&gt; 89 [data] =&gt; 67.0 ) ) [Nov 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-11-01 [maxmonth] =&gt; 2011-11-01 [nrcheck] =&gt; 91 [data] =&gt; 63.1 ) ) [Dec 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-12-01 [maxmonth] =&gt; 2011-12-01 [nrcheck] =&gt; 89 [data] =&gt; 57.5 ) ) ) [MPI] =&gt; Array ( [Sep 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-09-01 [maxmonth] =&gt; 2011-09-01 [nrcheck] =&gt; 89 [data] =&gt; 71.5 ) ) [Oct 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-10-01 [maxmonth] =&gt; 2011-10-01 [nrcheck] =&gt; 89 [data] =&gt; 67.0 ) ) [Nov 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-11-01 [maxmonth] =&gt; 2011-11-01 [nrcheck] =&gt; 91 [data] =&gt; 63.1 ) ) [Dec 11] =&gt; Array ( [0] =&gt; Array ( [minmonth] =&gt; 2011-12-01 [maxmonth] =&gt; 2011-12-01 [nrcheck] =&gt; 89 [data] =&gt; 57.5 ) ) ) </code></pre> <p>)</p> <p>here is a pastebin with var_export as suggested (can't seem to format it propperly here) <a href="http://pastebin.com/b8hYM7TW" rel="nofollow">http://pastebin.com/b8hYM7TW</a> Sorry for the huge code block but it had to be this big =( Either way currently the 'data' for MPI is wrong. That needs to become the data of the first array divided by the data of the second array and multiplied by 100 (percentage).</p> <p>The keys "Competitive Set" and "Test" are variable and not available in the scope i'm working in so those static names can't be used.</p> <p>I read about recursive functions but I'm still not getting it...</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USOrtix92
    1. USOrtix92
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COif you want code handouts, at least make it easy for someone to help. use var_export()
      singulars
      1. POCalculations on multidimensional array
      1. USgoat
    2. COAdded as a pastebin until I can get the formatting right. What is the difference between var_export and print_r in terms of making it easier to help?
      singulars
      1. POCalculations on multidimensional array
      1. USOrtix92
    3. COFrom the PHP.Manual: 'var_export() gets structured information about the given variable. It is similar to var_dump() with one exception: the returned representation is valid PHP code.'
      singulars
      1. POCalculations on multidimensional array
      1. USHamZa
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload