Skip to content

rohit-chouhan/ci-crud-snippet

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Generate complete dynamic select,insert,update,delete normally, and with ajax using this great snippet.

If you are using Ajax, please embed JQuery inside your <head> tag.

<script src="https://code.jquery.com/jquery-3.6.0.js"></script>

Install form Here

https://marketplace.visualstudio.com/items?itemName=rohit-chouhan.ci-crud-snippet

Usage (Database Connection)

Syntax Description
$ci-conn Create db connection

Usage (Insert, Update, Delete)

Syntax Description
$ci-ajax Ajax Code
$ci-insert Insert Code
$ci-insert-ajax Insert Code for Ajax
$ci-update Update Code
$ci-update-ajax Update Code for Ajax
$ci-delete Delete Code
$ci-delete-ajax Delete Code for Ajax

Usage (Select)

Syntax Description
$ci-select Retreving data
$ci-select-single Retreving Single Row data
$ci-column Retreving Specific Column data
$ci-where Retreving data with Where claus
$ci-like Retreving data with Like claus
$ci-count Row count from Table

Functions (Select)

Syntax Description
$ci-selectMax Retreving Max Value
$ci-selectMin Retreving Min Value
$ci-selectAvg Retreving Avg Value
$ci-selectSum Retreving Sum Value
$ci-selectCount Retreving Count Value

Input/Output

title

1.0.0
- Initial release

1.0.1 (16/07/2021)
- Bug fixed

1.0.2 (17/07/2021)
- Select Max Added
- Select Min Added
- Select Avg Added
- Select Sum Added
- Select Count Added