Use of CodeIgniter database

Use of CodeIgniter database

Load database,

?

123	$ This-> load-> database (); you can also modify $ autoload ['libraries'] = array ('database') in the autoload. php file in the config folder ');

In this way, you can use it.

Query a single piece of data:

?

12345

$ This-> db-> select ('title, content, date'); $ query = $ this-> db-> get_where ('test ', array ('id' => $ id); // $ this-> db-> where ('id', $ id ); // $ query = $ this-> db-> get ('test'); return $ query-> row_array ();

Query multiple data entries:

?

123456

$ This-> db-> select ('title, content, date'); $ query = $ this-> db-> get ('test '); // $ this-> db-> from ('test'); // $ query = $ this-> db-> get (); $ this-> db-> order_by ("title", "desc"); return $ query-> result_array ();

Retrieve the total number of records in the database:

?

1234	$ This-> db-> count_all ('test'); or $ this-> db-> where ('aid ', $ aid ); return $ this-> db-> count_all_results ('test ');