phpMyEdit Configuration Options

So much information on phpMyEdit was compiled that the php-form-generator.com web site was created in 2006.

Below are some older examples of filters for phpMyEdit forms. Variables used in most filters can be passed from another form, or from a link included in the page footer.

<a href="my_form.php?ltr=A">A</a>

In the requested form, process the variable and make it persistent across various page modes (Next, Previous, Search, Cancel).

$ltr = @$_REQUEST['ltr'];

$opts['cgi']['persist'] = array('ltr' => $ltr );

$opts['filters'] = 'company REGEXP "^'.$ltr.'"';

In the following example, a sessions script passes $valid_user. Also, a column named valid_user exists in the database table. Only those records accessible to $valid_user and fictitious user 'public' will be displayed using the following filter.

$opts['filters'] = 'valid_user = "'.$valid_user.'" OR valid_user = "public"';

$opts['cgi']['persist'] = array('valid_user ' => $valid_user );

The following example configures a persistent table level filter for one record id passed to the requested form using <a href="my_form.php?ltr=A&operation=View&id=1">ID #1</a>. This record remains filtered even if user clicks Cancel to leave View mode.

array_key_exists('id',$_GET) ? $id = $_GET['id'] : $id = $rec;

$opts['cgi']['persist'] = array('id' => $col_name);

$opts['filters'] = $id > 0 ? "col_name = '$id'" : '';

The following is a template for configuring different filters based on the numeric value associated with a variable named $xfl which is passed to the requested form through a link from another page, or from a link in the page footer.

$xfl = @$_REQUEST['xfl'];

if($xfl > 0){
   $opts['cgi']['persist'] = array('xfl' => $xfl);
}

switch($xfl){
   Case 1:
      $opts['filters'] = ''; // edit
      break;
   Case 2:
      $opts['filters'] = ''; // edit
      break;
   Case 3:
      $opts['filters'] = ''; // edit
      break;
   Case 0:
   default:
      break;
}

The database connection is closed by phpMyEdit.class.php. Thus, in order to run separate database queries in the page footer you need to reopen a connection or comment out $this->disconnect(); in the class file.

With PHP in general, declaring configuration variables using an array format like $opts['db'] for the database name has advantages over using a format like $db and $hn. For example, when variables are required by a function, you merely need to call global $opts; instead of global $db, $un, $pw, $hn;.

phpMyEdit requires the first column in the database table contain unique data, thus it is wise to always define MySQL™ column 0 as a numeric autoincrement column.

Additional information is available at the phpMyEdit Forum.