Postingan lainnya
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Bagaimana cara membuat koneksi login.html ke DB dgn php?
Mohon bantuannya, saya selalu gagal membuat koneksi login.html ke DB dengan menggunakan php. Contoh koneksi yang telah saya buat tapi gagal.
dbname = tbl_login dbtablename = tbl_login
?php
$username = $_POST['username'];
$password = $_POST['password'];
$username = stripcslashes($username);
$password = stripcslashes($password);
mysql_connect("localhost", "root", "");
mysql_select_db("tbl_login");
$result = mysql_query("select * from tbl_login where username = '$username' and password = '$password'") or die("Failed to query database ".mysql_error());
$row = mysql_fetch_array($result);
if ($row['username'] == $username && $row['password'] == $password ){
echo "Login berhasil".$row['username'];
}else{
echo "Login gagal";
}
?>
Mohon bantuannya, apa ada yang salah pada script diatas. Maaf saya masih pemula
contoh error :
3 Jawaban:
Silakan dicoba
mysqli_connect("localhost", "username", "password","nama database");
<pre> ?php
mysqli_connect("localhost", "root", "","tbl_login");
$username = $_POST['username'];
$password = $_POST['password'];
$username = stripcslashes($username);
$password = stripcslashes($password);
$result = mysqli_query("select * from tbl_login where username = '$username' and password = '$password'") or die("Failed to query database ".mysqli_error());
$row = mysqli_fetch_array($result);
if ($row['username'] == $username && $row['password'] == $password ){
echo "Login berhasil".$row['username'];
}else{
echo "Login gagal";
}
?> </pre>
itu di $result = mysqli_query() harus dua parmeter
jadi seperti ini <pre> <?php
$conn = mysqli_connect("localhost","root", "" ,"namadatabase");
$username = $_POST['username'];
$password = $_POST{'password'];
$result = mysqli_query($conn,"select * from namadatabase);
</pre>
coba kode ini
<pre>
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "Database"; //isikan nama database anda $table = "Table"; //isikan nama table anda // membuat koneksi ke database $conn = new mysqli($servername, $username, $password, $dbname); // cek koneksi ke database if ($conn->connect_error) { die("koneksi error: " . $conn->connect_error); }
$sql = "select * from $table where username = '$username' and password = '$password'"; $result = $conn->query($sql);
if ($result->num_rows == 1) { // output data of each row $row = $result->fetch_assoc()[0];
if($row['username'] == $username && $row['password'] == $password){
echo "berhasil".$row['username'];
}else{
echo "gagal";
}
} else { echo "0 results"; }
?> </pre>