Skip to main content

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
2 votes
1 answer
525 views

Optimize a query multiple tables & Multiple conditions

I need to optimize the query which has multiple joins. And also with multiple OR AND conditions which varies depending upon the user input. The query which gets generated is: SELECT emp.name as ...
Parikshit Bharadwaj's user avatar
-2 votes
2 answers
33 views

Codeignier---sql database [duplicate]

[Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'TantraBackup00.GuildName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause....
chirag jogani's user avatar
0 votes
1 answer
4k views

Get the last ID after INSERT the PostgreSQL database with PgBouncer

Previously we used PostgreSQL 9 with PgBouncer in session mode, and with that was able to easily create a new record and get the last ID with pg_get_serial_sequence and CURRVAL. INSERT INTO "...
Tom's user avatar
  • 428
0 votes
1 answer
58 views

Azure database - unable to locate in my Azure account

I have an Azure account where a developer that used to work with me has set up an MSSQL database on an Ubuntu VM. The PHP (CodeIgniter) system I am working on logs in (so database queries work ...
Kobus Myburgh's user avatar
1 vote
1 answer
1k 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 ...
morshed's user avatar
  • 111
0 votes
1 answer
582 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 ...
mohammad's user avatar
0 votes
1 answer
2k 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 ...
jpsai's user avatar
  • 1