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.
6
questions
-2
votes
2
answers
32
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....
0
votes
1
answer
1k
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 "...
- 285
0
votes
1
answer
28
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 ...
- 135
0
votes
1
answer
499
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
1
answer
236
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 ...
- 21
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 ...
- 1