Hello, I use codeigniter since few week and i just see a mistake... with oracle < 12.1 the pagination is incorrect :

In system/database/driver/oci8/oci8_driver.php you have to modify function _limit:


/**
     * LIMIT
     *
     * Generates a platform-specific LIMIT clause
     *
     * @param   string  $sql    SQL Query
     * @return  string
     */
    protected function _limit($sql)
    {
        if (version_compare($this->version(), '12.1', '>='))
        {
            // OFFSET-FETCH can be used only with the ORDER BY clause
            empty($this->qb_orderby) && $sql .= ' ORDER BY 1';

            return $sql.' OFFSET '.(int) $this->qb_offset.' ROWS FETCH NEXT '.$this->qb_limit.' ROWS ONLY';
        }

        $this->limit_used = TRUE;
        return 'SELECT * FROM (SELECT inner_query.*, rownum rnum FROM ('.$sql.') inner_query WHERE rownum < '.($this->qb_offset + $this->qb_limit + 1).')'
            .($this->qb_offset ? ' WHERE rnum >= '.($this->qb_offset + 1) : '');
    }



Calcul of limit is not exact in this case.


With this code it's ok  :




/**
     * LIMIT
     *
     * Generates a platform-specific LIMIT clause
     *
     * @param   string  $sql    SQL Query
     * @return  string
     */
    protected function _limit($sql)
    {
        if (version_compare($this->version(), '12.1', '>='))
        {
            // OFFSET-FETCH can be used only with the ORDER BY clause
            empty($this->qb_orderby) && $sql .= ' ORDER BY 1';

            return $sql.' OFFSET '.(int) $this->qb_offset.' ROWS FETCH NEXT '.$this->qb_limit.' ROWS ONLY';
        }

        if($this->qb_offset=="") $this->qb_offset=1;
        $this->limit_used = TRUE;
        return 'SELECT * FROM (SELECT /*+ FIRST_ROWS(n) */ inner_query.*, rownum rnum FROM ('.$sql.') inner_query WHERE rownum < '.(($this->qb_offset * $this->qb_limit)+ 1).')'
            .($this->qb_offset ? ' WHERE rnum >= '.(($this->qb_offset - 1)*$this->qb_limit+1) : '');
    }


Have fun & code
Nico (Miko)

My table looks like this , and I'm trying to allow user to change data order asc/desc by clicking the button at thead. I'm not sure how to do it , any idea ?

I have been using CI for a few years now and have several products in production using it.

I consider myself to have intermediate knowledge of CI.

If there a course out there that could take me from intermediate to expert level of knowledge?

Or would it be best to wait till CI4 before doing said course?

Thanks in Advance!

I am working on a basic blog application in Codeigniter 3.1.8 and Bootstrap 4.

I have been working for some time on this application and consequently, it has a lot of features. Most of these rely on the ids of posts, pages, etc.
For SEO purposes, I would like to use friendly URLs, instead of ids to display the individual posts, so I have added a slug column to the posts table.




The slugs are made from post titles, with this chunks of code in the Posts_model model and the Posts controller, respectively.
From the model:

Hi, J.P.
Why CI4 doesn't provide a funtion to read files in file_system_helper?

Is there a clean way of replacing the PHP config files in CodeIgniter 3 with a different format like JSON or TOML without having to type in the location of the value for each variable in the PHP file? Is this even a good idea?

Hello, sorry for disturb, i have a problem in my website, not load correctly css of one page in one linux hosting.
In develop hosting work correctly (xampp), in other webhosting with plesk work correctly
 


In hosting production not work correctly:


In error log i see:
404 Page Not Found: Css/jquery.dataTables.min.css
404 Page Not Found: Css/Redirecting.css

The code is:

Hi
When i load page,sometime website cannot load completely (css and other)
After reload page,it is OK
Why?
I attach picture here
Correct page is :
   

And when my page is not complete loading
   

In App.php there is an array variable:
    public $toolbarCollectors = [
        'CodeIgniter\Debug\Toolbar\Collectors\Timers',
        'CodeIgniter\Debug\Toolbar\Collectors\Database',
        'CodeIgniter\Debug\Toolbar\Collectors\Logs',
        'CodeIgniter\Debug\Toolbar\Collectors\Views',
//        'CodeIgniter\Debug\Toolbar\Collectors\Cache',
        'CodeIgniter\Debug\Toolbar\Collectors\Files',
        'CodeIgniter\Debug\Toolbar\Collectors\Routes',
        'CodeIgniter\Debug\Toolbar\Collectors\Events',
    ];

Is it possible to define an array variable in .env file?
For example:
app.css_files = [
     'bootstrap.css',
     'fontawesome.css',
     'stylesheet.css'
]
or
app.css_files = ['bootstrap.css', 'fontawesome.css', 'stylesheet.css']

I want to add two rowdata in one value using mpdf