Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
ini gimana cara ngatasinnya ya
tiap mau login ada error kaya gini
Notice: Undefined index: uname in C:\xampp\htdocs\kios\login_act.php on line 4 Notice: Undefined index: pass in C:\xampp\htdocs\kios\login_act.php on line 5 Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\kios\login_act.php on line 7 Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\kios\login_act.php on line 7
scriptnya :
mohon bantuannya bang
0
19 Jawaban:
$koneksi dari include config.php
$query=mysqli_query($koneksi,"select * from admin where uname='$uname' and pass='$pass'")
0
mysqli butuh satu parameter lagi
mysqli_query($query, $conn)
1
uname dan pass pada baris inni tidak terdefinisi:
$uname=$_POST['uname']; $pass=$_POST['pass'];
Pastikan di form login penamaan form inputnya harus name="uname" dan name="pass"
1
masih error bang
Notice: Undefined index: uname in C:\xampp\htdocs\kios\login_act.php on line 4
Notice: Undefined index: pass in C:\xampp\htdocs\kios\login_act.php on line 5
Notice: Undefined variable: koneksi in C:\xampp\htdocs\kios\login_act.php on line 7
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\kios\login_act.php on line 7
Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\kios\login_act.php on line 7
login_act.php
<?php
session_start();
include 'admin/config.php';
$uname=$_POST['uname'];
$pass=$_POST['pass'];
$pas=md5($pass);
$query=mysqli_query($koneksi,"select * from admin where uname='$uname' and pass='$pass'")or die(mysqli_error());
if(mysqli_num_rows($query)==1){
$_SESSION['uname']=$uname;
header("location:admin/index.php");
}else{
header("location:index.php?pesan=gagal")or die(mysqli_error());
// mysqli_error();
}
// echo $pas;
?>
config.php
<?php
/**
* Namafile : config.php
* ----------------------------*/
$dbhost = 'localhost';
$dbuser = 'root'; // ini berlaku di xampp
$dbpass = ''; // ini berlaku di xampp
$dbname = 'malasngoding_kios';
// melakukan koneksi ke database
$connect = new mysqli($dbhost,$dbuser,$dbpass,$dbname);
// cek koneksi yang kita lakukan berhasil atau tidak
if ($connect->connect_error) {
// jika terjadi error, matikan proses dengan die() atau exit();
die('Maaf koneksi gagal: '. $connect->connect_error);
}
0
Coba saya lihat file login yang ada form loginnya
1
$query=mysqli_query($connect,"select * from admin where uname='$uname' and pass='$pass'")or die(mysqli_error());
2
yang ini bukan ?
index.php
<!DOCTYPE html>
<html>
<head>
<title>KIOS MALASNGODING</title>
<link rel="stylesheet" type="text/css" href="assets/css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="assets/js/jquery-ui/jquery-ui.css">
<script type="text/javascript" src="assets/js/jquery.js"></script>
<script type="text/javascript" src="assets/js/bootstrap.js"></script>
<script type="text/javascript" src="assets/js/jquery-ui/jquery-ui.js"></script>
<?php include 'admin/config.php'; ?>
<style type="text/css">
.kotak{
margin-top: 150px;
}
.kotak .input-group{
margin-bottom: 20px;
}
</style>
</head>
<body>
<div class="container">
<?php
if(isset($_GET['pesan'])){
if($_GET['pesan'] == "gagal"){
echo "<div style='margin-bottom:-55px' class='alert alert-danger' role='alert'><span class='glyphicon glyphicon-warning-sign'></span> Login Gagal !! Username dan Password Salah !!</div>";
}
}
?>
<div class="panel panel-default">
<form action="login_act.php" method="post">
<div class="col-md-4 col-md-offset-4 kotak">
<h3>Silahkan Login ..</h3>
<div class="input-group">
<span class="input-group-addon"><span class="glyphicon glyphicon-user"></span></span>
<input type="text" class="form-control" placeholder="Username" name="uname">
</div>
<div class="input-group">
<span class="input-group-addon"><span class="glyphicon glyphicon-lock"></span></span>
<input type="password" class="form-control" placeholder="Password" name="pass">
</div>
<div class="input-group">
<input type="submit" class="btn btn-primary" value="Login">
</div>
</div>
</form>
</div>
</div>
</body>
</html>
1
oke sudah berhasil, tapi dihalaman awal ada error lagi :(. ini lg adaptasi mysqli gan hehe
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\kios\admin\header.php on line 68
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\kios\admin\header.php on line 69
68.$fo=mysqli_query("select foto from admin where uname='$use'");
69. while($f=mysqli_fetch_array($fo)){
0
Itu kurang parameter aja, sebelum query select tambahkan variabel koneksinya.
$query=mysqli_query($connect,"select * from admin where uname='$uname' and pass='$pass'")or die(mysqli_error());
0
oke berhasil bang. 1 lagi bang kasusnya
Fatal error: Uncaught Error: Call to undefined function mysqli_result() in C:\xampp\htdocs\kios\admin\barang.php:27 Stack trace: #0 {main} thrown in C:\xampp\htdocs\kios\admin\barang.php on line 27
26.$jumlah_record=mysqli_query($connect, "SELECT COUNT(*) from barang");
27.$jum=mysqli_result($jumlah_record, 0);
0
Kalau munuculin jumlah pake mysqli_num_rows() juga bisa,
$jumlah_record=mysqli_query($connect, "SELECT COUNT(*) from barang");
$jml = mysqli_num_rows($jumlah_record);
echo $jml;
Kalau mau nampilin list nya bisa gini:
$jumlah_record=mysqli_query($connect, "SELECT COUNT(*) from barang");
while($row=mysqli_fetch_array($jumlah_record)){
echo $row[1];
echo "<br/>";
echo $row[2];
}
0
oke berhasil lagi bang, ini ada kasus lg klo sy mau ganti password / menyimpan barang hasilnya gini
Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\kios\admin\ganti_pass.php on line 9
7.<?php
8.if(isset($_GET['pesan'])){
9. $pesan=mysqli_real_escape_string($_GET['pesan']);
10. if($pesan=="gagal"){
0
Sertakan saja kodingnya, susah kalau ga lihat codingnya
0
nih bang errornya Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\kios\admin\ganti_pass.php on line 9
<?php
include 'header.php';
?>
<h3><span class="glyphicon glyphicon-briefcase"></span> Password</h3>
<br/><br/>
<?php
if(isset($_GET['pesan'])){
$pesan=mysqli_real_escape_string($_GET['pesan']);
if($pesan=="gagal"){
echo "<div class='alert alert-danger'>Password gagal di ganti !! Periksa Kembali Password yang anda masukkan !!</div>";
}else if($pesan=="tdksama"){
echo "<div class='alert alert-warning'>Password yang anda masukkan tidak sesuai !! silahkan ulangi !! </div>";
}else if($pesan=="oke"){
echo "<div class='alert alert-success'>Password yang anda masukkan tidak sesuai !! silahkan ulangi !! </div>";
}
}
?>
<br/>
<div class="col-md-5 col-md-offset-3">
<form action="ganti_pass_act.php" method="post">
<div class="form-group">
<input name="user" type="hidden" value="<?php echo $_SESSION['uname']; ?>">
</div>
<div class="form-group">
<label>Password Lama</label>
<input name="lama" type="password" class="form-control" placeholder="Password Lama ..">
</div>
<div class="form-group">
<label>Password Baru</label>
<input name="baru" type="password" class="form-control" placeholder="Password Baru ..">
</div>
<div class="form-group">
<label>Ulangi Password</label>
<input name="ulang" type="password" class="form-control" placeholder="Ulangi Password ..">
</div>
<div class="form-group">
<label></label>
<input type="submit" class="btn btn-info" value="Simpan">
<input type="reset" class="btn btn-danger" value="reset">
</div>
</form>
</div>
<?php
include 'footer.php';
?>
0
Jawaban Terpilih
Mysqli harus pakai koneksi database:
$pesan=mysqli_real_escape_string($connect, $_GET['pesan']);
Tapi itu udah deprecated, cek disini:
http://php.net/manual/en/mysqli.real-escape-string.php
1
sangat membantu, thanks bang salam sukses. sorry klo banyak nanya, next kayaknya bakal nanya lagi hehe
0
Mau nanya untuk edit barang saat di simpan kok gak keubah ya?
edit_laku.php
<?php
include 'header.php';
?>
<h3><span class="glyphicon glyphicon-briefcase"></span> Edit Barang</h3>
<a class="btn" href="barang_laku.php"><span class="glyphicon glyphicon-arrow-left"></span> Kembali</a>
<?php
$id_brg=mysqli_real_escape_string($connect, $_GET['id']);
$det=mysqli_query($connect, "select * from barang_laku where id='$id_brg'")or die(mysqli_error());
while($d=mysqli_fetch_array($det)){
?>
<form action="update_laku.php" method="post">
<table class="table">
<tr>
<td></td>
<td><input type="hidden" name="id" value="<?php echo $d['id'] ?>"></td>
</tr>
<tr>
<td>Tanggal</td>
<td><input name="tgl" type="text" class="form-control" id="tgl" autocomplete="off" value="<?php echo $d['tanggal'] ?>"></td>
</tr>
<tr>
<td>Nama</td>
<td>
<select class="form-control" name="nama">
<?php
$brg=mysqli_query($connect, "select * from barang");
while($b=mysqli_fetch_array($brg)){
?>
<option <?php if($d['nama']==$b['nama']){echo "selected"; } ?> value="<?php echo $b['nama']; ?>"><?php echo $b['nama'] ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td>Harga</td>
<td><input type="text" class="form-control" name="harga" value="<?php echo $d['harga'] ?>"></td>
</tr>
<tr>
<td>Jumlah</td>
<td><input type="text" class="form-control" name="jumlah" value="<?php echo $d['jumlah'] ?>"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" class="btn btn-info" value="Simpan"></td>
</tr>
</table>
</form>
<?php
}
?>
<script type="text/javascript">
$(document).ready(function(){
$('#tgl').datepicker({dateFormat: 'yy/mm/dd'});
});
</script>
<?php
include 'footer.php';
?>
update_laku.php
<?php
include 'config.php';
$id=$_POST['id'];
$tanggal=$_POST['tanggal'];
$nama=$_POST['nama'];
$harga=$_POST['harga'];
$jumlah=$_POST['jumlah'];
mysqli_query($connect, "update barang_laku set tanggal='$tanggal', nama='$nama', harga='$harga', jumlah='$jumlah' where id='$id'");
header("location:barang_laku.php");
?>
0
coba rubah
$id= $POST['id'] menjadi $id = $_GET['id]
0