PHP Programming Tutorial 1 - php codeigniter4 configuration in xampp or wamp
PHP Programming Tutorial 2 - CodeIgniter 4 Application Structure
PHP Programming Tutorial 3 - What is MVC in Codeigniter 4
PHP Programming Tutorial 4 - Codeigniter 4 Environment Variables
PHP Programming Tutorial 5 - Controllers in CodeIgniter 4
PHP Programming Tutorial 6 - Views in CodeIgniter 4
PHP Programming Tutorial 7 - Models in CodeIgniter 4
PHP Programming Tutorial 8 - Remove index.php from URL in CodeIgniter 4
PHP Programming Tutorial 9 - Include header and footer in CodeIgniter 4
PHP Programming Tutorial 10 - Session in CodeIgniter 4
PHP Programming Tutorial 11 - URI Routing in CodeIgniter 4
PHP Programming Tutorial 12 - Highlight Menu using URI Segment in CodeIgniter 4
PHP Programming Tutorial 13 - Connect to Database in CodeIgniter 4
PHP Programming Tutorial 14 - Insert data in Database using CodeIgniter 4
PHP Programming Tutorial 15 - Retrieve data from Database using CodeIgniter 4
PHP Programming Tutorial 16 - Update data in Database using CodeIgniter 4
PHP Programming Tutorial 17 - Delete data in Database using CodeIgniter 4
PHP Programming Tutorial 18 - Generate PDF in CodeIgniter 4
PHP Programming Tutorial 19 - Send Email using PHPMailer in CodeIgniter 4
PHP Programming Tutorial 20 - Upload a File in CodeIgniter 4
🔰 PHP Programming Tutorial 15 - Retrieve data from Database using CodeIgniter 4 🔰
Here, we are using 3 files for retrieve data from MySQL:
Overview
Controller: User.php /app/Controllers/User.php Model: UserModel.php /app/Models/UserModel.php View: list.php /app/Views/list.php/app/Config/Routes.php
$routes->add('user/list', 'User::list');/app/Controllers/User.php
<?php namespace App\Controllers; use App\Models\UserModel; class User extends BaseController { public function __construct() { $db = db_connect(); $this->userModel = new UserModel($db); } public function add() { $this->load->view('add'); } public function list() { $data['result'] = $this->userModel->list(); echo view('list', $data); } }/app/Models/UserModel.php
<?php namespace App\Models; use CodeIgniter\Model; use CodeIgniter\Database\ConnectionInterface; class UserModel extends Model { protected $db; public function __construct(ConnectionInterface &$db) { $this->db =& $db; } public function list() { return $this->db ->table('user_info') ->get() ->getResult(); } }/app/Views/list.php
<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> </tr> <?php $i=1; foreach($result 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>
😉Subscribe and like for more videos:
https://www.youtube.com/@chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment
0 Comments
Leave a message
