I wanna select specific columns from table. Not all columns.
$this->userModel->where($where)->first();
I'm using this but it returns all data.
Asked
Active
Viewed 1.1k times
2
Aksen P
- 4,564
- 3
- 14
- 27
Hamid Ejaz
- 88
- 1
- 1
- 7
-
Do you know names of these columns? Syntax of `$this->userModel->where($where)` is weird for me. Would you like to use some separated method in model which will make a select for return? – Aksen P Jan 26 '20 at 21:08
-
do `print_r( $this->userModel->where($where)->first()` and show us what are you getting. – alithedeveloper Jan 26 '20 at 21:10
-
yes i know names of columns. how can i select like userid, username only – Hamid Ejaz Jan 26 '20 at 21:11
-
your question is not clear but for now, what I got is you can use `Where`. – Sandeep Sharma Jan 26 '20 at 21:16
-
i wanna select specific columns like we were did on Ci3 select('userid,username') – Hamid Ejaz Jan 26 '20 at 21:18
-
`$this->userModel` has inbuilt stuff like `$db->table('mytable');`? – Aksen P Jan 26 '20 at 21:26
-
Are you familiar with codeigniter 4? if yes i need this thing select userid,username from userid=5 in ci4 methods. – Hamid Ejaz Jan 26 '20 at 21:28
-
https://codeigniter.com/user_guide/database/query_builder.html#looking-for-specific-data may help... – dale landry Jan 26 '20 at 21:35
-
@dalelandry, CI3 has another syntax. There is case with CI4. – Aksen P Jan 26 '20 at 21:39
2 Answers
1
According to the CI4 query builder documentation you can use select() in this way:
$db = \Config\Database::connect();
$builder = $db->table('mytablename'); // 'mytablename' is the name of your table
$builder->select('userid, username'); // names of your columns, single string, separated by a comma
$builder->where('userid', 5); // where clause
$query = $builder->get();
return $query;
where() could be possible to use in 4 ways, you can choose.
This stuff should be placed in Model file, method of which would return $query set of DB data.
Aksen P
- 4,564
- 3
- 14
- 27
-
This solve my problem thanks a lot for getting records i add this thing in code $query->getFirstRow($this->tempReturnType) – Hamid Ejaz Jan 26 '20 at 21:52
-
@user1951608, you're welcome! Now you have CI4 documentation) It's weird that CI3 and CI4 have different websites, I thought they'd updated CI3 website, but no, they've created separated website. – Aksen P Jan 26 '20 at 21:56
-
1CI4 has improved a lot from CI3, and the CI3 userbase is higher as well, so separate website is better in my point of view. – Vishal Kumar Sahu Sep 20 '20 at 22:50
-
$builder->select('userid','username'); did not work for me. It selected only userid. In CI 4 docs, $builder->select() takes only the first parameter as a string of your column names. So it should be a string with comma separated values: $builder->select('userid, username'); – ChelaTheGreat Aug 13 '22 at 03:12
1
(Tested under CI 4.2.7)
There is also a select method in the model, which accepts an array of columns:
$userModel->select(['id','name'])->where('id', 1)->first();
acala
- 332
- 3
- 11