PHP Indonesia - Facebook: mas atau mbak , mau tanya sort ascending apa desce...

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. NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

mas atau mbak , mau tanya sort ascending apa desce... Jul 25th 2013, 03:42, by Yeni Kusumawati Yeni Kusumawati 3:42am Jul 25 mas atau mbak , mau tanya sort ascending apa descending dari coloum nama sama tahun dengan php saja gimana caranya ? ini screen shotnya -> Chabib Nurozak 3:45am Jul 25 SELECT * FROM tabel ORDER BY nama,tahun ASC begitukah maksudnya? Yeni Kusumawati 3:54am Jul 25 maksud saya , nanti bila diklik coloum nama nanti bisa sort ascending apa descending . begitu juga sama coloum tahun. kayak di xampp tu lho mas :D Zaini Jamathsani 3:55am Jul 25 oh pake jquery data table Chabib Nurozak 3:56am Jul 25 bisa main PHP pelajari $_GET, bisa pake plugin jquery,, misalkan ini http://www.tripwiremagazine.com/2013/06/jquery-filter-sort-plugins.html Muhamad Rizal 3:59am Jul 25 http://tablesorter.com/docs/ Dimas Ade Rifki Ananda 4:00am Jul 25 Pake data table aja tar semua urusan table udh dia yg ngurusin. Dr mulai sorting .pencarianndata.export Abdillah Hasny 4:01am Jul 25 pake Ext JS :v Fahd Al Aliem Romas 4:05am Jul 25 pake datatable : https://datatables.net/ Deni Tri Hartanto 4:11am Jul 25 bermain di $_GET dan rebuilding link nya bisa make http_build_query. hal-hal gini case enak buat belajar show data, jadi mending buat sndiri demi ilmunya. datatable nnti aja klo udh kerja :p :D Yayan Indra 4:25am Jul 25 pernah nemu webnya yg kyk dimaksud, tp lupa. coba searching2 aja Budi Tyo Tsuneni Aisuru 4:32am Jul 25 <h1>Data Mahasiswa</h1> <!-- membuat kolom tabel dan link pengurutan --> <!-- perhatikan parameter by=... --> <table border="1"> <tr><th><a href="<?php $_SERVER['PHP_SELF']?>?by=nim">NIM</a></th><th><a href="<?php $_SERVER['PHP_SELF']?>?by=nama">Nama Mhs</a></th><th><a href="<?php $_SERVER['PHP_SELF']?>?by=alamat">Alamat</a></th><th><a href="<?php $_SERVER['PHP_SELF']?>?by=sex">Jenis Kelamin</a></th><th><a href="<?php $_SERVER['PHP_SELF']?>?by=tgl">Tgl Lahir</a></th></tr> <?php // koneksi ke mysql mysql_connect("dbhost", "dbuser", "dbpass"); mysql_select_db("dbname"); // jika yang diklik kolom NIM if ($_GET['by'] == "nim") $orderBy = "nim"; // jika yang diklik kolom NAMA MHS else if ($_GET['by'] == "nama") $orderBy = "nama"; // jika yang diklik kolom ALAMAT else if ($_GET['by'] == "alamat") $orderBy = "alamat"; // jika yang diklik kolom JENIS KELAMIN else if ($_GET['by'] == "sex") $orderBy = "sex"; // jika yang diklik kolom TANGGAL LAHIR else if ($_GET['by'] == "tgl") $orderBy = "tgllahir"; // jika tidak ada yang diklik (default) else $orderBy = "nim"; // query untuk menampilkan data berdasarkan field yang terurut // sesuai pilihan di atas $query = "SELECT * FROM mahasiswa ORDER BY ".$orderBy; $hasil = mysql_query($query); while ($data = mysql_fetch_array($hasil)) { // tampilkan data echo "<tr><td>".$data['nim']."</td><td>".$data['nama']."</td><td>".$data['alamat']."</td><td>".$data['sex']."</td><td>".$data['tgllahir']."</td></tr>"; } ?> </table> coba yang ini gan???? Arful Ok 4:42am Jul 25 Pake data table mbag, gmpang

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