PHP PHP CODE HELP

[Spaghetto]

Pa help po ano po solution dito nag lahat kasing user lumalabas e gusto ko sana isa lang kaso di ko alam kung ano po yung sulution sana matulungan nyo po ako :>
code ng index.php

 <?php
    $sql = 'select * from users';
    $result = mysqli_query($link, $sql);
    if (mysqli_num_rows($result) > 1) {
      while ($row = mysqli_fetch_assoc($result)) {
        $id = $row['id'];
        $sqli = "select * from userlog";
        $resultI = mysqli_query($link, $sqli);
          while ($rowI = mysqli_fetch_assoc($resultI)) {
              echo "<div class='image'>";
                if ($rowI['status']==0) {
                }
                else{
                  echo "<img src='uploads/pic".$id.".jpg'>";
                }
                echo "<p>".$row['username']."</p>";
                echo "</div>";
          }
      }
    }

      echo "<form action='upload.php' method='POST' enctype='multipart/form-data'>
          <input type='file' name='file'>
        <button type='submit' name='submit'>Upload</button>
        </form>";
      
  ?>

code ng upload.php

<?php
    session_start();
    include_once 'db.php';
    $id = $_SESSION['id'];

    if (isset($_POST['submit'])) {
        $files = $_FILES['file'];

        $name = $_FILES['file']['name'];
        $tmp = $_FILES['file']['tmp_name'];
        $size = $_FILES['file']['size'];
        $error = $_FILES['file']['error'];

        //first error handling - allow the user to upload only jpg, jpeg and png
        $fileExt = explode('.', $name); // user.jpg ->  [0] = user , [1] = jpg
        $ActualExt = strtolower(end($fileExt));
        $allowed = array('jpg', 'jpeg', 'png');

        if (in_array($ActualExt, $allowed)) {
            if($error === 0){
                if($size < 1000000){
                    $newName = 'Pic'.$id.".".$ActualExt;
                    $dest = "uploads/".$newName;
                    move_uploaded_file($tmp, $dest);
                    $sql = "update profile set status=0 where userid='$id';";
                    mysqli_query($link, $sql);
                    header("location: index.php");
                } else{
                    echo "You file is too big.";
                }
            } else{
                echo "You have an error upload the file.";
            }
        } else{
            echo "You cannot Upload a file in that extention.";
        }

    }

 

[PHC_Jayvee]

baguhin mo sql

select * from user where username='username you want to show'

 

[Migfus]

Pwede din "LIMIT 1" sa sql

 

[PayamanBoy]

Line 7 ng index.php modifyt mo into:

$sqli = "select * from userlog where id='$id'";

yan nalang kung ang gusto mo ilagay yung specific user

 

[Spaghetto]

di ko po get :<

 

[KarmaPanda]

line 2 dito pa lang sa query na to $sql = 'select * from users'; dapat naka WHERE claus kana
WHERE id=user id logged in user
dapat id para unique

 

[Spaghetto]

line 2 dito pa lang sa query na to $sql = 'select * from users'; dapat naka WHERE claus kana
WHERE id=user id logged in user
dapat id para unique

$sql = "SELECT * from users where username = '".$_SESSION['username']."'"; ito po ginamit ko ok napo kaso nag repeat yung nakalogin

 

[Spaghetto]

$sql = "SELECT * from users where username = '".$_SESSION['username']."'"; ito po ginamit ko ok napo kaso nag repeat yung nakalogin

Pwede din "LIMIT 1" sa sql

pano po ito ilagay?

 

[KarmaPanda]

$row['status']

 

[Migfus]

Last part po sya after ng where

 

[Spaghetto]

maraming salamat po <3