(It's a sunny morning with a cup of coffee on the veranda so please forgive this philosophical post)
Been working on my brand new shiny CI4 project for a couple of days now and it's shaping up rather nicely. This project is a planned new REST-based backend for an old monolithic web-project created eons ago. The new UI is made in Sencha ExtJS 7.0.0-EA so it's bleeding edge both frontend and backend.

I have been using CI3 for many projects and consider myself rather fluent in how it works. Looking back at the CI4 project so far I notice a big shift in how I code CI4 compared to CI3 and notably that my Controllers are "fattier" than in my CI3 Controllers. With CI3 I adopted the "thin Controller - fat Model" approach where the Controller basically only called functions in the Model. The Models' code got pretty lengthy but kept the notion of working on the data while the Controller mainly checked input and access. In CI4 I now have lengthy database code that should have gone into the Model in CI4.

Don't get me wrong - I sort of like the new Model in CI4 but it is too much pixie-dust sprinkled over them. With all this magic going on I don't feel confident to add code in the Model that may upset the delicate machinery, breaking things. The (imagined?) one-to-one mapping between a Model and a database table may be part of my thinking around this. The mixing of the Query Builder and the Model is another thing that really scares me and I tend to use the Query Bilder completely separate from the Model.

All my hesitation might be just me over-thinking stuff but we need to deliver a fast and reliable solution to our customers and users and I need to feel as confident with CI4 as I did with CI3.

A big thank you for moving CI4 forward!
/Mattias

Hello all!

I have my Users.php controller that operates login/register and it works perfectly but I recently purchased a FB style script which has wall post, chat, and friends portion that I want to implement into my site. This script has its own controllers/models of course but I how do I add these within my Users.php so that everything connects and all the tables within my DB work together? 



,
Mekaboo

Hello everyone,

I wonder what are the most used OO Design Patterns you guys use along with your CI projects?

I'm asking this because sometimes I kind of end up writing heavy controllers with a lot of complex logic and some protected methods, for example, when I have to reuse a block of code, or creating methods on MY_Controller when there is more than one controller using that logic, etc.

Another example, sometimes I worry about data/variables relying on the session library because I think it's up to us to avoid overwriting a variable, so we have to be careful depending on how many variables you are going to deal in your session. Usually, my approach is using a name convention to avoid this scenario.

I also like to write my own "domain classes", to avoid only "array organized data", these will be my objects that will represent my database tables (entities). I try to design them with some OO principles that we don't have in the relational paradigm, for instance, if I have a "one to many" relationship in the database, in the equivalent object I'll have a collection (array of child-objects).

In other words, how many other classes, and how much complex, you guys like to create besides the traditional MVC pattern?

Thanks, have a great week!

Looking at CI4 and working with databases I can't find a way to get the number of rows returned from a query. 
In CI3 I often did:

This is that last of the known breaking changes, and one that had been bugging me for a while. Thanks to those that prodded this change on, we now have a bit more cohesive migration change. Follow the link to see all of the gory details, but here's the big items:

- No more serial names (001, 002, etc). All migrations use timestamps now, which can be formatted in several ways to suit your preference.
- Class names have changed, they're now Pascal-cased like all other classes in the system, and do not need Migration_ at the beginning of the name. This was unnecessary since they're all namespaced now.
- Command name has changed from migrate:latest to simply migrate.
- When running php spark migrate -all it now pulls together all migrations across all namespaces and sorts them by their timestamp, instead of treating each namespace separately.

Follow Full details here

Dear Team,
Please this code can run on view but returns zero or null for total_marks and Average score whenever i run it on controller.
Tell me what i am doing wrong. Thanks 

function testme ($exam_id,$class_id){

$soap_data['exam_id'] = $exam_id;
$soap_data['class_id'] = $class_id;

        $soap_data['year']       = $this->db->get_where('settings' , array('type'=>'running_year'))->row()->description;
        if($soap_data['class_id'] != '' && $soap_data['exam_id'] != ''){


$subjects = $this->db->get_where('subject' , array('class_id' => $class_id , 'year' => $running_year))->result_array();
foreach($subjects as $row){ echo $row['name'];}



$students = $this->db->get_where('enroll' , array('class_id' => $class_id , 'year' => $running_year))->result_array();
    foreach($students as $row){

$total_marks = 0;
            $total_grade_point = 0;
                    foreach($subjects as $row2)
$obtained_mark_query = $this->db->get_where('mark' , array(
'class_id' => $class_id , 
'exam_id' => $exam_id , 
'subject_id' => $row2['subject_id'] , 
'student_id' => $row['student_id'],
'year' => $running_year
));
if ( $obtained_mark_query->num_rows() > 0) {
$obtained_marks = $obtained_mark_query->row()->mark_obtained;
if ($obtained_marks >= 0 && $obtained_marks != '') {
$grade = $this->crud_model->get_grade($obtained_marks);
$total_grade_point += $grade['grade_point'];
}
$total_marks += $obtained_marks;

}

$soap_data['Total_score'] = $total_marks;
$this->db->where('class_id' , $class_id);
$this->db->where('year' , $running_year);
$this->db->from('subject');
$number_of_subjects = $this->db->count_all_results();
$average_score= ($soap_data['Total_score'] / $number_of_subjects);
$avg =  round($average_score,2);
$soap_data['Average_score'] = $avg;
}



        $query = $this->db->get_where('total_mark' , array(
                    'exam_id' => $soap_data['exam_id'],
                        'class_id' => $soap_data['class_id'],
                            'Total_score' => $soap_data['Total_score'],
                                'Average_score' => $soap_data['Average_score'],
                                    'year' => $soap_data['year']
                ));
        if($query->num_rows() < 1) {
           $students = $this->db->get_where('enroll' , array('class_id' => $soap_data['class_id'] , 'year' => $soap_data['year']))->result_array();
            foreach($students as $row) {
               $soap_data['student_id'] = $row['student_id'];
                $this->db->insert('total_mark' , $soap_data);
            }
}
}

}

More questions on CI3 -> CI4...
In my old project I use SQL_CALC_FOUND_ROWS to query the database for the total count of records while doing a WHERE/LIMIT query. I need to LIMIT the queries to keep the frontend UI happy with huge datasets. I should only insert SQL_CALC_FOUND_ROWS if there is a WHERE clause in the SQL query, otherwise the query will be slow and a COUNT(*) is better.

In CI3 I could inject the SELECT directly into the $db object, but that's not the case in CI4 where the $db is not global. Rather than passing around $db I wonder if it is possible to extend \CodeIgniter\Database\MySQLi\Builder with my own function to add a function so I could do something like this:

Struggling along trying to recreate my REST API from CI3 in CI4-beta4. I find it very cumbersome to configure all my route entries in Routes.php like this (far from complete):

I've been tasked with updating a codeigniter application from version 2 to 3 using the https://www.codeigniter.com/user_guide/i...e_300.html which had been going fine until I started testing the inputs.
I have never used codeigniter before so worried that if I keep tinkering I will break more of the application
The application is a booking diary where you have to log in to your account or create an account in order to book. The log in  to an existing account works but neither the create user form or the booking form send information to the database. They are not returning any errors on the page and in the log: Session: "sess_save_path" is empty; using "session.save_path" value from php.ini. Here is the Booking Controller:

Pagination on the number of pages but if i want to view data start with K, i click on 'K' and its jump to page 33 which is a page that starting with k letter. How to implement something like this? 

select all data to find the K starting point look waste of resource (because we need to find other 25 letter starting point too) any better way to implement this?

for example: *REDACTED*