tag:blogger.com,1999:blog-55676507624211497182024-02-20T02:24:53.563-08:00TEKNIK INFORMATIKAAnonymoushttp://www.blogger.com/profile/11498409131454238174noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5567650762421149718.post-23150094232983858572016-12-30T00:03:00.004-08:002016-12-30T00:03:58.767-08:00Cara Membuat Aplikasi CRUD Menggunakan Database Berbasis WebAssalamualaikum Wr Wb,,<br /><br />Kali ini saya akan menjelaskan cara membuar aplikasi CRUD, okk langsung aja untuk pembuatan aplikasi crud berbasis web.<br /><br /><br />1. Langkah pertama, buatlah dulu databasenya, dan simpan dengan nama crud, berikut codinganya<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7Tt94SAEExxN0rf4iinGNP6lIV3Rx5uDo1SAGhoDvaj_lYHNNy-pkA3mdh3DAfU_m3b0Tpr9mpN3iBm4eaN7Oy7vbiSjEv0A6MsbVm6bsn5mZ3ig-97k_SPs2gPJTLfbkcw9F1lbqNAk/s1600/db.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7Tt94SAEExxN0rf4iinGNP6lIV3Rx5uDo1SAGhoDvaj_lYHNNy-pkA3mdh3DAfU_m3b0Tpr9mpN3iBm4eaN7Oy7vbiSjEv0A6MsbVm6bsn5mZ3ig-97k_SPs2gPJTLfbkcw9F1lbqNAk/s640/db.PNG" width="640" /></a></div>
<br />
2. yang ke dua buatlah file dengan nama index.php<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLk5pbRwokYUdSgRX9ERFe_va4fWTjPBlaj6BR5HRfoKY1lORZbaXLROciAh95-XRdn4AzQz_HBjweCuR7FhPbK3HD4BWh14KyQ04GmMLv0_6WAsJ34pBLk8n9UqhvMYVVH7tbATQcs90/s1600/index.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="358" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLk5pbRwokYUdSgRX9ERFe_va4fWTjPBlaj6BR5HRfoKY1lORZbaXLROciAh95-XRdn4AzQz_HBjweCuR7FhPbK3HD4BWh14KyQ04GmMLv0_6WAsJ34pBLk8n9UqhvMYVVH7tbATQcs90/s640/index.png" width="640" /></a></div>
<br />
3. yang ke tiga, buatlah file dengan nama config.php, untuk mengkoneksikan ke databasenya.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr0fu2ipNROOe3XwXn-XBRhxO8rf-fsaC6IJH1qOsCd4MyFeatlMTSIk4Zqjjik9LwvPyJOMJCcbGY_GmKLSEvdp4bXRCVZS15IAgtXQLKrNDQv0vRIjug_gzOxHSX3tkNLNJB-0YawjU/s1600/konfig.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="52" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr0fu2ipNROOe3XwXn-XBRhxO8rf-fsaC6IJH1qOsCd4MyFeatlMTSIk4Zqjjik9LwvPyJOMJCcbGY_GmKLSEvdp4bXRCVZS15IAgtXQLKrNDQv0vRIjug_gzOxHSX3tkNLNJB-0YawjU/s640/konfig.PNG" width="640" /></a></div>
<br />
4. yang ke empat buatlah file dengan nama tambah.php untuk menambahkan data atau create<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBYw7-P0NSVCXLH_d_dk-2viLT7dbGbe-1jA0cyJLewcjA8lPjlI2NUI0r85Hoqvrc6NvslMVIfFH2FnCuuA1WPt-HkyquPQLPpGz6G_aQbPPwH9lcgCniZ-Mg5dNofNCEooAb5cpTu8U/s1600/tambah+data1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="228" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBYw7-P0NSVCXLH_d_dk-2viLT7dbGbe-1jA0cyJLewcjA8lPjlI2NUI0r85Hoqvrc6NvslMVIfFH2FnCuuA1WPt-HkyquPQLPpGz6G_aQbPPwH9lcgCniZ-Mg5dNofNCEooAb5cpTu8U/s640/tambah+data1.PNG" width="640" /> </a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6ub9fCaTasPxbpV7vvYzs9gm7O_6eslsBGd3SfxGN-IX4V0hAZArVyH3-c7j3hQjxZeWEuSOHTok0Dy0xrlmpYL8EspBNm5fSQ1k31uFAk9dC15vE6FaZfs7rHROBenQdfkGIWItHly0/s1600/tambah+data2.PNG" imageanchor="1"><img border="0" height="288" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6ub9fCaTasPxbpV7vvYzs9gm7O_6eslsBGd3SfxGN-IX4V0hAZArVyH3-c7j3hQjxZeWEuSOHTok0Dy0xrlmpYL8EspBNm5fSQ1k31uFAk9dC15vE6FaZfs7rHROBenQdfkGIWItHly0/s320/tambah+data2.PNG" width="640" /></a></div>
<br />
5. buatlah file dengan nama tampil.php untuk menampilkan data<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG02up3Q0l5aUeLMKY30FQ3PzuBwB5vrdyLWfJVWDJc2WtixFEXTsGjkqTCNWFDCZlrLkn3S_oa2f7AjrFo8VYDbhmejeIeyMo0c1VBb73bAPocERaglZjyogD6bd5XwVB4KjCnMXazAo/s1600/tampil.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="278" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG02up3Q0l5aUeLMKY30FQ3PzuBwB5vrdyLWfJVWDJc2WtixFEXTsGjkqTCNWFDCZlrLkn3S_oa2f7AjrFo8VYDbhmejeIeyMo0c1VBb73bAPocERaglZjyogD6bd5XwVB4KjCnMXazAo/s640/tampil.PNG" width="640" /></a></div>
<br />
6. membuat file dengan nama edit.php yaitu untuk mengedit data yang sudah ada<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1ly4Vvo2BIqnYRx1j1jMk7S70niHCeVfz6GKQrMiiDlsjc2t06kCBOL2XRI6taKU2lpa3dwVcmMt4COsgCkszmHAMcqMMMebnq00E_MTWWUOOLt889-kdRfME9BoWz80Ej6BwYgL23pI/s1600/edit1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="276" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1ly4Vvo2BIqnYRx1j1jMk7S70niHCeVfz6GKQrMiiDlsjc2t06kCBOL2XRI6taKU2lpa3dwVcmMt4COsgCkszmHAMcqMMMebnq00E_MTWWUOOLt889-kdRfME9BoWz80Ej6BwYgL23pI/s640/edit1.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi30CFjsMt7WGbPjAFMBsqMtLUDApFpKLaFsD7lmyeueg57xDpu1RNpbsgQC0ARTO1zczgM3-P_4ZzROGuhqKbnEMfBo7OccKSQsp16f1aqfDitY2zVj6dxwBHTbVfzHQYrjxStPAByDxk/s1600/edit2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi30CFjsMt7WGbPjAFMBsqMtLUDApFpKLaFsD7lmyeueg57xDpu1RNpbsgQC0ARTO1zczgM3-P_4ZzROGuhqKbnEMfBo7OccKSQsp16f1aqfDitY2zVj6dxwBHTbVfzHQYrjxStPAByDxk/s640/edit2.PNG" width="640" /></a></div>
<br />
7. Buatlah file dengan nama hapus.php untuuk menghapus file yang sudah ada<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3sHdN968NYqOFCN4hhnY_UoWewpnKe3z_jHag6WKH3lTaux9EZ7Q_GwEABBDoltDEwveE2BKGQsXkbd-BUcGayI5vg1XwPxAY0jwK2I-jyTqaZYq7SMq3giFij5utyOHG_jPN8Zht53A/s1600/hapus.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="95" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3sHdN968NYqOFCN4hhnY_UoWewpnKe3z_jHag6WKH3lTaux9EZ7Q_GwEABBDoltDEwveE2BKGQsXkbd-BUcGayI5vg1XwPxAY0jwK2I-jyTqaZYq7SMq3giFij5utyOHG_jPN8Zht53A/s640/hapus.PNG" width="640" /></a></div>
<br />
Dan inilah ahsilnya...<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQwAl6EsAhlFRO0IZwjzPdQg3gyKe1U5f8bad2epRyGUcZZbgekRiP8m3_Yg8H2425roF1Mp_mNpErFI3LnV4AqoLZCfwZXgIwk1kkSCZtN3CKpgqF0EtjiDa0GKfJTfG0MjALcu_DL5Y/s1600/tambah+data+1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQwAl6EsAhlFRO0IZwjzPdQg3gyKe1U5f8bad2epRyGUcZZbgekRiP8m3_Yg8H2425roF1Mp_mNpErFI3LnV4AqoLZCfwZXgIwk1kkSCZtN3CKpgqF0EtjiDa0GKfJTfG0MjALcu_DL5Y/s640/tambah+data+1.PNG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbk4AgCzpwrWE2qGmRqbQoPOjvgxb-eK6a9i1Dz2VCikyt-bVz4vqkPdFpkMyCkUUQ-lXPVe-7byWdowinLxWo1XH4XOyZ6vPWBVzArP0iiW6SaBZBAmA4eF8989WRI64PPHVo6t0iRZA/s1600/tambah+data.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbk4AgCzpwrWE2qGmRqbQoPOjvgxb-eK6a9i1Dz2VCikyt-bVz4vqkPdFpkMyCkUUQ-lXPVe-7byWdowinLxWo1XH4XOyZ6vPWBVzArP0iiW6SaBZBAmA4eF8989WRI64PPHVo6t0iRZA/s640/tambah+data.PNG" width="640" /></a></div>
<br />
<br />
<br />inilah tutorial dari saya,,<br /><br />dan semoga bermanfaat..<br /><br />Wassalamualaikum Wr Wb....Anonymoushttp://www.blogger.com/profile/11498409131454238174noreply@blogger.com0tag:blogger.com,1999:blog-5567650762421149718.post-54540892076854882112016-10-25T00:47:00.000-07:002016-10-25T01:19:08.324-07:00CARA MEMBUAT CRUD OOP MENGGUNAKN PDO<h2 id="apaitupdo" style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">
Apa Itu PDO?</span></span></span></h2>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">PDO adalah singkatan dari PHP Data Object. PDO adalah extension di PHP yang digunakan untuk mengakses database. PDO menyediakan <i>data-access</i>
abstraction layer yang memungkinkan kita menggunakan fungsi yang sama
untuk berbagai jenis database. Jadi, anda tidak perlu kawatir tentang
database yang anda pakai entah itu MySQL, MSSQL, Postgresql, atau Oracle
fungsi yang anda pakai untuk mengambil atau memanipulasi database tetap
sama.</span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span></span></span>
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">Oke, setelah anda mengenal PDO sekarang kita bisa memulai untuk membuat aplikasi CRUD kita.</span></span></span></div>
<h2 id="step1membuatdatabase" style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">
Step 1: Membuat Database</span></span></span></h2>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">Langkah pertama yang perlu anda lakukan adalah membuat database yang akan digunakan, anda bisa membuatnya menggunakan <code>phpMyAdmin</code>. Database yang akan kita gunakan akan diberi nama <b>crud_oop</b></span></span></span></div>
<h2 id="step2membuattable" style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">
Step 2: Membuat Table</span></span></span></h2>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">Setelah membuat database, kita harus membuat table dengan nama <code>tbBiodata</code> dengan struktur seperti gambar berikut:</span></span></span></div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsZwGc9UcSRpdEs2c2PJWRZCPzOd_tjqlkEL96yLCIUMew7Tb0qxycN-aUrNdNdMVU6IBQ6a9YIYZCsAhWmbvUoc0MCVGX16KeNxA0Dy7OkNjAxH7AUPNTkporSMhKMHUm4Tt2T3Th310/s1600/1+database.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsZwGc9UcSRpdEs2c2PJWRZCPzOd_tjqlkEL96yLCIUMew7Tb0qxycN-aUrNdNdMVU6IBQ6a9YIYZCsAhWmbvUoc0MCVGX16KeNxA0Dy7OkNjAxH7AUPNTkporSMhKMHUm4Tt2T3Th310/s320/1+database.PNG" width="320" /></a></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span></span></span>
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;">Anda bisa membuat table dengan struktur tersebut dengan menjalankan peritah SQL berikut:</span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span>
<span style="color: white;"><b> <span style="color: red;">CREATE TABLE `mahasiswa` (<br /> `id` int(11) NOT NULL,<br /> `nim` varchar(20) NOT NULL,<br /> `nama` varchar(30) NOT NULL,<br /> `tempat_lahir` varchar(30) NOT NULL,<br /> `tanggal_lahir` date NOT NULL,<br /> `jenis_kelamin` enum('Laki-laki','Perempuan') NOT NULL,<br /> `agama` enum('Islam','Kristen','Katholik','Hindu','Budha','Konghuchu') NOT NULL,<br /> `alamat` varchar(100) NOT NULL,<br /> `no_telepon` varchar(12) NOT NULL<br />) ENGINE=InnoDB DEFAULT CHARSET=latin1;</span></b></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span></span></span>
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><b><span style="color: red;"><span style="color: black;">Setelah anda mebuat table anda bisa mengisi data di table tersebut
sesuai keinginan atau dengan menjalankan perintah SQL berikut:</span></span></b></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><b><span style="color: red;"><span style="color: black;"> </span> </span></b></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"> <span style="color: red;">INSERT INTO `mahasiswa` (`id`, `nim`, `nama`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `agama`, `alamat`, `no_telepon`) VALUES<br />(1, '16001', 'Danang Kusuma', 'Bandar Lampung', '1990-02-01', 'Laki-laki', 'Islam', 'Jalan Gatot Subroto No. 10, Bandar Lampung', '085758857775'),<br />(2, '16002', 'Isyana Sarasvati', 'Jakarta', '1993-05-02', 'Perempuan', 'Islam', 'Jalan Pagar Alam No. 15, Kedaton, Bandar Lampung', '085789892909'),<br />(3, '16003', 'Indra Styawantoro', 'Purbolinggo', '1991-05-15', 'Laki-laki', 'Islam', 'Perum Griya Gedung Meneng Blok C2 No. 2, Rajabasa, Bandar Lampung', '085669919769'),<br />(4, '16004', 'Maudy Ayunda', 'Jakarta', '1994-12-19', 'Perempuan', 'Islam', 'Jalan Radin Intan No. 77, Tanjung Karang, Bandar Lampung', '089977955772'),<br />(5, '16005', 'Valentino Rossi', 'Metro', '1979-03-16', 'Laki-laki', 'Islam', 'Jalan Zaenal Abidin Pagaralam No. 1, Bandar Lampung', '081922919212'),<br />(6, '16006', 'Raisa Andriana', 'Jakarta', '1990-06-06', 'Perempuan', 'Islam', 'Jalan Yos Sudarso No. 135, Bandar Lampung', '081388955767'),<br />(7, '16007', 'Cristiano Ronaldo', 'Teluk Betung', '1986-02-25', 'Laki-laki', 'Islam', 'Jalan Teuku Umar No. 52, Kedaton Bandar Lampung', '081269962201'),<br />(8, '16008', 'M Muzaqi', '', '0000-00-00', '', '', '', ''),<br />(9, '099023022', 'Nia Ramadhani', 'Jakarta', '1996-02-01', 'Perempuan', 'Islam', 'Cengkareng Barat', '12345678'),<br />(10, '109209381', 'Frienly Faisal', '', '0000-00-00', 'Laki-laki', '', '', '');</span></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span></span></span>
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: black;">Saatnya coding! </span></span></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: black;">buatlah foldel di </span></span><span style="color: red;"><span style="color: black;"><span style="color: #444444;">C:\xampp\htdocs\kita beri nama
'pdo_oop' </span></span></span></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: black;"><span style="color: #444444;"><b>Source Code yang pertama 1</b> </span></span></span><span style="color: red;"><span style="color: black;"><span style="color: #444444;"><span style="color: #444444;">Sekarang
kita buat file untuk koneksi ke database mysql misal kita beri nama "library.php" berikut source codenya :</span></span></span></span></span></span></span></div>
<div style="text-align: justify;">
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> <span style="color: red;">
db = new PDO('mysql:host=localhost;dbname=crud_oop','root','');
}
public function tambahMhs($nim, $nama, $tempat_lahir, $tanggal_lahir, </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">$jenis_kelamin, $agama, $alamat, $no_telepon){
$sql = "INSERT INTO mahasiswa (nim, nama, tempat_lahir, tanggal_lahir, </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">jenis_kelamin, agama, alamat, no_telepon) VALUES('$nim', '$nama', '$tempat_lahir', '$tanggal_lahir', '$jenis_kelamin', '$agama', '$alamat', '$no_telepon')";
$query = $this->db->query($sql);
if(!$query){
return "Failed";
}
else{
return "Success";
}
}
public function editMhs($id){
$sql = "SELECT * FROM mahasiswa where id='$id'";
$query = $this->db->query($sql);
return $query;
}
public function updateMhs($nim, $nama, $tempat_lahir, $tanggal_lahir,</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;"> $jenis_kelamin, $agama, $alamat, $no_telepon){
$sql = "UPDATE mahasiswa SET nim='$nim', nama='$nama', </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">tempat_lahir='$tempat_lahir', tanggal_lahir='$tanggal_lahir', </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">jenis_kelamin='$jenis_kelamin', agama='$agama', alamat='$alamat', </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">no_telepon='$no_telepon' WHERE nim='$nim'";
$query = $this->db->query($sql);
if(!$query){
return "Failed";
}
else{
return "Success";
}
}
public function showmahasiswa(){
$sql = "SELECT * FROM mahasiswa order by id desc";
$query = $this->db->query($sql);
return $query;
}
public function deleteMhs($nim){
$sql = "DELETE FROM mahasiswa WHERE nim='$nim'";
$query = $this->db->query($sql);</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">if(!$query){
return "Failed";
}
else{</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"><span style="color: red;"> return "Success";
} }
}
?></span>
</span></span></span></span></pre>
</div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: black;"><span style="color: #444444;"><span style="color: #444444;"> Sourcode yang ke 2 : kita beri nama "index.php" berikut source codenya :</span></span></span></span></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span></span></span>
</div>
<div style="text-align: justify;">
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> <span style="color: red;"> <!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>List Mahasiswa</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">bootstrap/3.3.7/css/bootstrap.min.css" integrity=</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">"sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">min.js" integrity="</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<h2>Daftar Nama Mahasiswa</h2>
<table class="table">
<tr>
<td>NIM</td>
<td>Nama</td>
<td>Jenis Kelamin</td>
<td>Alamat</td>
<td>Edit</td>
<td>Delete</td>
</tr>
<?php
require("library.php");
$Lib = new Library();
$show = $Lib->showmahasiswa();
while($data = $show->fetch(PDO::FETCH_OBJ)){
echo "
<tr>
<td>$data->nim</td>
<td>$data->nama</td>
<td>$data->jenis_kelamin</td>
<td>$data->alamat</td>
<td><a class='btn btn-info' href='edit.php?id=$data->id'>Edit</td>
<td><a class='btn btn-danger' href='list.php?delete=$data->nim</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">'>Delete</a></td>
</tr>";
};
?>
</table>
<a href="index.php" class="btn btn-success">Tambah Mahasiswa Baru</a>
</div>
</body>
</html>
<?php
if(isset($_GET['delete'])){
$del = $Lib->deleteMhs($_GET['delete']);</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">if($del == "Success"){</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"><span style="color: red;"> header('Location: List.php'); }
?></span>
lalu kita coba buka, kolo saya menggunakan mozilla firefox ketikan </span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> </span><span style="color: #444444;">http://localhost/pdo_oop</span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;">jika berhasil maka akan tampil seerti gambar berikut.</span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> </span></span></span></span></pre>
</div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span></span></span>
</div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpww5qQ9Wd-_Sh4huhom8aAIKK7UD7SeqxgH-iLFv9zRilMwaAFqZhhpN5zUOFbnwlehyphenhyphenB01lGv90zRQVk6D4dECNQCZYHb7vRrxGswoQWlef7edX4Ko0iAR40vlK2EBxyLgnK3Zet99k/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpww5qQ9Wd-_Sh4huhom8aAIKK7UD7SeqxgH-iLFv9zRilMwaAFqZhhpN5zUOFbnwlehyphenhyphenB01lGv90zRQVk6D4dECNQCZYHb7vRrxGswoQWlef7edX4Ko0iAR40vlK2EBxyLgnK3Zet99k/s320/2.PNG" width="320" /></a></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: black;"><span style="color: #444444;"><span style="color: #444444;"> source Code yang ke 3 kita buat code untuk mnampilkan data dari my sql, saya buat dengan nama "list.php" berikut source kodenya.</span></span></span></span></span></span></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><br /></span></span></span>
</div>
<div style="text-align: justify;">
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> <span style="color: red;"><!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>List Mahasiswa</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin=</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">"anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin=</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">"anonymous"></script>
</head>
<body>
<div class="container">
<h2>Daftar Nama Mahasiswa</h2>
<table class="table">
<tr>
<td>NIM</td>
<td>Nama</td>
<td>Jenis Kelamin</td>
<td>Alamat</td>
<td>Edit</td>
<td>Delete</td>
</tr>
<?php
require("library.php");
$Lib = new Library();
$show = $Lib->showmahasiswa();
while($data = $show->fetch(PDO::FETCH_OBJ)){
echo "
<tr>
<td>$data->nim</td>
<td>$data->nama</td>
<td>$data->jenis_kelamin</td>
<td>$data->alamat</td>
<td><a class='btn btn-info' href='edit.php?id=$data->id'>Edit</td>
<td><a class='btn btn-danger' href='list.php?delete=$data->nim</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"><span style="color: red;">'>Delete</a></td>
</tr>";
};
?>
</table>
<a href="index.php" class="btn btn-success">Tambah Mahasiswa Baru</a>
</div>
</body>
</html>
<?php
if(isset($_GET['delete'])){
$del = $Lib->deleteMhs($_GET['delete']);
}
?></span> </span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;">jika kita panggil maka akan tampil sbb</span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> </span></span></span></span></pre>
</div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOtSWHXj9i4PHtuZLHgOs8oxrAiIxcVREI7rbCnCmuekKDUCRp5g9ryFpV698fFLK3CVjMCWrkbUp6NDZjD2YvEw7t9KZRU1r9NxLam-onfBLdoMWi_q_mSoTgFRd_4WXvJb0INMgPVfg/s1600/3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOtSWHXj9i4PHtuZLHgOs8oxrAiIxcVREI7rbCnCmuekKDUCRp5g9ryFpV698fFLK3CVjMCWrkbUp6NDZjD2YvEw7t9KZRU1r9NxLam-onfBLdoMWi_q_mSoTgFRd_4WXvJb0INMgPVfg/s400/3.PNG" width="400" /></a></span></span></span></div>
<div style="text-align: justify;">
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> Source Code yang ke 4, inilah source code yang terahir, yaitu untuk mengedit</span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> isi dari my sql</span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;">yang saya beri nama "edit.php" berikut source codenya.</span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> </span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;"><?php
require('library.php');
if(isset($_GET['id'])){
$Lib = new Library();
$id = $Lib->editMhs($_GET['id']);
$edit = $id->fetch(PDO::FETCH_OBJ);
echo '
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Edit Data Mahasiswa</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmU</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">cww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">min.js" </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<h2>Ubah Data Mahasiswa</h2>
<form action="edit.php" method="POST" class="form-group row">
NIM : <input type="text" name="nim" value="'.$edit->nim.'" required class=</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">"form-control"><br>
Nama : <input type="text" name="nama" value="'.$edit->nama.'" required </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">class="form-control"><br>
Tempat Lahir : <input type="text" name="tempat_lahir" value="'.</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">$edit->tempat_lahir.'" required class="form-control"><br/>
Tanggal Lahir : <input type="text" name="tanggal_lahir" value="'.</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">$edit->tanggal_lahir.'" required class="form-control"><br/>
Jenis Kelamin : <input type="text" name="jenis_kelamin" value="'.</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">$edit->jenis_kelamin.'" required class="form-control"><br/>
Agama : <input type="text" name="agama" value="'.$edit->agama.'</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">" required class="form-control"><br/>
No. Telepon : <input type="text" name="no_telepon" value="'.</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">$edit->no_telepon.'" required class="form-control"><br/>
Alamat : <textarea name="alamat" class="form-control">'.$edit->alamat.</span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">'</textarea><br/>
<input type="submit" name="updateMhs" value="Update" class="btn btn-info">
<input type="reset" value="Batal" class="btn btn-warning">
</form>
</div>
</body>
</html>
';
}
if(isset($_POST['updateMhs'])){
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$tempat_lahir=$_POST['tempat_lahir'];
$tanggal_lahir=$_POST['tanggal_lahir'];
$jenis_kelamin=$_POST['jenis_kelamin'];
$agama=$_POST['agama'];
$alamat=$_POST['alamat'];
$no_telepon=$_POST['no_telepon'];
$Lib = new Library();
$upd = $Lib->updateMhs($nim, $nama, $tempat_lahir, $tanggal_lahir, </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;">$jenis_kelamin, $agama, $alamat, $no_telepon);
if($upd == "Success"){
header('Location: List.php');
}
}
?></span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;"> </span></span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: #444444;"> </span></span></span></span></span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8sFGfVjaz9Ny6AEXXqitZ4mVnuXMUwoAumFDXcxp0twn1wTx6Kzv3mdHi_dPL70CDtdCRbNmtUMZsLDvd9bGTiZYW2nmij_jRRkTrVeBVqoiFUoRh5ZkdCnQRvxHMaoItoUY8vJS5CB0/s1600/edd.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8sFGfVjaz9Ny6AEXXqitZ4mVnuXMUwoAumFDXcxp0twn1wTx6Kzv3mdHi_dPL70CDtdCRbNmtUMZsLDvd9bGTiZYW2nmij_jRRkTrVeBVqoiFUoRh5ZkdCnQRvxHMaoItoUY8vJS5CB0/s320/edd.png" width="320" /></a></div>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> </span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;">beginilah tutorial yang saya dalam pembahasan kali ini </span></span></span></span></pre>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;">Semoga bermanfaat ya.... :D </span></span></span></span></pre>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<pre class="php" name="code"><span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: #444444;"> </span></span></span></span></pre>
</div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="color: #f3f3f3;"></span></div>
<div style="text-align: justify;">
<span style="color: #f3f3f3;"><span style="color: white;"><span style="color: white;"><span style="color: red;"><span style="color: black;"> </span></span></span></span></span></div>
Anonymoushttp://www.blogger.com/profile/11498409131454238174noreply@blogger.com0tag:blogger.com,1999:blog-5567650762421149718.post-72096532005420776102016-10-24T07:20:00.000-07:002016-10-24T07:42:08.185-07:00Mengubah Port Apache dan MySQL di XAMPP<h2>
Mengubah Port Apache</h2>
Mengubah port apache pada xampp <b>TIDAK</b> dapat
dilakukan melalui XAMPP Control Panel, mungkin sobat pernah membuka menu
config yang terletak di sebelah pojok kanan atas XAMPP Control Panel,
namun seperti pada peringatan yang muncul, untuk mengubah port yang
digunakan oleh XAMPP tetap harus melalui file konfigurasi.<br />
<img height="320" id="7l6yeermxjtj" src="data:image/gif;base64,R0lGODlhEAAQAOUdAOvr69HR0cHBwby8vOzs7PHx8ff397W1tbOzs+Xl5ebm5vDw8PPz88PDw7e3t+3t7dvb2+7u7vX19eTk5OPj4+rq6tbW1unp6bu7u+fn5+jo6N/f3+/v7/7+/ra2ttXV1f39/fz8/Li4uMXFxfb29vLy8vr6+sLCwtPT0/j4+PT09MDAwL+/v7m5ubS0tM7OzsrKytra2tTU1MfHx+Li4tDQ0M/Pz9nZ2b6+vgAAAAAAAAAAAAAAAAAAAAAAAAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQFMAA5ACwAAAAAEAAQAAAGg8CcMAcICAY5QsEwHBYPCMQhl6guGM5GNOqgVhMPbA6y5Xq/kZwkN3Fsu98EJcdYKCo5i7kKwCorVRd4GAg5GVgAfBpxaRtsZwkaiwpfD0NxkYl8QngARF8AdhmeDwl4pngUCQsVHDl2m2iveDkXcZ6YTgS3kAS0RKWxVQ+/TqydrE1BACH5BAkwADkALAAAAAAQABAAAAZ+wJwwJ1kQIgNBgDMcdh6KRILgQSAOn46TIJVSrdZGSMjpeqtgREAoYWi6BFF6xCAJS6ZyYhEIUwxNQgYkFxwBByh2gU0kKRVHi4sgOQuRTRJtJgwSBJElihwMQioqGmw5gEMLKk2AEkSBq4ElQmNNoYG2OVpDuE6Lrzmfp0NBACH5BAUwADkALAAAAAAQABAAAAaFwJwwJ1kQCDlCwTAcMh6KhDQnVSwYTkJ1un1gc5wtdxsh5iqaLbVKyVEWigq4ugZgTyiA9CK/JHIZWCsICCxpVWV/EzkHhAgth1UPQ4OOLXpScmebFA6ELHAZclBycXIULi8VZXCZawplFG05flWlakIVWravCgSaZ1CuksBDFQsAcsfFQQAh+QQJMAA5ACwAAAAAEAAQAAAGQcCccEgsGo/IpHLJzDGaOcKCCUgkAEuFNaFRbq1dJCxX2WKRCFdMmJiiEQjRp1BJwu8y5R3RWNsRBx9+SSsxgzlBACH5BAkwADkALAAAAAAQABAAAAaJwJwwJ1kQCDlCwTAcMh6KhDQnVSwYTkJ1un1gc5wtdxsh5iqaLbVKyTEWigq4ugZglRXpRX5J5DJYAFIAaVVlfhNrURqFVQ9DYhqCgzkzCGdnVQBwGRU0LQiXCRUAORQJCwAcOTChoYplBXIKLq6vUXRCCQ22olUEcroJB66KD8FNCjUrlxWpTUEAIfkEBTAAOQAsAAAAABAAEAAABobAnDAnWRAIOULBMBwyHoqENCdVLBhOQnW6fWBznC13G8nZchXNllql5Bg2xA1cZQOwShwCMdDkLgk5GVgAUgAie3syVDkTbFIaiIkIJ0NiGnp7HiNonRVVAHEuFjlQFVQVAI0JCzYjrKCPZQWnf1unYkMVWrFbBLVoUIaPD8C6CwCnAMhNQQA7" width="320" /><br />
Pada apache terdapat dua port yaitu port HTTP dengan nilai default 80
dan port SSL dengan nilai default 443. Ketika module apache dijalankan,
maka secara otomatis juga akan mengaktifkan kedua port tersebut, dan
untuk mengubah port HTTP, kita juga harus mengubah port SSL, jika tidak
maka akan muncul pesan error.<br />
<h2>
Mengubah Port HTTP – Apache</h2>
Untuk mengubah port HTTP, buka <span style="font-size: 16px; line-height: 1.5;">file httpd.conf (file konfigurasi apache) yang terletak di direktori apache/conf cari kata-kata <code>Listen 80</code> dan <code>ServerName localhost:80</code> kemudian ubah angka 80 menjadi angka port yang diinginkan, misal 7777</span><br />
<img alt="Cara Mengubah Port Apache Pada XAMPP - HTTP" class="alignnone size-full wp-image-1088 lazy-loaded" data-lazy-type="image" data-src="http://jagowebdev.com/wp-content/uploads/2016/04/mengubah_port_apache_pada_xampp_http.png" height="76" src="https://jagowebdev.com/wp-content/uploads/2016/04/mengubah_port_apache_pada_xampp_http.png" width="320" /><br />
dan<br />
<img alt="Mengubah Port Apache Pada XAMPP - HTTP" class="alignnone size-full wp-image-1089 lazy-loaded" data-lazy-type="image" data-src="http://jagowebdev.com/wp-content/uploads/2016/04/mengubah_apache_port_pada_xampp_http2.png" height="99" src="https://jagowebdev.com/wp-content/uploads/2016/04/mengubah_apache_port_pada_xampp_http2.png" width="588" /><br />
Jika sobat menginstall apache dari software lain seperti WAMPP atau
dari installer apache langsung, sobat dapat menyesuaikan lokasi file
konfigurasinya yang pasti nama filenya adalah httpd.conf<br />
<h2>
Mengubah Port SSL – Apache</h2>
Untuk mengubah port SSL, buka file httpd-ssl.conf yang ada di folder <code>apache\conf\extra</code>,
selanjutnya cari kata yang mengandung angka 443 (misal: Listen 443
dan ServerName localhost:443), ganti 443 dengan angka lain misal 444,
kemudian simpan file terebut.<br />
<img alt="Mengubah Port SSL Pada Apache" class="alignnone size-full wp-image-1090 lazy-loaded" data-lazy-type="image" data-src="http://jagowebdev.com/wp-content/uploads/2016/04/mengubah_port_apache_pada_xampp_ssl.png" height="118" src="https://jagowebdev.com/wp-content/uploads/2016/04/mengubah_port_apache_pada_xampp_ssl.png" width="504" /><br />
Selesai.<br />
<h2>
Mengubah Port MySQL</h2>
MySQL memiliki port default 3306.<br />
Sebagaimana port Apache, kita juga <b>TIDAK </b>dapat mengubah port MySQL melalui XAMPP Control Panel, untuk mengubahnya kita perlu untuk meng edit file konfigurasi MySQL.<br />
Untuk mengubah port MySQL, buka file <code>my.ini</code> yang biasanya terletak di <code>XAMPP/mysql/bin/my.ini</code>, cari kata-kata yang mengandung angka 3306, misalL <code>port = 3306</code>, kemudian ganti angka 3306 dengan angka lain, misal 3307.<br />
<img alt="Cara Mengubah MySQL Port Pada XAMPP" class="alignnone size-full wp-image-1086 lazy-loaded" data-lazy-type="image" data-src="http://jagowebdev.com/wp-content/uploads/2016/04/cara_mengubah_mysql_port_pada_xampp.png" height="216" src="https://jagowebdev.com/wp-content/uploads/2016/04/cara_mengubah_mysql_port_pada_xampp.png" width="400" /><br />
Selesai.<br />
Demilikan cara untuk mengubah port baik Apache maupun MySQL, semoga bermanfaat.Anonymoushttp://www.blogger.com/profile/11498409131454238174noreply@blogger.com0tag:blogger.com,1999:blog-5567650762421149718.post-2739084021622109802014-09-13T06:22:00.001-07:002014-09-13T06:22:53.009-07:00Realita Kehidupan Dunia<h2>
<a href="http://www.lampuislam.blogspot.com/2013/08/realita-kehidupan-dunia.html">Realita Kehidupan Dunia</a>
</h2>
<div class="post-meta">
<span>
Posted by Lampu Islam
</span>
<span>
Jumat, 16 Agustus 2013
</span>
<span>
<a href="http://www.lampuislam.blogspot.com/2013/08/realita-kehidupan-dunia.html#comment-form">2 comments</a></span>
</div>
<div style="text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNQIH_2JQo42PiwtyFeWZ95LDPHMd_G5GmfDtATRv1A3QqrML2AyYPIsICjirQqgvXXV68J3xmztaksTcI8B68kZb-xAIjt_wt-3iPoQt_b6-F3xXQ8LWL33SdQpE1LmwT56WZT7yCukY6/s1600/Dunia.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNQIH_2JQo42PiwtyFeWZ95LDPHMd_G5GmfDtATRv1A3QqrML2AyYPIsICjirQqgvXXV68J3xmztaksTcI8B68kZb-xAIjt_wt-3iPoQt_b6-F3xXQ8LWL33SdQpE1LmwT56WZT7yCukY6/s400/Dunia.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMacgiFl0Ez5i3L4-39G25-91u5gIuHPBXytr-hpSui44TTG4dsnt0XiJKws7vCH9cLQV2UauB5KIbspTBGSLdXw2Budi-JcXi7pQcyboXy4x03jqCfWWm2D5A0Zv6nFBw88_mdYKcMRlP/s1600/Dunia.jpg" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>
<br />
Dunia hanya dusta...<br />
Dunia hanya ilusi...<br />
Dunia hanya tipuan...<br />
Dunia hanya sementara...</div>
<div style="text-align: justify;">
Dunia adalah pemberhentian singkat menuju tujuan akhir kita. Dunia hanya
khayalan. Kita pikir dia nyata, tapi semakin kita mendekatinya,
kenyataan membangunkan kita! </div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Ali R.A. berkata “Orang-orang tertidur selama mereka hidup dan mereka terbangun ketika mati.”<br />
<br />
Kehidupan ini adalah UJIAN BESAR, dan DUNIA adalah RUANG
UJIANNYA.Mengejar dunia bagaikan mengejar bayangan kalian sendiri. Lebih
baik lari dari dunia ini, dan menyaksikan bagaimana dunia mengejar
kita. Tipu daya dunia jelas terlihat, tipu daya itu adalah kekayaan,
status, ras, dan nasionalisme.<br />
<br />
Isa A.S. pernah bertemu dengan dunia. Dunia menjelma menjadi seorang
gadis yang cantik dan Isa A.S. bertanya “Siapa kamu?” Dia menjawab
“Dunia.”<br />
<br />
Isa bertanya “Berapa banyak teman yang kau miliki?” Dia berkata “jutaan... semua ciptaan Allah S.W.T.”<br />
<br />
Isa A.S. bertanya “Kepada siapa kau setia?” Dia menjawab “Tidak siapapun.” <br />
<br />
Kemudian akhirnya Isa berkata “Bodohlah barangsiapa yang jatuh dalam tipu daya dan dustamu.”<br />
<br />
Kebenaran yang hakiki hanyalah Allah S.W.T. dan Islam dari-Nya. Dan hal
yang pasti adalah setiap yang bernyawa akan merasakan kematian. Kita
tidak akan mati membawa uang atau jabatan kita. Ketika kita mati,
perlahan-lahan orang melupakan bahwa inilah dunia.</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Uang, jabatan, status, dan gelar kita tidak berguna di dalam kubur.
Satu-satunya yang berguna hanyalah amal kita. Satu-satunya barang bawaan
kita adalah amal baik dan buruk.<br />
<br />
Hanya ada 3 pertanyaan dari malaikat-malaikat Allah di dalam kubur. Munkar dan Nakir akan bertanya <br />
<br />
“Siapa Tuhanmu? Allah.”<br />
“Apa din-mu? Islam.”<br />
“Siapa utusan yang dikirimkan kepadamu? Muhammad S.A.W.”</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<br />
Dan tidak akan ada pertanyaan keempat.</div>
<br />
Kita singgah di dunia untuk berjuang dan berkorban untuk Allah S.W.T.,
tetap teguh dalam agama kita, dan tidak menyakiti, berkhianat, menipu
diri sendiri, apalagi orang lain.<br />
<br />
Aku berdo’a kepada Allah S.W.T. agar memberikanku hati yang baik. Karena
dengan shalat, zakat, dan puasa, kita semua harus saling menghormati
dan mencintai satu sama lain. Semua nabi punya karakter yang baik. Aku
mengutarakan nasihat ini pertama untuk diriku sendiri. Cintai
saudara/saudarimu untuk Allah S.W.T. karena kita semua adalah ciptaan
Allah S.W.T. Dunia hanya sementara. Satu-satunya kebenaran adalah Allah
S.W.T. dan Islam dari-Nya.Anonymoushttp://www.blogger.com/profile/11498409131454238174noreply@blogger.com0