Postingan lainnya
edit data dengan session di php mysqli , muncul Notice: Undefined index: username in .
Error di line $username = $_POST['username']; dan teman-temannya di bawah $_POST['update']. muncul error Notice: Undefined index: username in C:\xampp\htdocs\andromax\inc\akun\ubahAkun.php on line 57
Notice: Undefined index: nama in C:\xampp\htdocs\andromax\inc\akun\ubahAkun.php on line 58
Notice: Undefined index: email in C:\xampp\htdocs\andromax\inc\akun\ubahAkun.php on line 59
Notice: Undefined index: nohand in C:\xampp\htdocs\andromax\inc\akun\ubahAkun.php on line 60
Notice: Undefined index: alamat in C:\xampp\htdocs\andromax\inc\akun\ubahAkun.php on line 61
Notice: Undefined index: tahunKeluar in C:\xampp\htdocs\andromax\inc\akun\ubahAkun.php on line 62 saya masih baru di forum. mohon bantuannya :) terima kasih.
<?php
$host = "localhost";
$user = "root";
$pass = "";
$dbname = "db_jadiklan";
$link = new mysqli($host,$user,$pass,$dbname);
$username =$_SESSION['username'];
$nama =$_SESSION['nama'];
$email =$_SESSION['email'];
$nohand =$_SESSION['nohand'];
$alamat =$_SESSION['alamat'];
$tahunKeluar =$_SESSION['tahunKeluar'];
$sql = "SELECT * FROM tm_driver WHERE username = '$username'";
$result = mysqli_query($link, $sql);
$data = mysqli_fetch_array($result);
if (isset($_POST['update'])){
$username = $_POST['username'];
$nama = $_POST['nama'];
$email = $_POST['email'];
$nohand =$_POST['nohand'];
$alamat =$_POST['alamat'];
$tahunKeluar =$_POST['tahunKeluar'];
$queryUpdate = " UPDATE tm_driver SET nama = '".$nama."', email ='".$email."',nohand='".$nohand."',alamat='".$alamat."', tahunKeluar='".$tahunKeluar."' where username = '".$username."'";
$resultUpdate = mysqli_query($link, $queryUpdate);
if ($resultUpdate){
echo "<script>alert('simpan berhasil')</script>";
}
else {
echo "<script>alert('gagal simpan')</script>";
}
}
?>
2 Jawaban:
berarti $username = $_POST['username'] dan lain-lain ga ada.
Jawaban Terpilih
<?php
//Tambah ini buat mulai session
session_start();
$host = "localhost";
$user = "root";
$pass = "";
$dbname = "db_jadiklan";
$link = new mysqli($host,$user,$pass,$dbname);
$username =$_SESSION['username'];
$nama =$_SESSION['nama'];
$email =$_SESSION['email'];
$nohand =$_SESSION['nohand'];
$alamat =$_SESSION['alamat'];
$tahunKeluar =$_SESSION['tahunKeluar'];
$sql = "SELECT * FROM tm_driver WHERE username = '$username'";
$result = mysqli_query($link, $sql);
$data = mysqli_fetch_array($result);
if (isset($_POST['update'])){
$username = $_POST['username'];
$nama = $_POST['nama'];
$email = $_POST['email'];
$nohand =$_POST['nohand'];
$alamat =$_POST['alamat'];
$tahunKeluar =$_POST['tahunKeluar'];
$queryUpdate = " UPDATE tm_driver SET nama = '".$nama."', email ='".$email."',nohand='".$nohand."',alamat='".$alamat."', tahunKeluar='".$tahunKeluar."' where username = '".$username."'";
$resultUpdate = mysqli_query($link, $queryUpdate);
if ($resultUpdate){
echo "<script>alert('simpan berhasil')</script>";
}
else {
echo "<script>alert('gagal simpan')</script>";
}
}
?>
Kurang session_start(); coba copas code diatas