Location: PHPKode > scripts > PHP Scaffolder > php-scaffolder/fields.php
<?php
/**
* Php Scaffolder: A tool to generate CRUD functionality
*
* Copyright 2009, Syed Abdul Baqi, hide@address.com
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*
* @package php scaffolder
* @author Syed Abdul Baqi <hide@address.com>
*/

include 'includes/config.php';

$msg = '';
if(!isset($_SESSION['table']))
{
  header('Location: index.php');
  exit;
}

$ss_fields = array();
if(isset($_POST['btnSubmit']))
{
  if(isset($_POST['primary']) && $_POST['primary'] != '')
  {
    $all_fields = array();
    foreach($_SESSION['field'] as $fields)
    {
      if(isset($_POST[$fields]) && $_POST[$fields] != "0")
        $all_fields[$fields] = $_POST[$fields];
        
      if(isset($_POST['list_' . $fields]))
        $list_fields[$fields] = $_POST[$fields];

      if(isset($_POST['view_' . $fields]))
        $view_fields[$fields] = $_POST[$fields];

      if(isset($_POST['edit_' . $fields]))
        $edit_fields[$fields] = $_POST[$fields];

      if(isset($_POST['ss_' . $fields]) && $_POST['ss_' . $fields] != "0")
        $ss_fields[$fields] = $_POST['ss_' . $fields];
    }
//print_r($ss_fields); exit;
    include 'includes/base.class.php';
    include 'includes/scaffold.class.php';
    
    $settings = array(
                       'database'     => $_SESSION['database'],
                       'table'        => $_SESSION['table'],
                       'all_fields'   => $all_fields,
                       'list_fields'  => $list_fields,
                       'view_fields'  => $view_fields,
                       'edit_fields'  => $edit_fields,
                       'ss_fields'    => $ss_fields,
                       'primary'      => $_POST['primary']
                     );

    $scaffold = new Scaffold($settings);
    $scaffold->generateCode();
    header('Location: ' . $_SESSION['table'] . '/' . $_SESSION['table'] . '.php');
    exit;
  }
  else
  {
    $msg = 'Table doesn\'t contain any primary key!';
  }
}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <meta name="generator" content="PSPad editor, www.pspad.com">
  <title></title>
  <script type="text/javascript">
    function checkField(field)
    {
      var name = field.name;
      var val  = field.value;
      
      if(val == 0)
      {
        document.getElementById('list_' + name).disabled = true;
        document.getElementById('view_' + name).disabled = true;
        document.getElementById('edit_' + name).disabled = true;
        document.getElementById('ss_' + name).disabled = true;

        document.getElementById('tr_' + name).style.background = "#cdcdcd";
      }
      else
      {
        document.getElementById('list_' + name).disabled = false;
        document.getElementById('view_' + name).disabled = false;
        document.getElementById('edit_' + name).disabled = false;
        document.getElementById('ss_' + name).disabled = false;

        document.getElementById('tr_' + name).style.background = "";
      }
    }
  </script>
  </head>
  <body>
    <?=$msg?>
    <form name="frmFIELDS" action="" method="post">
      <table border="1px">
        <tr>
          <td align="center" colspan="6"><h1>TABLE FIELD TYPES</h1></td>
        </tr>
        <tr>
          <td align="center"><strong>Field</strong></td>
          <td align="center"><strong>Type</strong></td>
          <td align="center"><strong>List</strong></td>
          <td align="center"><strong>View</strong></td>
          <td align="center"><strong>Edit/Add</strong></td>
          <td align="center"><strong>Validations</strong></td>
        </tr>
        <?php
          $fields = array();
          $sqlD = 'show columns from ' . $_SESSION['table'];
          $qryD = mysql_query($sqlD) or die('Error: ' . mysql_error());
          while($qryDResult = mysql_fetch_array($qryD))
          {
            $fields[] = $qryDResult[0];
            
            if($qryDResult['Key'] == 'PRI')
            {
        ?>
              <input type="hidden" name="primary" value="<?=$qryDResult[0]?>" />
              <tr>
                <td><?=$qryDResult[0]?></td>
                <td>
                  <strong>PRIMARY KEY</strong>
                </td>
              </tr>
        <?php
            }
            else
            {
        ?>
            <tr id="tr_<?=$qryDResult[0]?>">
              <td><?=$qryDResult[0]?></td>
              <td>
                <select name="<?=$qryDResult[0]?>" onchange="return checkField(this);">
                  
                  <?php foreach($type_arr as $key => $value): ?>
                  <option value="<?=$key?>"><?=$value?></option>
                  <?php endforeach; ?>
                </select>
              </td>
              <td>
                <input type="checkbox" name="list_<?=$qryDResult[0]?>" id="list_<?=$qryDResult[0]?>" checked/>
              </td>
              <td>
                <input type="checkbox" name="view_<?=$qryDResult[0]?>" id="view_<?=$qryDResult[0]?>" checked/>
              </td>
              <td>
                <input type="checkbox" name="edit_<?=$qryDResult[0]?>" id="edit_<?=$qryDResult[0]?>" checked/>
              </td>
              <td>
                <select name="ss_<?=$qryDResult[0]?>" id="ss_<?=$qryDResult[0]?>">
                  
                  <?php foreach($ss_arr as $key => $value): ?>
                  <option value="<?=$key?>"><?=$value?></option>
                  <?php endforeach; ?>
                </select>
              </td>
            </tr>
        <?php
            }
            $_SESSION['field'] = $fields;
          }
        ?>
        <tr>
          <td colspan="6"><br /><input type="submit" name="btnSubmit" value="NEXT>>>"></td>
        </tr>
      </table>
    </form>
  </body>
</html>
Return current item: PHP Scaffolder