Skip to main content

bikin table

5 replies [Last post]
does not have a status.
audya's picture
User offline. Last seen 14 weeks 1 day ago. Offline
Joined: 04/21/2011

met malem smuanya...mau nanya nih...gmn cara'y ngambil data dr database trus ditampilkan di table tp header table'y diambil dari database?

Rencana'y ky gini:

+-----------+---+---+
|Nama/Pel|Mat|IPA|
+-----------+---+---+
|AAAAAAA| 90| 70|
|BBBBBBB| 80| 60|
|CCCCCC| 90| 80|
+-----------+---+---+

Header Mat dan IPA tu hsl query dr table t_pelajaran,trs data nama dan nilai yg dbawahnya dari table t_nilai dicari berdasarkan pelajaran dan nama

does not have a status.
dyel0108's picture
User offline. Last seen 10 weeks 5 days ago. Offline
Joined: 06/18/2011
Saya sekalian mau tanya donk

Saya sekalian mau tanya donk kk.
Kalo misalnya hasil query nya mau di tampilin dengan format seperti calendar gimana ?
Jadi misalnya saya ada data keuntungan toko perhari.
Ntar saya mau tampilin data keuntungan per-bulan, tapi ga seperti laporan yang biasa panjang ke bawah.
Nah ini ntar di tampilin seperti calendar.
Mohon pencerahan nya donk kk.
Terima kasih sebelum nya.

does not have a status.
ecaiseng's picture
User offline. Last seen 6 weeks 3 days ago. Offline
Joined: 02/28/2011
coba pake ini d view

/**tabel**/
$this->table->set_heading("Nama/Pel", "Mat", "IPA");
foreach ($query->result() as $key=>$val)
{
//Baris Tabel
$this->table->add_row($val->Nama/Pel, $val->Mat, $val->IPA);
}

echo $this->table->generate();

->ace<-

does not have a status.
predhtz's picture
User offline. Last seen 1 week 5 days ago. Offline
Joined: 01/07/2010
coba pake ini untuk

coba pake ini untuk menampilkan field header hasil query database

/* ini dari manual guide CI */

Returns an array containing the field names. This query can be called two ways:

1. You can supply the table name and call it from the $this->db-> object:
$fields = $this->db->list_fields('table_name');

foreach ($fields as $field)
{
echo $field;
}

2. You can gather the field names associated with any query you run by calling the function from your query result object:
$query = $this->db->query('SELECT * FROM some_table');

foreach ($query->list_fields() as $field)
{
echo $field;
}

does not have a status.
Firu's picture
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 03/03/2010
reply

udah tau cara get data dari database kan???kalo udah tau harusnya simple, u tinggal passing data tersebut ke dalam view yang u buat....

Life is a collection of events. - By Firu

Have nice day
primbon's picture
User offline. Last seen 5 weeks 3 days ago. Offline
Joined: 10/29/2010
setuju,ama bro Firu.,jika

setuju,ama bro Firu.,jika sudah bisa get data dari database,terus
maenin di bagian formnya aja /kode HTML nya buat menyusun tampilannya sesuai keinginan,.hehe

Premium Drupal Themes by Adaptivethemes