Skip to main content

Posts

Cetak Rekap dengan MPDF

Controller: class Sks_rekap extends CI_Controller { public function __construct() { parent::__construct(); $this->load->model('sks/sks_rekap_model'); } public function index() {     $this->load->model('sks/sks_rekap_model');     $data['departments'] =  $this->sks_rekap_model->get_departments();     $data['center']='sks/sks_rekap_view';         /* note - you don't need to have the extension when it's a php file */     $this->load->view('dashboard/v_dashboard',$data); } public function cetak() {     $this->load->model('sks/sks_rekap_model');     $data['departments'] =  $this->sks_rekap_model->get_departments();         /* note - you don't need to have the extension when it's a php file */     $this->load->view('sks/sks_rekap_cetak_mpdf',$data); } } // model <?php ...

FPDF dengan CodeIgniter

Cetak Surat Keputusan Controller: <?php //File in controller named surat_keputusan.php defined('BASEPATH') OR exit('No direct script access allowed'); class Cetak_surat_keputusan extends CI_Controller { public function __construct()     {         parent::__construct();         $this->load->helper('url');         $this->load->database();                $this->db->select();         $this->db->from('surat.config_sk');                $query = $this->db->get();                 return $query->result();             } public function index() {      ...

CSV into MYSQL

Create a controller as  csv.php <? php class csv extends CI_Controller { public $data ; public function __construct () { parent :: __construct (); $this -> load -> model ( 'csv_model' ); } function index () { $this -> load -> view ( 'uploadCsvView' , $data ); } function uploadData () { $this -> csv_model -> uploadData (); redirect ( 'csv' ); } } ?> And create a model as  csv_model.php <? php class csv_model extends CI_Model { function __construct () { parent :: __construct (); } function uploadData () { $count = 0 ; $fp = fopen ( $_FILES [ 'userfile' ][ 'tmp_name' ], 'r' ) or die ( "can't open file" ); while ( $csv_line = fgetcsv ( $fp , 1024 )) { $count ++; if ( $count == 1 ) ...