Thread

no errors here, works out of the box, although its not oracle :(

May be the problem is that config.php should be adjusted. Because I don´t use a localhost server, I changed the

$config[‘base_url’]  = “http://pandora/iScaffold/”;

and everything worked!

A suggestion for the source code formating: there are several lines using hard tabs - Ascii 9 -, changinging that with spaces will avoid the problem of different behavoir with different tab size inside editors.

iScaffold is a great idea, not only giving a starting point to a more complex program, but giving to begginers a great lesson.

Regards and thanks

I have this problem with the generated code of iScaffold. I need help with the weird value the flashdata returns.

http://ellislab.com/forums/viewthread/126963/

Great work dude… Let try and test it.

I am trying to use iScaffold with a mysql DB.

I downloaded the ZIP file and uncompressed it my htdocs. I then changed the password setting in database.php.

When I load http://localhost/iScaffold, all I get is a blank screen.  I am sure the password is correct.

Can someone help?

thank you
————————————-

here’s the contents of my database.php (with the opening and ending <?php and comments)
————————————
$active_group = “lab_test_1”;
$active_record = TRUE;

$db[‘lab_test_1’][‘hostname’] = “localhost”;
$db[‘lab_test_1’][‘username’] = “root”;
$db[‘lab_test_1’][‘password’] = “qwerty”;
$db[‘lab_test_1’][‘database’] = “mysql”;
$db[‘lab_test_1’][‘dbdriver’] = “mysql”;
$db[‘lab_test_1’][‘dbprefix’] = “”;
$db[‘lab_test_1’][‘pconnect’] = TRUE;
$db[‘lab_test_1’][‘db_debug’] = TRUE;
$db[‘lab_test_1’][‘cache_on’] = FALSE;
$db[‘lab_test_1’][‘cachedir’] = “”;
$db[‘lab_test_1’][‘char_set’] = “utf8”;
$db[‘lab_test_1’][‘dbcollat’] = “utf8_general_ci”;
————————————

Trying to make it work. It couldn’t connect to database.
I saw you got

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

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

replacing with

$this->load->database();

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

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%<textarea>%TEXTAREA_VALUE%</textarea>%/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.

// 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!

Hi,

  I added a new template variable: %MODEL_ROW_ARRAY%

It creates an output like this:

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.

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 😊

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:

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

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

<p>            { $galleries_data.%FIELD_ID% }<br />
        </li><br />
    %/FIELD_LOOP%<br />
</ul>

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

/*************************
     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…

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 😊

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

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

Cheers, thank you very much !
Dave

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?