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:-




Comments

Popular posts from this blog

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...

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...

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...