• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Jaranguda

Belajar Mengajar

  • Home
  • Sponsor/Jasa
  • Tentang

Mengatasi Error PHP Couldn’t fetch mysqli

Last Updated on 11 February 2014 By tommy 3 Comments

Error yang muncul di browser/debugger

Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in /var/www/html/top10.php on line 85
Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/top10.php on line 91

setelah lihat code sana sini, ternyata error tersebut karena fungsi mysqli_close, di halaman top10.php saya meng-include-kan koneksi.php yang isinya

  1. <?php
  2.  
  3. $DB_NAME = 'dbname';
  4. $DB_HOST = 'localhost';
  5. $DB_USER = 'dbuser';
  6. $DB_PASS = 'dbpass';
  7.  
  8. $mysqli = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
  9. 	if (mysqli_connect_errno()) {
  10. 		printf("Koneksi gagal: %s\n", mysqli_connect_error());
  11. 		exit();
  12. 	}
  13. 	mysqli_close($mysqli);
  14.  
  15. ?>

ubah baris ke 13 sehingga menjadi

	// mysqli_close($mysqli);

dengan menambah tanda // di depan perintah PHP, sama dengan mendisable perintah tersebut.mysqli_close saya tambahkan di top10.php.

Tulisan menarik lainnya

  • Mengatasi WhatsApp Error di Tablet

    Pesan Errornya "This version of WhatsApp beome obsolete on May 22, 2015. Please go to…

  • Cara Mengatasi Error getCachedCompilePath Laravel 5

    Error yang muncul PHP Fatal error: Call to undefined method Illuminate\Foundation\Application::getCachedCompilePath() in /var/www/html/sastra/vendor/laravel/framework/src/Illuminate/Foundation/Console/ClearCompiledCommand.php on line…

  • Mengatasi HTTP Error 500 Internal Server untuk PHP

    Salah satu masalah yang paling sering muncul di PHP adalah 500 - Internal Server Error.…

  • Mengatasi Error TokenMismatchException di Laravel

    Error TokenMismatchException di Laravel 5, muncul karena form yang anda gunakan belum memiliki csrf token.…

Filed Under: PHP Tagged With: error, script

Reader Interactions

Comments

  1. Ismail says

    17 April 2020 at 12:33

    Warning: mysqli::query(): Couldn’t fetch mysqli in /storage/ssd4/840/13211840/public_html/models/m_anggota.php on line 16

    Warning: Anggota::tampil(): Couldn’t fetch mysqli in /storage/ssd4/840/13211840/public_html/models/m_anggota.php on line 16

    Reply
  2. Ismail says

    17 April 2020 at 12:32

    mysqli = $conn;
    }

    public function tampil($id = null) {
    $db = $this->mysqli->conn;
    $sql = ” SELECT * FROM tb_anggota”;
    if($id != null) {
    $sql .= “WHERE id_agt = $id”;
    }
    $query = $db->query($sql) or die ($db->error);
    return $query;
    }

    public function tambah($nm_agt, $jbt_agt, $prd_agt, $foto_agt) {
    $db = $this->mysqli->conn;
    $db->query(“INSERT INTO tb_anggota VALUES (”, ‘$nm_agt’, ‘$jbt_agt’, ‘$prd_agt’, ‘$foto_agt’)”) or die ($db->error);
    }

    public function edit($sql) {
    $db = $this->mysqli->conn;
    $db->query($sql) or die ($db->error);
    }

    public function hapus($id) {
    $db = $this->mysqli->con;
    $db->query(“DELETE FROM tb_anggota WHERE id_agt = ‘$id'”) or die ($db->error);
    }

    function __desctruct() {
    $db = $this->mysqli->conn;
    $db->close();
    }

    }
    ?>

    Reply
  3. Willy Asyraf says

    23 October 2019 at 16:55

    Terimakasih atas informasinya. Sangat membantu dikala deadline.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Pencarian

Tanya Jawab tentang DevOps SRE CPE, gabung di https://t.me/devopsindonesia

Terbaru

  • Cara Mengganti Port Screen Sharing macOS
  • Cara Menonaktifkan Pager di macOS
  • Cara Mengupdate Nama Apple silicon-as-a-Service Scaleway
  • Cara Force Delete Namespace di Kubernetes
  • Install PHP MariaDB di Mac Monterey

Komentar

  • mazda on Tutorial Lengkap Install Mail Server Postfix Dovecot MariaDB di CentOS 7
  • adi on Menggunakan Mikrotik Sebagai SSH Client
  • aris u on Solusi Simple Queue Mikrotik Tidak Berjalan
  • Bowo on Cara Mematikan SSID Molecool Balifiber
  • aris on Solusi Simple Queue Mikrotik Tidak Berjalan

Tulisan Populer

  • Password Router Huawei HG8245H5 Indihome 1.2m views
  • Password Terbaru ZTE F609 Indihome 784.5k views
  • Password Superadmin Huawei HG8245A 318.8k views
  • Cara Setting Manual Modem GPON ZTE F609 Indihome 273.1k views
  • Cara Setting Wireless ZTE F609 Indihome 257.3k views
  • Mengaktifkan Port LAN di Huawei HG8245 Indihome 170k views
  • Akses UseeTV Indihome via Wireless ZTE F609 156.9k views
  • Kemana Menghilangnya Saldo BCA 50 ribu 153.5k views
  • Cara Reset Password ZTE F609 Indihome 147.6k views
  • Cara Setting DHCP Server Modem/Router ZTE F609 113.6k views

Kategori

  • Delphi
  • dll
  • Gambas
  • Internet
  • Java
  • Lazarus
  • Linux
  • PHP
  • Review
  • Teknologi

Sponsor

kadal.id
carakami.com
kuotabisa.com
Untuk jadi sponsor, hubungi kita lewat halaman sponsor
© 2021. Jaranguda
  • Linux
  • PHP
  • Internet
  • Teknologi
  • Delphi
  • Gambas
  • Java