[Resolved] Posting data from an array

[GIJew]

Hey,

Here we go...

A form that lists the results of a database used for editing the information. The data is used to create menu links for the site. I have them stored (inside db) like "linkName:url:linkTitle"

I use explode() to seperate them all and voila. (Just giving background here).

When they are displayed back in the edit form, I have them set up like...

<?PHP
  // QUERY DB
  $getMENUQUERY = mySQL_QUERY ("SELECT * FROM blocks_sub WHERE block_id = '$bID'");

  echo '<form action="index.php?do=fetch&mod=blocks&func=submit&type=edit&sub=menu" method="POST">'
       .'<table cellpadding="1" cellspacing="0" align="center" class="sysBORDER_ALL">';

  // LOOP THROUGH THE RESULTS
  while ($menuBLOCK = mySQL_FETCH_ARRAY($getMENUQUERY)) {
    // STORE THE DATA INTO AN ARRAY
    $menuPIECES = explode(":",$menuBLOCK['block_value']);

// DISPLAY EACH BIT OF DATA INSIDE AN INPUT FIELD
echo '<tr>'    	
     .'<td><input type="text" name="menu_title[]" value="'.$menuPIECES[2].'"></td>'
     .'<td><input type="text" name="menu_url[]" value="'.$menuPIECES[0].'"></td>'
     .'<td><input type="text" name="menu_alt[]" value="'.$menuPIECES[1].'"></td>'
     .'</tr>'
     .'<input type="hidden" name="menu_subID[]" value="'.$menuBLOCK['block_sid'].'">';
  echo '</tr>'
  }
  echo '<tr>'
       .'<td align="center" colspan="3">'
      .'<span class="link-highlight">'
      .'<input type="image" src="themes/'.$cur_theme.'/images/buttons/set_settings.gif" name="submit">'
      .'</span>'
      .'</td>'
      .'</tr>'
      .'</table>'
      .'</form>';
?>

So I have the value's of each input field being store inside of an array. I'm not sure that it is right, I'm just testing things out right now.

When the form subits to the "submit function" (and this is where I'm getting all screwed up) this code happens.

<?PHP

  $c_Title = count ($_POST['menu_title']);
  $c_URL = count ($_POST['menu_url']);
  $c_Alt = count($_POST['menu_alt']);
  $c_ID = count($_POST['subID']);

  // I'M ONLY GOING TO DO THE ID BECAUSE IT'S THE ONLY ONE THAT WORKS.
  for ($i = 0; $i < $c_ID; $i ++) {
    $cID = $_POST['menu_subID'][$i];
    ### MYSQL TO PERFORM ###			    
  }
?>

I'm sorry for posting so much but the bare bones question in all of this is how do I get all of the posted data from the previous form and update it inside of the database?

Thank you very much in advance for your help.

[devinemke]

why are you storing "linkName:url:linkTitle" all as one field? why not simply create 3 separate fields, then you wont have to explode(). simply name each form field the same as the database field names and use the submitted data to construct your INSERT/UPDATE query.

[GIJew]

Hehe, I knew I would forget to include something.

The reason I'm doing it this way is because I have it all set up (1 table) to store different types of blocks (menu, html, login). I figured that since I want to have so many different types of blocks it might be easier to just have one table instead of a dozen.

To get a bit more exact though, I have two tables for the blocks. My setup for them is as follows...

BLOCKS
- block_id (VARCHAR) [unique - identifies block]
- block_title (VARCHAR) [main title]
- block_type (VARCHAR) [html/menu/etc...]
- block_position (ENUM - l,c,r) [where it's supposed to show]
- block_status (ENUM - 1,2) [enable/disable]
- block_order (INT) [order]

BLOCKS_SUB
- block_sid (INT) [auto_increment]
- block_id (VARCHAR) [same as BLOCKS TABLE]
- block_value (TEXT) [Displays content (html/menu...)

I join the tables together and voila. It works just fine with everything but this one thing (menu function)...

I know giving all the table info was probably an overkill but hey, you asked 🙂

[GIJew]

GOT IT!!!

Thanks for the try...

<?PHP
// Count the ID's of each row
$cID = count($_POST['menu_subID']);

// Loop through the results
for ($i = 0; $i < $cID; $i ++) {
  // Store unique ID in variable
  $cID = $_POST['menu_subID'][$i];
  // Format the results for storage
  $newURL = $_POST['menu_url'][$i].':'.$_POST['menu_alt'][$i].':'.$_POST['menu_title'][$i];
  // Update DB
  mySQL_QUERY ("UPDATE blocks_sub SET block_value = '$newURL' WHERE block_sid = '$cID'");
}
?>