Take social security number for example. Anyone use a method to decrypt the field before displaying on member profile page, then encrypt upon INSERT or UPDATE?

Wouldn't something simple like that help secure MySQL data should it be breached?

I am using CMSB version 2.61 and iOS 8.4.1  on an iPhone 4S and the checkboxes in CMS are dead. 

 I realize the iPhone is not the primary platform for updating my website but it would be nice to be able to use it in a pinch. 

foreach (@$_POST['roomSelect'] as $key => $value) {

    $update = mysql_query("
      UPDATE $studentTable
      SET `room` = '$value'
      WHERE `recid` = '$key'
      LIMIT 1
      ") or die(mysql_error());

    } // end foreach

...is updating db ok but it's throwing an error...

Notice: Undefined offset: 0 in /home/spapwc5/public_html/cms/lib/viewer_functions.php on line 1030

Am I missing with CMS functions? Any help would be appreciated.

With many users and changing section access it is necessary to keep track of who has access to what. Every year I have large staff turnover and it is more than a notion to hunt down and change the section access. Need to use a secondary source to keep track.

Would be very helpful to have a list of sections and ability to see all those users that have access thereto.

My question is is it possible to search for an empty or null value, e.g. color = '', as one of the multiple variables?

is it possible to do a url search for color = 'blue' and size = ''

(i.e. the size is blank)

I am trying to write something like... page.php/status-Open/decision_value- ?

Weirdness like... the thumbnail is a copy of  the live webpage.

Can uploadForm3_iframe.php escape it?

E.g. search for who has editor access to table x

It if matters, this topic can therefore be moved to the general forum.

Btw, I'm using the readfile() snippet in order to load a file stored in directory above public_html. Like I wrote, it works great until I load the viewer.

Can you think of why securing the page is messing with the latter code? See any options I could try to unfetter the readfile() ?

require_once '/myhost/public_html/cmsAdmin/lib/viewer_functions.php';
if (!$CURRENT_USER) {websiteLogin_redirectToLogin();}

if (file_exists($file)) {
    header('Content-Description: File Transfer');
    header('Content-Type: application/pdf');
    header('Content-Disposition: inline; filename='.basename($file));
    header('Content-Transfer-Encoding: binary');
    header('Expires: 0');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    header('Content-Length: ' . filesize($file));
    ob_clean();
    flush();
    readfile($file);
    exit;
    } // endif

Is the css for the id above above from createPDF or from CMSB?