카테고리 없음
[Codeigniter4] Database 값 추출 // Array
dosona
2020. 1. 7. 10:08
이번에는 Array에서 값을 추출하는 법을 알아보려고한다.
Model
class MemberModel extends Model
{
protected $db;
public function get_date(){
$sql = "SELECT * FROM teacher_member limit 20";
$query =$this->db->query($sql);
return $query-> getResult();
}
}
View(Array일때)
<html>
<head>
<title>test</title>
</head>
<body>
<?
foreach ($result as $row)
{
?>
<h2><?= $row->name?></h2>
<?
}
?>
</body>
</html>
Controller (Array일때)
class Pages extends Controller {
public function index()
{
$model = new Model\MemberModel();
$result = $model -> get_date();
$data['result'] = $result;
return view('BlogView', $data);
}
}