Retrieve data from database using CodeIgniter framework

Programing Coderfunda September 28, 2018 codeigniter No comments

Retrieve data from database using CodeIgniter framework

In this example we will discuss about how to retrieve a record or data from MySQL database using CodeIgniter framework PHP.

For retrieve data from MySQL database using CodeIgniter framework first we have to create a table in data base.

After create a table in the MySQL database you need to insert record or data on it.If you want to know how to insert data in CodeIgniter framework please visit the link : Insert data in CodeIgniter.

The SELECT statement is used to retrieve data from one or more tables:

The SQL query for retrieve specific column.

SELECT column_name(s) FROM table_name

or we can use the * character to retrieve ALL columns from a table:

SELECT * FROM table_name

To learn more about SQL, please visit our SQL tutorial.

We use 3 file for retrieve students data.

Crud.php Path: application\controllers\Crud.php
Crud_model.php Path: application\models\Crud_model.php
display_records.php Path: application\views\insert.php

Sql Table

CREATE TABLE crud (
`id` int(11) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
PRIMARY KEY (id)
);

Crud.php

<?php 
class Crud extends CI_Controller 
{
public function __construct()
{
//call CodeIgniter's default Constructorparent::__construct();
//load database libray manually$this->load->database();
//load Model$this->load->model('Crud_model');
}
//Displaypublic function displaydata()
{
$result['data']=$this->Crud_model->display_records();
$this->load->view('display_records',$result);
}
}
?>

student_fetch.php

<?php
class Crud_model extends CI_Model 
{
//Viewfunction display_records()
{
$query=$this->db->query("select * from crud");
return $query->result();
}
}

display_records.php

<html>
<head>
<title>Display records</title>
</head>
<body>
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr style="background:#CCC">
<th>Sr No</th>
<th>First_name</th>
<th>Last_name</th>
<th>Email Id</th>
<th>Delete</th>
<th>Update</th>
</tr>
<?php
$i=1;
foreach($data as $row)
{
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".$row->first_name."</td>";
echo "<td>".$row->last_name."</td>";
echo "<td>".$row->email."</td>";
echo "</tr>";
$i++;
}
?>
</table>

Now run the program on your browser with the below URL:

http://localhost/codeIgniter/index.php/Crud/displaydata

After fetch data the table look like this.

Id	first name	last name	Email Id
1	Divyasundar	Sahu	divyasundar@gmail.com
2	Hritika	Sahu	hritika@gmail.com
3	Milan	Jena	milanjena@gmail.com

Next ❯

Retrieve data from database using CodeIgniter framework

Programing Funda September 28, 2018 codeigniter No comments

Retrieve data from database using CodeIgniter framework

In this example we will discuss about how to retrieve a record or data from MySQL database using CodeIgniter framework PHP.

For retrieve data from MySQL database using CodeIgniter framework first we have to create a table in data base.

After create a table in the MySQL database you need to insert record or data on it.If you want to know how to insert data in CodeIgniter framework please visit the link : Insert data in CodeIgniter.

The SELECT statement is used to retrieve data from one or more tables:

The SQL query for retrieve specific column.

SELECT column_name(s) FROM table_name

or we can use the * character to retrieve ALL columns from a table:

SELECT * FROM table_name

To learn more about SQL, please visit our SQL tutorial.

We use 3 file for retrieve students data.

Crud.php Path: application\controllers\Crud.php
Crud_model.php Path: application\models\Crud_model.php
display_records.php Path: application\views\insert.php

Sql Table

CREATE TABLE crud (

`id` int(11) NOT NULL,

`first_name` varchar(30) NOT NULL,

`last_name` varchar(30) NOT NULL,

`email` varchar(30) NOT NULL,

PRIMARY KEY (id)

);

Crud.php

<?php 
class Crud extends CI_Controller 
{
public function __construct()
{
//call CodeIgniter's default Constructorparent::__construct();
//load database libray manually$this->load->database();
//load Model$this->load->model('Crud_model');
}
//Displaypublic function displaydata()
{
$result['data']=$this->Crud_model->display_records();
$this->load->view('display_records',$result);
}
}
?>

student_fetch.php

<?php
class Crud_model extends CI_Model 
{
//Viewfunction display_records()
{
$query=$this->db->query("select * from crud");
return $query->result();
}
}

display_records.php

<html>

<head>

<title>Display records</title>

</head>

<body>

<table width="600" border="1" cellspacing="5" cellpadding="5">

<tr style="background:#CCC">

<th>Sr No</th>

<th>First_name</th>

<th>Last_name</th>

<th>Email Id</th>

<th>Delete</th>

<th>Update</th>

</tr>

<?php
$i=1;
foreach($data as $row)
{
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".$row->first_name."</td>";
echo "<td>".$row->last_name."</td>";
echo "<td>".$row->email."</td>";
echo "</tr>";
$i++;
}
?>

</table>

Now run the program on your browser with the below URL:

http://localhost/codeIgniter/index.php/Crud/displaydata

After fetch data the table look like this.

Id	first name	last name	Email Id
1	Divyasundar	Sahu	divyasundar@gmail.com
2	Hritika	Sahu	hritika@gmail.com
3	Milan	Jena	milanjena@gmail.com

Next ❯

How to insert data in database - CodeIgniter framework

Programing Coderfunda September 28, 2018 codeigniter No comments

In this example we are going to show you how to insert data in database using CodeIgniter framework PHP.

For insert data in MySQL using CodeIgniter first we have to create a table in data base.

The INSERT INTO statement is used to insert new data to a MySQL table:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

To learn more about SQL, please visit our SQL tutorial.

For creating table the SQL query is:

SQL Query

CREATE TABLE crud (
`id` int(11) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
PRIMARY KEY (id)
);

Here we using 3 files for insert data in MySQL:

Crud.php Path: codeIgniter\application\controllers\Crud.php
Crud_model.php Path: codeIgniter\application\models\Crud_model.php
insert.php Path: codeIgniter\application\views\insert.php

Crud.php (Controller)

<?php 
class Crud extends CI_Controller 
{
public function __construct()
{
//call CodeIgniter's default Constructorparent::__construct();
//load database libray manually$this->load->database();
//load Model$this->load->model('Crud_model');
}
//Insertpublic function savedata()
{
//load registration view form$this->load->view('insert');
//Check submit button if($this->input->post('save'))
{
$first_name=$this->input->post('first_name');
$last_name=$this->input->post('last_name');
$email=$this->input->post('email');
$this->Crud_model->saverecords($first_name,$last_name,$email); 
echo "Records Saved Successfully";
}
}
}
?>

Crud_model.php (Model)

<?php
class Crud_model extends CI_Model 
{
//Insertfunction saverecords($first_name,$last_name,$email)
{
$query="insert into crud values('','$first_name','$last_name','$email')";
$this->db->query($query);
}
}

insert.php (View)

<!DOCTYPE html> 
<html>
<head>
<title>Registration form</title>
</head>
<body>
<form method="post">
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr>
<td width="230">First Name </td>
<td width="329"><input type="text" name="first_name"/></td>
</tr>
<tr>
<td>Last Name </td>
<td><input type="text" name="last_name"/></td>
</tr>
<tr>
<td>Email ID </td>
<td><input type="email" name="email"/></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="save" value="Save Data"/></td>
</tr>
</table>
</form>
</body>
</html>

Run the program on your browser with URL:

http://localhost/codeIgniter/index.php/Crud/savedata

Here codeIgniter is my folder name. Put your folder name instead of codeIgniter.Rest of things are same.

How to insert data in database - CodeIgniter framework

Programing Funda September 28, 2018 codeigniter No comments

In this example we are going to show you how to insert data in database using CodeIgniter framework PHP.

For insert data in MySQL using CodeIgniter first we have to create a table in data base.

The INSERT INTO statement is used to insert new data to a MySQL table:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

To learn more about SQL, please visit our SQL tutorial.

For creating table the SQL query is:

SQL Query

CREATE TABLE crud (
`id` int(11) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
PRIMARY KEY (id)
);

Here we using 3 files for insert data in MySQL:

Crud.php Path: codeIgniter\application\controllers\Crud.php
Crud_model.php Path: codeIgniter\application\models\Crud_model.php
insert.php Path: codeIgniter\application\views\insert.php

Crud.php (Controller)

<?php 
class Crud extends CI_Controller 
{
public function __construct()
{
//call CodeIgniter's default Constructorparent::__construct();
//load database libray manually$this->load->database();
//load Model$this->load->model('Crud_model');
}
//Insertpublic function savedata()
{
//load registration view form$this->load->view('insert');
//Check submit button if($this->input->post('save'))
{
$first_name=$this->input->post('first_name');
$last_name=$this->input->post('last_name');
$email=$this->input->post('email');
$this->Crud_model->saverecords($first_name,$last_name,$email); 
echo "Records Saved Successfully";
}
}
}
?>

Crud_model.php (Model)

<?php
class Crud_model extends CI_Model 
{
//Insertfunction saverecords($first_name,$last_name,$email)
{
$query="insert into crud values('','$first_name','$last_name','$email')";
$this->db->query($query);
}
}

insert.php (View)

<!DOCTYPE html> 
<html>
<head>
<title>Registration form</title>
</head>
<body>
<form method="post">
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr>
<td width="230">First Name </td>
<td width="329"><input type="text" name="first_name"/></td>
</tr>
<tr>
<td>Last Name </td>
<td><input type="text" name="last_name"/></td>
</tr>
<tr>
<td>Email ID </td>
<td><input type="email" name="email"/></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="save" value="Save Data"/></td>
</tr>
</table>
</form>
</body>
</html>

Run the program on your browser with URL:

http://localhost/codeIgniter/index.php/Crud/savedata

Here codeIgniter is my folder name. Put your folder name instead of codeIgniter.Rest of things are same.

Session with example CodeIgniter framework

Programing Coderfunda September 28, 2018 codeigniter No comments

Session with example CodeIgniter framework

In CodeIgniter or any other framework session is used to store information (in variables) and used it through out the application.

Initializing Session

To store data in session first of all we need to initialize the session.

In PHP we initialize the session by simply write the session_start(); function.

But in CodeIgniter We can do that by executing the following line in constructor.

$this->load->library(‘session');

Add data to session

In php we simply use $_SESSION super global variable to add value to a session.

$_SESSION[‘key’]=value;

Same thing can be done in CodeIgniter as shown below.

$this->session->set_userdata(‘session name', ‘any value’);

set_userdata() function takes two arguments. The first argument, session name, is the name of the session variable and here any value is the value assign to the session. We can use set_userdata() function to pass array to store values as shown below.

$newdata = array(
'username' => 'johndoe',
'email' => 'johndoe@some-site.com',
'logged_in' => TRUE
);
$this->session->set_userdata($newdata);

Remove Session Data

In PHP, we remove the data by using unset() function.
unset($_SESSION[‘some_name’]);

But in CodeIgniter we use unset_userdata() function that will remove data from session.

$this->session->unset_userdata(‘some_name');

If you want to remove more that one value and a array data then you can use the same function unset_userdata().

$this->session->unset_userdata($array_items);

Fetch Session Data

After set a data to a session we also retrieve it for our use. Userdata() function will be used for this purpose.

$name = $this->session->userdata(‘name');

Session with example CodeIgniter framework

Programing Funda September 28, 2018 codeigniter No comments

Session with example CodeIgniter framework

In CodeIgniter or any other framework session is used to store information (in variables) and used it through out the application.

Initializing Session

To store data in session first of all we need to initialize the session.

In PHP we initialize the session by simply write the session_start(); function.

But in CodeIgniter We can do that by executing the following line in constructor.

$this->load->library(‘session');

Add data to session

In php we simply use $_SESSION super global variable to add value to a session.

$_SESSION[‘key’]=value;

Same thing can be done in CodeIgniter as shown below.

$this->session->set_userdata(‘session name', ‘any value’);

$newdata = array(
'username' => 'johndoe',
'email' => 'johndoe@some-site.com',
'logged_in' => TRUE
);
$this->session->set_userdata($newdata);

Remove Session Data

In PHP, we remove the data by using unset() function.
unset($_SESSION[‘some_name’]);

But in CodeIgniter we use unset_userdata() function that will remove data from session.

$this->session->unset_userdata(‘some_name');

If you want to remove more that one value and a array data then you can use the same function unset_userdata().

$this->session->unset_userdata($array_items);

Fetch Session Data

After set a data to a session we also retrieve it for our use. Userdata() function will be used for this purpose.

$name = $this->session->userdata(‘name');

Hello world example - CodeIgniter framework

Programing Coderfunda September 28, 2018 No comments

In this example we will discuss about Hello world example CodeIgniter framework PHP.

We use two file for hello world example.

Hello.php (CodeIgniter\application\controllers\Hello.php )
hello_world.php (CodeIgniter\application\views\hello_world.php)

Hello.php

<?php 
defined('BASEPATH') OR exit('No direct script access allowed'); 
class Hello extends CI_Controller { 
public function index() 
{ 
$this->load->view('hello_world'); 
} 
} 
?>

hello_world.php

<!DOCTYPE html>
<html>
<head>
<title>Hello World !</title>
</head>
</body>
<h1>Hello World !</h1>
</body>
</html>

Now run the program on your browser with the below URL:
http://localhost/CodeIgniter/index.php/Hello

Hello world example - CodeIgniter framework

Programing Funda September 28, 2018 No comments

In this example we will discuss about Hello world example CodeIgniter framework PHP.

We use two file for hello world example.

Hello.php (CodeIgniter\application\controllers\Hello.php )
hello_world.php (CodeIgniter\application\views\hello_world.php)

Hello.php

<?php 
defined('BASEPATH') OR exit('No direct script access allowed'); 
class Hello extends CI_Controller { 
public function index() 
{ 
$this->load->view('hello_world'); 
} 
} 
?>

hello_world.php

<!DOCTYPE html>

<html>

<head>

<title>Hello World !</title>

</head>

</body>

<h1>Hello World !</h1>

</body>

</html>

Now run the program on your browser with the below URL:

http://localhost/CodeIgniter/index.php/Hello

28 September, 2018

Retrieve data from database using CodeIgniter framework

Sql Table

Crud.php

student_fetch.php

display_records.php

Retrieve data from database using CodeIgniter framework

Sql Table

Crud.php

student_fetch.php

display_records.php

SQL Query

Crud.php (Controller)

Crud_model.php (Model)

insert.php (View)

SQL Query

Crud.php (Controller)

Crud_model.php (Model)

insert.php (View)

Session with example CodeIgniter framework

Initializing Session

Add data to session

Remove Session Data

Fetch Session Data

Session with example CodeIgniter framework

Initializing Session

Add data to session

Remove Session Data

Fetch Session Data

Hello.php

hello_world.php

Hello.php

hello_world.php

Meta

Popular Posts

Categories

Social Media Links

Pages

Blog Archive

Laravel News