Customizable CRUD

[eluser]Atasa[/eluser]
Hey guys this is getting interesting...
My point of view is that we can discuss different ways and alternatives for ever.
Lets start from what we have already.
We have CI.
Then we check whether is OK this tool to work on.
Remember this is not an easy job.
I have looked for quite sometime now in frameworks, html generators, template systems etc.
The first thing that clicks to your mind when you see a framework is the philosophy it is based on.
If we have decided to use CI so lets see how far we can go, and if that is expensive too.
I also thing that some logic sould go also at the database it self.
One good example is the mysql database in MySql.

suashi you can try the following as well:

Code:

<?php

class Welcome extends Controller {
    
    
    function Welcome()
    {
        parent::Controller();
        $this->load->library('table');
        $this->load->helper('form');
        $this->load->helper('url');    
        
    }
    
    function index()
    {
    
    $form = array(
        'Row1' => array(
            'FIELD_NAME' => 'field1',
            'FORM_CAPTION' => 'Text for field1',
            'DEFAULT_VALUE' => 'enter text here',
            'EDIT_TYPE' => 'input',
            'LOOKUP_COMMAND' => ''
        ) ,
        'Row2' => array(
            'FIELD_NAME' => 'field2',
            'FORM_CAPTION' => 'Text for field2',
            'DEFAULT_VALUE' => 'Please make a Selection',
            'EDIT_TYPE' => 'select',
            'LOOKUP_COMMAND' => array ('key1'=>'value1','key2'=>'value2','key3'=>'value3')
        ) ,
        'Row3' => array(
            'FIELD_NAME' => 'field3',
            'FORM_CAPTION' => 'Please write your Details',
            'DEFAULT_VALUE' => '',
            'EDIT_TYPE' => 'textarea',
            'LOOKUP_COMMAND' => ''
        )
    );

    $oform = form_open('email/send')."\n";    
    $oform .= $this->table->set_heading('Name', 'Value');
    
    function BuildForm($myform)    
    {
        $mytable = &get;_instance();
        foreach ($myform as $array)
        {
            switch ($array['EDIT_TYPE'])
            {
                case 'input':
                $options = array('name' => $array['FIELD_NAME'], 'value' => $array['DEFAULT_VALUE'], 'maxlength' => '50');
                $mytable->table->add_row($array['FORM_CAPTION'], form_input($options));
                break;

                case 'textarea':
                $options = array('name' => $array['FIELD_NAME'],'value' => $array['DEFAULT_VALUE'],'rows' => '7','cols' => '50');
                $mytable->table->add_row($array['FORM_CAPTION'], form_textarea($options));
                break;

                case 'select':
                $mytable->table->add_row($array['FORM_CAPTION'], form_dropdown($array['FIELD_NAME'], $array['LOOKUP_COMMAND']));
                break;                                
            }
        }
    
    }
    BuildForm($form);
    
    $oform.= $this->table->generate();
    $oform.= form_reset('myreset', 'Reset Fields');
    $oform.= form_submit('mysubmit', 'Submit Post!');
    $oform.= "\n <br/>" . form_close() ;
    echo $oform;
    }//endIndex
    
    
}
?&gt;

It's small sample of binding an array to a form generator class.
for the sake of the example I have created a subfunction and used &get;_instance() method.
you can just run it by it self and see the results.

Very easy right?