Questions tagged [codeigniter]

Use ONLY if CodeIgniter is directly relevant to the question, e.g. how to use the database/querying features that are offered by CodeIgniter.

Filter by
Sorted by
Tagged with
0
votes
1answer
33 views

MySQL query takes too long in codeigniter

I've made this query SELECT id,name,iupac_name,inchi_key,molecular_weight,molecular_formula,exact_molecular_mass FROM compound WHERE name LIKE '%quer%' OR iupac_name LIKE '%quer%' OR ...
0
votes
0answers
18 views

mysql-5.7 and php5.6 - error on LONGTEXT Field type saying a 387 character long string cant fit in

Ok Here is my frustration cause: I've got this table structure: CREATE TABLE `blog_post` ( `bp_id` INT(11) NOT NULL AUTO_INCREMENT, `user_fid` INT(11) NULL DEFAULT NULL, `cat_fid` INT(11)...
0
votes
1answer
51 views

MYSQL - how can use a field of current record as a where clause in a sub query

Ok. I want these info from each user record. user.username user.fullname report_qty so the first two fields exist in the user table. but the last one should be computed from ther tables. i have a ...
0
votes
0answers
6 views

Getting data from two tables and displaying 3 rows associated with one column of first table

Here is my query in controller "g.id, g.game_name, g.game_tags, g.game_image, g.screen_shot, g.description, m.difficulty, m.links", "games g", "mode_links m", "m.game_id = g.id", "g....
1
vote
1answer
74 views

I Want To insert data in transaction table and at the same time update customer table in codeigniter

(codeigniter) I Want To insert data in transaction table and at the same time update customer table . I want to Add value of ChangeDue in transation table To value now_debt in Customer Table ...
0
votes
1answer
557 views

“undefined function pg_pconnect()” when connecting to Postgres from CodeIgniter

I just installed Postgresql and pgadmin in my Ubuntu system. I can create a database from the pgadmin interface and everything seems ok, but when I try to connect to the database from my CodeIgniter ...
0
votes
1answer
477 views

Remove a field in array in mongodb using codeigniter library [on hold]

using mongo db library for ci link my user collection is as follows { "_id" : ObjectId("5a9cf393be713df40e00002d"), "id" : "1", "name" : "ali", "category" : { "back" : "12", "front" : "...