CRUD SYSTEM for CodeIgniter and MySQL
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
codeigniter/application
excrud.md.img
excrud
img_src
readme.md

readme.md

EX_CRUD

EX_CRUD : CRUD SYSTEM for CodeIgniter and MySQL

  • Easy Customizable ( using Bootstrap + Twig Template )
  • You can use CRUD + Search + Execute SQL

● Install EX_CRUD

1. upload files to your server

  • codeigniter/application/
  • /excrud

2. configure config.php , database.php

  • codeIgniter/application/config/config.php
$config['base_url'] = 'http://YOUR_SITE_NAME/';
  • codeIgniter/application/config/database.php

3. change directory permission (0777)

chmod 0777 codeigniter/application/excrud

● Start EX_CRUD

access excrud_admin Controller

ex) http://YOUR_SITE_NAME/excrud_admin
ex) http://YOUR_SITE_NAME/index.php/excrud_admin

● Configure ex_crud

1. Create Json file "___sample___override.json"

select menu "Config > Create Json Sample"

2. Rename Json file "___sample___override.json" to "override.json"

cd codeIgniter/application/excrud/
mv ___sample___override.json  override.json

3. Edit "override.json"

4. re create Json file

select menu "Config > Json re-create"

● How to edit override.json

ex

	"test_dt": {
		"visible_flg"   : 0 ,
		"order_by"      : "test_id ASC",
		"search_columns": [
			"user_name"
		],

      "table_desc": {
        "test_id": {
            "view_list_title": "テーブルID"
        },
        "user_name": {
            "view_list_title": "ユーザー名"
        }
      }
  } ,
  "item_dt": {
      "visible_flg": 0 ,
      "table_desc": {
        "item_id": {
            "view_list_title": "商品ID"
        },
        "item_name": {
            "view_list_title": "商品名"
        }
      }
  }

override.json properties

property value(s)
visible_flg 1 ( show this table ) ( default )
0 ( hide this table )
order_by ORDER BY in list view
search_columns search columns

override.json(table_desc)properties

property value(s)
tabe_header table header title
view_add_flag 1 ( show in add view ) ( default )
0 ( hide in edit view )
view_edit_flag 1 ( show in edit view ) ( default )
0 ( hide in edit view )
view_delete_flag 1 ( show in delete view ) ( default )
0 ( hide in delete view )
editable_flag 1 ( editable ) ( default )
0 ( can not edit )
input_type text ( default )
select
checkbox
radio
textarea
input_type_css width:300px;height:500px;
input_values values for select, checkbox
view_list_flag 1 ( show in list view ) ( default )
0 ( hide in list view )
view_list_title title for list view
view_list_format format for list view
( You can use variables
{{data}}, {{z['db_column_name']}} )
view_list_nowrap_flag 0 ( wrap )( default )
1 ( no wrap )
multiple_edit_flag 1 ( show in multipile edit )
0 ( hide in multipile edit ) ( default )

ex) input_type : "checkbox"

"my_flg": {
    "input_type"     : "checkbox" ,
    "input_values"   : [
      { "name"  : "my_flag_label" , "value" : 1 }
    ]
},

ex) input_type : "select"

"my_country": {
    "input_type"     : "select" ,
    "input_values"   : [
      { "name"  : "USA"       , "value" : "USA" } ,
      { "name"  : "Brazil"    , "value" : "Brazil" } ,
      { "name"  : "France"    , "value" : "France" } ,
      { "name"  : "Australia" , "value" : "Australia" } ,
      { "name"  : "Canada"    , "value" : "Canada" } 
    ]
},

ex) input_type : "radio"

"my_country": {
    "input_type"     : "radio" ,
    "input_values"   : [
      { "name"  : "male"     , "value" : "male" } ,
      { "name"  : "female"   , "value" : "female" } 
    ]
},