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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

General Questions /

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

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

database row count

Go to End

3 Posts   1441 Views


Community Member, 6 Posts

2 August 2011 at 2:59pm

Edited: 02/08/2011 3:00pm

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

Community Member, 344 Posts

2 August 2011 at 11:39pm


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 %>


Community Member, 6 Posts

3 August 2011 at 4:34pm

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'.