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.
7
questions
0
votes
1answer
18 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 ...
0
votes
1answer
122 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
21 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
53 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....
0
votes
1answer
114 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
736 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 ...
