Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

database row count


3 Posts   1011 Views


2 August 2011 at 2:59pm (Last edited: 2 August 2011 3:00pm), Community Member, 6 Posts

hi. I have a database table like that in the attached file. I want count number of database rows. if in sql may look something like this, SELECT count (KotaPenerima) FROM `student` WHERE KotaPenerima = 'Jawa Barat'. How do I put this function, and if I want to display query results on the front page.


Attached Files

2 August 2011 at 11:39pm Community Member, 215 Posts


function Students() {
$students = DataObject::get('Student', "KotaPenerima = 'Jawa Barat'");
return !empty($students) ? $students : false;

<% if Students %>
student count: $Students.Count
<% control Students %>
student lastname: $Lastname
<% end_control %>
<% end_if %>


3 August 2011 at 4:34pm Community Member, 6 Posts

Hi devlin .. thanks for your quick response.
Wow ..
it's work, Thank you very much.

I'm still a newbie in using SilverStripe.
but I found another problem, I would like the 'KotaPenerima' a variable that contains all of the 'KotaPenerima, not just 'JawaBarat'. may be an array, I do not know what to put where the array functions?

so that I can display the count of each 'KotaPenerima'.