{"id":79,"date":"2016-05-10T13:35:27","date_gmt":"2016-05-10T13:35:27","guid":{"rendered":"http:\/\/symbioticindia.in\/docu\/?p=79"},"modified":"2016-05-10T13:35:27","modified_gmt":"2016-05-10T13:35:27","slug":"introduction-to-codeigniter-basic-with-crud","status":"publish","type":"post","link":"http:\/\/symbioticindia.in\/docu\/2016\/05\/10\/introduction-to-codeigniter-basic-with-crud\/","title":{"rendered":"Introduction to CodeIgniter Basic With CRUD"},"content":{"rendered":"<h1>Introduction to CodeIgniter Basic With CRUD<\/h1>\n<p>CodeIgniter (CI) is one of popular php framework. If you are already building PHP Application, CodeIgniter will help you to do it better and more easily. With CodeIgniter, you can save time, make your web more robust, your code will be easier to read and maintenance. It is free, lightweight, and simple to install. In this post, we will know more deep about CodeIgniter before write code.<span id=\"more-1168\"><\/span><br \/>\nNice, CodeIgniter is small and lightweight framework. You don\u2019t need long time to download it. You can get it from http:\/\/www.codeigniter.com. CI was written by Rick Ellis, rock musician turned programmer.<br \/>\nWith CodeIgniter, you can cut down the amount of code you need to type. This is not just good for lazy, but: less type, fewer mistake, and less time for spend debugging.<br \/>\nBut, CodeIgniter is not everything. We will not find \u2018engine generator\u2019 that can build page self. Several frameworks have features like that. For example, they can create web page (that to do basic Create, Read, Update, and Delete operation) automatically. CodeIgniter doesn\u2019t do this.<br \/>\nThis, I copy from their help page: \u201cOur goal for CodeIgniter is <strong>maximum performance, capability, and flexibility in the smallest, lightest possible package<\/strong>.<br \/>\nFrom a technical and architectural standpoint, CodeIgniter was created with the following objectives:<\/p>\n<ul>\n<li><strong>Dynamic Instantiation<\/strong>. In CodeIgniter, components are loaded and routines executed only when requested, rather than globally. No assumptions are made by the system regarding what may be needed beyond the minimal core resources, so the system is very light-weight by default. The events, as triggered by the HTTP request, and the controllers and views you design will determine what is invoked.<\/li>\n<li><strong>Loose Coupling<\/strong>. Coupling is the degree to which components of a system rely on each other. The fewer components depend on each other the more reusable and flexible the system becomes. Our goal was a very loosely coupled system.<\/li>\n<li><strong>Component Singularity<\/strong>. Singularity is the degree to which components have a narrowly focused purpose. In CodeIgniter, each class and its functions are highly autonomous in order to allow maximum usefulness.<\/li>\n<\/ul>\n<p>Nice feature, CodeIgniter is very flexible. We can apply at PHP 4.3.2 and above, or PHP 5.0 or above. CI support serveral database: MySQL, MySQLi, MS SQL, Postgre, Oracle, SQLite, and ODBC.<br \/>\nOk, now, we will learn how to install CodeIgniter.<br \/>\nFor this series i\u2019ll be using the latest version of CodeIgniter at the time of writing; 2.10.<br \/>\n<strong>Installation<\/strong><br \/>\n1. Head over to the CodeIgniter website <a href=\"http:\/\/codeigniter.com\/\">http:\/\/codeigniter.com\/<\/a> and download the source.<br \/>\n2. Extract the CodeIgniter files into an appropriate folder on your web server. if you want to work locally, use WAMP, MAMP or XAMPP.<br \/>\n3. Open your installation in a web browser and you should get the screen below.<br \/>\n<a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci1\/\" rel=\"attachment wp-att-1169\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1169\" title=\"CodeIgniter Basic Installation\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci1.jpg\" alt=\"CodeIgniter Basic Installation\" width=\"449\" height=\"465\" \/><\/a><br \/>\n<strong>Create your First Application with CodeIgniter<\/strong><br \/>\nAs usually, we will create first application by build hello application. But, before write code, we must know that we will build application use Model Controller View (MVC) pattern. First, we make controller, create a file name \u201chello.php\u201d within: CodeIgniter \\application\\controllers. Enter following code:<\/p>\n<div id=\"highlighter_439526\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code><code class=\"plain\">(!defined(<\/code><code class=\"string\">'BASEPATH'<\/code><code class=\"plain\">)) <\/code><code class=\"functions\">exit<\/code><code class=\"plain\">(<\/code><code class=\"string\">'No direct script access allowed'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">class<\/code> <code class=\"plain\">Hello <\/code><code class=\"keyword\">extends<\/code> <code class=\"plain\">CI_Controller{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">__construct(){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">parent::__construct();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">you(){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;view(<\/code><code class=\"string\">'you_view'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<ul>\n<li>\u00b7 Next step, make a view. Create you_view.php within <strong>codeigniter\\ application\\views<\/strong>. Enter just simple line code like:<\/li>\n<\/ul>\n<div id=\"highlighter_524596\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;!DOCTYPE html PUBLIC <\/code><code class=\"string\">\"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\"<\/code><code class=\"string\">\"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;html xmlns=<\/code><code class=\"string\">\"http:\/\/www.w3.org\/1999\/xhtml\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;meta http-equiv=<\/code><code class=\"string\">\"Content-Type\"<\/code> <code class=\"plain\">content=<\/code><code class=\"string\">\"text\/html; charset=utf-8\"<\/code> <code class=\"plain\">\/&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;title&gt;My First CodeIgniter Practice&lt;\/title&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;\/head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;h1&gt; HELLO CI Buddy...!&lt;\/h1&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;\/body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"plain\">&lt;\/html&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now, test your application. Point your browser to<strong>http:\/\/localhost\/codeigniter\/index.php\/Hello\/you<\/strong> You should get like this:<br \/>\n<a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci4\/\" rel=\"attachment wp-att-1170\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1170\" title=\"First CodeIgniter\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci4.jpg\" alt=\"First CodeIgniter\" width=\"412\" height=\"235\" \/><\/a><br \/>\nSee, this flow:<br \/>\n<a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci5\/\" rel=\"attachment wp-att-1171\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1171\" title=\"first codeigniter controller\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci5-500x337.jpg\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" srcset=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci5-500x337.jpg 500w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci5-444x300.jpg 444w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci5.jpg 572w\" alt=\"first codeigniter controller\" width=\"500\" height=\"337\" \/><\/a><\/p>\n<h1>Creating and Sending Parameters between Controller and View<\/h1>\n<p>Now we will build controller and view better. Create parameters in controller and send it to view. It will make our application more flexible.<\/p>\n<ol>\n<li>Create a file name hello2.php within <strong>codeigniter\/application\/controller<\/strong>. write become like this:<\/li>\n<\/ol>\n<div id=\"highlighter_470301\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code><code class=\"plain\">(!defined(<\/code><code class=\"string\">'BASEPATH'<\/code><code class=\"plain\">)) <\/code><code class=\"functions\">exit<\/code><code class=\"plain\">(<\/code><code class=\"string\">'No direct script access allowed'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">class<\/code> <code class=\"plain\">Hello2 <\/code><code class=\"keyword\">extends<\/code> <code class=\"plain\">CI_Controller{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><code class=\"comments\">\/\/ declare variables or class properties<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">var<\/code> <code class=\"variable\">$name<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">var<\/code> <code class=\"variable\">$color<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">__construct(){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">parent::__construct();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"comments\">\/\/ give default value<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;name=<\/code><code class=\"string\">\"Abir\"<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;color=<\/code><code class=\"string\">\"red\"<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">you(){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$data<\/code><code class=\"plain\">[<\/code><code class=\"string\">'name'<\/code><code class=\"plain\">]=<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;name;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$data<\/code><code class=\"plain\">[<\/code><code class=\"string\">'color'<\/code><code class=\"plain\">]=<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;color;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><code class=\"comments\">\/\/ define variable sent to views<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;view(<\/code><code class=\"string\">'you_view2'<\/code><code class=\"plain\">,<\/code><code class=\"variable\">$data<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>Next step, make a view. Create you_view2.php within <strong>codeigniter\\ application\\views<\/strong>. Enter just simple line code like:<\/li>\n<\/ol>\n<div id=\"highlighter_402927\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;!DOCTYPE html PUBLIC <\/code><code class=\"string\">\"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\"<\/code><code class=\"string\">\"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;html xmlns=<\/code><code class=\"string\">\"http:\/\/www.w3.org\/1999\/xhtml\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;meta http-equiv=<\/code><code class=\"string\">\"Content-Type\"<\/code> <code class=\"plain\">content=<\/code><code class=\"string\">\"text\/html; charset=utf-8\"<\/code> <code class=\"plain\">\/&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;title&gt;My First CodeIgniter Practice&lt;\/title&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;h1 style=<\/code><code class=\"string\">\"color:&lt;?php echo $color; ?&gt;\"<\/code><code class=\"plain\">&gt; Hello &lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$name<\/code><code class=\"plain\">; ?&gt;!&lt;\/h1&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/html&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Point your browser to http:\/\/localhost\/codeigniter\/index.php\/hello2\/you.<br \/>\n<a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci7\/\" rel=\"attachment wp-att-1172\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1172\" title=\"Creating and Sending Parameters between Controller and View\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci7.jpg\" alt=\"Creating and Sending Parameters between Controller and View\" width=\"410\" height=\"234\" \/><\/a><\/p>\n<h1>Getting Parameters from GET<\/h1>\n<p>Now, we will learn how to get parameter from GET. As we know, we can see this parameter from Url. Example: http:\/\/localhost\/index.php?name=Andi. Clear, we can get parameter name. How about in CodeIgniter?<\/p>\n<ol>\n<li>Ok, we learn by doing. Create a file name hello3.php within codeigniter\/\/application\/controller. write become like this:<\/li>\n<\/ol>\n<div id=\"highlighter_522828\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code><code class=\"plain\">(!defined(<\/code><code class=\"string\">'BASEPATH'<\/code><code class=\"plain\">)) <\/code><code class=\"functions\">exit<\/code><code class=\"plain\">(<\/code><code class=\"string\">'No direct script access allowed'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">class<\/code> <code class=\"plain\">Hello3 <\/code><code class=\"keyword\">extends<\/code> <code class=\"plain\">CI_Controller{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><code class=\"comments\">\/\/ declare variables or class properties<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">var<\/code> <code class=\"variable\">$name<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">var<\/code> <code class=\"variable\">$color<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">__construct(){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">parent::__construct();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"comments\">\/\/ give default value<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;name=<\/code><code class=\"string\">\"Faisal\"<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;color=<\/code><code class=\"string\">\"red\"<\/code><code class=\"plain\">;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">you(<\/code><code class=\"variable\">$firstname<\/code><code class=\"plain\">=<\/code><code class=\"string\">''<\/code><code class=\"plain\">, <\/code><code class=\"variable\">$lastname<\/code><code class=\"plain\">=<\/code><code class=\"string\">''<\/code><code class=\"plain\">)<\/code><code class=\"comments\">\/\/ Give variable that can GET value<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$data<\/code><code class=\"plain\">[<\/code><code class=\"string\">'name'<\/code><code class=\"plain\">]=(<\/code><code class=\"variable\">$firstname<\/code><code class=\"plain\">)?<\/code><code class=\"variable\">$firstname<\/code><code class=\"plain\">.<\/code><code class=\"string\">' '<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$lastname<\/code><code class=\"plain\">:<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;name;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$data<\/code><code class=\"plain\">[<\/code><code class=\"string\">'color'<\/code><code class=\"plain\">]=<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;color;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"comments\">\/\/ define variable sent to views<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;view(<\/code><code class=\"string\">'you_view2'<\/code><code class=\"plain\">,<\/code><code class=\"variable\">$data<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now, try point your browser to<a href=\"http:\/\/localhost\/codeigniter\/index.php\/hello3\/you\/Masud\/Alam\">http:\/\/localhost\/codeigniter\/index.php\/hello3\/you\/Masud\/Alam<\/a><br \/>\n<a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci8\/\" rel=\"attachment wp-att-1173\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1173\" title=\"Getting Parameters from GET\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci8.jpg\" alt=\"Getting Parameters from GET\" width=\"490\" height=\"234\" \/><\/a><\/p>\n<h1>Setting Base Url Configuration<\/h1>\n<p>Please, open config.php within codeigniter\\application\\config. Set config like below:<\/p>\n<p><a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci_crud7\/\" rel=\"attachment wp-att-1186\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1186\" title=\"CodeIgniter Configuration\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud7.jpg\" alt=\"CodeIgniter Configuration\" width=\"440\" height=\"105\" \/><\/a><\/p>\n<h1>Setting Database Configuration<\/h1>\n<p>Please, open database.php within codeigniter\\application\\config. Set config like below:<\/p>\n<p><a href=\"http:\/\/www.w3programmers.com\/?attachment_id=1175\" rel=\"attachment wp-att-1175\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1175\" title=\"CodeIgniter Database settings\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci9.jpg\" alt=\"CodeIgniter Database settings\" width=\"359\" height=\"158\" \/><\/a><\/p>\n<p>Make sure, it matches with your database.<\/p>\n<h2>Preparing Database<\/h2>\n<p>We will learn about showing data from database in CodeIgniter. But, before that, we prepare a database for practice. This post create a database named \u201cci_test\u201d and a table named \u201cusers\u201d. We use phpMyAdmin for easy.<\/p>\n<ol start=\"1\">\n<li>Open your phpmyadmin.<\/li>\n<li>Enter database name \u201cci_test\u201d in <strong>create new database<\/strong> field.<\/li>\n<li>Click Create button. Your database will be created.<\/li>\n<li>Create new table by running this query in your sql window:<\/li>\n<\/ol>\n<div id=\"highlighter_581169\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">CREATE<\/code> <code class=\"keyword\">TABLE<\/code> <code class=\"plain\">IF <\/code><code class=\"color1\">NOT<\/code> <code class=\"plain\">EXISTS `users` (<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">`id` <\/code><code class=\"keyword\">int<\/code><code class=\"plain\">(11) <\/code><code class=\"color1\">NOT<\/code> <code class=\"color1\">NULL<\/code> <code class=\"plain\">AUTO_INCREMENT,<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">`<\/code><code class=\"keyword\">name<\/code><code class=\"plain\">` <\/code><code class=\"keyword\">varchar<\/code><code class=\"plain\">(50) <\/code><code class=\"color1\">NOT<\/code> <code class=\"color1\">NULL<\/code><code class=\"plain\">,<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">`email` <\/code><code class=\"keyword\">varchar<\/code><code class=\"plain\">(100) <\/code><code class=\"color1\">NOT<\/code> <code class=\"color1\">NULL<\/code><code class=\"plain\">,<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">`address` <\/code><code class=\"keyword\">varchar<\/code><code class=\"plain\">(255) <\/code><code class=\"color1\">NOT<\/code> <code class=\"color1\">NULL<\/code><code class=\"plain\">,<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">`mobile` <\/code><code class=\"keyword\">varchar<\/code><code class=\"plain\">(15) <\/code><code class=\"color1\">NOT<\/code> <code class=\"color1\">NULL<\/code><code class=\"plain\">,<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">PRIMARY<\/code> <code class=\"keyword\">KEY<\/code> <code class=\"plain\">(`id`)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">) ENGINE=InnoDB <\/code><code class=\"keyword\">DEFAULT<\/code> <code class=\"plain\">CHARSET=latin1 AUTO_INCREMENT=16 ;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<ol start=\"1\">\n<li>Insert some sample data to your users table by running this query in your sql window:<\/li>\n<\/ol>\n<div id=\"highlighter_610666\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">INSERT<\/code> <code class=\"keyword\">INTO<\/code> <code class=\"plain\">`users` (`id`, `<\/code><code class=\"keyword\">name<\/code><code class=\"plain\">`, `email`, `address`, `mobile`) <\/code><code class=\"keyword\">VALUES<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">(1, <\/code><code class=\"string\">'Masud Alam'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'m@sud.com'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'ldsjfla lsdj lsdj flk'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'9879879'<\/code><code class=\"plain\">),<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">(2, <\/code><code class=\"string\">'Sohel Alam'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'al@m.com'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'Dhaka,Bangladesh,BD'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'09080'<\/code><code class=\"plain\">),<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">(8, <\/code><code class=\"string\">'Salim'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'salim.hossain@ebizzsol.com'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'test'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'01717552181'<\/code><code class=\"plain\">),<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">(9, <\/code><code class=\"string\">'Syed Salim'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'salimhossain@gmail.com'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'Gulshan, Dhaka'<\/code><code class=\"plain\">,<\/code><code class=\"string\">'01717552181'<\/code><code class=\"plain\">),<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">(10, <\/code><code class=\"string\">'Salim Hossain'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'salimhossain@gmail.com'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'Gazipur-1700, Dhaka, Bangladesh.'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'01717552181'<\/code><code class=\"plain\">),<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">(13, <\/code><code class=\"string\">'Galib'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'g@lib.com'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'Dhaka,Bangladesh'<\/code><code class=\"plain\">, <\/code><code class=\"string\">'987979'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<h1>Showing All Data from your users table:<\/h1>\n<p>Now, we learn how to show data in CodeIgniter. As we know, CodeIgniter use MVC pattern. We will use Model for retrieve data from database.<\/p>\n<p>First, build a model. Create a file named \u201cusers_model.php\u201d within codeigniter\/application\/models. Enter following code:<\/p>\n<div id=\"highlighter_425880\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">class<\/code> <code class=\"plain\">Users_model <\/code><code class=\"keyword\">extends<\/code> <code class=\"plain\">CI_Model {<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">__construct()<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">parent::__construct();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;database(<\/code><code class=\"string\">\"ci_test\"<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">get_all_users()<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$query<\/code> <code class=\"plain\">= <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;db-&gt;get(<\/code><code class=\"string\">'users'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">return<\/code> <code class=\"variable\">$query<\/code><code class=\"plain\">-&gt;result();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>22<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>23<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>24<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>25<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>26<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>27<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Next, we make a view. Create a file named \u201cshow_users.php\u201d within ci\/application\/views. Enter folowing code:<\/p>\n<div id=\"highlighter_370247\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;!DOCTYPE html PUBLIC <\/code><code class=\"string\">\"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\"<\/code><code class=\"string\">\"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;html xmlns=<\/code><code class=\"string\">\"http:\/\/www.w3.org\/1999\/xhtml\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;meta http-equiv=<\/code><code class=\"string\">\"Content-Type\"<\/code> <code class=\"plain\">content=<\/code><code class=\"string\">\"text\/html; charset=utf-8\"<\/code> <code class=\"plain\">\/&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;title&gt;CI CRUD&lt;\/title&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;h2&gt; Simple CI CRUD Application &lt;\/h2&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;table width=<\/code><code class=\"string\">\"600\"<\/code> <code class=\"plain\">border=<\/code><code class=\"string\">\"1\"<\/code> <code class=\"plain\">cellpadding=<\/code><code class=\"string\">\"5\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Id&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>22<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>23<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;User Name&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>24<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>25<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Email&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>26<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>27<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Mobile&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>28<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>29<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Address&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>30<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>31<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>32<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>33<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php <\/code><code class=\"keyword\">foreach<\/code> <code class=\"plain\">(<\/code><code class=\"variable\">$user_list<\/code> <code class=\"keyword\">as<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">){ ?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>34<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>35<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>36<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>37<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;id; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>38<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>39<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;name; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>40<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>41<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;email; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>42<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>43<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;address; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>44<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>45<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;mobile; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>46<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>47<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>48<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>49<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php }?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>50<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>51<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/table&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>52<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>53<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>54<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>55<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/html&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Build controller. Create a file named \u201cusers.php\u201d within codeigniter\\application\\controllers. Enter following code:<\/p>\n<div id=\"highlighter_190374\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code> <code class=\"plain\">( ! defined(<\/code><code class=\"string\">'BASEPATH'<\/code><code class=\"plain\">)) <\/code><code class=\"functions\">exit<\/code><code class=\"plain\">(<\/code><code class=\"string\">'No direct script access allowed'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">class<\/code> <code class=\"plain\">Users <\/code><code class=\"keyword\">extends<\/code> <code class=\"plain\">CI_Controller {<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">__construct()<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">parent::__construct();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">#<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;helper(<\/code><code class=\"string\">'url'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;model(<\/code><code class=\"string\">'users_model'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">index()<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>22<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>23<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$data<\/code><code class=\"plain\">[<\/code><code class=\"string\">'user_list'<\/code><code class=\"plain\">] = <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;users_model-&gt;get_all_users();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>24<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>25<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;view(<\/code><code class=\"string\">'show_users'<\/code><code class=\"plain\">, <\/code><code class=\"variable\">$data<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>26<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>27<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>28<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>29<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now, try to point your browser to <a href=\"http:\/\/localhost\/codeigniter\/index.php\/users\/\">http:\/\/localhost\/codeigniter\/index.php\/users\/<\/a><\/p>\n<p><a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci_crud1\/\" rel=\"attachment wp-att-1176\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1176\" title=\"Show Data with CodeIgniter\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud1-500x380.jpg\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" srcset=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud1-500x380.jpg 500w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud1-394x300.jpg 394w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud1.jpg 577w\" alt=\"Show Data with CodeIgniter\" width=\"500\" height=\"380\" \/><\/a><\/p>\n<p>Now, we will add links for insert, edit, and delete links for create our crud system. We use URL Helper to build the links.<\/p>\n<p>Update show_users.php (views) with following code :<\/p>\n<div id=\"highlighter_823663\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;!DOCTYPE html PUBLIC <\/code><code class=\"string\">\"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\"<\/code><code class=\"string\">\"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;html xmlns=<\/code><code class=\"string\">\"http:\/\/www.w3.org\/1999\/xhtml\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;meta http-equiv=<\/code><code class=\"string\">\"Content-Type\"<\/code> <code class=\"plain\">content=<\/code><code class=\"string\">\"text\/html; charset=utf-8\"<\/code> <code class=\"plain\">\/&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;title&gt;CI CRUD&lt;\/title&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;script type=<\/code><code class=\"string\">\"text\/javascript\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">function<\/code> <code class=\"plain\">show_confirm(act,gotoid)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code><code class=\"plain\">(act==<\/code><code class=\"string\">\"edit\"<\/code><code class=\"plain\">)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">var<\/code> <code class=\"plain\">r=confirm(<\/code><code class=\"string\">\"Do you really want to edit?\"<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">else<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>22<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>23<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">var<\/code> <code class=\"plain\">r=confirm(<\/code><code class=\"string\">\"Do you really want to delete?\"<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>24<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>25<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code> <code class=\"plain\">(r==true)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>26<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>27<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>28<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>29<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">window.location=<\/code><code class=\"string\">\"&lt;?php echo base_url();?&gt;index.php\/users\/\"<\/code><code class=\"plain\">+act+<\/code><code class=\"string\">\"\/\"<\/code><code class=\"plain\">+gotoid;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>30<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>31<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>32<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>33<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>34<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>35<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/script&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>36<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>37<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>38<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>39<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>40<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>41<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;h2&gt; Simple CI CRUD Application &lt;\/h2&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>42<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>43<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;table width=<\/code><code class=\"string\">\"600\"<\/code> <code class=\"plain\">border=<\/code><code class=\"string\">\"1\"<\/code> <code class=\"plain\">cellpadding=<\/code><code class=\"string\">\"5\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>44<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>45<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>46<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>47<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Id&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>48<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>49<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;User Name&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>50<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>51<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Email&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>52<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>53<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Mobile&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>54<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>55<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code><code class=\"plain\">&gt;Address&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>56<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>57<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th scope=<\/code><code class=\"string\">\"col\"<\/code> <code class=\"plain\">colspan=<\/code><code class=\"string\">\"2\"<\/code><code class=\"plain\">&gt;Action&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>58<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>59<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>60<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>61<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php <\/code><code class=\"keyword\">foreach<\/code> <code class=\"plain\">(<\/code><code class=\"variable\">$user_list<\/code> <code class=\"keyword\">as<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">){ ?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>62<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>63<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>64<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>65<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;id; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>66<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>67<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;name; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>68<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>69<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;email; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>70<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>71<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;address; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>72<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>73<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$u_key<\/code><code class=\"plain\">-&gt;mobile; ?&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>74<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>75<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td width=<\/code><code class=\"string\">\"40\"<\/code> <code class=\"plain\">align=<\/code><code class=\"string\">\"left\"<\/code> <code class=\"plain\">&gt;&lt;a href=<\/code><code class=\"string\">\"#\"<\/code> <code class=\"plain\">onClick=<\/code><code class=\"string\">\"show_confirm('edit',&lt;?php echo $u_key-&gt;id;?&gt;)\"<\/code><code class=\"plain\">&gt;Edit&lt;\/a&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>76<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>77<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td width=<\/code><code class=\"string\">\"40\"<\/code> <code class=\"plain\">align=<\/code><code class=\"string\">\"left\"<\/code> <code class=\"plain\">&gt;&lt;a href=<\/code><code class=\"string\">\"#\"<\/code> <code class=\"plain\">onClick=<\/code><code class=\"string\">\"show_confirm('delete',&lt;?php echo $u_key-&gt;id;?&gt;)\"<\/code><code class=\"plain\">&gt;<\/code><code class=\"functions\">Delete<\/code> <code class=\"plain\">&lt;\/a&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>78<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>79<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>80<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>81<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php }?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>82<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>83<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>84<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>85<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td colspan=<\/code><code class=\"string\">\"7\"<\/code> <code class=\"plain\">align=<\/code><code class=\"string\">\"right\"<\/code><code class=\"plain\">&gt; &lt;a href=<\/code><code class=\"string\">\"&lt;?php echo base_url();?&gt;index.php\/user\/add_form\"<\/code><code class=\"plain\">&gt;Insert New User&lt;\/a&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>86<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>87<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>88<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>89<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/table&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>90<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>91<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>92<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>93<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/html&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now Again try to point your browser to <a href=\"http:\/\/localhost\/codeigniter\/index.php\/users\/\">http:\/\/localhost\/codeigniter\/index.php\/users\/<\/a><\/p>\n<p><a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci_crud2\/\" rel=\"attachment wp-att-1177\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1177\" title=\"Codeigniter Crud with Actions\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud2-500x397.jpg\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" srcset=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud2-500x397.jpg 500w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud2-377x300.jpg 377w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud2.jpg 594w\" alt=\"Codeigniter Crud with Actions\" width=\"500\" height=\"397\" \/><\/a><\/p>\n<h1>Insert Data to our database using CodeIgniter<\/h1>\n<p>Now, we begin create a form for input data.<\/p>\n<p>Create \u201cinsert.php\u201d within codeigniter\\application\\views. Write following code:<\/p>\n<div id=\"highlighter_265315\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;!DOCTYPE html PUBLIC <\/code><code class=\"string\">\"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\"<\/code><code class=\"string\">\"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;html xmlns=<\/code><code class=\"string\">\"http:\/\/www.w3.org\/1999\/xhtml\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;meta http-equiv=<\/code><code class=\"string\">\"Content-Type\"<\/code> <code class=\"plain\">content=<\/code><code class=\"string\">\"text\/html; charset=utf-8\"<\/code> <code class=\"plain\">\/&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;title&gt;CI Insert Form&lt;\/title&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;form method=<\/code><code class=\"string\">\"post\"<\/code> <code class=\"plain\">action=<\/code><code class=\"string\">\"&lt;?php echo base_url();?&gt;index.php\/users\/insert_user_db\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;table width=<\/code><code class=\"string\">\"400\"<\/code> <code class=\"plain\">border=<\/code><code class=\"string\">\"0\"<\/code> <code class=\"plain\">cellpadding=<\/code><code class=\"string\">\"5\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"213\"<\/code> <code class=\"plain\">align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter your username&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>22<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>23<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td width=<\/code><code class=\"string\">\"161\"<\/code><code class=\"plain\">&gt;&lt;input type=<\/code><code class=\"string\">\"text\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"name\"<\/code> <code class=\"plain\">size=<\/code><code class=\"string\">\"20\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>24<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>25<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>26<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>27<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>28<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>29<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter your email&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>30<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>31<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;input type=<\/code><code class=\"string\">\"text\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"email\"<\/code> <code class=\"plain\">size=<\/code><code class=\"string\">\"20\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>32<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>33<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>34<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>35<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>36<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>37<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter your Mobile&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>38<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>39<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;input type=<\/code><code class=\"string\">\"text\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"mobile\"<\/code> <code class=\"plain\">size=<\/code><code class=\"string\">\"20\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>40<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>41<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>42<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>43<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>44<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>45<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter Your Address&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>46<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>47<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;textarea name=<\/code><code class=\"string\">\"address\"<\/code> <code class=\"plain\">rows=<\/code><code class=\"string\">\"5\"<\/code> <code class=\"plain\">cols=<\/code><code class=\"string\">\"20\"<\/code><code class=\"plain\">&gt;&lt;\/textarea&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>48<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>49<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>50<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>51<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>52<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>53<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;&amp;nbsp;&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>54<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>55<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;input type=<\/code><code class=\"string\">\"submit\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"submit\"<\/code> <code class=\"plain\">value=<\/code><code class=\"string\">\"Send\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>56<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>57<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>58<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>59<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/table&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>60<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>61<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/form&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>62<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>63<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>64<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>65<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/html&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now, we need to load Insert Form. Put at controller (users.php within codeigniter\/application\/controllers), add_form () method.<\/p>\n<div id=\"highlighter_133528\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">add_form()<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;view(<\/code><code class=\"string\">'insert'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now for insert data from our insert.php form to users table we need to create another method called insert_user_db() in our controllers with following code:<\/p>\n<div id=\"highlighter_759650\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">insert_new_user()<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$udata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'name'<\/code><code class=\"plain\">] = <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;input-&gt;post(<\/code><code class=\"string\">'name'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$udata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'email'<\/code><code class=\"plain\">] = <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;input-&gt;post(<\/code><code class=\"string\">'email'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$udata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'address'<\/code><code class=\"plain\">] = <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;input-&gt;post(<\/code><code class=\"string\">'address'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$udata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'mobile'<\/code><code class=\"plain\">] = <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;input-&gt;post(<\/code><code class=\"string\">'mobile'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$res<\/code> <code class=\"plain\">= <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;users_model-&gt;insert_users_to_db(<\/code><code class=\"variable\">$udata<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code><code class=\"plain\">(<\/code><code class=\"variable\">$res<\/code><code class=\"plain\">){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">header(<\/code><code class=\"string\">'location:'<\/code><code class=\"plain\">.base_url().<\/code><code class=\"string\">\"index.php\/users\/\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;index());<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now add new method insert_users_to_db in your models<\/p>\n<div id=\"highlighter_978806\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">insert_users_to_db(<\/code><code class=\"variable\">$data<\/code><code class=\"plain\">)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">return<\/code> <code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;db-&gt;insert(<\/code><code class=\"string\">'users'<\/code><code class=\"plain\">, <\/code><code class=\"variable\">$data<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now, click your \u201cInsert New User\u201d link in your browser , you see your insert form like this:<\/p>\n<p><a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci_crud3\/\" rel=\"attachment wp-att-1181\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1181\" title=\"CodeIgniter Insert Form \" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud3.jpg\" sizes=\"auto, (max-width: 468px) 100vw, 468px\" srcset=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud3-438x300.jpg 438w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud3.jpg 468w\" alt=\"CodeIgniter Insert Form \" width=\"468\" height=\"320\" \/><\/a><\/p>\n<p>Ok. You can test it. Input some data to your insert form .<\/p>\n<p><a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci_crud4\/\" rel=\"attachment wp-att-1182\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1182\" title=\"CodeIgniter Insert Form with sample data\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud4.jpg\" sizes=\"auto, (max-width: 463px) 100vw, 463px\" srcset=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud4-436x300.jpg 436w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud4.jpg 463w\" alt=\"CodeIgniter Insert Form with sample data\" width=\"463\" height=\"318\" \/><\/a><\/p>\n<p>Now, we create a method called getById()\u00a0to get a single user information at our model<\/p>\n<div id=\"highlighter_741577\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">getById(<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$query<\/code> <code class=\"plain\">= <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;db-&gt;get_where(<\/code><code class=\"string\">'users'<\/code><code class=\"plain\">,<\/code><code class=\"keyword\">array<\/code><code class=\"plain\">(<\/code><code class=\"string\">'id'<\/code><code class=\"plain\">=&gt;<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">));<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">return<\/code> <code class=\"variable\">$query<\/code><code class=\"plain\">-&gt;row_array();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>After Create getById Method in our users_model, Now We Create edit Method to send a single user information to edit.php form as follows:<\/p>\n<div id=\"highlighter_5155\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">edit(){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$id<\/code> <code class=\"plain\">= <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;uri-&gt;segment(3);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"spaces\">\u00a0<\/code><code class=\"variable\">$data<\/code><code class=\"plain\">[<\/code><code class=\"string\">'user'<\/code><code class=\"plain\">] = <\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;users_model-&gt;getById(<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;load-&gt;view(<\/code><code class=\"string\">'edit'<\/code><code class=\"plain\">, <\/code><code class=\"variable\">$data<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Now we create edit.php form for update users:<\/p>\n<div id=\"highlighter_952490\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;!DOCTYPE html PUBLIC <\/code><code class=\"string\">\"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\"<\/code><code class=\"string\">\"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;html xmlns=<\/code><code class=\"string\">\"http:\/\/www.w3.org\/1999\/xhtml\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;meta http-equiv=<\/code><code class=\"string\">\"Content-Type\"<\/code> <code class=\"plain\">content=<\/code><code class=\"string\">\"text\/html; charset=utf-8\"<\/code> <code class=\"plain\">\/&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;title&gt;CI Insert Form&lt;\/title&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/head&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;form method=<\/code><code class=\"string\">\"post\"<\/code> <code class=\"plain\">action=<\/code><code class=\"string\">\"&lt;?php echo base_url();?&gt;index.php\/users\/update\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;?php<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">extract(<\/code><code class=\"variable\">$user<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">?&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;table width=<\/code><code class=\"string\">\"400\"<\/code> <code class=\"plain\">border=<\/code><code class=\"string\">\"0\"<\/code> <code class=\"plain\">cellpadding=<\/code><code class=\"string\">\"5\"<\/code><code class=\"plain\">&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>22<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>23<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"213\"<\/code> <code class=\"plain\">align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter your username&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>24<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>25<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td width=<\/code><code class=\"string\">\"161\"<\/code><code class=\"plain\">&gt;&lt;input type=<\/code><code class=\"string\">\"text\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"name\"<\/code> <code class=\"plain\">size=<\/code><code class=\"string\">\"20\"<\/code> <code class=\"plain\">value=<\/code><code class=\"string\">\"&lt;?php echo $name; ?&gt;\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>26<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>27<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>28<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>29<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>30<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>31<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter your email&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>32<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>33<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;input type=<\/code><code class=\"string\">\"text\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"email\"<\/code> <code class=\"plain\">size=<\/code><code class=\"string\">\"20\"<\/code> <code class=\"plain\">value=<\/code><code class=\"string\">\"&lt;?php echo $email; ?&gt;\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>34<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>35<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>36<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>37<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>38<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>39<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter your Mobile&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>40<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>41<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;input type=<\/code><code class=\"string\">\"text\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"mobile\"<\/code> <code class=\"plain\">size=<\/code><code class=\"string\">\"20\"<\/code> <code class=\"plain\">value=<\/code><code class=\"string\">\"&lt;?php echo $mobile; ?&gt;\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>42<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>43<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>44<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>45<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>46<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>47<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;Enter Your Address&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>48<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>49<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;&lt;textarea name=<\/code><code class=\"string\">\"address\"<\/code> <code class=\"plain\">rows=<\/code><code class=\"string\">\"5\"<\/code> <code class=\"plain\">cols=<\/code><code class=\"string\">\"20\"<\/code><code class=\"plain\">&gt;&lt;?php <\/code><code class=\"functions\">echo<\/code> <code class=\"variable\">$address<\/code><code class=\"plain\">; ?&gt;&lt;\/textarea&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>50<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>51<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>52<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>53<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>54<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>55<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;th align=<\/code><code class=\"string\">\"right\"<\/code> <code class=\"plain\">scope=<\/code><code class=\"string\">\"row\"<\/code><code class=\"plain\">&gt;&amp;nbsp;&lt;\/th&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>56<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>57<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>58<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;input type=<\/code><code class=\"string\">\"hidden\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"id\"<\/code> <code class=\"plain\">value=<\/code><code class=\"string\">\"&lt;?php echo $id; ?&gt;\"<\/code> <code class=\"plain\">\/&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>59<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;input type=<\/code><code class=\"string\">\"submit\"<\/code> <code class=\"plain\">name=<\/code><code class=\"string\">\"submit\"<\/code> <code class=\"plain\">value=<\/code><code class=\"string\">\"Update\"<\/code> <code class=\"plain\">\/&gt;&lt;\/td&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>60<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>61<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>62<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>63<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/table&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>64<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>65<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/form&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>66<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>67<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/body&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>68<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>69<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">&lt;\/html&gt;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>After create edit form, now we add updating function.<\/p>\n<p>First, create update_info () method at model \u201cusers_model.php\u201d.<\/p>\n<div id=\"highlighter_268466\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">update_info(<\/code><code class=\"variable\">$data<\/code><code class=\"plain\">,<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;db-&gt;where(<\/code><code class=\"string\">'users.id'<\/code><code class=\"plain\">,<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">return<\/code> <code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;db-&gt;update(<\/code><code class=\"string\">'users'<\/code><code class=\"plain\">, <\/code><code class=\"variable\">$data<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Then, create update() method at your controller \u201cusers.php\u201d:<\/p>\n<div id=\"highlighter_946028\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">update()<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$mdata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'name'<\/code><code class=\"plain\">]=<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">'name'<\/code><code class=\"plain\">];<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$mdata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'email'<\/code><code class=\"plain\">]=<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">'email'<\/code><code class=\"plain\">];<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$mdata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'address'<\/code><code class=\"plain\">]=<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">'address'<\/code><code class=\"plain\">];<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>10<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>11<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$mdata<\/code><code class=\"plain\">[<\/code><code class=\"string\">'mobile'<\/code><code class=\"plain\">]=<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">'mobile'<\/code><code class=\"plain\">];<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>12<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>13<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$res<\/code><code class=\"plain\">=<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;users_model-&gt;update_info(<\/code><code class=\"variable\">$mdata<\/code><code class=\"plain\">, <\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">'id'<\/code><code class=\"plain\">]);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>14<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>15<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">if<\/code><code class=\"plain\">(<\/code><code class=\"variable\">$res<\/code><code class=\"plain\">){<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>16<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>17<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">header(<\/code><code class=\"string\">'location:'<\/code><code class=\"plain\">.base_url().<\/code><code class=\"string\">\"index.php\/users\/\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;index());<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>18<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>19<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>20<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>21<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<h1>Deleting Data<\/h1>\n<p>Now, we create deleting function.<\/p>\n<p>First, create a method delete_a_user() for deleting data at model.<\/p>\n<div id=\"highlighter_760516\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"plain\">delete_a_user(<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;db-&gt;where(<\/code><code class=\"string\">'users.id'<\/code><code class=\"plain\">,<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">return<\/code> <code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;db-&gt;<\/code><code class=\"functions\">delete<\/code><code class=\"plain\">(<\/code><code class=\"string\">'users'<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>Then, create a method for deleting data at controller:<\/p>\n<div id=\"highlighter_608831\" class=\"syntaxhighlighter  \">\n<div class=\"lines\">\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>1<\/code><\/td>\n<td class=\"content\"><code class=\"keyword\">public<\/code> <code class=\"keyword\">function<\/code> <code class=\"functions\">delete<\/code><code class=\"plain\">(<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">)<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>2<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>3<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">{<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>4<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>5<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;users_model-&gt;delete_a_user(<\/code><code class=\"variable\">$id<\/code><code class=\"plain\">);<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>6<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>7<\/code><\/td>\n<td class=\"content\"><code class=\"variable\">$this<\/code><code class=\"plain\">-&gt;index();<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt2\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>8<\/code><\/td>\n<td class=\"content\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"line alt1\">\n<table>\n<tbody>\n<tr>\n<td class=\"number\"><code>9<\/code><\/td>\n<td class=\"content\"><code class=\"plain\">}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><a href=\"http:\/\/www.w3programmers.com\/introduction-to-codeigniter-basic-with-crud\/ci_crud6\/\" rel=\"attachment wp-att-1183\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1183\" title=\"Delete with CodeIgniter\" src=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud6-500x384.jpg\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" srcset=\"http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud6-500x384.jpg 500w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud6-390x300.jpg 390w, http:\/\/www.w3programmers.com\/wp-content\/uploads\/2012\/09\/ci_crud6.jpg 597w\" alt=\"Delete with CodeIgniter\" width=\"500\" height=\"384\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction to CodeIgniter Basic With CRUD CodeIgniter (CI) is one of popular php framework. If you are already building PHP Application, CodeIgniter will help you to do it better and more easily. With CodeIgniter, you can save time, make your web more robust, your code will be easier to read and maintenance. It is free, ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"http:\/\/symbioticindia.in\/docu\/2016\/05\/10\/introduction-to-codeigniter-basic-with-crud\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,6,16],"tags":[],"class_list":["post-79","post","type-post","status-publish","format-standard","hentry","category-codeigniter","category-php","category-xampp"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/79","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/comments?post=79"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/79\/revisions"}],"predecessor-version":[{"id":80,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/79\/revisions\/80"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=79"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=79"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}