Showing posts with label CRUD. Show all posts
Showing posts with label CRUD. Show all posts

Monday 15 August 2016

Update Database -CRUD 3 -Codeigniter 3

Posted on August 15, 2016 by Hasta Nurhusada
Gambar 1. Update Database -CRUD 3 -Codeigniter 3



Langkah Awal:

1.  Config Database(dilihat halaman crud 1)
2.  Autoload Database (dilihat halaman crud 1)
3. Baseurl (dilihat halaman crud 2)
link halaman sebelumya:
https://komputasistat.blogspot.co.id/2016/08/insert-database-crud-2-codeigniter-3.html
https://komputasistat.blogspot.co.id/2016/08/select-database-crud-1-codeigniter-3.html

Langkah Selanjutnya:


1. database SQL:
CREATE TABLE IF NOT EXISTS `user` (
  `role` int(1) NOT NULL,
  `id_user` int(4) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` char(128) NOT NULL,
  `last_login` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`role`, `id_user`, `username`, `password`, `last_login`) VALUES
(1, 1, 'hastan', 'C1CF6A5C0E168B080C446E7F5600B2404BA06387DC10D96014C941E5F82615AE96AA231727D38728AA446F26B6765CFDBA3E9A18F27E39B0A4B8EA2A541B4E41', '2016-08-14 00:00:00'),
(2, 2, 'Oddsay', '5EBD6FB1059317FC5FBB57BB23AE6CEF10AAB311C04BEFC6D62CD3E4F7B0B6503857CF573EE84180113DF96DA1621334FDC3F691E96470637C8A4EF5B5E2A88E', '2016-08-15 00:00:00'),
(3, 3, 'Oddsaydev', '18F0AE1FC46894039381FBEFCC06C4E0B0C647DD45733D4AA1756502F68942768BCABE6A2E2ECB0DC4F6456B3B1CC2B4DF54AB78EC20C8DB21A0083EEAAEEB3B', '2016-08-15 00:00:00');

2. Updatedata.php (..\application\controllers\Updatedata.php)
<?php
defined('BASEPATH') OR  exit('No direct script access allowed');
class Updatedata extends CI_Controller{
 function __construct(){
 parent::__construct();  
  $this->load->model('updatedata_models');
                $this->load->helper( array('url' ,'form' )) ;

 }
public function index(){
 
     $data['user'] = $this->updatedata_models->tampil_data()->result();
  $this->load->view('updatedata_forms',$data);
}
public function updatevalue(){
 $data['user'] = $this->updatedata_models->update_data($this->input->post('id_user'))->result();
 $this->load->view('updatevalue_forms',$data);
}
public function eksekusi(){
 //echo"hallo".$this->input->post('id_user');
 $data['user'] = $this->updatedata_models->eksekusi_data($this->input->post('id_user'),$this->input->post('role'),$this->input->post('username'))->result();
 $this->load->view('updatedata_forms',$data);
}

}

3. updatedata_models.php (..\application\models\updatedata_models.php)
<?php
defined('BASEPATH') OR  exit('No direct script access allowed');
class Updatedata extends CI_Controller{
 function __construct(){
 parent::__construct();  
  $this->load->model('updatedata_models');
                $this->load->helper( array('url' ,'form' )) ;

 }
public function index(){
 
     $data['user'] = $this->updatedata_models->tampil_data()->result();
  $this->load->view('updatedata_forms',$data);
}
public function updatevalue(){
 $data['user'] = $this->updatedata_models->update_data($this->input->post('id_user'))->result();
 $this->load->view('updatevalue_forms',$data);
}
public function eksekusi(){
 //echo"hallo".$this->input->post('id_user');
 $data['user'] = $this->updatedata_models->eksekusi_data($this->input->post('id_user'),$this->input->post('role'),$this->input->post('username'))->result();
 $this->load->view('updatedata_forms',$data);
}

}

4.updatedata_forms.php (..\application\views\updatedata_forms.php)
<!DOCTYPE html>
<html>
<head>
 <title>Update komputasistat.blogspot.com</title>
</head>
<body>
 <center><h1>Update</h1></center>
 
 <table style="margin:20px auto;" border="1">
  <tr>
   <th>No</th>
   <th>Role</th>
   <th>Id User</th>
   <th>Username</th>
   <th>Password</th>
   <th>Last Login</th>
   <th>Action</th>
  </tr>
  <?php 
  $no = 1;
  foreach($user as $u){ 
  ?>
  <?php echo form_open('updatedata/updatevalue'); ?>
  <tr>
   <td><?php echo $no++ ?></td>
   <td><?php echo $u->role ?></td>
   <td><?php echo $u->id_user ?></td>
   <td><?php echo $u->username ?></td>
   <td><?php echo $u->password ?></td>
   <td><?php echo $u->last_login ?></td>
   <td>
<?php echo form_hidden('id_user',$u->id_user); ?>
    <?php echo form_submit('submit', 'update'); ?> </td>
  
  </tr>
  <?php echo form_close(); ?>
  <?php } ?>
 </table>
 
</body>
</html>

5.updatevalue_forms.php (..\application\views\updatevalue_forms.php)

<!DOCTYPE html>
<html>
<head>
 <title>Update komputasistat.blogspot.com</title>
</head>
<body>
 <center><h1>Update Value</h1></center>
<?php echo form_open('updatedata/eksekusi'); ?>
  <?php 
  foreach($user as $u){ 
  ?>
 
  
  id user: <?php echo $u->id_user ;?><br/>
  <?php echo form_hidden( 'id_user',$u->id_user );  ?>
  role: <?php echo form_input( 'role',$u->role );  ?><br/>
  username: <?php echo form_input( 'username',$u->username );?><br/>
  <?php echo form_submit($u->id_user, 'update'); ?> </td>
  
 
  <?php } ?>

 <?php echo form_close(); ?>
</body>
</html>
Posted in , , | No comments

Sunday 14 August 2016

Insert Database -CRUD 2 -Codeigniter 3

Posted on August 14, 2016 by Hasta Nurhusada
Gambar 1. Insert Database -CRUD 2 -Codeigniter 3

Pengaturan Awal:

1.  Database /MySQL (menggunakan database tutorial sebelumnya)
2.  Config Database
3.  Autoload Database
dapat melihat halaman sebelumya:
https://komputasistat.blogspot.co.id/2016/08/select-database-crud-1-codeigniter-3.html


Langkah Selanjutnya:


1. Atur baseurl karena kita akan menggunaan fungsi baseurl
sourcecode (...\application\config\config.php)


$config['base_url'] = 'http://localhost:8012/latihanci/MVC/1/';
*sesuaikan dengan baseurl CodeIgneter anda

2. Pada kali ini helper form juga digunakan. Ketika menggunakan helper lebih dari satu kita dapat menggunakan array
source code: Login.php (...\application\controllers\InsertLogin.php)
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class InsertLogin extends CI_Controller {


 function __construct(){
  parent::__construct();  
  $this->load->model('data_insert');
        $this->load->helper(array('url','form'));
 }
 public function index()
 {
          if($this->input->post('submit')){
            $this->data_insert->tambah();
            $this->load->view('telahterinsert');
        }else
        $this->load->view('data_insert_form');
 }

}

3.
source code: data_insert.php (...\application\models\data_insert.php)
<?php
class data_insert extends CI_Model { 

    function tambah() {
        $role = $this->input->post('role');
        $id_user = $this->input->post('id_user');
        $username = $this->input->post('username');
        $password = $this->input->post('password');

        $data = array (
            'role' => $role,
            'id_user'  => $id_user,
            'username'=> $username,
            'password' => $password

        );  
        $this->db->insert('user',$data);
    }
}

4.
source code: data_insert_form.php (...\application\views\data_insert_form.php)
<html>
<head>
<title>Form Tambah Data Login</title>
<base href="<?php echo base_url(); ?>" />
</head>
<body>
<h3>Tambah Data Login</h3>
<?php echo form_open('insertlogin'); ?>
<table>
<tr>
    <td> role </td>
    <td> <?php echo form_input('role'); ?> </td>
</tr>
<tr>
    <td> id_user </td>
    <td> <?php echo form_input('id_user'); ?> </td>
</tr>
<tr>
    <td> username </td>
    <td> <?php echo form_input('username'); ?> </td>
</tr>
<tr>
    <td> password </td>
    <td> <?php echo form_input('password'); ?> </td>
</tr>

<tr>
    <td> </td>
    <td> <?php echo form_submit('submit', 'Tambah'); ?> </td>
</tr>
</table>
<?php echo form_close(); ?>
 
</form>
</body>
</html>

5. bila berhasil ter insert source code telahterinsert.php akan dipanggil

 source code: telahterinsert.php (...\application\views\telahterinsert.php)
<!DOCTYPE html>
<html>
<head>
</head>
<body>
 <center><h1>Telah TerInsert</h1></center>
 
</body>
</html>


6. Data yang sudah ters-insert dapat dilihat menggunakan phpmyadmin/ gunakan tutorial sebelumnya
https://komputasistat.blogspot.co.id/2016/08/select-database-crud-1-codeigniter-3.html



Jika ingin menggunakan css untuk memperindah textfield dapat menggunakan class yang disisipkan pada form_input

contoh:
<?php echo form_input('role','','class="test"'); ?>

<style>
.test{
display: block;
  margin: 0;
  width: 100%;
  font-family: sans-serif;
  font-size: 18px;
  appearance: none;
  box-shadow: none;
  border-radius: none;
}
</style>


Trimakasih...



Posted in , , | No comments

Select Database -CRUD 1 -Codeigniter 3

Posted on August 14, 2016 by Hasta Nurhusada

Gambar 1. Select Database -CRUD 1 -Codeigniter3


Source SQL:

-- --------------------------------------------------------

--
-- Struktur dari tabel `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `role` int(1) NOT NULL,
  `id_user` int(4) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` char(128) NOT NULL,
  `last_login` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`role`, `id_user`, `username`, `password`, `last_login`) VALUES
(1, 1, 'hasta', 'C1CF6A5C0E168B080C446E7F5600B2404BA06387DC10D96014C941E5F82615AE96AA231727D38728AA446F26B6765CFDBA3E9A18F27E39B0A4B8EA2A541B4E41', '2016-08-14 00:00:00'),
(2, 2, 'andi', 'ED0D587073B2A487FA0638D970255179F0F4D298B33ED39317797681BB57E2277C560FFB9A3F75A81ADC261D4D7CEE06769380751D44E0669226D4CF042E44B0', '2016-08-14 00:00:00');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


1. atur database:
hostname: localhost
usernam:root
password:
database:latihanci
(Pengaturan database disesuaikan dengan database yang akan digunakan)

source code: database.php (...\application\config\database.php)
$db['default'] = array(
 'dsn' => '',
 'hostname' => 'localhost',
 'username' => 'root',
 'password' => '',
 'database' => 'latihanci',
 'dbdriver' => 'mysqli',
 'dbprefix' => '',
 'pconnect' => FALSE,
 'db_debug' => (ENVIRONMENT !== 'production'),
 'cache_on' => FALSE,
 'cachedir' => '',
 'char_set' => 'utf8',
 'dbcollat' => 'utf8_general_ci',
 'swap_pre' => '',
 'encrypt' => FALSE,
 'compress' => FALSE,
 'stricton' => FALSE,
 'failover' => array(),
 'save_queries' => TRUE
);

2. Panggil Library database menjadi autoload

source code: database.php (...\application\config\autoload.php)
$autoload['libraries'] = array('database');

3.Ubah default_controller agar control Login.php (nama controller yang akan kita buat) menjadi halaman depan/utama :

 source code: database.php (...\application\config\autoload.php)

$route['default_controller'] = 'login';

4.
source code: Login.php (...\application\controllers\Login.php)
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Login extends CI_Controller{
 function __construct(){
  parent::__construct();
  $this->load->model('data_user');
  $this->load->helper('url');

 }
 public function index(){
  $data['user']=$this->data_user->tampil_data()->result();
  $this->load->view('loginform',$data);

 }

}

5.
source code: data_user.php (...\application\models\data_user.php)
<?php
class data_user extends CI_Model{
 function tampil_data(){
  return $this->db->get('user');
 }
}

6.
source code: loginform.php(...\application\views\loginform.php)

<!DOCTYPE html>
<html>
<head>
 <title>Select Database CI3</title>
</head>
<body>
 <center><h1>Codeigniter 3</h1></center>
 <table style="margin:20px auto;" border="1">
  <tr>
   <th>No</th>
   <th>Role</th>
   <th>Id User</th>
   <th>Username</th>
   <th>Password</th>
   <th>Last Login</th>
  </tr>
  <?php 
  $no = 1;
  foreach($user as $u){ 
  ?>
  <tr>
   <td><?php echo $no++ ?></td>
   <td><?php echo $u->role ?></td>
   <td><?php echo $u->id_user ?></td>
   <td><?php echo $u->username ?></td>
   <td><?php echo $u->password ?></td>
   <td><?php echo $u->last_login ?></td>
  
  </tr>
  <?php } ?>
 </table>
</body>
</html>
Posted in , , | No comments
Subscribe to: Posts (Atom)