Discontinued

[eluser]Vangelis B[/eluser]
Trying to make it work. It couldn't connect to database.
I saw you got

Code:

$this->load->database('lab_test_1');

in controllers/generate.php line 46 and models/model_iscaffold.php line 22.

replacing with

Code:

$this->load->database();

did the trick. You may want to correct it as well.

[eluser]Kow[/eluser]
Hello Herrakleun,

Gratulations for you nice job, I'm looking long for an ultimate CRUD solution for a long time, and I think this will help me a lot in the future. I have some suggestions for the next releases:

- intelligent form generation.
TEXTAREA for text db fields, SELECT for enums, checkbox for BOOLEAN or int(1) fields.
- Better form control %TABLE_INPUTS%
I'm using smarty templates with CI, so I still have to create the views by hand, but It's not a big problem, they always need work.

Maybe:
%TABLE_INPUTS%
%INPUT%<input name="username" value="">%/INPUT%
%SELECT%<select name="user_level">%OPTIONS%</select>%/SELECT%
%TEXTAREA%&lt;textarea&gt;%TEXTAREA_VALUE%&lt;/textarea&gt;%/TEXTAREA%
%/TABLE_INPUTS%

- documentation
- provide a search function in the demo model
- add pagination to the enroll model
- realtion mapper config file
maybe it can help automatically create relations for tables.

Code:

// This is a 1:1 relation and should produce a $this->db->join('groups', 'users.group_id = groups.group_id')
   $iScaffold['relations'][] = array( 'users.group_id', array( 'groups.group_id','groups.group_name' );

Creating the template language can get tricky with advanced mapping, but not impossible.

Cheers!

[eluser]Kow[/eluser]
Hi,

I added a new template variable: %MODEL_ROW_ARRAY%

It creates an output like this:

Code:

foreach ( $query->result_array() as $row )
        {
            $temp_result [] = array(
    $row['g_category_id'],
    $row['g_title'],
    $row['g_thumb'],
    $row['g_type'],
    $row['g_rel_prods'],
    $row['g_link'],
    $row['g_banner_id'],
    $row['g_ts'],
);
        }
        return $temp_result;

It can be useful, because you can modify the data more easily like adding a DATE() function or creating extra variables like $row['seo_url'] based on existing values.

[eluser]The Wizard[/eluser]
Hello kow
i am happy it helped you.

feel free to modify the code for your own use and you may feel happy to
post it to the google code too.

take care

[eluser]Kow[/eluser]
I took the project a bit further meanwhile:

- Added %FIELD_LOOP% %/FIELD_LOOP% support

I'm using Template lite with codeigniter, and this is a view for me:

Code:

<h3>Details of { $table_name }, record #{ $id }</h3>

<ul>
    %FIELD_LOOP%
        <li>
            <strong>{ $%NAME_TABLE%_fields.%FIELD_COUNT% }:</strong><br />
            { $galleries_data.%FIELD_ID% }
        </li>
    %/FIELD_LOOP%
</ul>

- Auto generated language file for table field names. It creates file like this:

Code:

/*************************
     Table: Banners
*************************/
$lang['b_id'] = '';
$lang['b_name'] = '';
$lang['b_file'] = '';
$lang['b_link'] = '';
$lang['b_clicks'] = '';


/*************************
     Table: Categories
*************************/
$lang['cg_id'] = '';
$lang['cg_name'] = 'Category name'; // example nameing
$lang['cg_parent'] = '';

In my version, the filed names are matched in the model.

- I also added pagination to the model templates

As soon as I complete the saving and editing modifications I contact you.

I work on a form configurator now, to create checkboxes, selects, textareas and so on...

[eluser]The Wizard[/eluser]
Wow, you quite impress all of us

feel free to complete your version and add your name to the developer list.

i appreciate your doing, thank you

[eluser]Dave Porter[/eluser]
Hi everyone,

New to CI and read this thread with interest...

But where do you get the latest version of iScaffold ?
The download link shows the file is way back in May !

cheers Dave

[eluser]Kow[/eluser]
Hello,

You can grab the code here: http://code.google.com/p/ci-crud-generator/

Version 2.0 is on the way, please stay tuned It will be released before Xmas.
http://tibor.szasz.hu/post/iscaffold-20-preview/28

[eluser]Dave Porter[/eluser]
Cheers, thank you very much !
Dave

[eluser]Unknown[/eluser]
I really want to try iScaffold out but every time I click generate I get this error:

An Error Was Encountered
The URI you submitted has disallowed characters.

It does that no matter what I try to change. Anyone have any ideas on what could be causing it?