Table Structure
Model
<?php
namespace App\Models;
use CodeIgniter\Model;
class ContactModel extends Model
{
protected $table='holywebcontact';
protected $primaryKey = 'ID';
protected $allowedFields = ['ID', 'Name', 'Phone', 'Message', 'CreatedDate'];
}
Controller
<?php
namespace App\Controllers;
use App\Models\ContactModel;
class Home extends BaseController
{
public function dataread()
{
$data['title'] = 'DB Get Demo';
$crudModel = new ContactModel();
$data['user_data'] = $crudModel->findAll();
return view('tmp2', $data);
}
}
$data["model"]=$album->where('AlbumID', $aid)->findAll();
Get All record with ouder by clause
$data=$GalleryModel->orderBy('ID', 'DESC')->findAll();
View
<?php
foreach ($model as $item)
{
echo $item["ID"] . "," . $item['Name'] . "<br>";
}
?>
