Login

GamalAbomera · 04-14-2020, 02:03 PM

(04-14-2020, 11:37 AM)jreklund Wrote: Can you show the code? Just remove the password of course.
Does it instantly die or when you do anything specific?

it's simple code

controler

PHP Code:
<?php namespace App\Controllers;
use CodeIgniter\Controller;
use App\Models\NewsModel;


class News extends Controller{
    public function index()
    {
        $model = new NewsModel();
        $data['news'] = $model->findAll();
        echo view('template/all',$data);
    }
    public function show($slug = null)
    {
        $model = new NewsModel();
        $db = \Config\Database::connect();
        // $data['news'] = $model->where(['slug'=> $slug])->first();
        $query = $db->query('SELECT * FROM news');
        $results = $query->getResult();

        $data['news'] = $results;

        echo view('template/show',$data);
    }
} 

model

PHP Code:
<?php

namespace App\Models;

use CodeIgniter\Model;

class NewsModel extends Model
{
    protected $table = 'news';
} 

view

PHP Code:
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>All News</title>
</head>

<body>
    <?php
    if (!empty($news)) {
        foreach ($news as $news_item) {
    ?>
            <div>
                <h4> <?php echo $news_item['title'] ?> </h4>
                <p> <?php echo $news_item['body'] ?> </p>
            </div>
        <?php
        }
    } else {
        ?>
        <h3>No News</h3>

        <p>Unable to find any news for you.</p>
    <?php
    }
    ?>
</body>

</html> 