codeigniter-base-model

codeigniter-base-model copied to clipboard

Get data from 2 tables joint in abother table

7

Hi, I have a simple database which uses joins as follows : Table 1 contains portfolio items: Portfolio_items portfolio_id name description Table 2 contains portfolio categories: Categories categories_id name Table...

absmugz

nikhildev4nk

How can I make parallel connection to two DBs on a Model?

1

Hi as per the documnetation $_db_group = 'group_name'; will make this->_db to point on defined db but how can I make a persistant connection to both db and query both...

sagark1510

many to many relationship

2

How to i will add many to many relationship ? is it possible ?

saifulapm

If we are sure that we need only one record, than why not to make that execution faster by limiting the result to one record.

DevotionGeo

Problem with my deleted_by & deleted_at

5

Hi friends I am new to base model deleted_by & deleted_at is not functioning properly null value is updated can anybody help whats wrong in my code. class Article_model extends...

prashantnirgun

delete_by() function doesn't have correct return, possibly others

4

The function `delete_by()` will always return 1, even if nothing was deleted. To fix this the function should return `$this->db->affected_rows();` instead of `$result` Detailed example below with added code for...

facultymatt

_set_where() doesn't allow arbitrary query strings

1

the where() methods in _set_where() could have the 3rd argument as FALSE, so an arbitrary SQL string isn't backticked?

Gumster

The class will automatically use the default database connection, and even load it for you if you haven't yet. You can specify a database connection on a per-model basis by...

webquail

How should i include not equal to (<>) condition in where clause

1

skhajavali