Mengatasi Error PHP Couldn’t fetch mysqli

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

```
<?php
```
```
 
```
```
$DB_NAME = 'dbname';
```
```
$DB_HOST = 'localhost';
```
```
$DB_USER = 'dbuser';
```
```
$DB_PASS = 'dbpass';
```
```
 
```

$mysqli = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);

```
	if (mysqli_connect_errno()) {
```

		printf("Koneksi gagal: %s\n", mysqli_connect_error());

```
		exit();
```
```
	}
```
```
	mysqli_close($mysqli);
```
```
 
```
```
?>
```

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.

Comments

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
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();
}
}
?>
Willy Asyraf says
23 October 2019 at 16:55
Terimakasih atas informasinya. Sangat membantu dikala deadline.

Tulisan menarik lainnya

Reader Interactions

Comments

Leave a Reply Cancel reply