Databases
StackOverflow2013
Postsdbo
POIssue with a foreach statement
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIssue with a foreach statement
    primarykey
    data
    text
    <p>I'd like to renew this question: <a href="https://stackoverflow.com/questions/14798794/populating-a-calendar-with-php-foreach-code">Populating a calendar with PHP foreach code</a></p> <p>The problem has returned for some weird reason, and it says that I have an invalid argument supplied for foreach. What's weird, is that it works on my localhost website all fine.</p> <p>The result should be that the code should display a populated calendar. It does on my localhost server, but it doesn't online, on a website. I'm confused.</p> <p>This has fixed it for my localhost server:</p> <pre><code>foreach(array_merge(array_values($history), array_values($events)) as $event) </code></pre> <p>But when I put the website online, chrome just gives me this:</p> <pre><code>&lt;b&gt;Warning&lt;/b&gt;: array_values() [&lt;a href='function.array-values'&gt;function.array-values&lt;/a&gt;]: The argument should be an array in &lt;b&gt;/home/flyeurov/public_html/lib/skins/flyeuro/events/events_index.tpl&lt;/b&gt; on line &lt;b&gt;30&lt;/b&gt; &lt;b&gt;Warning&lt;/b&gt;: array_merge() [&lt;a href='function.array-merge'&gt;function.array-merge&lt;/a&gt;]: Argument #2 is not an array in &lt;b&gt;/home/flyeurov/public_html/lib/skins/flyeuro/events/events_index.tpl&lt;/b&gt; on line &lt;b&gt;30&lt;/b&gt; &lt;b&gt;Warning&lt;/b&gt;: Invalid argument supplied for foreach() in &lt;b&gt;/home/flyeurov/public_html/lib/skins/flyeuro/events/events_index.tpl&lt;/b&gt; on line &lt;b&gt;30&lt;/b&gt;&lt;br /&gt; </code></pre> <p>The arrays $history and $events are confirmed to work.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USzzwyb89
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIssue with a foreach statement
      1. This table or related slice is empty.
      1. VTClose
    2. VO
      singulars
      1. POIssue with a foreach statement
      1. This table or related slice is empty.
      1. VTClose
    3. VO
      singulars
      1. POIssue with a foreach statement
      1. This table or related slice is empty.
      1. VTClose
    1. COConfirmed how? And work how? because clearly `$events` is not an array.
      singulars
      1. POIssue with a foreach statement
      1. USPeeHaa
    2. COThe first thing I'd do to troubleshoot is move pieces out of the foreach. `$hist = array_merge(array_values($history);$ev=array_values($events);var_dump($hist);var_dump($ev);` That way you can see what is going on with the data.
      singulars
      1. POIssue with a foreach statement
      1. USmkaatman
    3. CO`$events` and `$history` are in a different file. The foreach statement is in a .tpl file, where the two variables are applied to. What I did to confirm it works, is first replaced the foreach with default `foreach ($events as $event)` and it didn't work. When I replaced the .tpl with the default version, everything worked. I assume that works then?
      singulars
      1. POIssue with a foreach statement
      1. USzzwyb89
 

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