Rabu, 07 Agustus 2013

PHP Indonesia - Facebook: Gan, nanya.. Misal kita punya table "post" isinya ...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Gan, nanya.. Misal kita punya table "post" isinya ...
Aug 7th 2013, 09:23, by Nip Noph

Nip Noph 9:23am Aug 7
Gan, nanya..
Misal kita punya table "post" isinya "judul", ama "content".
Kalo mau ada tambahan fitur "tags" itu enaknya nambah colom "tags" di table "post" yang isinya dipisahkan oleh tanda koma(contoh : php,html,css) atau bikin table baru yang nanti terhubung ke table post?

Al Ghurahy 9:28am Aug 7
langsung aja lah tambah satu kolom/field tags. kecuali tabelnya ribet banget..

Nip Noph 9:33am Aug 7
iya sih gan Al Ghurahy..
tp misal kalo mau nyari brp jumlah artikel yang ada tags "php"? search semua artikel pada tags tertentu?
tekniknya gmn gan yg efektif?

Nip Noph 9:34am Aug 7
trus nyari list tags apa aja yang ada di table post?

Al Ghurahy 9:35am Aug 7
select count(`tags`) as `jumlah` from `artikel` where `tags` like '%php%';

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar