Rajin Ngoding

Upload Multi Table Relation Dengan Laravel Excel

Admin Ganteng 0 Aplikasi, Info Tekno, laravel, linux, tips and tricks Minggu, Desember 22, 2019

<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on"><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;">Assalamwalaikum Warohmatullahi Wabarokatuh.<br />
Hi.. sahabat rajin, kali ini kita akan membahas bagaimana cara Upload ke banyak table berelasi dengan 1 file excel pada package laravel excel.</div><div style="line-height: 100%; margin-bottom: 0in;">Pastikan mesin kamu sudah terinstall extentions php berikut :</div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><div style="line-height: 100%; margin-bottom: 0in;">PHP extension php_zip enabled</div><div style="line-height: 100%; margin-bottom: 0in;">PHP extension php_xml enabled</div><div style="line-height: 100%; margin-bottom: 0in;">PHP extension php_gd2 enabled</div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;">disini saya menggunakan laravel versi 6 dan mysql sebagai databasenya.</div><div style="line-height: 100%; margin-bottom: 0in;">Oya tujuan tulisan ini bukan untuk manggurui teman-teman sekalian, tetapi untuk catatan saya ketika saya lupa / mentok ketika ada masalah. Rasulullah shallallaahu ‘alaihi wa sallam bersabda:</div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="letter-spacing: normal;">“</span></span></span><em><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-weight: normal;">Ikatlah ilmu dengan dengan menulisnya</span></span></span></span></span></em><span style="font-variant: normal;"><span style="color: black;"><span style="letter-spacing: normal;">”</span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">Kasus :</span></span></span></span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
<ul style="text-align: left;"><li><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><b>Table Users</b></span></span></span></span></span></span></li>
<li><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><b>Table Mahasiswa</b></span></span></span></span></span></span></li>
<li><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><b>Table Profile</b></span></span></span></span></span></span></li>
</ul></div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;"><br />
</span></span></span></span></span></span></span><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">Dimana table mahasiswa dan profile masing-masing mempunyai field users_id</span></span></span></span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">Persiapan :</span></span></span></span></span></span></span></div><br />
<code><br />
composer require maatwebsite/excel<br />
</code><br />
<br />
<code><br />
'providers' => [<br />
/*<br />
* Package Service Providers...<br />
*/<br />
Maatwebsite\Excel\ExcelServiceProvider::class,<br />
]<br />
<br />
'aliases' => [<br />
...<br />
'Excel' => Maatwebsite\Excel\Facades\Excel::class,<br />
]<br />
</code><br />
<br />
<br />
<div style="font-weight: normal; line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;">Lalu Publish Vendor Providers dengan perintah</span></span></span></span></span></span></div><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>    <br />
<div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><div style="line-height: 100%; margin-bottom: 0in;"><pre><code>
php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider"
</code>
</pre></div><br />
<style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: 12pt;">Selanjutnya kita akan buat file import dengan melakukan perintah :</span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: 12pt;"><br />
</span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><pre><code>
php artisan make:import MhsImport
</code>
</pre>Jika Kita Cek ada folder baru di dalam app/Imports/MhsImport<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDoz5sWb8TZWpF27aLpT25pDbnnEt3oaa2M1CLy-PTAOliOXzguxJ1of88o34JYJPELl-wVWSxigv8h6eB4QeUFvB1IB_ijY-vVFAjCmIBOAUsPVXRpi6ClAN3r50BrxIqDfi3KO_GZyE/s1600/folder.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="258" data-original-width="190" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDoz5sWb8TZWpF27aLpT25pDbnnEt3oaa2M1CLy-PTAOliOXzguxJ1of88o34JYJPELl-wVWSxigv8h6eB4QeUFvB1IB_ijY-vVFAjCmIBOAUsPVXRpi6ClAN3r50BrxIqDfi3KO_GZyE/s320/folder.png" width="233" /></a></div><br />
Pertama kita akan menggunakan metode collection untuk membaca isi dari file excel yang akan kita buat :<br />
Untuk Template excel saya buat seperti berikut :<br />
<style type="text/css">
  body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial"; font-size:x-small }
  a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em;  } 
  a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em;  } 
  comment { display:none;  } 
 </style>      <br />
<table border="0" cellspacing="0"><colgroup width="92"></colgroup>  <colgroup width="69"></colgroup>  <colgroup width="167"></colgroup>  <colgroup width="89"></colgroup>  <colgroup width="84"></colgroup>  <colgroup width="75"></colgroup>  <colgroup width="90"></colgroup>  <colgroup width="77"></colgroup>  <colgroup width="80"></colgroup>  <colgroup width="61"></colgroup>  <colgroup width="63"></colgroup>  <colgroup width="71"></colgroup>  <tbody>
<tr>   <td align="center" height="17" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">NAMA</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">NIM</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">EMAIL</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">PASSWORD</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">ANGKATAN</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">JURUSAN</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">KURIKULUM</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">TTL</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">KELAMIN</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">AGAMA</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">STATUS</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">DIBUAT</td>  </tr>
<tr>   <td align="left" height="17" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">aman</td>   <td align="right" sdnum="1033;" sdval="14050880" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">14050880</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">aman@email.com</td>   <td align="right" sdnum="1033;" sdval="123" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">123</td>   <td align="right" sdnum="1033;" sdval="192" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">192</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Ekonomi</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Ekonomi</td>   <td align="left" sdnum="1033;0;@" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1991-05-05</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">LAKI-LAKI</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">ISLAM</td>   <td align="right" sdnum="1033;" sdval="1" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">admin</td>  </tr>
<tr>   <td align="left" height="17" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">asas</td>   <td align="right" sdnum="1033;" sdval="1405051" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1405051</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">asas@email.com</td>   <td align="right" sdnum="1033;" sdval="124" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">124</td>   <td align="right" sdnum="1033;" sdval="192" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">192</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Perbankan</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Perbankan</td>   <td align="left" sdnum="1033;0;@" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1991-05-06</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">LAKI-LAKI</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">ISLAM</td>   <td align="right" sdnum="1033;" sdval="1" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">admin</td>  </tr>
</tbody></table><code><br />
<br />
namespace App\Imports;<br />
<br />
use Illuminate\Support\Collection;<br />
use Maatwebsite\Excel\Concerns\ToCollection;<br />
use Maatwebsite\Excel\Concerns\WithHeadingRow;<br />
use DB;<br />
use App\User;<br />
use Carbon\Carbon;<br />
<br />
</code></div><br />
<br />
Code Lengkap Isi Dari Class MhsImport<br />
<pre><code>
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use DB;
use App\User;
use Carbon\Carbon;
use App\Notifications\UserWelcome;

class MhsImport implements WithHeadingRow,ToCollection
{
/**
* @param Collection $collection
*/
public function collection(Collection $rows)
{

foreach ($rows as $key) {
$user=User::updateOrCreate(
['email'=>$key['email'],'nim'=>$key['nim']]
,[
'uuid'=>unik(),
'name'=>$key['nama'],

'password'=>bcrypt($key['password']),
'old_password'=>$key['password'],
'status'=>$key['status'],
'created_by'=>$key['dibuat']

]);
$selectuser=User::where('email',$key['email'])->get();
$jurusan=DB::table('jurusan')->where('name','LIKE','%'.$key['jurusan'].'%')->first();
$kurikulum=DB::table('kurikulum')->where('name','LIKE','%'.$key['kurikulum'].'%')->first();

foreach ($selectuser as $mhs ) {
$x=DB::table('mahasiswa')->updateOrInsert(['users_uuid'=>$mhs->uuid],[
'uuid'=>unik(),
'nim'=>$mhs->nim,
'angkatan'=>$key['angkatan'],
'jurusan_uuid'=>$jurusan->uuid,
'kurikulum_uuid'=>$kurikulum->uuid,
'created_by'=>'Import',
'created_at'=>Carbon::now(),

]);
}
foreach ($selectuser as $pro ) {
DB::table('profile')->updateOrInsert(['users_uuid'=>$pro->uuid],[
'uuid'=>unik(),
'nama_lengkap'=>$pro->name,
'religion'=>$key['agama'],
'dob'=>$key['ttl'],
'sex'=>$key['kelamin']
]);
}
}

}

}
</code>
</pre></div><br />
<br />
Lalu isi file Controller<br />
<pre><code>
use App\Imports\MhsImport;
use Excel;
use DB;

class TesController extends Controller
{

public function store(Request $request)
{
DB::beginTransaction();

try {
DB::commit();

$file = $request->file('file');
Excel::import(new MhsImport,$file);

echo "OK";
} catch (\Exception $e) {
DB::rollback();
//toastr()->error($e->getMessage());
echo $e->getMessage();
}

}
</code>
</pre></div><br />
Ok sekian wasalamwalikum..</div>

Upload Multi Table Relation Dengan Laravel Excel

Assalamwalaikum Warohmatullahi Wabarokatuh. Hi.. sahabat rajin, kali ini kita akan membahas bagaimana cara Upload ke banyak table berel...

Baca selengkapnya »

Mengatasi A non-numeric value encountered pada looping laravel

Admin Ganteng 0 laravel, tips and tricks Sabtu, November 02, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
Simple<br />
Masalah ini disebabkan karena operator arimatika tidak berfungsi jika integer + string<br />
seperti : 20+'30'<br />
jadi bagaimana mensiasatinya?<br />
berikut<br />
contoh : Salah<br />
<code><br />
$total='';<br />
$data=DB::table('jadwal')<br />
->select('jadwal.uuid as uuid','mata_kuliah.sks as sks')<br />
->join('krs_mhs','krs_mhs.jadwal_uuid','=','jadwal.uuid')<br />
->join('mata_kuliah','mata_kuliah.mk_uuid','=','jadwal.mk_uuid')<br />
->where('jadwal.akademik_uuid',tahunakademik())<br />
->where('krs_mhs.users_uuid', $user)<br />
->groupBy('jadwal.uuid','mata_kuliah.sks')<br />
->get();<br />
<br />
foreach ($data as $key) {<br />
$total+=$key->sks;<br />
}<br />
return $total;<br />
</code><br />
<br />
Bisa kita perhatikan bahwa variable <b>$total </b>bernilai string sehingga outpunya pun terpengaruh menjadi string.<br />
coba edit variable nya menjadi <b>$total=0 </b>, lalu lakukan refresh kembali.<br />
<br />
tulisan ini bertujuan supaya saya tidak lupa.<br />
teriamkasih semua. ⺗<br />
<br /></div>

Mengatasi A non-numeric value encountered pada looping laravel

Simple Masalah ini disebabkan karena operator arimatika tidak berfungsi jika integer + string seperti : 20+'30' jadi bagaimana m...

Baca selengkapnya »

Cara Parser Variable {{}} Dinamis Laravel Blade

Admin Ganteng 0 Aplikasi, Info Tekno, laravel, postgress, Web Programming Selasa, Mei 21, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Hai Assalamwalaikum, Hari ini saya akan mencoba berbagi tips bagaimana cara parser variable dinamis menggunakan blade di laravel untuk kebutuhan tamplate email, dokumen, surat menyurat dan lain-lain.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Tujuan saya menulis ini sebenarnya supaya tidak lupa, karena ilmu masih belum seberapa. Jadi mohon dimaklumi jika ada tulisan saya yang tidak teman-teman mengerti.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Awalnya saya mencari bagaimana cara parser variable dinamis ke editor (Ckeditor)  dengan segala keterbatasan dan ditambah jadwal dateline yang mepet, karena harus menyelesaikan modul ini kebayang gimana putus asa. Wkwk.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Awalnya tulisan menarik saya temukan pada blog </span><a href="http://tnt.studio/blog/email-templates-from-database"><u><span class="15" style="color: blue; font-family: "times new roman"; text-decoration: underline;">tnt.studio</span></u></a><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"> disana di jelaskan bagaimana cara membuat email tamplate yang datanya dari DB.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Sebenarnya ada 2 metode untuk melakukannya, yang pertama menggunakan </span><b><span style="font-family: "calibri"; font-weight: bold;">str_replace , preg_replace_callback .</span></b><b><span style="font-family: "calibri"; font-weight: bold;"><o:p></o:p></span></b></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; font-weight: normal;">Bisa kita taruh di helper ataupun di dalam model.</span><span style="font-family: "calibri"; font-weight: normal;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; font-weight: normal;">Dalam case ini saya akan menaruhnya di model, sesuai tutorial dari blog di atas,  dengan bahasa yang fahami.</span><span style="font-family: "calibri"; font-weight: normal;"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<span style="font-family: "calibri"; font-weight: normal;"> Metode pertama:</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<pre><span style="font-family: "calibri"; font-weight: normal;"><code>     $nama_user='Admin Ganteng';
     $data=str_replace('{{$nama_user}}',$nama_user,'' );
     $text="Haloo {$nama_user}... Apa Kabar?";
     return view('tes',['konten'=>$text]);</code></span></pre>
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj4ZQ5CytSSJD0JKucBxTIGfqRZcMCcPKKCAYP8fjYXKpC1YJqJ8PSBh38KR-K7j4ZFCq2Ope1JcgnPhwKwYElN40TjqoOX4iq6fJpKYTuP0K3ScEknfUtAdAOwZ2qxZLXP3fy503qPiI/s1600/Screenshot+from+2019-05-21+10-38-03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="135" data-original-width="481" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj4ZQ5CytSSJD0JKucBxTIGfqRZcMCcPKKCAYP8fjYXKpC1YJqJ8PSBh38KR-K7j4ZFCq2Ope1JcgnPhwKwYElN40TjqoOX4iq6fJpKYTuP0K3ScEknfUtAdAOwZ2qxZLXP3fy503qPiI/s1600/Screenshot+from+2019-05-21+10-38-03.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXCMTyGK62nj1ryV6BUrCYqMG8eXJGrBYTcPItnAgo0lPcmEvXnY-SgtjaBNeHkxUuYxh8W5oSUWQJH0a4QcGH5THsXSNdd5Zv5CsFtnQT5SXUN0cy205wECYLIrG0vJqQe4OQLEOXNCM/s1600/Screenshot+from+2019-05-21+10-38-52.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="390" data-original-width="957" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXCMTyGK62nj1ryV6BUrCYqMG8eXJGrBYTcPItnAgo0lPcmEvXnY-SgtjaBNeHkxUuYxh8W5oSUWQJH0a4QcGH5THsXSNdd5Zv5CsFtnQT5SXUN0cy205wECYLIrG0vJqQe4OQLEOXNCM/s1600/Screenshot+from+2019-05-21+10-38-52.png" /></a></div>
<pre><span style="font-family: "calibri"; font-weight: normal;"><code><div class="MsoNormal">
<div class="MsoNormal">
</div>
</div>
</code></span></pre>
<br />
Metode ke 2,<br />
Siapkan 1 Controller dan 1 Models:<br />
<br />
<br />
<pre><code>
    protected $table="tes";
    public function parse($data)
{
    $parsed = preg_replace_callback('/{{(.*?)}}/', function ($matches) use ($data) {
        list($shortCode, $index) = $matches;

if( isset($data[$index]) ) {
            return $data[$index];
        } else {
            throw new Exception("Shortcode {$shortCode} not found in template id {$this->id}", 1);
        }

}, $this->content);

return $parsed;
</code>
</pre>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS8JQfe_2wj8tImB18mLPJvNQYLEl9vOIML6ROEUUiz54wqSfHAcmLDZx78MUqgkyxtSMViSKsFb9ztHKszluKiosW9wA9_VYlASxY1s-0-7CmB-Vzp7bgiof2D7zj7omz7hmDnSQe8y8/s1600/Screenshot+from+2019-05-21+11-16-19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="519" data-original-width="839" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS8JQfe_2wj8tImB18mLPJvNQYLEl9vOIML6ROEUUiz54wqSfHAcmLDZx78MUqgkyxtSMViSKsFb9ztHKszluKiosW9wA9_VYlASxY1s-0-7CmB-Vzp7bgiof2D7zj7omz7hmDnSQe8y8/s1600/Screenshot+from+2019-05-21+11-16-19.png" /></a></div>
<br />
Bagian Controller<br />
<pre><code>
$db=DB::table('tes')->where('id',44)->first();
     $template          = new Tes;
     $template->id      = 44;
     $template->content =$db->nama_aja;
     $data              = [
       'nama_pt'=>'PT. ABC',
       'nama_saya'=>"Admin Ganteng"
     ];
     return view('tes',['konten'=>$template->parse($data)]);
</code>
</pre>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVSvLpjLxYaHwDPQxLENd-cpJDMdmvm1_wsZuuwsMhpoBx198y80PCH_1UPtF2pCHb4CoCt_jovXlM5BXU7S_siPvV6OJvUzBFCKRKXVVyrtEeR7H7s3Vv2mkozlxDk-DsSbwwPUocKa0/s1600/xd.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="341" data-original-width="530" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVSvLpjLxYaHwDPQxLENd-cpJDMdmvm1_wsZuuwsMhpoBx198y80PCH_1UPtF2pCHb4CoCt_jovXlM5BXU7S_siPvV6OJvUzBFCKRKXVVyrtEeR7H7s3Vv2mkozlxDk-DsSbwwPUocKa0/s1600/xd.png" /></a></div>
<br />
Source database yang isinya HTML:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhxvRbLBr8yAm_M5uWJYn7iKmylKCEKMGs2WzA2LQuiGheacq6oPu3yuG60szaTin-_5TvIBKFf7W4yyIS5caacuNoO9jjbRlMl7LcxqIPY-eX6-W6pYsI9WM1c-aOEdaHOGxPcKc7ctk/s1600/Screenshot+from+2019-05-21+11-29-25.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="229" data-original-width="652" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhxvRbLBr8yAm_M5uWJYn7iKmylKCEKMGs2WzA2LQuiGheacq6oPu3yuG60szaTin-_5TvIBKFf7W4yyIS5caacuNoO9jjbRlMl7LcxqIPY-eX6-W6pYsI9WM1c-aOEdaHOGxPcKc7ctk/s1600/Screenshot+from+2019-05-21+11-29-25.png" /></a></div>
<br />
<br />
Output:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN1_qfKosCdKq4GB7p_fUGuYszqjTLxB_twmybnitmHFfWxVIh_lNbin6lL2fRy8tO2ulMox8kuYe5TDl00KOGXgkgvwKL_IXC8FVc4No8GvYJ0Q9s_bBvxTCJSJDHOrMHasenyU5eRhA/s1600/Screenshot+from+2019-05-21+11-49-15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="315" data-original-width="944" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN1_qfKosCdKq4GB7p_fUGuYszqjTLxB_twmybnitmHFfWxVIh_lNbin6lL2fRy8tO2ulMox8kuYe5TDl00KOGXgkgvwKL_IXC8FVc4No8GvYJ0Q9s_bBvxTCJSJDHOrMHasenyU5eRhA/s1600/Screenshot+from+2019-05-21+11-49-15.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Caranya masih sama cukup menambahkan <b>{{nama_pt}}, {{nama_saya}} </b>dalam value databse tsb.<br />
<br />
<br />
ok sekian tipsnya, wasalam.<br />
<br /></div>
</div>

Cara Parser Variable {{}} Dinamis Laravel Blade

Hai Assalamwalaikum, Hari ini saya akan mencoba berbagi tips bagaimana cara parser variable dinamis menggunakan blade di laravel untuk keb...

Baca selengkapnya »

Membuat Nomor Transaksi Otomatis Tidak Habis Pada Laravel 5.8

Admin Ganteng 0 laravel, postgress, tips and tricks, Web Programming Senin, April 22, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
Assalamwalaikum man teman,<br />
Kali ini saya Akan membagikan sedikit trik bagaimana membuat penomoran otomatis pada laravel 5.8,<br />
Sebenarnya cara ini saya adopsi dari tulisan bang fikri di <a href="http://mfikri.com/artikel/Membuat-Kode-unik-berdasarkan-tanggal-dengan-Codeigniter.html" target="_blank">http://mfikri.com</a> . Tapi bedanya saya  terapkan pada laravel, Oya dalam case ini Laravel yang  saya pakai versi 5.8 dan database Postgress jika kalian menggunakan Mysql jangan khawatir, karena syntax query builder tidak jauh berbeda.<br />
oke langsung aja, saya anggap temen-temen sudah instal pacakage Laravel nya, jadi tidak harus dijeslakan hehe.<br />
<br />
pertama kita buat table nya terlebih dahulu.<br />
<code><br />
</code><br />
<pre><code>-- Table: public.project

-- DROP TABLE public.project;

CREATE TABLE public.project
(
    id bigint NOT NULL DEFAULT nextval('project_id_seq'::regclass) ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ),
    kode character varying(50) COLLATE pg_catalog."default",
    jenis_id integer NOT NULL,
    layanan_id integer NOT NULL,
    user_id integer,
    total_penghadap integer,
    status character varying(15) COLLATE pg_catalog."default",
    create_at timestamp without time zone,
    add_by character varying(50) COLLATE pg_catalog."default",
    update_at time without time zone,
    update_by character varying(50) COLLATE pg_catalog."default",
    CONSTRAINT project_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.project
    OWNER to postgres;
</code></pre>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLDulmf4KOGH2mOCinZzQrTo8-edF1oFYbpbnBfZIC9OZxyt46yiMJM1gNsyc97A8Ir4rJ5QBIKph2L-Ia65BNDW35ovcMQX2AqwebVVn2cY4xYyVC4gFVxzeu34b5DhmmIZbo0EEeyZM/s1600/blog.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="412" data-original-width="666" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLDulmf4KOGH2mOCinZzQrTo8-edF1oFYbpbnBfZIC9OZxyt46yiMJM1gNsyc97A8Ir4rJ5QBIKph2L-Ia65BNDW35ovcMQX2AqwebVVn2cY4xYyVC4gFVxzeu34b5DhmmIZbo0EEeyZM/s1600/blog.png" /></a></div>
<br />
lalu buat controler baru dengan perintah<br />
<code><br />
</code><br />
<pre><code>php artisan make:controller KodeController
</code></pre>
<code><br />
</code><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6Iq8NgWwydedT0CnA5DuM22jWsSXZbwAOnIlZfPXngM4TW2pfQaf-2pD_AL-wdQGeF4kyaEmU5JIoFe2yVO454unHvN5BhYGGTz8-oB9isKnunKMDUa0Tb8t93doxwwHbmAq2QcrUrmE/s1600/terminal.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="122" data-original-width="907" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6Iq8NgWwydedT0CnA5DuM22jWsSXZbwAOnIlZfPXngM4TW2pfQaf-2pD_AL-wdQGeF4kyaEmU5JIoFe2yVO454unHvN5BhYGGTz8-oB9isKnunKMDUa0Tb8t93doxwwHbmAq2QcrUrmE/s1600/terminal.png" /></a></div>
Kurang lebih isinya seperti ini :<br />
<code class="php"><br />
</code><br />
<pre><code class="php">namespace App\Http\Controllers;

use DB;

use Carbon\Carbon;
class KodeController extends Controller
{
  //
  public function index()
  {
    
    echo $this->kode();

}
  protected function kode()
  {
    $kd="";
   $query = DB::table('project')
   ->select(DB::raw('MAX(RIGHT(kode,4)) as kd_max'))
    ->whereDate('create_at',Carbon::today());
   if ($query->count()>0) {
    foreach ($query->get() as $key ) {
    $tmp = ((int)$key->kd_max)+1;
    $kd = sprintf("%04s", $tmp);
    }
   }else {
$kd = "0001";
   }

return  "PR-".date('dmy').$kd;
  }
   
}
</code></pre>
<code class="php"><br />
</code><br />
setelah itu kita buat <b>Route </b>untuk mengarahkan ke Controller yang kita buat tadi.<br />
<br />
<code class="php"></code><br />
<pre><code class="php">Route::get('tes', 'KodeController@index');
</code></pre>
<br />
<br />
lalu bisa langsung panggil <i>localhost/nama_aplikasi/kode </i>Maka harusnya outputnya seperti ini<br />
<b>PR-2204190002<i>  </i></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHNyJE-Jz0XNQO1QZ82LG3yVgIiM_MP9s4QUyGOttTiXModqvy6cOH4ktMFh2OzbLEgJr8Fyvt3d5CztfU2togU5zbx6HwtWkYgzdDDbge_mfBQqpzI_2EPhBRx_NEAgOXmzto64vduec/s1600/web.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="98" data-original-width="620" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHNyJE-Jz0XNQO1QZ82LG3yVgIiM_MP9s4QUyGOttTiXModqvy6cOH4ktMFh2OzbLEgJr8Fyvt3d5CztfU2togU5zbx6HwtWkYgzdDDbge_mfBQqpzI_2EPhBRx_NEAgOXmzto64vduec/s1600/web.png" /></a></div>
<b><i><br /></i></b>
Seperti yang di jelaskan di tulisan situs sumber bahwa kode unik tersebut berarti 22 (day), 04 (month),19(year), dan 0001 (jumlah digit yang mampu ditampung).<br />
<br />
Hah 0001, berarti jumlah digit yang mampu ditampung juga 9999 donk?<br />
<br />
Benar, jumlah digit yang mampu ditampung memang 9999. Tetapi, yang mampu ditampung adalah 9999 per-hari. Jika tanggalnya berubah, misalkan tanggal 23/04/2019 maka jumlah digit akan kembali ke 0001. Sehingga kode uniknya menjadi 23042019. Dalam arti kata kode unik berdasarkan tanggal ini mampu menampung 9999 transaksi perhari.<br />
<br />
oke sekian dan terimakasih,<br />
sumber terkait : <a href="http://mfikri.com/artikel/Membuat-Kode-unik-berdasarkan-tanggal-dengan-Codeigniter.html" target="_blank">http://mfikri.com</a><br />
Wasalam</div>

Membuat Nomor Transaksi Otomatis Tidak Habis Pada Laravel 5.8

Assalamwalaikum man teman, Kali ini saya Akan membagikan sedikit trik bagaimana membuat penomoran otomatis pada laravel 5.8, Sebenarnya c...

Baca selengkapnya »

Cara Migrasi Mysql / MariaDB Ke Postgress SQL

Admin Ganteng 0 linux, postgress, Server, tips and tricks, Web Programming Jumat, April 05, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
Hai sahabat,<br />
mohon maaf, baru posting. Karena kesibukan sebagai pekerja meyita waktu begitu lama sampai lupa untuk menulis blog kesayangan kita bersama.<br />
<br />
ok langsung saja,<br />
Bagimana sih caranya migrasi data dari mysql / mariaDb ke Postgress?<br />
nah ada beberapa cara tentunya yang bisa teman-teman pakai.<br />
bisa menggunakan <b><a href="http://pgloader.io/">pgloader.io</a> </b>bahkan ada tools yang berbayar.<br />
nah dalam tulisan ini saya akan menggunakan methode import manual dari <b>Pgadmin4</b><br />
nah jika temen-temen belum punya, silahkan donwload di <a href="https://www.pgadmin.org/">https://www.pgadmin.org/</a><br />
<br />
ok kita mulai.<br />
pertama kita buka dan login dahulu ke <b>Pgadmin4 </b>,<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigruu2b3zP5HI2vSPZldkuWL-N1n-NBmKfOgnwU2yfXVNxmRkS2b30IAcw1mA0suhTueMPjozjDeAtDNds45CAUuaIyg6MktDhoCkXFQBMCTGayOF_bZptGbdTaICqwAI84OekI8r76lw/s1600/blog-1.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="190" data-original-width="1307" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigruu2b3zP5HI2vSPZldkuWL-N1n-NBmKfOgnwU2yfXVNxmRkS2b30IAcw1mA0suhTueMPjozjDeAtDNds45CAUuaIyg6MktDhoCkXFQBMCTGayOF_bZptGbdTaICqwAI84OekI8r76lw/s640/blog-1.png" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">halaman <b>pgadmin</b></td></tr>
</tbody></table>
<br />
lalu buatlah 1 database baru :<br />
klik kanan server - create-server<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3xV81TA1Ztjkpy0nSHLz2ngZ30hg48G1avix9RZBd5BvwVHUy-x7X_YF4M-p_vUoGpRbYB96H5fmC4sPYu5Ob8ocjiZ6ue_ZotTNQ002XMWH9R-gz_1XKP63XLKja0ICpAwpWQ2R23v8/s1600/Screenshot+from+2019-04-05+06-58-19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="210" data-original-width="508" height="264" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3xV81TA1Ztjkpy0nSHLz2ngZ30hg48G1avix9RZBd5BvwVHUy-x7X_YF4M-p_vUoGpRbYB96H5fmC4sPYu5Ob8ocjiZ6ue_ZotTNQ002XMWH9R-gz_1XKP63XLKja0ICpAwpWQ2R23v8/s640/Screenshot+from+2019-04-05+06-58-19.png" width="640" /></a></div>
lalu aktifkan database yang kita buat tadi<br />
contoh saya membuat <b>my_db</b><br />
Lalu expand database yang kita buat tadi dan klik kanan pada <b>schemas </b>lalu klik kanan pada <b>tables </b><br />
pilih <b>create-table </b><br />
<b><br /></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwtjzOE38RCbpGyYRhhxXEG5EbV3IfTg9k1WZglbLdPL1O3GSMcJ1WSmFXiTJf8laVwWIZTIbdZUulEW5MQAR-X9kaJdsU767qjGJJuGYuMOd3ADcKh29F2iwV9pzO-7uDMzBwuQY2mVA/s1600/Screenshot+from+2019-04-05+07-02-33.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="253" data-original-width="523" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwtjzOE38RCbpGyYRhhxXEG5EbV3IfTg9k1WZglbLdPL1O3GSMcJ1WSmFXiTJf8laVwWIZTIbdZUulEW5MQAR-X9kaJdsU767qjGJJuGYuMOd3ADcKh29F2iwV9pzO-7uDMzBwuQY2mVA/s640/Screenshot+from+2019-04-05+07-02-33.png" width="640" /></a></div>
<br />
<br />
setelah itu kita buat table dengan struktur dan type data pada table yang akan kita buat contoh:<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-7O84xM0Ujuv8_dvAbPuzn0n0suhG6TBdQoIpEtCZHTEvt3wNPs9kPxtjfyI6AZsRC3uEhgk8oDWQ-1R_BmbPq9YRidaRS0NdUwBsfgrS-cw8Lp9sZUb2oiqycqcTB5pa9Nr7P8CGwO4/s1600/Screenshot+from+2019-04-05+07-05-02.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="552" data-original-width="700" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-7O84xM0Ujuv8_dvAbPuzn0n0suhG6TBdQoIpEtCZHTEvt3wNPs9kPxtjfyI6AZsRC3uEhgk8oDWQ-1R_BmbPq9YRidaRS0NdUwBsfgrS-cw8Lp9sZUb2oiqycqcTB5pa9Nr7P8CGwO4/s640/Screenshot+from+2019-04-05+07-05-02.png" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Tampilan Create Table</td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmFMu2sslhlBoFuMkep0ojQocAbfy4O6kT_jXumEJDiUDmk0ARJnm7tEC4-JZKTK0FGCvenqqWUMjkvU8p6jj-Y5MM4hsQk7jfbLbQ7ths28u4HqK7Ksa2q09cMufgsVdt0sPKioGtj7k/s1600/Screenshot+from+2019-04-05+07-06-54.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="165" data-original-width="916" height="114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmFMu2sslhlBoFuMkep0ojQocAbfy4O6kT_jXumEJDiUDmk0ARJnm7tEC4-JZKTK0FGCvenqqWUMjkvU8p6jj-Y5MM4hsQk7jfbLbQ7ths28u4HqK7Ksa2q09cMufgsVdt0sPKioGtj7k/s640/Screenshot+from+2019-04-05+07-06-54.png" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">struktur table dari mysql</td></tr>
</tbody></table>
kita samakan di postgress tab ke bagian <b>collums</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmpCFQ7W3LThrUKpX61yphevcTvQCqae7zzGOlAVq2vAFVakXYKu5czw_qqx1Ind9JIarAo9abjrWM3RbQ_JxRd3YHlMsMFcMGwtbsAMf-gcbrovvgV3a4hGTe-rzPYy-zSX-Wl2fTBZE/s1600/Screenshot+from+2019-04-05+07-08-38.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="549" data-original-width="697" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmpCFQ7W3LThrUKpX61yphevcTvQCqae7zzGOlAVq2vAFVakXYKu5czw_qqx1Ind9JIarAo9abjrWM3RbQ_JxRd3YHlMsMFcMGwtbsAMf-gcbrovvgV3a4hGTe-rzPYy-zSX-Wl2fTBZE/s640/Screenshot+from+2019-04-05+07-08-38.png" width="640" /></a></div>
<b><br /></b>
lalu save.<br />
setelah itu klik kanan pada <b>tes_table - </b>pilih<b> import/export</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_gnmUgjMCB55quBTy9u5jE8pMifIwNeHd94LwHl9EppDhKKOvcjarzEPY6a6RYIf3sdlhdNxGN5Ah9Gy3hsky947tUDTABGVnh_jKZ_bEa5iiBh_9Pu0-uNgjsNpJpcOjbidKlwvex-s/s1600/Screenshot+from+2019-04-05+07-10-52.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="364" data-original-width="352" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_gnmUgjMCB55quBTy9u5jE8pMifIwNeHd94LwHl9EppDhKKOvcjarzEPY6a6RYIf3sdlhdNxGN5Ah9Gy3hsky947tUDTABGVnh_jKZ_bEa5iiBh_9Pu0-uNgjsNpJpcOjbidKlwvex-s/s640/Screenshot+from+2019-04-05+07-10-52.png" width="618" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
lalu kembali ke mysql</div>
<div class="separator" style="clear: both; text-align: left;">
klik export by <b>CSV</b></div>
<div class="separator" style="clear: both; text-align: left;">
pada layar pdadmin swipe menjadi <b>Import </b>lalu pilih file <b>csv </b>yang kita export tadi</div>
<b><br /></b>
lalu setting beberapa rule pada pgadmin<br />
- <span style="background-color: #ebeef3; font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif; font-size: 14px;">Encoding = UTF8</span><br />
<span style="background-color: #ebeef3; font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif; font-size: 14px;">- </span><span style="background-color: #ebeef3; font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif; font-size: 14px;">Delimiter = , (Koma)</span><br />
<span style="background-color: #ebeef3; font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif; font-size: 14px;">-</span><span style="background-color: #ebeef3; font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif; font-size: 14px;">Quote = " (tanda petik)</span><br />
<span style="background-color: #ebeef3; font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif; font-size: 14px;">-</span><span style="background-color: #ebeef3; font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif; font-size: 14px;">Escape =" ( Petik)</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBUCzbJ-WIVZW2plNLSxXkdKL-DkvdPhl1_rngK2ZXIec0PUHIQRZh9FjDIoyWuBEQ4W6a2FHsBIPBUcKKw9ZK2QpCEyZKaVShZZd20lYHL2o6O9xfT8dXcwT1xsFHvFb-tNLst_oCUuw/s1600/Screenshot+from+2019-04-05+07-17-20.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="506" data-original-width="705" height="458" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBUCzbJ-WIVZW2plNLSxXkdKL-DkvdPhl1_rngK2ZXIec0PUHIQRZh9FjDIoyWuBEQ4W6a2FHsBIPBUcKKw9ZK2QpCEyZKaVShZZd20lYHL2o6O9xfT8dXcwT1xsFHvFb-tNLst_oCUuw/s640/Screenshot+from+2019-04-05+07-17-20.png" width="640" /></a></div>
<span style="font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px;">lalu langsung kita klik OK</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFTwJCU9E-N4IHZw_OieQWee9mFLrcpekbNYpxoIdSyMJza34h55IS2klHvb5b7BsiIhZcyFNJlOf6eBolxreCNmXoZo9hsGmWQpBp26Y0lUzCkMgzLqp_Cbnv3twgMvmi_XDdaW2ZdnU/s1600/Screenshot+from+2019-04-05+07-21-57.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="256" data-original-width="556" height="292" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFTwJCU9E-N4IHZw_OieQWee9mFLrcpekbNYpxoIdSyMJza34h55IS2klHvb5b7BsiIhZcyFNJlOf6eBolxreCNmXoZo9hsGmWQpBp26Y0lUzCkMgzLqp_Cbnv3twgMvmi_XDdaW2ZdnU/s640/Screenshot+from+2019-04-05+07-21-57.png" width="640" /></a></div>
<br />
<span style="font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px;">Jika Suskses maka ada keterangan sperti di atas .</span></span><br />
<span style="font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px;"><br /></span></span>
<span style="font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px;">ok demikian tips hari ini, semoga bermanfaat.</span></span><br />
<span style="font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px;"><br /></span></span>
<span style="font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px;">salam -</span></span><br />
<span style="font-family: "roboto" , "helvetica neue" , , "blinkmacsystemfont" , "segoe ui" , "arial" , sans-serif;"><span style="background-color: white; font-size: 14px;">admin</span></span></div>

Cara Migrasi Mysql / MariaDB Ke Postgress SQL

Hai sahabat, mohon maaf, baru posting. Karena kesibukan sebagai pekerja meyita waktu begitu lama sampai lupa untuk menulis blog kesayangan...

Baca selengkapnya »

Cara Pasang TWRP Android Via Terminal Linux

Admin Ganteng 1 linux, tips and tricks, Tutorial, ubuntu Sabtu, Agustus 11, 2018

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Hai Assalamwalaikum...</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Kali ini saya akan membagikan pengalaman pasang TWRP di Ponsel kesayangan saya</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><b>Redmi Note 4</b>. Ya walaupun seri lama tapi pusing juga kalau pemakaian standard, jadi mau gak mau musti di costum.</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiv2pNq1LRj9A8nlL4HZaV_TRH67fQQ3WGQExEBP8Tm5ylkYgALTCcY4l1qLgDEFSw8BgrqppBAWgjYG8bdLWeW4A6Yq__n0sHFa24G-41j11CoL-WkTCp8_791fq6yYPBBbYoIkvK02rA/s1600/Logo_Android.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="480" data-original-width="480" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiv2pNq1LRj9A8nlL4HZaV_TRH67fQQ3WGQExEBP8Tm5ylkYgALTCcY4l1qLgDEFSw8BgrqppBAWgjYG8bdLWeW4A6Yq__n0sHFa24G-41j11CoL-WkTCp8_791fq6yYPBBbYoIkvK02rA/s320/Logo_Android.png" width="320" /></a></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p><br /></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Apa itu TWRP?</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Dikutip dari situs resminya </span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">TWRP Adalah Perangkat lunak kustom ini dapat digunakan sebagai pengganti firmware penggantian lengkap firmware perangkat dengan "ROM" khusus seperti OmniROM,</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Pertanyaannya adalah, apakah bisa kita flash TWRP Via Linux?</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Jawabannya adalah BISA SANGAT!</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Karena saya sudah membuktikannya</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Pertama</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p> Download dulu recovery.img <a href="http://zipansion.com/2q6kh" target="_blank">disini</a> (<i>Untuk Redmi Note 4 Nikel</i>)</o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Atau sesuai Tipe HP kalian (Cari sendiri costumnya hehe).</span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Lalu lanjutkan buka via terminal </span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Install fastboot</span><span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"># </span><i><span style="font-family: Calibri; font-size: 10,5000pt; font-style: italic; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><span style="color: blue;">apt install fastboot</span></span></i><i><span style="font-family: Calibri; font-size: 10,5000pt; font-style: italic; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></i></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Install adb driver</span><span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"># </span><i><span style="font-family: Calibri; font-size: 10,5000pt; font-style: italic; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><span style="color: blue;">apt install adb</span></span></i><i><span style="font-family: Calibri; font-size: 10,5000pt; font-style: italic; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></i></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Setelah itu pastikan HH kalian aktive untuk USB debugingnya.</span><span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Klik aboutphone klik 7x Miui version (user xiomi)</span><span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Lalu masuk develover option, centang USB Debuging .</span><span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Lalu kita sirkon via terminal, Ketik :</span><span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal" style="mso-pagination: widow-orphan; text-align: left;">
<span style="background: rgb(255,255,255); color: blue; font-family: ProximaNova; font-size: 12,0000pt; font-style: normal; letter-spacing: 0,0000pt; mso-font-kerning: 0,0000pt; mso-shading: rgb(255,255,255); mso-spacerun: 'yes'; text-transform: none;"># </span><i><span style="background: rgb(255, 255, 255); color: blue; font-family: ProximaNova; text-transform: none;">adb devices</span><span style="background: rgb(255, 255, 255); color: #424242; font-family: ProximaNova; text-transform: none;"> </span></i><span style="background: rgb(255,255,255); color: #424242; font-family: ProximaNova; font-size: 12,0000pt; font-style: normal; letter-spacing: 0,0000pt; mso-font-kerning: 0,0000pt; mso-shading: rgb(255,255,255); mso-spacerun: 'yes'; text-transform: none;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Lalu ketik konfirmasi yang ada dilayar HH kalian “OK”,</span><span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<style>
@font-face{
font-family:"Times New Roman";
}

@font-face{
font-family:"宋体";
}

@font-face{
font-family:"SimSun";
}

@font-face{
font-family:"Calibri";
}

@font-face{
font-family:"ProximaNova";
}

p.MsoNormal{
mso-style-name:Normal;
mso-style-parent:"";
margin:0pt;
margin-bottom:.0001pt;
mso-pagination:none;
text-align:justify;
text-justify:inter-ideograph;
font-family:Calibri;
mso-fareast-font-family:SimSun;
mso-bidi-font-family:'Times New Roman';
font-size:10,5000pt;
mso-font-kerning:1,0000pt;
}

span.msoIns{
mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
text-underline:single;
color:blue;
}

span.msoDel{
mso-style-type:export-only;
mso-style-name:"";
text-decoration:line-through;
color:red;
}
@page{mso-page-border-surround-header:no;
 mso-page-border-surround-footer:no;}@page Section0{
margin-top:72,0000pt;
margin-bottom:72,0000pt;
margin-left:90,0000pt;
margin-right:90,0000pt;
size:595,3000pt 841,9000pt;
layout-grid:15,6000pt;
}
div.Section0{page:Section0;}</style><br />
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Jika outputnya seperti ini maka HH success terhubung dalam ADB driver</span><span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNY1QXSrG9RzzDEPmW5OhjRYTVZKRJsJmA0N4O7QnpqmnboN7iYKmCItnUxzT8uXK4Osq6Pi_DQiDuWF3dw5cCRMas4Omc5v6eGbJL-_MyIeRhhEUu-M5GF53oUN4vZssyZqx4qZCLoNw/s1600/adb.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="486" data-original-width="592" height="523" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNY1QXSrG9RzzDEPmW5OhjRYTVZKRJsJmA0N4O7QnpqmnboN7iYKmCItnUxzT8uXK4Osq6Pi_DQiDuWF3dw5cCRMas4Omc5v6eGbJL-_MyIeRhhEUu-M5GF53oUN4vZssyZqx4qZCLoNw/s640/adb.png" width="640" /></a></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';">Lalu reboot ke Fastboot Mode dengan ketik</span></div>
<div class="MsoNormal">
<span style="font-family: Calibri; font-size: 10,5000pt; font-style: normal; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-font-kerning: 1,0000pt; mso-spacerun: 'yes';"># </span><span style="background-color: white; color: blue; font-family: ProximaNova, Arial, sans-serif; font-size: 16px; text-align: left;"><i>adb reboot bootloader</i></span></div>
<div class="MsoNormal">
<span style="background-color: white; color: blue; font-family: ProximaNova, Arial, sans-serif; font-size: 16px; text-align: left;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
Maka Otomatis HH kalian Akan reboot dan masuk ke mode fastboot.</div>
<div class="MsoNormal" style="text-align: left;">
<br /></div>
<div class="MsoNormal" style="text-align: left;">
langkah selanjutnya adalah cek status Unlock HH kamu dengan ketik</div>
<div class="MsoNormal" style="text-align: left;">
<br /></div>
<div class="MsoNormal" style="text-align: left;">
# <i><span style="background-color: white; color: blue; font-family: ProximaNova, Arial, sans-serif; font-size: 16px; word-wrap: break-word;">fastboot getvar all</span><span style="background-color: white; color: #424242; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"> </span></i></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; color: #424242; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">Jika Outputnya </span><span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><span style="color: blue;">YES </span>seperti berikut maka kita tinggal flash saja.</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">namun jika <span style="color: red;">NO </span>maka kalian harus melaukan request unlock terlebih dahulu.</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl2faRTvkpuMapdcdWOS1nx-CQK9IZZa9Pa8HoT0L3tPUQU7TWT1fr0uEABL_U6INUplCB7L0Ba2_215jO9rg81UKlhCXAPd7j26eAEVWVVAoJEXLgH5AS9L1UE4t3VIE7lxcy82xYRXQ/s1600/adb-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="486" data-original-width="613" height="506" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl2faRTvkpuMapdcdWOS1nx-CQK9IZZa9Pa8HoT0L3tPUQU7TWT1fr0uEABL_U6INUplCB7L0Ba2_215jO9rg81UKlhCXAPd7j26eAEVWVVAoJEXLgH5AS9L1UE4t3VIE7lxcy82xYRXQ/s640/adb-2.png" width="640" /></a></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">Ok, selanjutnya copy file <i>recovery.img </i>yang tadi kita download di folder home (di luar folder download).</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">kita bisa ketikan perintah</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"># <i>mv Download/recovery.img /home/<span style="color: blue;">Namauser/</span> disini . (nama user PC kamu)</i></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">atau move saja dengan file manager kalo susah hahaha.</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">setelah ada di depan, kita ketikan perintah :</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">#</span><i><span style="background-color: white; color: blue; font-family: ProximaNova, Arial, sans-serif; font-size: 16px; word-wrap: break-word;">fastboot flash recovery recovery.img</span><span style="background-color: white; color: #424242; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"> </span></i></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; color: #424242; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<br /></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: ProximaNova, Arial, sans-serif;"><span style="background-color: white;">Lalu outputnya seperti ini :</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6lNREWiOglYNb3rMHT6puIjUr3ldbkuolYM3_wzDbwXqN2jCWmToi1Ijwfr131-5fbarwIwBbtn5BRAQLXDWZvKz6RmtJTSZg_GMnlKJ6RQrBmDFWJtBBc26NkSp2txfVzNPAm2kYu2g/s1600/adb-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="515" data-original-width="615" height="534" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6lNREWiOglYNb3rMHT6puIjUr3ldbkuolYM3_wzDbwXqN2jCWmToi1Ijwfr131-5fbarwIwBbtn5BRAQLXDWZvKz6RmtJTSZg_GMnlKJ6RQrBmDFWJtBBc26NkSp2txfVzNPAm2kYu2g/s640/adb-3.png" width="640" /></a></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: ProximaNova, Arial, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: ProximaNova, Arial, sans-serif;"><span style="background-color: white;">Maka Flash TWRP (Costum Recovery berhasil) , Dan masih Ada 1 langkah lagi.</span></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: ProximaNova, Arial, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: ProximaNova, Arial, sans-serif;"><span style="background-color: white;">ketikan </span></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: ProximaNova, Arial, sans-serif;"><span style="background-color: white;"> # </span></span><span style="background-color: white; color: blue; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><i>fastboot boot recovery.img</i></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">untuk reboot ke mode recovery</span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">Maka Hasilnya taraaa:</span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwRi19G-aUM-mnJEBgD3FttIgilO5rjyEQjJl7VYlzEJj6bo-1KjJzSEg-nwjm14ZHCpTeRLG0g00rykrC3DSacyFcabSzNEumn1f8tocCJSmaEYyMvRHgJq4iUahbpRu_ygEkJNJBaDE/s1600/Screenshot_2018-08-11-10-17-58.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1600" data-original-width="900" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwRi19G-aUM-mnJEBgD3FttIgilO5rjyEQjJl7VYlzEJj6bo-1KjJzSEg-nwjm14ZHCpTeRLG0g00rykrC3DSacyFcabSzNEumn1f8tocCJSmaEYyMvRHgJq4iUahbpRu_ygEkJNJBaDE/s640/Screenshot_2018-08-11-10-17-58.png" width="360" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">TWRP yang sudah di setting bahasa Inggris<br /></td></tr>
</tbody></table>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;"><br /></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="background-color: white; font-family: ProximaNova, Arial, sans-serif; font-size: 16px;">Ok demikian postingan kali ini, silahkan bertanya melalui komentar atau via facebook saya di <a href="https://web.facebook.com/rajin.ngoding" target="_blank">facebook</a> .</span></div>
<div class="MsoNormal" style="text-align: left;">
Wasalam..</div>
</div>

Cara Pasang TWRP Android Via Terminal Linux

Hai Assalamwalaikum... Kali ini saya akan membagikan pengalaman pasang TWRP di Ponsel kesayangan saya Redmi Note 4 . Ya walaupun seri ...

Baca selengkapnya »

Rajin Ngoding

Upload Multi Table Relation Dengan Laravel Excel

Mengatasi A non-numeric value encountered pada looping laravel

Cara Parser Variable {{}} Dinamis Laravel Blade

Membuat Nomor Transaksi Otomatis Tidak Habis Pada Laravel 5.8

Cara Migrasi Mysql / MariaDB Ke Postgress SQL

Cara Pasang TWRP Android Via Terminal Linux

Ads

Formulir Kontak

Label

Entri Populer

Arsip Blog

Labels