Menampilkan Tabel Dengan PHP Koneksi MYSQL

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVaxE-SVCi1rUiac7rRHHJV9e1t7gAO5E3MV9zj50PVh1G7VdigKRB0MIksXUEuwVCtS-_7DwX8nB5eVMRzIUfSLJxvxNWmRnDdeS6ZyhOfPvxzFUUcFE3Dk_uQrsC-Zyw2bvfKrD3dv2M/s1600/KONEKSI2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="146" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVaxE-SVCi1rUiac7rRHHJV9e1t7gAO5E3MV9zj50PVh1G7VdigKRB0MIksXUEuwVCtS-_7DwX8nB5eVMRzIUfSLJxvxNWmRnDdeS6ZyhOfPvxzFUUcFE3Dk_uQrsC-Zyw2bvfKrD3dv2M/s320/KONEKSI2.jpg" width="320" /></a></div> <br /> Sebelum kawan mengetik koding dibawah ini sebaiknya kawan membuat database dahulu hehhe.. kalo udah dibuat sih gpp.. langsungkoding aja.. :D<br /> <br /> <?php<br /> $db_host = 'localhost'; // Nama Server Komputer<br /> $db_user = 'root';     // User Server  Komputer<br /> $db_pass = '';        // Password Server<br /> $namadatabase = 'abcde';  // Nama Database<br /> <br /> $conn = mysqli_connect($db_host, $db_user, $db_pass, $namadatabase);<br /> if (!$conn) {<br /> <span class="Apple-tab-span" style="white-space: pre;"> </span>die ('Gagal terhubung MySQL:'. mysqli_connect_error());<span class="Apple-tab-span" style="white-space: pre;"> </span><br /> }<br /> <br /> $sql = 'select * from barang';<br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><br /> $query = mysqli_query($conn, $sql);<br /> <br /> if (!$query) {<br /> <span class="Apple-tab-span" style="white-space: pre;"> </span>die ('SQL Error: ' . mysqli_error($conn));<br /> }<br /> echo '<table border = 0><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><thead><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><tr><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><th>LIST BARANG</th><br />      <span class="Apple-tab-span" style="white-space: pre;"> </span></tr><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span></thead><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><tbody>';<br /> <br /> echo '<table border = 1><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><thead><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><tr><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><th>KODE BARANG</th><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><th>NAMA BARANG</th><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><th>JENIS BARANG</th><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><th>QUANTITY</th><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span></tr><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span></thead><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><tbody>';<br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><br /> while ($row = mysqli_fetch_array($query))<br /> {<br /> <span class="Apple-tab-span" style="white-space: pre;"> </span>echo '<tr><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><td>'.$row['kdbrg'].'</td><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><td>'.$row['namabrg'].'</td><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><td>'.$row['jenisbrg'].'</td><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span><td>'.$row['qty'].'</td><br /> <span class="Apple-tab-span" style="white-space: pre;"> </span></tr>';<br /> }<br /> echo'<br /> <span class="Apple-tab-span" style="white-space: pre;"> </span></tbody><br /> </table>';<br /> mysqli_free_result($query);<br /> mysqli_close($conn);<br /> <br /> Note : Nama tabel dan sebagainya disesuaikan yah.... kalo tidak sesuai nanti muncul error loh.. :p<br /> trus save file tersebut dengan nama view tabel<br /> <br /> <br /> Create : Abednego,S.T</p>

Sebelum kawan mengetik koding dibawah ini sebaiknya kawan membuat database dahulu hehhe.. kalo udah dibuat sih gpp.. langsungkoding aja.....

Koneksi PHP ke Database MYSQL

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpDiP30h7Eeo5wYqwpl0y2bIj6UQVo7KHSH95at9_ytVXUy1n94_Txd0qnSYpoLFFGLTDOVziD5riNuVdOTriL6AGGoW9JctcDoqfozTljRFKhE_PrX2x5EDHOWSX_QOG0i5mRAEcH8apy/s1600/KONEKSI.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="77" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpDiP30h7Eeo5wYqwpl0y2bIj6UQVo7KHSH95at9_ytVXUy1n94_Txd0qnSYpoLFFGLTDOVziD5riNuVdOTriL6AGGoW9JctcDoqfozTljRFKhE_PrX2x5EDHOWSX_QOG0i5mRAEcH8apy/s320/KONEKSI.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;"><?php </span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">         </span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">          $server="localhost";       </span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">          $username="root";          </span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">          $sandi="";                </span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">          $database="abcde";          </span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">          $koneksi=mysql_connect ($server, $username, $sandi);</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;"><br /></span></span> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">            if ($koneksi)</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">                   {</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">                    mysql_select_db ($database) or die ("DATABASE TIDAK DITEMUKAN");</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">                 echo " <b> Koneksi Berhasil </b> ";</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">        } else </span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">            {</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">               echo "<b> Koneksi Gagal </b>";</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">              }</span></span><br /> <span style="color: #777777; font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">?></span></span><br /> <span style="background-color: white; font-family: "georgia" , "times new roman" , "times" , serif; font-size: 12.96px; margin: 0px; padding: 0px;"><br /></span> <span style="background-color: white; font-family: "georgia" , "times new roman" , "times" , serif; font-size: 12.96px; margin: 0px; padding: 0px;">Trus simpan File tersebut dengan nama Koneksi.php dan simpan file tersebut pada folder htdocs</span><br /> <br /> <span style="background-color: white; font-family: "georgia" , "times new roman" , "times" , serif; font-size: 12.96px; margin: 0px; padding: 0px;"><br /></span> <span style="background-color: white; font-family: "georgia" , "times new roman" , "times" , serif; font-size: 12.96px; margin: 0px; padding: 0px;"><br /></span> <span style="font-family: "georgia" , "times new roman" , "times" , serif;"><span style="background-color: white; font-size: 12.96px;">Create : Abednego,S.T</span></span></p>

<?php                      $server="localhost";                  $username="root";                     $sandi...

Logika Buble Sort

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrYdLBYrhquIpGMNfYr9JUMsKUhL9HoZL6nNlGamRS5PtxmPwCCogyHT3gGI9Ne7tT-13DlqT4V5w4wHJSkUAKK-Q35m2boCJMrV4sUKS0VwGfwHiOX9BH6MYHcoO9GhCry1hvkPlrl7-m/s1600/sort.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrYdLBYrhquIpGMNfYr9JUMsKUhL9HoZL6nNlGamRS5PtxmPwCCogyHT3gGI9Ne7tT-13DlqT4V5w4wHJSkUAKK-Q35m2boCJMrV4sUKS0VwGfwHiOX9BH6MYHcoO9GhCry1hvkPlrl7-m/s320/sort.jpg" width="202" /></a></div> <div class="separator" style="clear: both; text-align: center;"> Gambar diatas adalah koding logika Buble Sort</div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Buat kalian siswa/i RPL SMK DBI mangga dipelajari dan dipahami ya.... sugan we teu lieur.. hahaa </div> <br /> <br /> <br /> Create : Abednego,S.T</p>

Gambar diatas adalah koding logika Buble Sort Buat kalian siswa/i RPL SMK DBI mangga dipelajari dan dipahami ya.... sugan we teu lieu...

Tutorial Looping Dengan JAVA Part 2

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVwWF7Y8mdukuteMb0wMBdJMY-XRZYjx_21tMUyvmp9SCQOfGNCl_tF_NcBYdHdRJeZ0CnZtpBhpWVZK4M2HiHX57QgvD6pZ1yeD15RzmlrnjvikZUnvQ-DCgWWq26-kL-0hFapWZlTv0k/s1600/java2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVwWF7Y8mdukuteMb0wMBdJMY-XRZYjx_21tMUyvmp9SCQOfGNCl_tF_NcBYdHdRJeZ0CnZtpBhpWVZK4M2HiHX57QgvD6pZ1yeD15RzmlrnjvikZUnvQ-DCgWWq26-kL-0hFapWZlTv0k/s320/java2.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar diatas adalah hasil dari tutorial dibawah ini </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;"> Nah pada Tutorial Looping Java Part 2 ini saya akan memberikan Looping bertingkat untuk lebih jelasnya silakan lihat koding dibawah ini : </div> <div> <br /></div> <div> <div> public class Looping2 {</div> <div> <br /></div> <div>     public static void main(String[] args)</div> <div>     {</div> <div>         </div> <div>         for (int a=1; a<=5; a++) </div> <div>            {</div> <div>                for (int b=1; b<=a; b++ ) </div> <div>                    {  </div> <div>                      System.out.print(b);</div> <div>                    }</div> <div>                System.out.println("");      </div> <div>           }</div> <div>                    </div> <div>     }</div> <div> }</div> </div> <div> <br /></div> <div> <div class="separator" style="clear: both;"> untuk menjalankan hasil koding atas kawan pencet F6 pada aplikasi NETBEANS ... pasti hasilnya seperti gambar diatas .. :D</div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> Create : Abednego,S.T</div> </div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <br /></p>

Gambar diatas adalah hasil dari tutorial dibawah ini  Nah pada Tutorial Looping Java Part 2 ini saya akan memberikan Looping bert...

Tutorial Looping Dengan JAVA Part 1

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7dOuhrMmwsFGyXdIEggUC1Js6yBbkq84uG3ZFAOAVDmzhnv6In-S4RaCLzP57tpeU6RxbK256F09KU0qzlgumAwkb_sag-Fm7PqDeE4Zc8i-b7HtpgVXPYeGmnmI7EXiew3TpAPprEYW2/s1600/java1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7dOuhrMmwsFGyXdIEggUC1Js6yBbkq84uG3ZFAOAVDmzhnv6In-S4RaCLzP57tpeU6RxbK256F09KU0qzlgumAwkb_sag-Fm7PqDeE4Zc8i-b7HtpgVXPYeGmnmI7EXiew3TpAPprEYW2/s320/java1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar diatas adalah hasil dari tutorial dibawah ini </div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Next..... saya akan menerangan Looping dalam bahasa JAVA ... sebenernya sama saja semua Looping dalam bahasa pemograman hanya bahasanya aja harus menyesuaikan... nah... kalian liat koding dibawah ini : </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both;"> package looping;</div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> public class looping </div> <div class="separator" style="clear: both;"> {</div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;">       public static void main(String[] args) </div> <div class="separator" style="clear: both;">          {</div> <div class="separator" style="clear: both;">              for (int angka =1; angka <= 10; angka++ )</div> <div class="separator" style="clear: both;">          {</div> <div class="separator" style="clear: both;">             System.out.println(angka);</div> <div class="separator" style="clear: both;">          }</div> <div class="separator" style="clear: both;">      }    </div> <div class="separator" style="clear: both;"> }</div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> untuk menjalankan hasil koding atas kawan pencet F6 pada aplikasi NETBEANS ... pasti hasilnya seperti gambar diatas .. :D</div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> Create : Abednego,S.T</div> <br /></p>

Gambar diatas adalah hasil dari tutorial dibawah ini  Next..... saya akan menerangan Looping dalam bahasa JAVA ... sebenernya sam...

Aplikasi Iventory Sederhana Versi 0.0.1

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-6oxbERacpip2Ru-ttb3fBRv6Wen_xiP0u0xzhYjA8GdMKob3QI6nU3-JsG92ux1IRGqPe03R4l5qdRmPVgJHNtdkQh4MOdadUBeqBGDoo9BBcgH2nv8MA07nnr_Bxg4NbYZFa8W0LBWd/s1600/crud1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-6oxbERacpip2Ru-ttb3fBRv6Wen_xiP0u0xzhYjA8GdMKob3QI6nU3-JsG92ux1IRGqPe03R4l5qdRmPVgJHNtdkQh4MOdadUBeqBGDoo9BBcgH2nv8MA07nnr_Bxg4NbYZFa8W0LBWd/s320/crud1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both;"> Kali ini saya akan memberikan hasil aplikasi yang sudah saya buat supaya kalian bisa mempelajarinya hehehe.... silakan download disini => <a href="https://drive.google.com/file/d/0B_f1GrxyPvdXMFg4cjRadl95TlU/view?usp=sharing" target="_blank">Aplikasi Iventory Versi 0.0.2</a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both;"> bila ada pertanyaan silakan koment ya.. :D</div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> Create : Abednego,S.T</div> </p>

Kali ini saya akan memberikan hasil aplikasi yang sudah saya buat supaya kalian bisa mempelajarinya hehehe.... silakan download disini ...

Tutorial CRUD Dengan Delphi 7 Koneksi MYSQL

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg57FuWlqDIV6ghcpHJpLDwNZLrOo__Co349Vg58-VbDdGdTsbGzw7NV-VSGbw4ZTkQUWuIFWXlMYjT2e5Kalukp9H6oE1gyhvM7RVXSEi-vI15CxyXAPvqybQSldP1L2T6ENX7zIIcZs-d/s1600/crud1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg57FuWlqDIV6ghcpHJpLDwNZLrOo__Co349Vg58-VbDdGdTsbGzw7NV-VSGbw4ZTkQUWuIFWXlMYjT2e5Kalukp9H6oE1gyhvM7RVXSEi-vI15CxyXAPvqybQSldP1L2T6ENX7zIIcZs-d/s320/crud1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar diatas merupakan hasil dari tutorial dibawah ini</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;"> Baiklah sekarang saya akan membuat tutorial CRUD apa itu CRUD ?? hehee...CRUD itu adalah singkatan dari CREATE , READ , UPDATE dan DELETE udah tau yahh...  :D</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Tutorial ini adalah sambungan dari <a href="http://meta-aksara.blogspot.co.id/2017/05/mengkoneksikan-delphi-7-ke-mysql-dengan.html" target="_blank">Mengkoneksikan Delphi 7 ke MYSQL Dengan Zeoslib</a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> </div> 1.nah silakan kawan - kawan design tampilan FORM nya seperti dibawah ini :<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8SqiVgwPrIOi237LZ6vJbRoYzuKPIdyrI5mGI2EYjYB2gfaU0xizS80lIVxxBz558uglnubaIJwNkk7YeKiOJOXTupzqkjVwYGUuPhWLJG2rKD0Iewq0DIz1J0nHeuR5GHOk4eYUn8ASF/s1600/crud2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8SqiVgwPrIOi237LZ6vJbRoYzuKPIdyrI5mGI2EYjYB2gfaU0xizS80lIVxxBz558uglnubaIJwNkk7YeKiOJOXTupzqkjVwYGUuPhWLJG2rKD0Iewq0DIz1J0nHeuR5GHOk4eYUn8ASF/s320/crud2.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 2.Gambar diatas saya menambahkan component LABEL , EDIT dan BUTTON silakan sesuaikan yah tampilan nya.. serapih mungkin biar enak dilihat nya ... :p</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 3.Jika sudah kawan kawan sekarang klik 2 kali pada BUTTON -> TAMBAH dan ketik koding dibawah ini : </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both;"> procedure TForm1.Button1Click(Sender: TObject);</div> <div class="separator" style="clear: both;"> begin</div> <div class="separator" style="clear: both;">      barang.Append;</div> <div class="separator" style="clear: both;">      Edit1.Enabled:=True;</div> <div class="separator" style="clear: both;">      Edit2.Enabled:=True;</div> <div class="separator" style="clear: both;">      Edit3.Enabled:=True;</div> <div class="separator" style="clear: both;">      Edit4.Enabled:=True;</div> <div class="separator" style="clear: both;">      Edit1.SetFocus;</div> <div class="separator" style="clear: both;"> end;</div> <br /> 4.Lalu klik 2 kali pada BUTTON -> BATAL  dan  ketik koding dibawah ini :<br /> <br /> procedure TForm1.Button5Click(Sender: TObject);<br /> begin<br />      Edit1.Clear;<br />      Edit2.Clear;<br />      Edit3.Clear;<br />      Edit4.Clear;<br />      Edit1.Enabled:=False;<br />      Edit2.Enabled:=False;<br />      Edit3.Enabled:=False;<br />      Edit4.Enabled:=False;<br />      barang.Cancel;<br /> end;<br /> <br /> 5.Lalu klik 2 kali pada BUTTON -> SIMPAN dan ketik koding dibawah ini :<br /> <br /> procedure TForm1.Button4Click(Sender: TObject);<br /> begin<br />      if Edit1.Text = '' then<br />         begin<br />              ShowMessage('Kode Barang Masih Kosong');<br />              Exit;<br />         end<br />         else<br />             begin<br />                    barangkdbrg.Value    :=Edit1.Text;<br />                    barangnamabrg.Value  :=Edit2.Text;<br />                    barangjenisbrg.Value :=Edit3.Text;<br />                    barangqty.Value      :=StrToInt(Edit4.Text);<br />                    barang.Post;<br />                    ShowMessage('Data Tersimpan');<br /> <br />                    Edit1.Clear;<br />                    Edit2.Clear;<br />                    Edit3.Clear;<br />                    Edit4.Clear;<br /> <br />                    Edit1.Enabled:=False;<br />                    Edit2.Enabled:=False;<br />                    Edit3.Enabled:=False;<br />                    Edit4.Enabled:=False;<br />             end;<br /> <br /> 6.Lalu klik 2 kali pada BUTTON -> GANTI dan ketik koding dibawah ini :<br /> <br /> procedure TForm1.Button2Click(Sender: TObject);<br /> begin<br />      Edit1.Enabled:=True;<br />      Edit2.Enabled:=True;<br />      Edit3.Enabled:=True;<br />      Edit4.Enabled:=True;<br /> <br />      Edit1.Text   :=barangkdbrg.Value;<br />      Edit2.Text   :=barangnamabrg.Value;<br />      Edit3.Text   :=barangjenisbrg.Value;<br />      Edit4.Text   :=IntToStr(barangqty.Value);<br /> <br />      barang.Edit;<br /> <br />     <br /> end;<br /> <br /> 7..Lalu klik 2 kali pada BUTTON -> HAPUS dan ketik koding dibawah ini :<br /> <br /> procedure TForm1.Button3Click(Sender: TObject);<br /> begin<br />         barang.delete;<br />        Showmessage('Data Terhapus');<br /> end;<br /> <br /> <br /> OK..!! beres ... :D nah sekarang pencet F9 untuk menjalankan aplikasinya .. :D<br /> <br /> <br /> Create : Abednego,S.T<br /> <br /> <br /> <br /></p>

Gambar diatas merupakan hasil dari tutorial dibawah ini Baiklah sekarang saya akan membuat tutorial CRUD apa itu CRUD ?? hehee......

Mengkoneksikan Delphi 7 ke MYSQL Dengan Zeoslib

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdm_2wzH5DSqkWmQB5GtHHDJi9aVo7APABAL73PTet3IZv3vtLuAM8qLqInRpjYci_gWluGgNXCq6olQLNwD74rEek9GU7Fiu758_f4zuJRGfvrdLlNRx59Qu9ul_pjLE4PVL5F7A7mQ7G/s1600/dbgrid14.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdm_2wzH5DSqkWmQB5GtHHDJi9aVo7APABAL73PTet3IZv3vtLuAM8qLqInRpjYci_gWluGgNXCq6olQLNwD74rEek9GU7Fiu758_f4zuJRGfvrdLlNRx59Qu9ul_pjLE4PVL5F7A7mQ7G/s320/dbgrid14.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar diatas merupakan hasil dari tutorial dibawah ini</div> <br /> Tutorial ini adalah kelanjutan dari tutorial dari  <span style="background-color: white; color: #2b2828; font-family: "droid sans"; font-size: 23.4px;">Cara Instal Zeos Pada Delphi 7 </span><br /> bisa dilihat pada link disini : <span style="background-color: white; color: #2b2828; font-family: "droid sans";"><a href="http://meta-aksara.blogspot.co.id/2017/05/cara-instal-zeos-pada-delphi-7.html" target="_blank">Cara Instal Zeos Pada Delphi 7</a> <span style="font-size: x-small;"> </span></span><br /> nah apabila sudah di instal ZEOSLIB nya ... lalu sekarang adalah tahapan untuk mengkoneksikan DELPHI 7 ke database MYSQL dengan ZEOSLIB ...<br /> <br /> 1.Buka apliakasi delphi 7<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0-GoYC0lITpsQ85F49h1IKd3yPyAUKqAnyCHUQN5A0uYtRRy_Jwge3nC3Tn3Sm7c45YAxN8tb0lJQj4ei-MigunZq0WmRoUseG8IPbsq_JrjXQOU77z0HK5tC229qoO4Vt9dGVf-wIfbY/s1600/form+delphi1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0-GoYC0lITpsQ85F49h1IKd3yPyAUKqAnyCHUQN5A0uYtRRy_Jwge3nC3Tn3Sm7c45YAxN8tb0lJQj4ei-MigunZq0WmRoUseG8IPbsq_JrjXQOU77z0HK5tC229qoO4Vt9dGVf-wIfbY/s320/form+delphi1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 2.Cari pallet DATA CONTROLS</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj958wBF4pTV63b8m1D4zdK2Jk7FK27ehQY95jRTwH46ajCK8KjkgWHpAsywN6W8ju7wcuh4M88Mp3ERJNpQUF59ialfFLdfxzwyafDBy5W0HNjib1WRqzNq_aW9no9A2Q-9wlvEA3K1Jss/s1600/dbgrid.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="46" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj958wBF4pTV63b8m1D4zdK2Jk7FK27ehQY95jRTwH46ajCK8KjkgWHpAsywN6W8ju7wcuh4M88Mp3ERJNpQUF59ialfFLdfxzwyafDBy5W0HNjib1WRqzNq_aW9no9A2Q-9wlvEA3K1Jss/s320/dbgrid.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 3.Klik DBGRID dan simpan di FORM ... lalu sesuaikan tampilannya seperti gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQHP7Q-z613bvE8PhGEmNk46rnAdsao2rzxjr472O5MLnjgE39dED_3FClJhL5zhUX4QTB4GSs5RrbBRxP8fumxrh-APoXEL-AwvR16-kWBHNLkCWnQDQRneYMNszBtZ7US6aqBcM7rDrL/s1600/dbgrid1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQHP7Q-z613bvE8PhGEmNk46rnAdsao2rzxjr472O5MLnjgE39dED_3FClJhL5zhUX4QTB4GSs5RrbBRxP8fumxrh-APoXEL-AwvR16-kWBHNLkCWnQDQRneYMNszBtZ7US6aqBcM7rDrL/s320/dbgrid1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 4.Setelah design FORM nya sekarang kawan cari pallet Zeos Acces ligat gambar dibawah :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTjZSEJZiIZQ-6YJBfyX98l641sd93fzcqj8ucCpudISTOuvVlZLyYrAHvGUMyiTBjBA7dSZkULBjrL6qd_HtvYghtui47ftiuUoy_ZPfb2kfoXGCVT30uXlaAC9KwbrMaX6bhoT0f39qP/s1600/dbgrid2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTjZSEJZiIZQ-6YJBfyX98l641sd93fzcqj8ucCpudISTOuvVlZLyYrAHvGUMyiTBjBA7dSZkULBjrL6qd_HtvYghtui47ftiuUoy_ZPfb2kfoXGCVT30uXlaAC9KwbrMaX6bhoT0f39qP/s320/dbgrid2.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 5.Component dalam Zeoslib </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGJaAUDDCteJSzFxe5z_OLaCy0B5BxMB2pAq6_r6GXZvKc2TkpOA0mnmFS_4TwAIMGMBvlvsDJaKcnIolrwUXuOaWbYP9qP7-1HdcCSgzeBotcEtFdOGecLl5dc6XU9InEEvB3e2_7sQI2/s1600/dbgrid3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="36" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGJaAUDDCteJSzFxe5z_OLaCy0B5BxMB2pAq6_r6GXZvKc2TkpOA0mnmFS_4TwAIMGMBvlvsDJaKcnIolrwUXuOaWbYP9qP7-1HdcCSgzeBotcEtFdOGecLl5dc6XU9InEEvB3e2_7sQI2/s320/dbgrid3.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 6.Setelah itu kawan pilih Zconnection dan Zquery pada pallet Zeoslib tersebut seperti pada gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5rnZZNhY6XIis_3PGvbFASfIxKfYnEff2UaeGUKTwh3INHQLddS0U36Ln3Rkw5vFNesxP5YK3o2ychL6f30XoaFl4lb69uRyP86N4mh45MpgUh6_HXOW8nvTu4uxV6zJ2eMR7ZEO5ODe4/s1600/dbgrid4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5rnZZNhY6XIis_3PGvbFASfIxKfYnEff2UaeGUKTwh3INHQLddS0U36Ln3Rkw5vFNesxP5YK3o2ychL6f30XoaFl4lb69uRyP86N4mh45MpgUh6_HXOW8nvTu4uxV6zJ2eMR7ZEO5ODe4/s320/dbgrid4.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 7.Setelah itu kawan cari component DATASOURCE pada pallet DATA ACCES seperti gambar dibah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgocAMAGaFVsdyRJYBFtKM38G7idG7IDkR-OzHp4wkVLVTh6PnbAcOXU3sBFzT4bz6LR0T_F_M-POvwG9XlZIYdfNPgqyTn2WxBuziy-aPqUwZc76Mi5UnhUfujgtrVgxyh1AeRBSZ6mgxd/s1600/dbgrid5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgocAMAGaFVsdyRJYBFtKM38G7idG7IDkR-OzHp4wkVLVTh6PnbAcOXU3sBFzT4bz6LR0T_F_M-POvwG9XlZIYdfNPgqyTn2WxBuziy-aPqUwZc76Mi5UnhUfujgtrVgxyh1AeRBSZ6mgxd/s1600/dbgrid5.jpg" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 8.Setelah itu kawan pilih DATASOURCE (DB) pada pallet DATA ACCES lihat gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY-499lmdFKoyZxAwgaFtQt3TZHt8HmTy1MPDGljM8T9YUdGE_Hlo9OCacKGSCLzrK8iMBN_yHjo5HDwwe-d_ItzUGxxLdyQDtHprn3RXRD8ZUomP3rm1U6qhuFp7fLc_sT9SzbdfiN1lG/s1600/dbgrid6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY-499lmdFKoyZxAwgaFtQt3TZHt8HmTy1MPDGljM8T9YUdGE_Hlo9OCacKGSCLzrK8iMBN_yHjo5HDwwe-d_ItzUGxxLdyQDtHprn3RXRD8ZUomP3rm1U6qhuFp7fLc_sT9SzbdfiN1lG/s320/dbgrid6.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 9.nah component yang dibutuhkan sudah siap dipakai ... sekarang tinggal cara SETTING componentnya.</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 10.Sekarang klik pada Zconnection nya dan silakan isi PROPERTIES nya seperti gambar dibawah ini:</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj90zaVs6iX58I9jrobIONA_KdYDHjf4Gl7KfHSdBAlcQLxRWcrf6zd5xwLHEGTupsIkTE_HmP5cKdGVqBrmA8byG9rBbYu1AaG2I81DTUYZd2wV4hRg99KDrokW-zRk9RPOT35QdEFvmbT/s1600/dbgrid7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj90zaVs6iX58I9jrobIONA_KdYDHjf4Gl7KfHSdBAlcQLxRWcrf6zd5xwLHEGTupsIkTE_HmP5cKdGVqBrmA8byG9rBbYu1AaG2I81DTUYZd2wV4hRg99KDrokW-zRk9RPOT35QdEFvmbT/s320/dbgrid7.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 11.Jika sudah di SETTING ... sekarang klik pada ZQuery nya , lihat gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3sQnWEeKAcqNdAayLjlqaxLkG0mp6iKSmlqiOKkzRNFmRJ-h5eeNr-EKHc2lgsrSV3U6b0_Id6gjlgyvHqtauD34Q1LLexrDqz6Hdt0j-kRiGPSo_VF75Z87z_2t_T-fxkmN_0iSSFOCA/s1600/dbgrid8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3sQnWEeKAcqNdAayLjlqaxLkG0mp6iKSmlqiOKkzRNFmRJ-h5eeNr-EKHc2lgsrSV3U6b0_Id6gjlgyvHqtauD34Q1LLexrDqz6Hdt0j-kRiGPSo_VF75Z87z_2t_T-fxkmN_0iSSFOCA/s320/dbgrid8.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 12.Setelah itu masih pada ZQuery ... kawan cari PROPERTIES pada ZQuery  -> SQL (String) </div> <div class="separator" style="clear: both; text-align: left;"> jika sudah menemukan klik BUTTON yang kecil tersebut ... maka tampilannya akan berubah menjadi seperti ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzNlISeFNyKw-fEVbJVEDvD4vZR89nNk95MbOck7ru_yAfVOBh9r3Q7W6nAfa0nrI1kzie-aqelF6FX2xEf9iR0gptJ6XL1rwtgo3AWRna7hx6Ctk8iRMezkqXqklogy4BdHl_zasxky4H/s1600/dbgrid9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzNlISeFNyKw-fEVbJVEDvD4vZR89nNk95MbOck7ru_yAfVOBh9r3Q7W6nAfa0nrI1kzie-aqelF6FX2xEf9iR0gptJ6XL1rwtgo3AWRna7hx6Ctk8iRMezkqXqklogy4BdHl_zasxky4H/s320/dbgrid9.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 13.Nah sekarang tinggal memasukan Query nya ... silakan ketik Querynya seperti ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFLczrxNOtfMzJom1twvdj2nmRNpfmAMw8cDcx5YcJGSvNBAJJ4vkZeiSQRD0SHbJhAO0-ozISqYT7py13a-AEndWmQB9P7BXFKiWNVxiI5DL2FVJ4YxIaLnos9992GJ3XBQoKlCBepbpU/s1600/dbgrid10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFLczrxNOtfMzJom1twvdj2nmRNpfmAMw8cDcx5YcJGSvNBAJJ4vkZeiSQRD0SHbJhAO0-ozISqYT7py13a-AEndWmQB9P7BXFKiWNVxiI5DL2FVJ4YxIaLnos9992GJ3XBQoKlCBepbpU/s320/dbgrid10.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 14.Dan klik BUTTON OK...</div> <div class="separator" style="clear: both; text-align: left;"> 15.Masih pada ZQuery ... sekarang kawan cari PROPERTIES -> Active posisinya paling atas </div> <div class="separator" style="clear: both; text-align: left;"> Active awalnya di isi dengan FALSE .. nah sekarang ganti dengan TRUE </div> <div class="separator" style="clear: both; text-align: left;"> 16.Dan sekarang kawan klik component DATASOURCE dan setting PROPERTIES nya seperti gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPbtyd_S2GGzNaQl2CPciHolHVlNiUjA3qdPJo6n7x9HzZMe9dwtfILN2UB6NxRPysMqHdb-H7cmoxbiQJ3FLLUGYWxDmZDFi2gjZu9hMEhPqz29KRAiO-4Mem9YdxpNaEgthBs9NWPpS3/s1600/dbgrid11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPbtyd_S2GGzNaQl2CPciHolHVlNiUjA3qdPJo6n7x9HzZMe9dwtfILN2UB6NxRPysMqHdb-H7cmoxbiQJ3FLLUGYWxDmZDFi2gjZu9hMEhPqz29KRAiO-4Mem9YdxpNaEgthBs9NWPpS3/s320/dbgrid11.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 17.Gambar diatas settingan nya belum di input nah sekarang lihat hasil setingan DATASOURCE tersebut pada gambar dibawah ini : </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1FM_IDP64yDrWGgDGd9si8OrrIzapehhD0w2_Vaw5gbxZZrS-mi8F0OxFnnR6-vxZPBaUtGGp8LGLmXKS_U2mDLrMKXfqcInWT6jQQ_y3e0AIP2TxFyFXzw6BVk3ywFCdsSJBs-hZBujq/s1600/dbgrid12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1FM_IDP64yDrWGgDGd9si8OrrIzapehhD0w2_Vaw5gbxZZrS-mi8F0OxFnnR6-vxZPBaUtGGp8LGLmXKS_U2mDLrMKXfqcInWT6jQQ_y3e0AIP2TxFyFXzw6BVk3ywFCdsSJBs-hZBujq/s320/dbgrid12.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 18.Setingan DATASOURCE sudah beres ... nah sekarang kita seting DBGRID nya untuk tahapan akhir... sekarang klik pada DBGRID nya dan cari DATASOURCE pada PROPERTIES... jika sudah ketemu DATASOURCE nya silakan isi dengan "dsbarang" lihat gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL-AhK8dWfoDxPAgds6OhhhJjhYM6DMvBUWEGa_Hv_0mDgMQ499lmxNrOL0xNa9ne0zfkrpqYY9g-Ev7KQ_8ZErocM7tLzIl5ARbJtOGZE1ImsfnOSLEZAYiuIHw3nOxp9hK1YUswU_1XI/s1600/dbgrid13.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL-AhK8dWfoDxPAgds6OhhhJjhYM6DMvBUWEGa_Hv_0mDgMQ499lmxNrOL0xNa9ne0zfkrpqYY9g-Ev7KQ_8ZErocM7tLzIl5ARbJtOGZE1ImsfnOSLEZAYiuIHw3nOxp9hK1YUswU_1XI/s320/dbgrid13.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 19.Sekarang kaawan pencet F9 untuk menjalakan APLIKASI nya.. :D</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Create : Abednego,S.T</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <br /> <span style="background-color: white; color: #2b2828; font-family: "droid sans"; font-size: 23.4px;"><br /></span> <span style="background-color: white; color: #2b2828; font-family: "droid sans"; font-size: 23.4px;"><br /></span></p>

Gambar diatas merupakan hasil dari tutorial dibawah ini Tutorial ini adalah kelanjutan dari tutorial dari   Cara Instal Zeos Pada Del...

Tutorial Membuat Database Dengan Navicat Part 3

<p><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlXlmv0yKKsstImyoJN2yoyEUNjcC7wKUt2p-KNWAGUKF5wAxjTPUc8sI73OAofsW0L1c9U8YL0OOwwzv1CIrxZpfQs2QkLIWc6SerA6kccCebYoXWlws3hfEZ4y6w_-T3FJoJa3eCA3NL/s1600/hasilquery2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlXlmv0yKKsstImyoJN2yoyEUNjcC7wKUt2p-KNWAGUKF5wAxjTPUc8sI73OAofsW0L1c9U8YL0OOwwzv1CIrxZpfQs2QkLIWc6SerA6kccCebYoXWlws3hfEZ4y6w_-T3FJoJa3eCA3NL/s320/hasilquery2.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar ini adalah hasil dari tutorial dibawah ini</div> <div style="text-align: center;"> <br /></div> <div style="text-align: center;"> <br /></div> <div style="text-align: left;"> oke kita lanjutkan Tutorial Membuat Database Dengan Navicat Part 2 yang sebelumnya nah sekarang yang part 3 .. hehe... langsung saja ya... </div> <div style="text-align: left;"> <br /></div> <div style="text-align: left;"> kita akan memasukan data pada tabel yang kita buat sebelumnya ... tahapannya adalah sebagai berikut :</div> <div style="text-align: left;"> <br /></div> <div style="text-align: left;"> 1.klik menu query seperti gambar dibawah ini :</div> <div style="text-align: left;"> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnFFbHb5TZUbj349frwjJZTxy5DXXCvjejnx-kbXlHa7Ib5edTPfmxFoyuU2qKeWVEepGIL5hDvz4zTtRXcWoDRY6GhpBFQmVdU5JT2GlBzu-4eZC60WE4StMuZYZ6xUH2tLr2tQ7B86_/s1600/navicat8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnFFbHb5TZUbj349frwjJZTxy5DXXCvjejnx-kbXlHa7Ib5edTPfmxFoyuU2qKeWVEepGIL5hDvz4zTtRXcWoDRY6GhpBFQmVdU5JT2GlBzu-4eZC60WE4StMuZYZ6xUH2tLr2tQ7B86_/s320/navicat8.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 2.ketik query nya seperti ini : INSERT into barang VALUES ('002','ASSUS ROG','LAPTOP',30)</div> <div class="separator" style="clear: both; text-align: left;"> 3.kalo sudah klik tombol RUN yang warna hijau </div> <div class="separator" style="clear: both; text-align: left;"> 4.dan hasilnya seperti gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHyfc-4-yzGiL0A70U1oIwizRFFHIR1cQPqGR151MlaQ-tIqT-anJbC85ifZPR84cuLqeouWexyXh9BOyeKC8eIB-j1MSg6l6Lm1yaJCre8RbBtjUD3Blbi5z-WFVBDH8KVfo9uA4nHN26/s1600/hasilquery1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHyfc-4-yzGiL0A70U1oIwizRFFHIR1cQPqGR151MlaQ-tIqT-anJbC85ifZPR84cuLqeouWexyXh9BOyeKC8eIB-j1MSg6l6Lm1yaJCre8RbBtjUD3Blbi5z-WFVBDH8KVfo9uA4nHN26/s320/hasilquery1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 5.berhasil dan sudah jadi isi dari tabel tersebut ... untuk mengeceknya kawan tinggal klik menu TABLE pada navicat hasilnya seperti digambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgvK__Ltk8ldYiMsKekH4MrPb1W_7d87e3t0f6DFfgvHAb_SS4dL7u6aZN4NpcAJ28PT19ytpMAD-rpatijxQzUYaFUVD7i3dsZa3pS23VVre1BF0HF2DO6a4QIoEjr_7HbNXsnssSAADD/s1600/tabel7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgvK__Ltk8ldYiMsKekH4MrPb1W_7d87e3t0f6DFfgvHAb_SS4dL7u6aZN4NpcAJ28PT19ytpMAD-rpatijxQzUYaFUVD7i3dsZa3pS23VVre1BF0HF2DO6a4QIoEjr_7HbNXsnssSAADD/s320/tabel7.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 6.lalu klik 2 kali pada tabel barang tersebut ... hasil tampilannya seperti gambar dibah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi73xP7QS-E-9_K6jfuZOxqRCSo8Mt00_YgPUw91nhianHJyQbdYc4fpoaB_4wRWoWNQi9gdNCX69-yyQFcg4hh5erwqh0t-Pnn0PdN5yiSBmIiShiNhRFxEpkBqP5lKM_DMsLwb9nOOOjz/s1600/hasilquery2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi73xP7QS-E-9_K6jfuZOxqRCSo8Mt00_YgPUw91nhianHJyQbdYc4fpoaB_4wRWoWNQi9gdNCX69-yyQFcg4hh5erwqh0t-Pnn0PdN5yiSBmIiShiNhRFxEpkBqP5lKM_DMsLwb9nOOOjz/s320/hasilquery2.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> dan berhasil ... :D sudah ada isinya tuh pada tabel barang...</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Create : Abednego,S.T </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> </div> </p>

Gambar ini adalah hasil dari tutorial dibawah ini oke kita lanjutkan Tutorial Membuat Database Dengan Navicat Part 2 yang sebel...

Tutorial Membuat Database Dengan Navicat Part 2

<p><div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8_TdJLbAs_db0013-1d33LTyVXO5elENKVjtJ6m9rLpHM2CeOWAVxQF-0JM_QIeqopp4k_s9kLQJ3xrGT817HJoMH-UJUdtXy1tQLGTYqjRHqbix6w0FjV_2gkeLAkaXs7Jt0Bc9K23Bn/s1600/nav1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8_TdJLbAs_db0013-1d33LTyVXO5elENKVjtJ6m9rLpHM2CeOWAVxQF-0JM_QIeqopp4k_s9kLQJ3xrGT817HJoMH-UJUdtXy1tQLGTYqjRHqbix6w0FjV_2gkeLAkaXs7Jt0Bc9K23Bn/s320/nav1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar ini adalah hasil dari tutorial dibawah ini</div> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> Tulisan sebelum nya tentang <a href="http://meta-aksara.blogspot.co.id/2017/05/tutorial-membuat-database-dengan-navicat.html" target="_blank">Tutorial Membuat Database Dengan Navicat Part 1</a> adalah cara membuat database... nah kali ini saya akan menjelaskan cara membuat tabel dengan navicat...<br /> saya akan memakai database yang sudah dibuat pada tutorial sebelumnya yahhh....ok langsung aja kita buat tabelnya... :D tahapannya sebgai berikut :<br /> <br /> 1.buka navicatnya ..<br /> 2.lihat pada kiri atas .. disitu ada nama database yang pernah kita buat sebelumnya<br /> 3.klik 2 kali pada database nya.... nanti muncul tampilan gambar dibawah ini :<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6V5snEl6-QSi4Be_v4_CgJGZ8H2GDLJUDKCXwL0s7cvRp4Ehnw2QjyttdEDwCfRwENwNrxN91AH_PVIQS6DuB-Hi_IzvroDgUB9ajyAFdsoT6fk1_CmXyxceGE7h8zk0wINp18RBSw0i8/s1600/tabel1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6V5snEl6-QSi4Be_v4_CgJGZ8H2GDLJUDKCXwL0s7cvRp4Ehnw2QjyttdEDwCfRwENwNrxN91AH_PVIQS6DuB-Hi_IzvroDgUB9ajyAFdsoT6fk1_CmXyxceGE7h8zk0wINp18RBSw0i8/s1600/tabel1.jpg" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 4.nah disitu nama databasenya adalah "abcde" yang sebelumnya kita buat pada tutorial pertama</div> <div class="separator" style="clear: both; text-align: left;"> 5.setelah itu ada menu Queries pada database "abcde" tersebut silakan kalian pilih dan klik kanan Queriesnya dan klik NEW QUERY seperti gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPqf7V7ADgfnk8-XE9pj9GAnJsLaN_5R2gD18Zlfg4wN80ndcXdMWgejEXBxTGqYeIxfENOJC9iTvVLEY9FGQM8g0fAKF_HnfSgY5ft5kwpd5NJrWPh9MlSChICsccYb0w7LkIku_qZAMt/s1600/tabel2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPqf7V7ADgfnk8-XE9pj9GAnJsLaN_5R2gD18Zlfg4wN80ndcXdMWgejEXBxTGqYeIxfENOJC9iTvVLEY9FGQM8g0fAKF_HnfSgY5ft5kwpd5NJrWPh9MlSChICsccYb0w7LkIku_qZAMt/s320/tabel2.jpg" width="261" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 6.setelah klik NEW QUERY tampilan dilayar navicat akan seperti ini : </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7y9bbJ4Fu_stLRQGC6wgPS30XnlfiMiDUB6XHBQ8Bf7GiL3omznVIWdN-g2mXm-9m0LT45jLL5pQLNy4DrIUuNiF_6vElYxsxC2Bj2nhxXTocN9UAGjFCCVKO5lz_4yuVz1F6iq6-LjG1/s1600/tabel3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="163" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7y9bbJ4Fu_stLRQGC6wgPS30XnlfiMiDUB6XHBQ8Bf7GiL3omznVIWdN-g2mXm-9m0LT45jLL5pQLNy4DrIUuNiF_6vElYxsxC2Bj2nhxXTocN9UAGjFCCVKO5lz_4yuVz1F6iq6-LjG1/s320/tabel3.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 7.setelah itu kalian baru deh membuat tabel pada QUERY EDITOR ... nah silakan kalian ketik query yang saya buat di dalam layar QUERY EDITOR seperti gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPuRWr9NI7Va8sjajzk4ACzCulkhZfgbTv0-ez5gOhtDOENvBlHMfqAXKUznfd88Z6XsaS1WscOtOgOIgB2revN8esgwtbZ1fwKmQ7RVJe1rAWEg98nSAYFl6Ees5pyZL0K3hag9ZPGd7i/s1600/tabel4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="309" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPuRWr9NI7Va8sjajzk4ACzCulkhZfgbTv0-ez5gOhtDOENvBlHMfqAXKUznfd88Z6XsaS1WscOtOgOIgB2revN8esgwtbZ1fwKmQ7RVJe1rAWEg98nSAYFl6Ees5pyZL0K3hag9ZPGd7i/s320/tabel4.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 8.nah kalo sudah diketik query nya silakan pencet tombol warna hijau yang tulisannya RUN  diatas menu query editor</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 9.apabila sudah di RUN ... akan menghasilkan tampilan seperti ini : </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfDXL2OOY29WgJGl35bGnPeGc9L66rSle3jxRwo6IPldpk0L3fUEPRyCLgGh85Squ5AKBG2PVHECvWzkJvYg5YJPf7oGBaOvCRJTmZVQx8mTJ5YBox67lfrIvEeo6_1ql_VufhBw4Q-gmg/s1600/tabel5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfDXL2OOY29WgJGl35bGnPeGc9L66rSle3jxRwo6IPldpk0L3fUEPRyCLgGh85Squ5AKBG2PVHECvWzkJvYg5YJPf7oGBaOvCRJTmZVQx8mTJ5YBox67lfrIvEeo6_1ql_VufhBw4Q-gmg/s320/tabel5.jpg" width="206" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 10.nah berhasil deh membuat tabel nya.. mudahkan .. :D</div> <div class="separator" style="clear: both; text-align: left;"> 11.untuk mengecek tabelnya kalian silakan pilih dan klik menu TABLE pada navicat lihat gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgou5PosF8Ni3OlFGU82E0I_sdgZuBPcfmLnuBg2olMc3KYRuSkRpOpuRelMA-beNipy6bCVEr2VTjh8DnkCYh1u1FJ8wBJtGSHtvIM7u3_lz7iu0YmiXEBpq4LzjCwmhh6Dt1E_A3pF235/s1600/tabel6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgou5PosF8Ni3OlFGU82E0I_sdgZuBPcfmLnuBg2olMc3KYRuSkRpOpuRelMA-beNipy6bCVEr2VTjh8DnkCYh1u1FJ8wBJtGSHtvIM7u3_lz7iu0YmiXEBpq4LzjCwmhh6Dt1E_A3pF235/s1600/tabel6.jpg" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 12.setelah diklik akan menghasilkan tampilan layar berikut :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLJBBQgB7WycPBygWLHBODDvYLVtUvLphsR-L5FCn4GZ2oSBJ7QRTsf_Q0ZUkX_qY_hDPxXFrYzjmcUiCEFf8ApV9OFyqQKwyYOTgKOdGGytqbWTTFWAPZuiOY5RITO0qEHYLqtnyvgiiU/s1600/tabel7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLJBBQgB7WycPBygWLHBODDvYLVtUvLphsR-L5FCn4GZ2oSBJ7QRTsf_Q0ZUkX_qY_hDPxXFrYzjmcUiCEFf8ApV9OFyqQKwyYOTgKOdGGytqbWTTFWAPZuiOY5RITO0qEHYLqtnyvgiiU/s320/tabel7.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 13.jreng... jreng... hahaahaha... berhasil deh ada tabel barang nya yang tadi kalian buat ... :D</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> demikian cara / Tutorial Membuat Database Dengan Navicat Part 2 nantikan tutorial part 3 nya yahhh.. :D</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Create : Abednego,S.T </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <br /></p>

Gambar ini adalah hasil dari tutorial dibawah ini Tulisan sebelum nya tentang  Tutorial Membuat Database Dengan Navicat Part 1  a...

Aplikasi Hitung Bunga Saldo Dengan Delphi 7

<p><div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5zJhyN8RYxuIuAGi9oaYdUR96t_kgAL0D4qlCTsHdCF3tE2TBQwphgUE30BOpt70j7X2gDtfPX5-Vn4aELJZxQ3XVfNKaYavOAvGBmPs0HaAaTM9VmcRtXRvZcGLuK58TKF52PT9HaZq4/s1600/hasilapp2.pg.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="137" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5zJhyN8RYxuIuAGi9oaYdUR96t_kgAL0D4qlCTsHdCF3tE2TBQwphgUE30BOpt70j7X2gDtfPX5-Vn4aELJZxQ3XVfNKaYavOAvGBmPs0HaAaTM9VmcRtXRvZcGLuK58TKF52PT9HaZq4/s320/hasilapp2.pg.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar ini adalah hasil dari tutorial dibawah ini</div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Yoi... ketemu lagi dengan tutorial blog saya.. hehehe.. ok langsung aja.. kali ini saya akan berbagi </div> <div class="separator" style="clear: both; text-align: left;"> ilmu kepada kawan melalui aplikasi ini ... :D nih liat gambat dibawah ini : </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitCUBhYp-bP-JJ8LAGKyE0HFslKSGtExGyEHFKTI-0G2F6-iiZfeNB2OkSH-bwUhDUWPN8oAZTwjLtAjTRdnBM5bNvoAdPcvYhhrbcHAVt6kmFp39Awmk5H3aRFqGE7bOqsWO0avN3CaFf/s1600/aplikasi2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitCUBhYp-bP-JJ8LAGKyE0HFslKSGtExGyEHFKTI-0G2F6-iiZfeNB2OkSH-bwUhDUWPN8oAZTwjLtAjTRdnBM5bNvoAdPcvYhhrbcHAVt6kmFp39Awmk5H3aRFqGE7bOqsWO0avN3CaFf/s320/aplikasi2.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Silakan Design dulu ya form nya biar rapih dikit .. :D</div> <div class="separator" style="clear: both; text-align: left;"> nah... gambar diatas saya pakai 4 COMPONENT </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 1.LABEL</div> <div class="separator" style="clear: both; text-align: left;"> 2.EDIT</div> <div class="separator" style="clear: both; text-align: left;"> 3.COMBOBOX</div> <div class="separator" style="clear: both; text-align: left;"> 4.MEMO</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Untuk COMBOBOX silakan kalian cari ITEM (STRING) pada PROPERTIES di OBJECT INSPETOR</div> <div class="separator" style="clear: both; text-align: left;"> setelah itu silakan isi ITEM (STRING) nya dari angka 1 sampai 12 bila sudah...</div> <div class="separator" style="clear: both; text-align: left;"> silakan klik 2 kali pada BUTTON ... dan silakan ketik koding nya seperti dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both;"> procedure TForm1.Button1Click(Sender: TObject);</div> <div class="separator" style="clear: both;"> var</div> <div class="separator" style="clear: both;"> saldo:currency;</div> <div class="separator" style="clear: both;"> bunga,i,bulan:integer;</div> <div class="separator" style="clear: both;"> begin</div> <div class="separator" style="clear: both;">      if TryStrToCurr(Edit1.Text,saldo) and TryStrToint(Edit2.Text,bunga) and TryStrToInt(ComboBox1.Text,bulan) then</div> <div class="separator" style="clear: both;">      begin</div> <div class="separator" style="clear: both;">           for i:=1 to bulan do</div> <div class="separator" style="clear: both;">           begin</div> <div class="separator" style="clear: both;">                saldo:=saldo+(saldo*(bunga/100)*bulan);</div> <div class="separator" style="clear: both;">                Memo1.LineS.Add('saldo bulan ke'+inttostr(i)+' = Rp.'+CurrToStrF(saldo,ffnumber,2));</div> <div class="separator" style="clear: both;">            end;</div> <div class="separator" style="clear: both;">      end;</div> <div class="separator" style="clear: both;"> end;</div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> nah beres deh aplikasinya.. :D tinggal pencet F9 ... </div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> <br /></div> <div class="separator" style="clear: both;"> Create : Abednego,S.T</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <br /></p>

Gambar ini adalah hasil dari tutorial dibawah ini Yoi... ketemu lagi dengan tutorial blog saya.. hehehe.. ok langsung aja.. kal...

Aplikasi Kelipatan 3 Dengan Delphi 7

<p><div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEismeHGB1gF82QKhKrpm17e3XMvpCVvNymcDh9jM2yRNJNHChbG_uNqpW96mkflGpASrIEMWnNEvX0MrviZfEN3YkYEwJmXqwO0iTTVOtVu20_ULhSbYxSqKllzROjMyOkID_9cPulWK-du/s1600/hasilapp.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEismeHGB1gF82QKhKrpm17e3XMvpCVvNymcDh9jM2yRNJNHChbG_uNqpW96mkflGpASrIEMWnNEvX0MrviZfEN3YkYEwJmXqwO0iTTVOtVu20_ULhSbYxSqKllzROjMyOkID_9cPulWK-du/s1600/hasilapp.jpg" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar ini adalah hasil dari tutorial dibawah ini</div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Tutorial pada saat ini saya akan membagikan sedikit logika dalam pemograman untuk itu perhatikan gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggZu4C5Fo0YzOc3mnlGXmXuFTamZax-9N8xYXnaMi02l6PATs77p-DiVxscZJvexJhjLqNCkZGX8uBn-UDUPIaL5va8doMISvsWDnpDu_igUSswg5UzRi3Yz9shsalB42BpqByRrhfXO_6/s1600/aplikasi1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggZu4C5Fo0YzOc3mnlGXmXuFTamZax-9N8xYXnaMi02l6PATs77p-DiVxscZJvexJhjLqNCkZGX8uBn-UDUPIaL5va8doMISvsWDnpDu_igUSswg5UzRi3Yz9shsalB42BpqByRrhfXO_6/s1600/aplikasi1.jpg" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> pada gambar diatas saya menggunakan 3 LABEL , 1 EDIT dan 1 BUTTON , silakan design dulu ya .. :D</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> LABEL 1 = KELIPATAN 3</div> <div class="separator" style="clear: both; text-align: left;"> LABEL 2 = HASIL</div> <div class="separator" style="clear: both; text-align: left;"> LABEL 3= KOSONGKAN </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> nah pada BUTTON silakan klik 2 kali dan ketik koding dibawah ini : </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both;"> procedure TForm1.Button1Click(Sender: TObject);</div> <div class="separator" style="clear: both;"> var</div> <div class="separator" style="clear: both;">     n1:integer;</div> <div class="separator" style="clear: both;">    hasil:boolean;</div> <div class="separator" style="clear: both;"> begin</div> <div class="separator" style="clear: both;">      if TryStrToInt(Edit1.Text,n1) then</div> <div class="separator" style="clear: both;">        hasil:=kelipatan3(n1);</div> <div class="separator" style="clear: both;">      if hasil = true then</div> <div class="separator" style="clear: both;">        Label3.Caption:='Benar atau Salah..? : Benar'</div> <div class="separator" style="clear: both;">      else</div> <div class="separator" style="clear: both;">          Label3.Caption:='Benar atau Salah..? : Salah';</div> <div class="separator" style="clear: both;"> end;</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> apabila sudah diketik koding nya silakan pencet F9 untuk menjalankan aplikasinya</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Create : Abednego,S.T</div> <br /></p>

Gambar ini adalah hasil dari tutorial dibawah ini Tutorial pada saat ini saya akan membagikan sedikit logika dalam pemograman unt...

Aplikasi Iventory Sederhana Versi Setup / Instalan

<p><div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZY6YlWrb5siH_xy13jrTL5xAfG6Y4rRZwsuKWhPpblVKk7K-E-QhE2qXNPfB4A98xSgfv8xMJuijMvEEujS5DhtPJ-07ruYYu6JTX3EdwZRVYvgeM3q-8Py67poe03tUfyS7dbzpF8itp/s1600/iventory.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="61" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZY6YlWrb5siH_xy13jrTL5xAfG6Y4rRZwsuKWhPpblVKk7K-E-QhE2qXNPfB4A98xSgfv8xMJuijMvEEujS5DhtPJ-07ruYYu6JTX3EdwZRVYvgeM3q-8Py67poe03tUfyS7dbzpF8itp/s320/iventory.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar ini adalah hasil dari tutorial dibawah ini</div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Kali ini saya akan memberikan hasil aplikasi yang sudah saya buat supaya kalian bisa mempelajarinya hehehe.... silakan download disini => <a href="https://drive.google.com/file/d/0B_f1GrxyPvdXbExVa1FCdEhNUkE/view?usp=sharing" target="_blank">Aplikasi Iventory</a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> bila ada pertanyaan silakan koment ya.. :D</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Create : Abednego,S.T</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <br /></p>

Gambar ini adalah hasil dari tutorial dibawah ini Kali ini saya akan memberikan hasil aplikasi yang sudah saya buat supaya kalian...

Soal UKK (SMK DHARMA BHAKTI INDONESIA - BATUJAJAR)

<p><div align="center" class="MsoNormal" style="text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfP5Y8ZI9Job6PjQHfFtceUk36pCq4df5e4qD6jzOBANhsN8nuwA3kUoL9c805y4fwXZgUIUoGdO8xPHaYt6x4LulEIFR2d20mMTE54uwljVZa1VTaEOw6rFYDidFMBEzPZ4Z02zs0JmQl/s1600/delph71.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfP5Y8ZI9Job6PjQHfFtceUk36pCq4df5e4qD6jzOBANhsN8nuwA3kUoL9c805y4fwXZgUIUoGdO8xPHaYt6x4LulEIFR2d20mMTE54uwljVZa1VTaEOw6rFYDidFMBEzPZ4Z02zs0JmQl/s320/delph71.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Untuk lebih jelas lihat soalnya silakan klik pada gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div style="text-align: center;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjnzFxLaVNqedoJQsrF2ZE-2e_YoF5htY7RKXx8PsHOj_AGJ7JzfKpOng-J_2oGTM6EVp8MaED_SOmEm2JSaEw9pQldE4qcFvvOSeHL6LX8SSP45_nrXTZ3vroV9hcfg-4RYIgkbWok1m7/s1600/soal1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="278" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjnzFxLaVNqedoJQsrF2ZE-2e_YoF5htY7RKXx8PsHOj_AGJ7JzfKpOng-J_2oGTM6EVp8MaED_SOmEm2JSaEw9pQldE4qcFvvOSeHL6LX8SSP45_nrXTZ3vroV9hcfg-4RYIgkbWok1m7/s320/soal1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Selamat Mengerjakan.. :D</div> <br /></div> <div style="text-align: left;"> <span style="text-align: justify;"><br /></span></div> <div style="text-align: left;"> <span style="text-align: justify;">Create : Abednego.S.T</span></div> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> </p>

Untuk lebih jelas lihat soalnya silakan klik pada gambar dibawah ini : Selamat Mengerjakan.. :D Create : Abednego.S.T ...

Alur Proses Data Absensi Siswa dan Staf Sekolah

<p><div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div style="text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUMyVshRWI5bPryXpEWb6wSagV75Bsm1De8_DusEQxDs3-4wCYwZZgQ3-oIekeUtECyQQn0trYNGiczT4qdBt836xggiDvynTp92t7WnnLn9FDYPmFEtRH2efQN1r_c2Yt7vqFSo5eVAnJ/s1600/alur+data+absensi+sekolah.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUMyVshRWI5bPryXpEWb6wSagV75Bsm1De8_DusEQxDs3-4wCYwZZgQ3-oIekeUtECyQQn0trYNGiczT4qdBt836xggiDvynTp92t7WnnLn9FDYPmFEtRH2efQN1r_c2Yt7vqFSo5eVAnJ/s320/alur+data+absensi+sekolah.jpg" width="281" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="" style="clear: both; text-align: left;"> Teknology semakin berkembang dan sangat cepat .. nah pada kali ini saya akan memberikan alur data proses absensi di kalangan sekolah SD,SMP dan SMK/A , Diagram adalah design yang sangat penting dalam membuat suatu aplikasi .... ok nih lihat gambar dibawah ini biar jelas .. :D</div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> pada gambar diatas menunjukan bahwa aplikasi absensi berbasis fringer print sudah support SMS kepada orang tua.. tujuan nya adalah untuk memantau anak dari orang tua supaya terlihat jelas bahwa anka tersebut dateng kesekolah atau tidak... heheehe :D</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Create : Abednego,S.T</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <br /></p>

Teknology semakin berkembang dan sangat cepat .. nah pada kali ini saya akan memberikan alur data proses absensi di kalangan sekola...

Tutorial Membuat Database Dengan Navicat Part 1

<p><div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqwfGeevWL7uEbf-48pH2dJ2wDmuWJ4QEdnIAJoCQ76B6p1MDZfWdmElbC0UhyphenhyphenGfvgt_G-W4-inUYfz5MQZbzO_o82SpeMn3SPBMg6TlZWmGoGX-y1_nJSV19g_FtC89onElyqNYH5qDm3/s320/navicat11.jpg" /></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> Gambar ini adalah hasil dari tutorial dibawah ini</div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> Yoi..... kawan sekarang saya akan memberikan tutorial cara membuat database dengan aplikasi NAVICAT .... kalo yang belum punya aplikasi navicat nya bisa di download <a href="https://www.navicat.com/download" target="_blank">disi<span id="goog_1459880830"></span><span id="goog_1459880831"></span>ni</a><br /> <br /> ok langsung bahas aja ya... biar ga banyak basa - basi... hahah.... apabila udah di instal aplikasinya hasilnya seperti gambar dibawah ini :<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRewDaBDsJ2UaL_MYQl3Gg30mpvEYEYOdeXngbSaSu7A6VfZQagYeSa1M7z-diujysKdWauuIuQc7ftRYEdAonkUQWmVQYi4JghKZDRA7vCPtNQhaoMm7bwSHW3yjUI1C-b3ghn9VK7Kyw/s1600/navicat1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRewDaBDsJ2UaL_MYQl3Gg30mpvEYEYOdeXngbSaSu7A6VfZQagYeSa1M7z-diujysKdWauuIuQc7ftRYEdAonkUQWmVQYi4JghKZDRA7vCPtNQhaoMm7bwSHW3yjUI1C-b3ghn9VK7Kyw/s320/navicat1.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Untuk membuat koneksi database kita harus membuat antar koneksi dengan aplikasi navicat</div> <div class="separator" style="clear: both; text-align: left;"> berikut tahapannya :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 1.klik pada menu connection pada disamping atas dan pilih MYSQL seperti gambar dibawah :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTJnTyqX-0rV7bF62qY2rsxDKesmgRNex8t4lr8Eu-3SohpkZ3RlyeLI8IBtMna9rwF3zjPWGRUFgf_YhPZp4yKuwtCotDJV99bW49f1lhE5hO0XklbtqqJQeXTYP9anURxRRUuDlliwx/s1600/navicat2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTJnTyqX-0rV7bF62qY2rsxDKesmgRNex8t4lr8Eu-3SohpkZ3RlyeLI8IBtMna9rwF3zjPWGRUFgf_YhPZp4yKuwtCotDJV99bW49f1lhE5hO0XklbtqqJQeXTYP9anURxRRUuDlliwx/s1600/navicat2.jpg" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 2.Apabila sudah di klik MYSQL nya akan muncul tampilan dibawah ini  dan silakan kalian isi sesuai gambar yang saya buat</div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8BLe2kYKtVFxL0HVL-YSNVwjUzoM4YkZ9ZHych-WZ99m0ZDYX1RPXdJpKzNOKTmTn9sINDaUa7gSTcgJyn6f-jLP0yi9Vx3_13MnjeCkbt7uH2U4GMzxsSDZJOcXoIPmjlT3JSrfaObv7/s1600/navicat3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8BLe2kYKtVFxL0HVL-YSNVwjUzoM4YkZ9ZHych-WZ99m0ZDYX1RPXdJpKzNOKTmTn9sINDaUa7gSTcgJyn6f-jLP0yi9Vx3_13MnjeCkbt7uH2U4GMzxsSDZJOcXoIPmjlT3JSrfaObv7/s320/navicat3.jpg" width="286" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 3.Apabila sudah diisi pencet tombol Test Connection hasilnya seperti dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNKubIYZ2Nc-cEy4XHvw4FSV37TAq0ySqWNNEMATrZ0B8nibV1TMZBw7IBwz8CR1nFa6xh87GNPhSi9ghBjMzn5r1Z4HJrI4xpv72IYJrdruL6EGaRNc_bqDphsW37w1KJMuehY9k4GblW/s1600/navicat4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNKubIYZ2Nc-cEy4XHvw4FSV37TAq0ySqWNNEMATrZ0B8nibV1TMZBw7IBwz8CR1nFa6xh87GNPhSi9ghBjMzn5r1Z4HJrI4xpv72IYJrdruL6EGaRNc_bqDphsW37w1KJMuehY9k4GblW/s320/navicat4.jpg" width="281" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 4.Setelah itu tekan tombol OK...</div> <div class="separator" style="clear: both; text-align: left;"> 5.Hasilnya seperti gambar dibawah ini hehe... udah berhasil tuh membuat koneksinya</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlhSVQGySovt35JmtD5uys576NT1-_mvl3DcD5IyFC8oFu1E13HDQok5hNE7xksNfuzVGlwNaXVRmHfbHr_8YpI8e9YafnUL4H6oTsFTVbD5NYWq2ln2SHOvLYU6JjCe3u3afroARLqyUs/s1600/navicat5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlhSVQGySovt35JmtD5uys576NT1-_mvl3DcD5IyFC8oFu1E13HDQok5hNE7xksNfuzVGlwNaXVRmHfbHr_8YpI8e9YafnUL4H6oTsFTVbD5NYWq2ln2SHOvLYU6JjCe3u3afroARLqyUs/s1600/navicat5.jpg" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 6.Nah... sekarang tinggal membuat databasenya..</div> <div class="separator" style="clear: both; text-align: left;"> 7.Setelah itu klik kanan pada koneksi database tersebut seperti gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5DM1IbEMqaigZEei__xYq3oI_uyT4s_auKU1lEikwhQ_9fCkamIMiD24z2jqwHdeblUlctDOVYHVLhD1mCxX57DpmGLDCVS1vKPN2pZ4rZ_oedwk8hSYd0D1jYp-N6XHnDp8124_Fi3cB/s1600/navicat6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5DM1IbEMqaigZEei__xYq3oI_uyT4s_auKU1lEikwhQ_9fCkamIMiD24z2jqwHdeblUlctDOVYHVLhD1mCxX57DpmGLDCVS1vKPN2pZ4rZ_oedwk8hSYd0D1jYp-N6XHnDp8124_Fi3cB/s320/navicat6.jpg" width="190" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 8.Pilih Open Connection dan klik </div> <div class="separator" style="clear: both; text-align: left;"> 9.nah statusnya sekarang udah terbuka koneksinya</div> <div class="separator" style="clear: both; text-align: left;"> 10.Habis itu silakan cari tombol QUERY dan klik nanti akan ada cara menambahkan QUERY untuk membuat databasenya perhatikan gambar berikut :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgez1oqB_laTHAIZ6FshOaEJC4pXQH5FUvRA0rq1o06WHyI6AVzqHtJKTXHgOLgE6xY3E-8mvH-WefYh3nRG4tfE2OtfTtcYDXeX-TaEx9Tymf2_KYN73mb9F15Jbsu7mD8Y9OauSFwrc2X/s1600/navicat7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="100" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgez1oqB_laTHAIZ6FshOaEJC4pXQH5FUvRA0rq1o06WHyI6AVzqHtJKTXHgOLgE6xY3E-8mvH-WefYh3nRG4tfE2OtfTtcYDXeX-TaEx9Tymf2_KYN73mb9F15Jbsu7mD8Y9OauSFwrc2X/s320/navicat7.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 11.klik NEW QUERY nya nanti akan muncul tampilan editor QUERY seperti gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg64tNPfUjZTappVu1cyqVcaox1adGUmYUfqTRnNcqPcU9X7v_QTl8kSIHFBYZOFTzgmqNbvgJ1wSt8odZEbGBpIdhtxIYn3JbVa2w6_PJz3cYsUp4KxOCztLgGM85-sTFqByupYoNq6R1G/s1600/navicat8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg64tNPfUjZTappVu1cyqVcaox1adGUmYUfqTRnNcqPcU9X7v_QTl8kSIHFBYZOFTzgmqNbvgJ1wSt8odZEbGBpIdhtxIYn3JbVa2w6_PJz3cYsUp4KxOCztLgGM85-sTFqByupYoNq6R1G/s320/navicat8.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 12.Udah samakan tampilannya... sekarang tinggal ketik QUERY nya lihat gambar dibawah ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXzyeRI6YyeFJD5asYxFEOc-HQp0O5Cat96IIDGe7YCQuToqUAlfQJjR8-tGXohnTMLYXqYqW_Y2RsROchGHNinCbu95ct_qnpEMlt3tY31lP60vWkj2v114Re3_7znj3UklzAe10pAkVV/s1600/navicat9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXzyeRI6YyeFJD5asYxFEOc-HQp0O5Cat96IIDGe7YCQuToqUAlfQJjR8-tGXohnTMLYXqYqW_Y2RsROchGHNinCbu95ct_qnpEMlt3tY31lP60vWkj2v114Re3_7znj3UklzAe10pAkVV/s320/navicat9.jpg" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 13.Jika sudah diketik querynya habis itu klik tombol RUN yang warna hijau diatas query editor</div> <div class="separator" style="clear: both; text-align: left;"> 14.Apabila sudah di klik hasilnya seperti ini :</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEgrD7L7sgCL368kqiwRCAIm-7gpauON19W4k7mfZ3Za2HmrWmYRknx5yia-yoNCuREwQsf0oW6vAa7YTNbHE2UrVQYQZhVP_BsuX81GjfjEbxWp90VTzyHEGsH3Kz06yW1VU5T8fhyBNH/s1600/navicat10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEgrD7L7sgCL368kqiwRCAIm-7gpauON19W4k7mfZ3Za2HmrWmYRknx5yia-yoNCuREwQsf0oW6vAa7YTNbHE2UrVQYQZhVP_BsuX81GjfjEbxWp90VTzyHEGsH3Kz06yW1VU5T8fhyBNH/s320/navicat10.jpg" width="311" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 15.Ok berhasil buat databasenya ... </div> <div class="separator" style="clear: both; text-align: left;"> 16.Bila ingin melihat databasenya klik kanan koneksi databasenya trus cari REFRESH </div> <div class="separator" style="clear: both; text-align: left;"> 17.</div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqwfGeevWL7uEbf-48pH2dJ2wDmuWJ4QEdnIAJoCQ76B6p1MDZfWdmElbC0UhyphenhyphenGfvgt_G-W4-inUYfz5MQZbzO_o82SpeMn3SPBMg6TlZWmGoGX-y1_nJSV19g_FtC89onElyqNYH5qDm3/s1600/navicat11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqwfGeevWL7uEbf-48pH2dJ2wDmuWJ4QEdnIAJoCQ76B6p1MDZfWdmElbC0UhyphenhyphenGfvgt_G-W4-inUYfz5MQZbzO_o82SpeMn3SPBMg6TlZWmGoGX-y1_nJSV19g_FtC89onElyqNYH5qDm3/s320/navicat11.jpg" width="215" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> 18.Silakan lihat pada list database koneksi  kawan....</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> *Untuk tutorial selanjutkan tentang cara membuat tabel dengan QUERY.... see u ... </div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> Create : Abednego,S.T</div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <br /></p>

Gambar ini adalah hasil dari tutorial dibawah ini Yoi..... kawan sekarang saya akan memberikan tutorial cara membuat database deng...