jQuery Forum

1. <input type="checkbox" name="colors_love[]" value="Bright_Red" class="cbx" <?php if($rows['colors_love[]']=='Bright_Red') echo "checked='checked'"; ?>     

1. <?php if($rows['colors_love']=='Black') echo "checked='checked'"; ?> />

1. <?php if ( $arr[$i++]) echo 'checked="checked"';?> >

1. <?php     
   $result = mysql_query("SELECT * FROM style WHERE style.user_id=$user_id ") or die(mysql_error());
   $row = mysql_fetch_array($result );
   $search = array('_', ',');
   $replace = array(' ', ', ');
   $rows = str_replace($search, $replace, $row);
   ?>
     <td bgcolor=#000000 class="Colorbox input_field" onclick="toggle_colorbox(this);" title="Black"><div class=Check>&#10003;</div>
        <input type="checkbox" name="colors_love[]" value="Black" class="cbx" <?php if($rows['colors_love']=='Black') echo "checked='checked'"; ?> /></td>

Wizzud,

I hadn't even realized I'd made that mistake when I was copying and pasting the code - Good catch :-)

That was a great suggestion to lift the html from the browser's View Source :-) I think it helped narrow down the problem :-) The HTML only shows checked='checked' when one value in an array has been selected, and when more than one value is selected it doesn't get added to the HTML. It also made me realize that I have the same problem with standard checkboxes (my apologies - I was sure I'd tested that already), so you're definitely right that the problem lies with my php. Any suggestions?

I added a few fields to help test things - Account Information has two questions which use standard checkboxes, one is of them is set up as an array (the code is a bit clunky though since these fields are normally displayed in Select and MultiSelect elements). I also included a field where the php displays the database values in text format so you can see the values which are being echoe'd by the php vs. what is being checked.

I've 2 screenshots with these below :-) I wasn't able to set up a working example without providing access to the database password information, but I've uploaded the attached the files so that you can see the full code (in order to simplify things I only included 3 customer questions with the relevant code). http://click2fit.com/test_files/member_infoA.php is the primary file and the files used to submit information to the database are
http://click2fit.com/test_files/profile-taste-exec1.php and http://click2fit.com/test_files/profile-createaccount-execA.php 

I am so grateful for your help, along with other's like msd1811, to figure this out :-D

- Chaya

Image 1 - Displays check marks when 1 value has been selected

 

Image 2 - Doesn't display check marks when more than 1 value has been selected

1. <?php     
2. $result = mysql_query("SELECT * FROM style WHERE style.user_id=$user_id ") or die(mysql_error());
3. $row = mysql_fetch_array($result );
4. $search = array('_', ',');
5. $replace = array(' ', ', ');
6. $rows = str_replace($search, $replace, $row);
7. $explodedColorsLove = explode(', ', $rows['colors_love']);
8. ?>

1. <td bgcolor=#000000 class="Colorbox input_field" onclick="toggle_colorbox(this);">
2. <div class=Check>&#10003;</div>
3. <input type="checkbox" name="colors_love[]" value="Black" class="cbx"
4. <?php if(in_array("Black", $explodedColorsLove)) echo "checked='checked'"; ?> /></td>         
   

1. <script>
2.           $(function () {
3.               var selectColorbox = function () {
4.                   // scope (this) is .Colorbox (expected to be a td)
5.                   var select = !$(this).hasClass('ColorboxSelected');
6.                   $(this).toggleClass('ColorboxSelected', select)
7.                   // check or uncheck the checkbox...
8.                 .find('.cbx').prop('checked', select);
9.                   return false; // no need to let the click go any further up
10.               };
11.               // this assumes that your color boxes are all within tr.account_rows elements...
12.               $('tr.account_rows').on('click', '.Colorbox', selectColorbox);
13.           });
14.      </script>

1. <?php
2. $Colors = array(
3.  'Black' =>'#000000',
4.  'Charcoal' =>'#666666',
5.  'Light_Gray' =>'#999999',
6.  // and so on, thru to ...
7.  'Tiffany_Blue' =>'#4EE2EC'
8.     );
9. $result = mysql_query("SELECT * FROM style WHERE style.user_id=$user_id")
10.         or die(mysql_error());
11. $row = mysql_fetch_array($result );
12. // convert the 'colors_love' field to an array without doing any string replacements...
13. $colors_love = explode(',', $rows['colors_love']);
14. $search = array('_', ',');
15. $replace = array(' ', ', ');
16. $rows = str_replace($search, $replace, $row);
17. ?>

Wizzud, The visibility toggles between Rows 1 & 2 in the table; Row 1 displays only the values that are in the database for that customer (currently in text format, but will be replaced with color boxes as soon as this works ;-) ), and Row 2 shows all available choices and preselects the values in the database.

1. <table cellPadding=0 cellSpacing=0 width=100% >             
2. <tr class="account_rows textbox_toggle" valign="top"><td class="account_fields" style="width:7%"><label>Like:</label></td><td class="customer_data_field textbox_toggle"><?php echo $rows['colors_love']; ?></td></tr>
3. <tr class="account_rows" valign="top"><td class="account_fields" style="width:7%"><label>Like:</label></td>
4. <?php
5. foreach($Colors as $cname=>$ccode){
6.     $checked = in_array($cname, $colors_love);
7. ?>
8. <td bgcolor="<?php echo $ccode; ?>"
9.         title="<?php echo str_replace('_', ' ', $cname); ?>"
10.         class="Colorbox input_field<?php echo $checked ? ' ColorboxSelected' : ''; ?>">
11.     <div class="Check">&#10003;</div>
12.     <input type="checkbox" class="cbx"
13.         name="colors_love[]" value="<?php echo $cname; ?>"
14.         <?php echo $checked ? 'checked="checked"' : ''; } ?> />
15. </td>
16.   </tr>       
17. </table>

1. <?php
2.     //initialize a counter
3.     $count = 0;
   
4.     foreach($Colors as $cname=>$ccode){
5.     $checked = in_array($cname, $colors_love);
   
6.      //if it's divisible by 6 then we echo a new row
7.      if(($count % 6) == 0)  {
8.         echo("</tr><tr>\n");
9.         $count++;
10.         }else {
11.         $count++;
12.     }
    
13. ?>

Switching the code and adding the class did it :-D Out of curiosity, why does if( $count > 0 && $count % 6 == 0) work, and if(($count % 6) && $count != 0) which I'd also tried, but forgot to mention, not work?

Also, there's one final thing to get this working perfectly - It adds all the selected fields, but it doesn't allow unselecting all (if one selection is left selected it's fine but if I unselect all then it won't unselect anything). Any idea what could be causing that?

1. <?php
2. require_once('auth.php');
3. require_once('config.php');
4. $user_id = $_SESSION['SESS_USER_ID'];
5. // INSERT
6. $fieldlist=$vallist='';
7. foreach ($_POST as $key => $value) {
8. if ($key=='colors_love'){
9.      serialize($value);
10.      $value= implode(',',$value);
11.      } 
12.      $fieldlist.=$key.',';
13.      $vallist.='\''.($value).'\',';
14. }
15. $fieldlist=substr($fieldlist, 0, -1);
16. $vallist=substr($vallist, 0, -1);
17. $fieldlist.=', user_id';
18. $vallist.=','.$user_id;
19. // UPDATE
20. $setlist='';
21. foreach ($_POST as $key=>$value){
22. if ($key=='colors_love'){
23.      serialize($value);
24.      $value= implode(',',$value);
25.      } 
26. $setlist.=$key .'=\''.$value.'\',';
27. }
28. $setlist=substr($setlist, 0, -1); 
29. $result = mysql_query('UPDATE style SET '.$setlist.' WHERE user_id='.$user_id);
30. if (mysql_affected_rows()==0) {
31. $result = mysql_query('INSERT INTO style ('.$fieldlist.') VALUES ('.$vallist.')');
32.     } 
33.   header("location: member_account_iframe.php");
34. exit();
35. ?>

  And then on member_account_iframe.php I have the code which you're familiar with:

1. <?php
2. $Colors = array(...);
3. $result = mysql_query("SELECT * FROM style WHERE style.user_id=$user_id")
4.         or die(mysql_error());
5. $row = mysql_fetch_array($result );
6. // convert Checkbox Arrays elements to an array without doing any string replacements...
7. $colors_love = explode(',', $row['colors_love']);
8. $search = array('_', ',');
9. $replace = array(' ', ', ');
10. $rows = str_replace($search, $replace, $row);
11. ?>

1. if ($key=='colors_love'){
2.      $value= implode(',',$value);
3.      } 
4. if ($key=='colors_hate'){
5.      $value= implode(',',$value);
6.      } 

1. if(!isset($_POST['colors_love'])){
2.     $_POST['colors_love'] = array();
3. }
4. if(!isset($_POST['colors_hate'])){
5.     $_POST['colors_love'] = array();
6. }