All Questions
Tagged with mysql codeigniter
10,161
questions
0
votes
1
answer
27
views
Same table union from different databases
I have 03 MySQL databases as 2022_db, 2023_db and 2024_db. All the tables and table structures in the 03 databases are same & included different values.I want to get the sum of values in two ...
- 281
0
votes
0
answers
33
views
Codeigniter 3 won't show in localhost
The output when I entered localhost/[folder_project_name]
For information, this folder I've got is the source code for my project. This source code given to me from the lead. I want to make similar ...
- 1
-1
votes
0
answers
24
views
Get value of 2 tables using join, using first table column value
I want CodeIgniter formatted query, not simple mysql query.
I have 2 tables. I want to get ProductID (primary key) from tblProduct using ProductUrl value. Then tblProduct.ProductID should join with ...
- 230
0
votes
0
answers
71
views
query optimization for perfex crm accounting module when dealing with large number of data
Could someone assist me in optimizing the following two functions responsible for loading data into dashboard charts? They currently take approximately five minutes to execute due to a growing dataset ...
- 19
1
vote
1
answer
131
views
mysqli::real_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known
I am trying to debug my codeigniter 1.0.0 app code using phpstorm and xdebug with Docker. Both Phpmyadmin and Adminer containers are able to connect to mysql on another container, but codeigniter ...
- 738
0
votes
0
answers
30
views
Codeigniter 4 : BUG Data not inserted to database
I have a data problem where $data does not enter the pemesanan table. I have done dd($data) and the data is in array form. when I do $PemesananModel->save($data), the data is not inserted to the ...
0
votes
2
answers
59
views
Subquery Condition In Codeigniter 4
Any idea how to convert query below into Codeigniter?
select agency from agency where agency not in (SELECT agency FROM trip where trip_type = 'local trip' group by trip_type, agency having count(...
- 11
0
votes
1
answer
110
views
I got some error in pagination in ci3 below i have attached the error
this is the error
A PHP Error was encountered
Severity: 8192
Message: ctype_digit(): Argument of type null will be interpreted as string in the future
Filename: libraries/Pagination.php
Line Number: ...
0
votes
0
answers
53
views
MySql field name have dot . Data not insert [duplicate]
I have OrderList table in mysql. there is field name paymentInfo.Prepaid.razorpayOrderId. I want to insert the data using codeigniter. But I'm getting below the error
Unknown column 'paymentInfo....
- 9,209
2
votes
0
answers
51
views
Search and filter with multiple tables
I want to search and filter from multiple tables with search term as input from user
I have tables like
Profiles
id first_name last_name middle_name gender life_status lds_number status
1 ...
- 570
0
votes
1
answer
21
views
Sum with join returns wrong data
I have 3 tables in the database and I'm trying to return summation from 2 columns regarding a criteria.
I need to list the sections [sec_name] , Defects QTY [sum(pdr_qty)] ,Production QTY [sum(pg_qty)]...
- 13
0
votes
2
answers
57
views
How can I display the number of doctors for each department in this code?
I have a table in the database that I named department, and another that I named doctor. I plan to display the number of doctors for each department. But when I try to display them, I always get the ...
- 11
0
votes
0
answers
45
views
Codigniter database connection to Digital Ocean DB
From Codeigniter 3, I am unable to connect to Digital Ocean Managed MysQL database. I can connect MySQL from terminal of any allowed instance AND native PHP works as well but not from Codeigniter &...
- 91
0
votes
0
answers
25
views
Fetching values from database and show in an array as a php variable is not working
I have a holidays table where company_id and off_days are two columns which have multiple rows. I have created a function nextWorkingDay() to skip Friday and holidays depend on company_id. In the ...
1
vote
0
answers
89
views
CodeIgniter 4 migration fails but the equivalent MySQL query does not
CodeIgniter newbie here.
I am trying to create a migration in CodeIgniter 4 and it keeps failing due to the same issue.
I tried to run the - to my understanding - equivalent query in MySQL and that ...
- 11