Articles → PHP CODEIGNITER → Crudigniter

Crudigniter

Purpose

Table Script

CREATE TABLE Customers (
  customer_id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
  customer_namevarchar(100), 
  customer_contact_numbervarchar(20), 
  customer_alternative_numbervarchar(20), 
  customer_email_idvarchar(50), 
  customer_addressvarchar(200), 
  customer_emergency_numbervarchar(20)
)

Steps

1. Navigate to the URL - http://www.crudigniter.com/
2. Login to the portal.
3. On the home screen, click on the "Upload SQL file.." button to select the table script.

Click to Enlarge


4. You can see the list of tables. In this example, we have defined only one table. So, select the table using the "select table".

Click to Enlarge


5. In the next window, we can specify different settings like controller file name, model file name, field controls before the code generation.

Click to Enlarge


6. Click on the "Continue to Naming & Options" button.
7. There is another option for some more settings.

Click to Enlarge


8. Finally, click on the "Get Code" button for getting the code.
9. Here is the generated code.

Click to Enlarge