Skip to main content

Tolong Ajarin penggunaan database...

April 30, 2009 by medoose

medoose's picture

Mas, tolong dong ajarin database di CI, kayak INSERT, GET, UPDATE, dsb...

misalnya saya pingin bikin user profile page nih, terus kan harus bikin form buat masukin ke database sbb:
Nama :
Email :
signatur :
profile pict :
dll...
ato contoh lainnya saya pengen bikin halaman buat write post, edit post, delete post, dsb...

tolong ya ajarin... pusing niiih baca2 user guide CI yang bahasa inggrisnya...

Thanx be4...

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

sory nech

February 13, 2010 by bella, 1 year 51 weeks ago
Comment: 5892

bella's picture

sory nech kurang enak nulis comment disini tidak bebas, itu gw tulis sebagian aja tapi klo lo mau gw kirim ke email lo aja

select

February 13, 2010 by bella, 1 year 51 weeks ago
Comment: 5891

bella's picture

model: mUser
function ambilData(){
$data = array();
$query = $this->db->get('msuser');
if($query >= 0){
foreach($query->result_array() as $row){
$data[] = $row;
}
}
$query->free_result();
return $data;
}

nah skerang kita buat controller:
class Welcome extends Controller{
function Welcome (){
parent::Controller();
}
function user(){
$data['user'] = $this->MUser->ambilData();
$this->load->view('home',data);
}
}

insert + update

February 13, 2010 by bella, 1 year 51 weeks ago
Comment: 5890

bella's picture

di model insert:
function insert($nama,$Email){
$data = array(
'nama' => $nama,
'email' => $email
);
$this->db->insert('muser',$data);
}
di model update:
function update($id,$nama,$Email){
$data = array(
'nama' => $nama,
'email' => $email
);
$this->db->where('id',$id);
$this->db->update('muser',$data);
}

yg gampang pake scaffold aja

May 12, 2009 by dodets, 2 years 38 weeks ago
Comment: 3589

dodets's picture

coba baca guide nya yg bagian scaffold.. :D

bla bla bla

May 12, 2009 by medoose, 2 years 38 weeks ago
Comment: 3587

medoose's picture

weleh, kok yang jawab spam bahasa arab??

cegah spam pake capcha

May 12, 2009 by snowinthedark, 2 years 38 weeks ago
Comment: 3590

snowinthedark's picture

bos admin klo bisa di forum ditambahin capcha pada saat pengiriman comment biar spam gk ikut nangkring di forum :D

Premium Drupal Themes by Adaptivethemes