February 7, 2020


The secondary benefit of using binds is that the values are automatically escaped, producing safer queries. Returns the query results as an array of rows, where each row is an object of type stdClass. What version of CI are you using? Identical to the above row method, except it returns an array. What does your panel look like when you login today? It gives the following error:

Uploader: Arashijinn
Date Added: 20 September 2008
File Size: 20.51 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 1675
Price: Free* [*Free Regsitration Required]

If your query has more than one row, it returns the current row and moves the internal data pointer ahead. Generates an array of stdClass objects containing codeignitef meta-data.

Array containing the fetched rows Return type: My website was working fine for some time until it suddenly stopped connecting to the database. The secondary benefit of using binds is that the values are automatically escaped, producing safer queries. I would check codeeigniter apache error log as well as the php error log to see mhsqli going on. Sign up using Facebook. When strict mode is enabled, if you are running multiple groups of transactions and one group fails, all subsequent groups will be rolled back.


These failovers can be specified by setting the failover for a connection like this:.

Number of fields in the result set Return type: Then, to globally tell the system to use that group you would set this variable located in the config file:. Today, magically, I was victim of the infamous “white screen of death”.

Array containing field meta-data Return type: Can you run all three snippets in a test. Please make sure your database settings are correct.

The how-to material for this has been codeignitsr over several articles.

Join the Conversation

It gives the following error: This method returns the query result as a pure array, or an empty array when no result is produced. If the database platform does not support primary key detection, the first column name may be assumed as the primary key. Stack Overflow works best with JavaScript enabled. I am getting the old panel when I login. This function will also add a table prefix to your table, assuming you have a prefix specified in your database config file.

In addition to the two methods codeignniter below, the following methods also can take a class name to return the results as: The second parameter is the class name to instantiate.


Generating Query Results — CodeIgniter documentation

View a Printable Version. Cosmo Arun 6. Not all methods are supported by all database drivers, some of them may fail and return FALSE if the underlying driver does not support them. Hi I’m kinda new to this coddigniter I would like to ask someone here that are experts in codeigniter framework and PHP.

This class will not be called directly. Post as a guest Name. Thanks for taking the time out to help me here This is the database. What should I do?

Returns the requested result row as an object of type stdClass. This method returns the query result as an array of objectsor coddeigniter empty array on failure.

Database Configuration — CodeIgniter documentation

Takes a column or table name optionally with an alias and applies the configured dbprefix to it. Samuel Anand 1 5. Returns the entire result set as an array of instances of the class requested.