Fixing the Cannot use object of type mysqli as array Error in CodeIgniter 4

Encountering the `Cannot use object of type mysqli as array` error in CodeIgniter 4? Learn how to resolve this issue with our easy-to-follow guide!
---

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: I'm facing this error Cannot use object of type mysqli as array

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Understanding and Fixing the Cannot use object of type mysqli as array Error in CodeIgniter 4

If you've been working with CodeIgniter 4 and encountered the frustrating error message: Cannot use object of type mysqli as array, you're not alone. This common error usually occurs when you're trying to treat an object as an array, which can happen if you mistakenly attempt to access query results incorrectly in your controller.

In this post, we'll dive into the problem, understand why it occurs, and, most importantly, explore the solution that will get you back on track.

The Problem Explained

In your controller code, you're trying to fetch data from the database using the Model, but instead of returning the data itself, you're returning the query object. This mix-up between the query object and the expected array format leads to the error when you attempt to access the results in your view.

Controller Code Example

Here’s the key snippet from your original controller code:

[[See Video to Reveal this Text or Code Snippet]]

Understanding the Query Object

In this example, the $data variable contains a query builder object, not the actual data array you need to render in your view. When you then pass this object to the view and try to use it like an array, PHP throws the Cannot use object of type mysqli as array error.

The Solution

To fix this problem, you need to adjust your controller code to properly retrieve the results from your query. Let’s break down the solution step-by-step.

Step 1: Modify the Query Execution

You should replace the combination of select() and where() methods followed by get() with the findAll() method, which will correctly return the array of results based on the specified criteria. Here’s the corrected version of your controller:

[[See Video to Reveal this Text or Code Snippet]]

Explanation of the Fix

Select Method: The select() method specifies which columns you want to retrieve. In this case, it’s text, title, and image.

Where Method: This filters the data to get results that match the specified ID.

FindAll Method: Using findAll() fetches the data as an array rather than a query object, which eliminates the error when you access this data in your view.

Step 2: Access the Data in the View

Once you have the results correctly loaded into the variable $nadeem['result'], you can iterate over it in your view without encountering errors. Here's the relevant part of your view code:

[[See Video to Reveal this Text or Code Snippet]]

Ensuring Everything Works Together

By correctly retrieving the data as an array in your controller, your view should now render without any issues.

Conclusion

In summary, the error Cannot use object of type mysqli as array can be resolved easily by ensuring that you're passing the correct data type to your view. Remember to always grab the actual results from your queries before attempting to use them.

By following the steps outlined in this guide, you should now be able to effectively troubleshoot and fix this error in your CodeIgniter 4 applications.

If you have any further questions or run into other issues, feel free to reach out or leave a comment!