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.
  4. Picture showing the home screen to upload the script file

    Click to Enlarge

  5. You can see the list of tables. In this example, we have defined only one table. So, select the table using the "select table".
  6. Picture showing the list of tables from the script file

    Click to Enlarge

  7. In the next window, we can specify different settings like controller file name, model file name, field controls before the code generation.
  8. Picture showing the configuration settings

    Click to Enlarge

  9. Click on the "Continue to Naming & Options" button.
  10. There is another option for some more settings.
  11. Picture showing the project options for more configuration

    Click to Enlarge

  12. Finally, click on the "Get Code" button for getting the code.
  13. Here is the generated code.
  14. Picture showing the code generated for a given table schema

    Click to Enlarge



Posted By  -  Karan Gupta
 
Posted On  -  Tuesday, January 5, 2021

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250