PHP - Help: Extracting Data From A Multidimensional Array

Hi all,

I hope someone can help me out here as I think I am close but am not sure where to go from here.  The problem is:
I have a cms where a user can see a list of photos in the gallery.
I provide them the ability to select what photos they want to appear on a particular webpage.
The problem I have is that the user wants to be able to put the photos in whatever order they choose.

So, I have a form (see attached), the html code is:

          <table width="566px" cellspacing="0" border="0">              <tr>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='119' />&nbsp;Bathroom Sin...
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='113' />&nbsp;Courtyard 1
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' name='photos[][0]' value='114' />&nbsp;Courtyard 2
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value=""/>                  </div>
                </td>
              </tr>...

Now, lets assume that the user ticked the box next to 'Courtyard 2' and entered an integer '1' in the input box to signify that this image should be displayed 1st on the chosen webpage.  These 2 values go into the multidimensional array (photoid, ranking) and are submitted in the form to php in the photos[][] array.

But here is where I have the problem.  I am trying to extract the values from the array and then do an insert to a table in mysql.  My syntax must be wrong somewhere so I am asking anyone to please offer any advice:

  if (isset($_REQUEST['submitted'])){   
       $photos = $_REQUEST['photos'];
...

    if(!empty($photos)){
       foreach($photos as $photoID){
         $sql = "INSERT IGNORE INTO menuItemPhotos
                SET photoid='$photoID[0]', menuItemid='$id', ranking='$photoID[1]'";
        $ok = @mysql_query($sql); // execute the query
      } // End of foreach($photos as $photoID){
    } // End of if(!empty($photos)){

Thanks
Conor

[attachment deleted by admin]

I have a multidimensional array for a calendar application as shown below.  The first level is an associative array for calendar dates, and the second is a numeric array for multiple events on each day.  The third level holds the events.  I know that I can extract a single event using the array indices, such as:

echo $events['2010-11-24'][0]['event_date'];

If I know the number of events for the date, I can extract them one-by-one by incrementing the array index.  However, I never know how many events will be stored for any one day.

I also know that I can extract all the data in the entire array using a foreach loop.  But how can I extract only the data in a subarray?


Array
(
    [2010-11-16] => Array
        (
            => Array
                (
                    [event_date] => 2010-11-16
                    [title] => Board Meeting
                )

            [1] => Array
                (
                    [event_date] => 2010-11-16
                    [title] => Second event
                )

        )

    [2010-11-24] => Array
        (
            => Array
                (
                    [event_date] => 2010-11-24
                    [title] => New meeting
                )

        )

)

Hi guys,
This is my problem:
I have a csv file let's say have these values:

blue,1,2,3,4
red,8,5,6,7

I need to add thes values into a 2d array
to be able to use like this:
colors[1][2]=2
colors[2][4]=7

Where my first number is the row and the second number is the value within that row.

This is what I got so far

<?PHP
$i=0;
$j=0;
$file_handle = fopen("color-list.csv", "r");
while (!feof($file_handle) )
   {
   $colors = fgetcsv($file_handle, 10000);

for ($j=0; $j<=4; $j++)
               {
               $row[$i][$j]=$colors[$j];
                                        print row[$i][$j];
               }
$i++;
?>

For some reason this doesn't work. Maybe I am declaring the arrays wrong.

Thank you!

Hi - I have an array where one of the values delivers a string. Here is the output from a print_r($pickupdates):

Code: [Select]
Array
(
    [0] => Array
        (
            [location] => Clearwater
            [TheDates] => 1311746700,1321746641,1331668779
        )

    [1] => Array
        (
            [location] => Canmore
            [TheDates] => 1311746700,1321746641,1331746641
        )

    [2] => Array
        (
            [location] => Collingwood
            [TheDates] => 1311746700,1321746641,1331746641
        )

    [3] => Array
        (
            [location] => Varsity
            [TheDates] => 1321746641,1330746700,1331746700
        )

The challenge is to get the location and TheDates  into a nice HTML table which would look like this:

Code: [Select]
LOCATION          DATE 1            DATE 2              DATE 3

Clearwater         April 1              May 1                June 1

Varsity               April 2              May 2                June 2

Collingwood        April 3              May 3                June 3


Canmore        April 4              May 4                June 4


Ok - Now I am stuck, I need to be able to uniquely identify each date that is associated with the location such that I can run a foreach() on then so I can populate the table properly. I tried using list() and explode. List does not separate the dates and explode needs a string not an array.

I'm really stuck - a very big Heartfelt thanks to anyone who can steer me in the right direction.

MANY THANKS !

Hi all

I have a question about how to store parsed data into a multidimensional arrays -- I can store items into an array, but multidimensional arrays mystify me a bit.  Any help would be greatly appreciated. 

I'm storing the images in a table, grouped according to their table and their descriptions, so that later when I call the images, I can display them accordingly. I'm using the Simple HTML DOM Parser.  So say I have two tables, one with three images, and another with one.  I'd like the resulting to array to look like:

Code: [Select]
Array
(
    [0] => Array
        (
            [0] => image1.jpg
            [1] => 1st Variation Description
        )

    [1] => Array
        (
            [0] => image2.jpg
            [1] => image3.jpg
            [2] => image4.jpg
            [3] => 2nd Variation Description
        )

)

This is what I have so far:
Code: [Select]
$html = str_get_html($vartables);   
$varinfo = array();
foreach($html->find('table') as $table){
        $varinfo[] = $table->innertext;
}
print_r($varinfo);

Which yields:

Code: [Select]
Array
(
    [0] =>
 <tr>
  <td width=150>
Description1
 </td>

 <td><a href="image1.jpg">
<img src="image1" height=100 border=1></a>
  </td>
 </tr>

    [1] =>
 <tr>
  <td width=150>
Description2
  </td>

<td><a href="image2.jpg">
<img src="image2.jpg" height=200 border=1></a>
  </td>
  <td><a href="image3.jpg">
<img src="image3.jpg" height=200 border=1></a>

  </td>
 <td><a href="image4.jpg">
<img src="image4.jpg" height=200 border=1></a>
  </td>
 </tr>

)

I'd like to strip out the html and keep the .jpg's and descriptions together in a multidimensional array...unfortunately my newbness is getting the better of me there, I'm researching but running into a roadblock.  Thanks in advance for any help.