hi I am developing a website, that on registration form, takes username password and an image to upload into the database, creating a dedicated folder for each user. Now what I am trying to do is to get the image when the user logs in, obviously the image that should be displayed would be the one of the user uploaded when registering. Is it possible to do so without id but using username folder? This is how I upload the image.
$username = $_POST ['username'];
$password = $_POST ['password'];
$email = $_POST ['email'];
$image = $_FILES['image']['name'];
$image_tmp = $_FILES['image']['tmp_name'];
$s = " select * from usertable where username = '$username'";
$result = mysqli_query($con, $s);
$num = mysqli_num_rows($result);
if($num == 1){
echo "Username Already Taken";
}else{
mkdir("Images/$username", 0777, true);
move_uploaded_file($image_tmp,"Images/$username/$image");
$reg= "insert into usertable(username, password, email,imagename) values ('$username', '$password', '$email','$image')";
mysqli_query($con, $reg);
echo "registration successfull";
}
login form
$username = $_POST ['username'];
$password = $_POST ['password'];
$s = " select * from usertable where username = '$username' && password = '$password'";
$dirname = "images/$username";
$images = glob($dirname."*.png");
$result = mysqli_query($con, $s);
$num = mysqli_num_rows($result);
if($num == 1){
$_SESSION['images']= $images;
$_SESSION['username']= $username;
header('location:home.php');
}else{
header('location:index.php');
}
Home page
<title>Welcome</title>
</head>
<body >
<a href ="logout.php"> Log Out </a>
<img src="<?php echo $_SESSION['images']; ?>"/>
<h1>Welcome <?php echo $_SESSION['username']; ?></h1>