Postingan lainnya
Warning: mysqli_query() expects at least 2 parameters,1 given in on line 8
1 Jawaban:
Coba di posting dulu mas, file koneksi nya....
soalnya, kalau ngk salah penggunaan mysql ama mysqli agak beda peggunaanya, tergantung di koneksinya pake apaan.Biasanya kalau kita pake mysql, script querynya itu sisa langsung masukin query ke mysql_query dan ngk pake parameter koneksi lagi, contoh :
mysql_query("INSERT INTO students (student_name, student_email, student_city)
VALUES ('John', 'john@example.com','los angeles')");
sedangkan kalau makenya mysqli, dia selain make script query, dia juga make parameter koneksinya, contohnya:
$sql = "INSERT INTO students (student_name, student_email, student_city)
VALUES ('John', 'john@example.com','los angeles')";
$mysqli->query($sql); //disini $mysqli merupakan variabel koneksi pada file koneksi.php
nah untuk referensi aja, kalau menggunakan mysqli_query : #source link : https://www.formget.com/php-mysqli-insert/ #Source Code :
koneksi.php
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
// Create connection
$conn = new mysqli($servername, $username, $password,$dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
insert.php
include "koneksi.php";
$sql = "INSERT INTO students (student_name, student_email, student_city)
VALUES ('John', 'john@example.com','los angeles')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}$conn->close();