21309 Posts in 5738 Topics by 2603 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 762 Views |
-
database row count
2 August 2011 at 2:59pm Last edited: 2 August 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.
thanks.
Attached Files-
Student.png
16 KB -
Student2.png
16 KB
-
-
Re: database row count
2 August 2011 at 11:39pm
Page.php
function Students() {
$students = DataObject::get('Student', "KotaPenerima = 'Jawa Barat'");
return !empty($students) ? $students : false;
}Page.ss
<% if Students %>
student count: $Students.Count
<% control Students %>
student lastname: $Lastname
<% end_control %>
<% end_if %>http://doc.silverstripe.org/sapphire/en/topics/datamodel
http://doc.silverstripe.org/sapphire/en/reference/advanced-templates -
Re: database row count
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'.
| 762 Views | ||
|
Page:
1
|
Go to Top |
