Postingan lainnya
Tentang Coding
Maaf gan, saya bukan anak IT, lg mau belajar ttg dunia percodingan. Boleh tau ini salahnya dimana? Lagi mau nyoba Beesmart nih Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\x\beesmart\config\server.php on line 6
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\x\beesmart\login.php on line 158
Fatal error: Uncaught Error: Call to undefined function mysql_fetch_array() in C:\xampp\htdocs\x\beesmart\login.php:159 Stack trace: #0 {main} thrown in C:\xampp\htdocs\x\beesmart\login.php on line 159
3 Jawaban:
Kalo error yang pertama dan kedua itu fungsi mysqli_select_db() sama mysqli_query() membutuhkan dua parameter sedangkan kamu baru memasukan satu parameter. Kalo error yang ketiga itu mah fungsinya udah gak kepake lagi pakenya yang ini mysqli_fetch_array()... Saya saranin gan gak usah pake fungsi mysqli_select_db pake mysqli_connect aja
contoh:mysqli_query('localhost' , 'root' , '' , 'namaDatabasenya');
Referensinya di php.net cari aja fungsinya
Jawab:
1. Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\x\beesmart\config\server.php on line 6
<?php
require("constants.php");
// 1. Create a database connection
$connection = mysqli_connect("DB_SERVER","DB_USER","DB_PASS");
if (!$connection) {
die("Database connection failed: " . mysqli_error());
}
// 2. Select a database to use
$db_select = mysqli_select_db($connection, "DB_NAME"); //samakan pada bagian ini
if (!$db_select) {
die("Database selection failed: " . mysqli_error());
}
?>
2. Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\x\beesmart\login.php on line 158
$sql = "select * from website where site_key like'$search'";
mysqli_query($connection,$sql); //ubah pada bagian ini, $connection dari yg diatas
3.Fatal error: Uncaught Error: Call to undefined function mysql_fetch_array() in C:\xampp\htdocs\x\beesmart\login.php:159 Stack trace: #0 {main} thrown in C:\xampp\htdocs\x\beesmart\login.php on line 159
$row = mysqli_fetch_array($result, MYSQLI_NUM)