![Setting Koneksi database Codeigniter](https://www.rumahweb.com/journal/wp-content/uploads/2019/06/Setting-Koneksi-database-Codeigniter.jpg 1200w, https://www.rumahweb.com/journal/wp-content/uploads/2019/06/Setting-Koneksi-database-Codeigniter-300x158.jpg 300w, https://www.rumahweb.com/journal/wp-content/uploads/2019/06/Setting-Koneksi-database-Codeigniter-768x403.jpg 768w, https://www.rumahweb.com/journal/wp-content/uploads/2019/06/Setting-Koneksi-database-Codeigniter-1024x538.jpg 1024w)
Setelah berhasil upload file Codeigniter ke hosting, Anda perlu melakukan setting koneksi databasenya terlebih dahulu agar dapat berfungsi dengan normal. Pada panduan kali ini, kami akan membahas bagaimana cara setting koneksi database codeigniter 3 dan 4.
Sebelum membahas tentang cara setting Koneksi Database di Codeigniter, kami akan mengulas sedikit tentang apa itu CodeIgniter. Berikut informasi selengkapnya.
Mengenal Codeigniter
Codeigniter adalah framework PHP yang berbasis MVC (Model, View, Controller) yang pertama kali dirilis pada 28 Februari 2006 oleh Rick Ellis.
Codeigniter juga dikenal sebagai framework yang cukup ringan, sehingga tidak memerlukan resource yang besar untuk menggunakannya. Selain itu codeigniter bersifat Open-source sehingga dapat digunakan, dikembangkan oleh siapapun.
Maka dari itu tidak heran Codeigniter menjadi salah satu framework yang cukup populer bagi programmer pemula maupun yang sudah advance.
Selengkapnya tentang Codeigniter bisa Anda baca pada artikel berikut.
Membuat dan Import database
Sebelum melakukan setting koneksi database codeigniter, pastikan Anda sudah membuat database dan import file databasenya terlebih dahulu. Berikut tahapannya,
Step 1 : Membuat Database
Sebelum melakukan setting koneksi database, pastikan Anda sudah membuat database, dan user database, serta menghubungkan database dengan user databasenya terlebih dahulu melalui cPanel dari menu MySQL® Databases,
![membuat database di cpanel](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database-1024x410.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database-300x120.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database-768x307.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database-370x148.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database-270x108.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database-570x228.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database-740x296.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/1-membuat-database.png 1374w)
Sebelumnya kami sudah pernah membahas bagaimana cara membuat database di cPanel. Untuk lebih detail bagaimana cara membuat database Anda dapat mempelajari melalui artikel berikut, Cara Membuat Database Terlengkap di cPanel.
Step 2 : Import file database
Setelah berhasil membuat database di cPanel, selanjutnya adalah melakukan import file database melalui phpMyAdmin di cPanel hosting terlebih dahulu. Berikut tahapannya,
Akses ke phpMyAdmin dari cPanel, dan pilih import pada database dimana file .sql akan diimport,
![import file database](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database-1024x296.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database-300x87.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database-768x222.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database-370x107.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database-270x78.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database-570x165.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database-740x214.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/2-import-database.png 1258w)
Selanjutnya silahkan pilih file .sql yang akan diimport, dan pilih “Go” atau “Import”.
![import database](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-1024x353.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-300x104.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-768x265.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-1536x530.png 1536w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-370x128.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-270x93.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-570x197.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database-740x255.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/3-import-database.png 1649w)
Jika proses import database berhasil, akan mendapati tampilan seperti gambar berikut,
![import sql selesai](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-1024x376.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-300x110.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-768x282.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-1536x564.png 1536w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-370x136.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-270x99.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-570x209.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database-740x272.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/4-finish-import-database.png 1656w)
Setelah selesai membuat database, dan import file databasenya. Berikut adalah tahapan untuk setting Koneksi database di codeigniternya.
Codeigniter 3
Apabila Anda memiliki aplikasi berbasis codeigniter 3, silahkan untuk mengikuti tahapan berikut,
- Login ke cPanel hosting
- Akses ke menu File manager
- Akses Folder public_html > application seperti gambar berikut,
![setting koneksi database codeigniter](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application-1024x468.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application-300x137.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application-768x351.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application-370x169.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application-270x123.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application-570x260.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application-740x338.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/6-masuk-folder-application.png 1278w)
- Setelah itu, silahkan masuk kedalam folder config
![folder config ci](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config-1024x522.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config-300x153.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config-768x392.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config-370x189.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config-270x138.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config-570x291.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config-740x377.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/7-folder-config.png 1047w)
- Setelah berhasil masuk ke folder config, selanjutnya silahkan Anda klik kanan pada file database.php dan edit seperti gambar berikut,
![setting koneksi database di codeigniter](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database-1024x642.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database-300x188.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database-768x481.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database-370x232.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database-270x169.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database-570x357.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database-740x464.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/8-edit-file-database.png 1058w)
- Selanjutnya silahkan Anda sesuaikan setting koneksi databasenya sebagai berikut,
- hostname : isi dengan localhost
- username : isi dengan username database yang sebelumnya sudah dibuat
- password : isikan dengan password user databasenya
- database : isi dengan nama database yang sudah dibuat
Setelah selesai, silahkan Anda simpan file database.php
![masukkan database ke file config](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/10-sesuaikan-setting-database.png 782w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/10-sesuaikan-setting-database-300x246.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/10-sesuaikan-setting-database-768x631.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/10-sesuaikan-setting-database-370x304.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/10-sesuaikan-setting-database-270x222.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/10-sesuaikan-setting-database-570x468.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/10-sesuaikan-setting-database-740x608.png 740w)
Codeigniter 4
Berikut adalah tahapan untuk setting koneksi database pada Codeigniter 4,
- Akses ke cPanel hosting
- Masuk ke menu File manager
- Masuk ke folder core codeigniter 4 (Sesuaikan dengan letak folder core Codeigniter 4 Anda).
![setting koneksi database ci4](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4-1024x510.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4-300x150.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4-768x383.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4-370x184.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4-270x135.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4-570x284.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4-740x369.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/12-masuk-folder-ci4.png 1292w)
- Setelah itu silahkan masuk ke folder app
![folder app](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4-1024x460.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4-300x135.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4-768x345.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4-370x166.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4-270x121.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4-570x256.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4-740x332.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/13-folder-appci4.png 1289w)
- Lalu masuk ke folder Config
![folder config](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4-1024x420.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4-300x123.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4-768x315.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4-370x152.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4-270x111.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4-570x234.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4-740x304.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/14-config-folder-coi4.png 1299w)
- Setelah itu silahkan Anda klik kanan pada file Database.php, dan pilih Edit seperti gambar berikut,
![file config database](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database-1024x493.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database-300x144.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database-768x370.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database-370x178.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database-270x130.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database-570x274.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database-740x356.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/15-edit-file-database.png 1278w)
- Selanjutnya silahkan Anda sesuaikan setting Koneksi databasenya sebagai berikut,
- hostname : isi dengan localhost
- username : isi dengan username database yang sebelumnya sudah dibuat
- password : isikan dengan password user databasenya
- database : isi dengan nama database yang sudah dibuat
Setelah selesai menyesuaikan, silahkan save file Database.php dan coba untuk akses kembali website Anda.
![setting koneksi database CI4](https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database-1024x576.png 1024w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database-300x169.png 300w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database-768x432.png 768w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database-370x208.png 370w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database-270x152.png 270w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database-570x320.png 570w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database-740x416.png 740w, https://www.rumahweb.com/journal/wp-content/uploads/2023/12/16-sesuaikan-koneksi-database.png 1101w)
Demikian tutorial Cara setting Koneksi database di Codeigniter, selamat mencoba.