Skip to main content

Database Connectivity in Codeigniter with MYSQL Database

Database connectivity from MySQL to CI?
.........................................................................................

steps1st:-

create database and table from MySQL database using PHPMyAdmin

step2nd:-

open project folder and edit config/database.php

and edit username, password, database

username=root
password=' '
database= dbname

step3rd:-

create controller and load view and create an action method in the controller

step4th

create view form according to the table in the view file

step5th

create a model class and define a method for data insertion under the model folder

class Modelname extends CI_Model
{
      function methodname()
      {

      }   

}


step6:-

load database.php file under model class constructor

function __construct()
{
   parent::__construct();
   $this->load->database();
}

step7:-

create a method on the model and write data insertion code

step8:-

call model method from the controller action method.

first load model then call a model class method

$this->load->model('modelname');
$this->modelname->met    hod(param,..)

Show record
9) create another method in the controller and load view

10) create another method in the model and write data selection code

11) call a model method from the controller

12) send model data into view from the controller


Complete Code for Data Operation

Code of Database.php what will be changed:
'hostname' => 'localhost',
'username' => 'root',
'password' => '',
'database' => 'phpdb2',

Code of Controller:-

<?php
class Student extends CI_Controller
{

function index()
{

$this->load->view('stuview');
}

    function stuadd()
    {
    $this->load->model('Stumodel');
    $r = $this->input->post('txtrno');
    $s = $this->input->post('txtname');
    $b = $this->input->post('txtbranch');
    $f = $this->input->post('txtfees');
    $res=$this->Stumodel->stuinsert($r,$s,$b,$f);
    if($res==1)
    $data['res']= "data inserted successfully";
    else
    $data['res']= "problem in insertion";
    $this->load->view('stuview',$data);
    }
    function stushow()
    {
    $this->load->model('Stumodel');
    $data['res']=$this->Stumodel->showstudent();
    $this->load->view('viewstudent',$data);
    }

}


?>

.............................................*....................................................................
Code of View:-
....................................................................................................
stuview.php

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h1>Welcome in Student Information</h1>

<form action="<?php echo site_url(); ?>/Student/stuadd" method="post">

<input type="text" name="txtrno" placeholder="enter rno" />
<br>
<br>
<input type="text" name="txtname" placeholder="enter name" />
<br>
<br>
<input type="text" name="txtbranch" placeholder="enter branch" />
<br>
<br>
<input type="text" name="txtfees" placeholder="enter fees" />
<br>
<br>
<input type="submit" name="btnsubmit" value="Insert" />
</form>
<?php
echo @$res;
?>
</body>
</html>

Code for Display View:-
viewstudent.php

<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<center>
<h1>Student Information</h1>
<?php
//print_r($res);
echo "<table border='1'><tr><th>Rno</th><th>Sname</th><th>Branch</th><th>Fees</th></tr>";
foreach($res as $k)
{
echo "<tr>";
foreach ($k as $v) {
echo "<td>$v"."</td>";
}
echo "</tr>";
}
echo "</table>";
?>
</center>
</body>
</html>

Code of Complete Model Class:-
<?php
class Stumodel extends CI_Model
{
    function __construct()
    {
    parent::__construct();
    $this->load->database();
    }

    function stuinsert($r,$s,$b,$f)
    {
    $this->db->insert('student',array('rno'=>$r,'name'=>$s,'branch'=>$b,'fees'=>$f));
    return $this->db->affected_rows();
    }
    function showstudent()
    {
    $res = $this->db->get('student');
    return $res->result_array();
    }

}





?>

Database Schema:-


Labels:

Comments

Post a Comment

POST Answer of Questions and ASK to Doubt

Popular posts from this blog

DSA in C# | Data Structure and Algorithm using C#

  DSA in C# |  Data Structure and Algorithm using C#: Lecture 1: Introduction to Data Structures and Algorithms (1 Hour) 1.1 What are Data Structures? Data Structures are ways to store and organize data so it can be used efficiently. Think of data structures as containers that hold data in a specific format. Types of Data Structures: Primitive Data Structures : These are basic structures built into the language. Example: int , float , char , bool in C#. Example : csharp int age = 25;  // 'age' stores an integer value. bool isStudent = true;  // 'isStudent' stores a boolean value. Non-Primitive Data Structures : These are more complex and are built using primitive types. They are divided into: Linear : Arrays, Lists, Queues, Stacks (data is arranged in a sequence). Non-Linear : Trees, Graphs (data is connected in more complex ways). Example : // Array is a simple linear data structure int[] number...
Post a Comment
Read more

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...
Post a Comment
Read more

Top 50 Most Asked MERN Stack Interview Questions and Answers for 2025

 Top 50 Most Asked MERN Stack Interview Questions and Answers for 2025 Now a days most of the IT Company asked NODE JS Question mostly in interview. I am creating this article to provide help to all MERN Stack developer , who is in doubt that which type of question can be asked in MERN Stack  then they can learn from this article. I am Shiva Gautam,  I have 15 Years of experience in Multiple IT Technology, I am Founder of Shiva Concept Solution Best Programming Institute with 100% Job placement guarantee. for more information visit  Shiva Concept Solution 1. What is the MERN Stack? Answer : MERN Stack is a full-stack JavaScript framework using MongoDB (database), Express.js (backend framework), React (frontend library), and Node.js (server runtime). It’s popular for building fast, scalable web apps with one language—JavaScript. 2. What is MongoDB, and why use it in MERN? Answer : MongoDB is a NoSQL database that stores data in flexible, JSON-like documents. It...
Post a Comment
Read more