Skip to main content

check email sudah didatabase

May 24, 2011 by juliyan

juliyan's picture

master bantu check coding ku ya,
tujuannya check email yg diinput kalau sudah ada didatabase muncul message kalau true tinggal disave.
ini hasilnya kok malah blank page setelah di run

makasih sebelumnya master

model

class Member_model extends CI_Model {
	//==== Constructor ====//
	function Member_model()
	{
		parent::__construct();
	}
 
	//==== Inisialisasi nama tabel yang digunakan ====//
	var $table = 'tbl_member';
 
	//==== Menambahkan sebuah data ke tabel ====//
	function add($member)
	{
		$this->db->insert($this->table, $member);
	}
 
	//==== Mendapatkan email untuk di check ====//
	function get_member_by_email($email)
	{
		$condition = array("email"=>$this->db->escape_str($email));
		$query = $this->db->get_where($this->table, $condition);
 
		if ($query->num_rows() > 0)
		{
			return FALSE;
		}
		else
		{
			return TRUE;
		}
 
	}
}

controller

class Member extends CI_Controller {
	// Constructor //
	function Member()
	{
		parent::__construct();
		$this->load->model('Member_model', '', TRUE);
		$this->load->library('form_validation');
	}
 
 
	// Berpindah ke form untuk entry data baru //
	function daftar()
	{		
		// Inisialisasi data umum
		$data['content_view'] 	= 'member/member_form';
		$data['form_action']	= site_url('member/add_process');
 
		$this->load->view('page', $data);
	}
 
	// Proses untuk entry data baru //
	function add_process()
	{		
		// Inisialisasi data umum
		$data['content_view'] 	= 'member/member_form';
		$data['form_action']	= site_url('member/add_process');
 
		// cek email 
		if ($this->form_validation->run() == TRUE)
		{
		   $email = $this->input->post('txt_email');
 
		   if ($this->Member_model->get_member_by_email($email) == TRUE)
		   {
 
			$filefoto 	= basename($_FILES['fl_foto']['name']);
				if($filefoto == '')
				{
					$filefoto = 'tidakadafoto.jpg';
				}
				else
				{   
					$filefoto 	= $filefoto;
					$path		= './foto/'.$filefoto;
					$upload		= copy($_FILES['fl_foto']['tmp_name'], $path);
				}
 
 
			// mengambil data untuk disimpan di tabel
			$member = array(
						'email' 	=> $this->input->post('txt_email'),
						'password' 	=> md5($this->input->post('txt_password')),
						'nama' 		=> $this->input->post('txt_nama'),
						'member_pict' 	=> $filefoto 
						);
 
			$this->Member_model->add($member);
 
			$this->session->set_flashdata('message', 'Terimakasih telah mendaftar menjadi member');
			redirect('member/daftar');	
 
				}
 
		   else
		   {
			$this->session->set_flashdata('message', 'Maaf, eMail Anda telah ada dalam database kami');
			redirect('member/daftar');
		   }
		}
	}
 
 
 
}

view

<form name="member_form" id="member_form"  method="post" enctype="multipart/form-data" action="<?php echo $form_action; ?>">
 
		<table width="550" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="150">eMail <em>*</em></td>
    <td width="5">:</td>
    <td width="395"><input type="text" name="txt_email" id="txt_email" value="<?php echo set_value('email', isset($default['email']) ? $default['email'] : ''); ?>" class="required email"/>
    </td>
  </tr>
  <tr>
    <td>Password <em>*</em></td>
    <td>:</td>
    <td><input type="password" name="txt_password" id="txt_password" value="<?php echo set_value('password', isset($default['password']) ? $default['password'] : ''); ?>" class="required" minlength="8"/></td>
  </tr>
  <tr>
    <td>Ulangi Password <em>*</em></td>
    <td>:</td>
    <td><input type="password" name="txt_repassword" id="txt_repassword" value="<?php echo set_value('repassword', isset($default['repassword']) ? $default['repassword'] : ''); ?>" class="required" minlength="8"/></td>
  </tr>
  <tr>
    <td>Nama <em>*</em></td>
    <td>:</td>
    <td><input type="text" name="txt_nama" id="txt_nama" value="<?php echo set_value('nama', isset($default['nama']) ? $default['nama'] : ''); ?>" class="required" minlength="3"/></td>
  </tr>
  <tr>
    <td>Foto</td>
    <td>:</td>
    <td><input type="file" name="fl_foto" id="fl_foto" size="30" style="height:25px;"></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td> <em>*</em> Wajib diisi</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3"><input type="submit" name="submit" id="submit" value="DAFTAR" class="content_button" /> <input type="reset" name="reset" id="reset" value="RESET" class="content_button" /></td>
  </tr>
  </table>
</form>

Comments

Comment viewing options

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

masih sama

May 25, 2011 by juliyan, 9 weeks 2 hours ago
Comment: 8225

juliyan's picture

sudah dipanggil flashdata nya tapi masih sama master firgilius, hasilnya blank page juga..
apa salah dialgoritmanya ya?

Re

May 25, 2011 by firgilius, 9 weeks 3 min ago
Comment: 8229

firgilius's picture

Itu redierctnya
 redirect('member/daftar');
coba cek view
$this->load->view('page', $data);

problem solved

May 26, 2011 by juliyan, 8 weeks 6 days ago
Comment: 8237

juliyan's picture

problem solved
ternyata yang salah di controller di from_validation seharusnya FALSE tapi bikin TRUE.

if ($this->form_validation->run() == FALSE)

makasih buanyak master firgilius

$this->load->view('page',

May 26, 2011 by juliyan, 8 weeks 6 days ago
Comment: 8233

juliyan's picture

$this->load->view('page', $data);
hanya untuk memanggil header, sidebar dan footer saja.

sebelumnya kalau saya tidak pakai ini di controller, bisa jalan dan data bisa disimpan di database tapi pas pakai ini untuk check email malah jadi blank page

if ($this->form_validation->run() == TRUE)
			{
				$email = $this->input->post('txt_email');
 
				if ($this->Member_model->get_member_by_email($email) == TRUE)
				{

selintas sih dilihat algoritma sudah benar, apa ya yg salah?

View

May 24, 2011 by firgilius, 9 weeks 5 hours ago
Comment: 8223

firgilius's picture

Karena d view-nya g ada pemanggilan flashdata, cobain:

<?php if($this->session->flashdata('error')):?>
            <div class="warning">
                <?php echo $this->session->flashdata('message');?>
            </div>
            <?php endif;?>

Premium Drupal Themes by Adaptivethemes