Asumsi pertama, saya sudah membuat beberapa custom fields.
Contoh ketika dilihat di tabel
smf_custom_fieldsid_field | | | col_name | | | field_name | | | field_desc | | | field_type | | | field_options |
- | - | - | - | - | - | - | - | - | - | - |
1 | | | lokasi | | | Lokasi | | | Alamat tempat tinggal saat ini | | | text | | | |
2 | | | jeniske | | | Jenis Kelamin | | | | | | radio | | | Laki-laki,Perempuan |
3 | | | status | | | Status | | | Status nikah
| | | select | | | Nikah, Belum Nikah
|
4 | | | pekerjaa | | | Pekerjaan | | | Aktivitas sehari-hari yang ditekuni | | | text | | | |
Kemudian saya sambil beberapa member yang sudah punya data custom profil di
smf_themesid_member | | | id_theme | | | variable | | | value |
2 | | | 1 | | | lokasi | | | Indonesia |
2 | | | 1 | | | jeniske | | | Laki-laki |
2 | | | 1 | | | status | | | Belum Nikah
|
2 | | | 1 | | | pekerjaa | | | SMF Maniacs
|
1 | | | 1 | | | lokasi | | | Di mana saja
|
1 | | | 1 | | | jeniske | | | Laki-laki |
1 | | | 1 | | | status | | | Nikah |
1 | | | 1 | | | pekerjaa | | | Forum Administrator |
3 | | | 1 | | | lokasi | | | |
3 | | | 1 | | | jeniske | | | Perempuan
|
3 | | | 1 | | | status | | | Belum Nikah
|
3 | | | 1 | | | pekerjaa | | | |
Dalam hal ini diambil sampel 3 member saja, plus kolom (atribut) saya pilih saja, tidak semua ditampilkan.
Sekarang kita gabungkan dengan data di tabel
smf_members.
Tugas 1 Menampilkan data member urut status.select distinct smf_members.id_member, smf_members.real_name, smf_themes.value as status
from smf_members, smf_themes
where smf_members.id_member=smf_themes.id_member
and smf_themes.variable='status' ORDER BY status
hasil: id_member | | | real_name | | | status |
1 | | | Administrator | | | Nikah |
2 | | | Cyclon | | | Belum Nikah |
3 | | | SMF | | | Belum Nikah |
Tugas 2 Menampilkan statistik member berdasarkan jenis kelamin.SELECT smf_themes.value AS Kelamin, count( smf_themes.value ) AS Jumlah
FROM smf_members, smf_themes
WHERE smf_members.id_member = smf_themes.id_member
AND smf_themes.variable = 'jeniske'
GROUP BY Kelamin
hasil: Kelamin | | | Jumlah |
- | - | - |
Laki-laki
| | | 2 |
Perempuan
| | | 1 |
Tugas 3 Menampilkan statistik member berdasarkan status nikah.SELECT smf_themes.value AS Status, count( smf_themes.value ) AS Jumlah
FROM smf_members, smf_themes
WHERE smf_members.id_member = smf_themes.id_member
AND smf_themes.variable = 'status'
GROUP BY Status
hasil: Status | | | Jumlah |
- | - | - |
Belum Nikah
| | | 2 |
Nikah
| | | 1
|
Tutorial lain menyusul. Have fun!
sipppp... mantab
om tanya...... kalo mau nambah fields apa yang harus di edit di RC? misala mau nambah fields kelas, atau jurusan: plisssssssss om, nuwun sebelum dan sesudahya :)