从上传查询中查看特定ID

Question

in my project there are 2 user, the admin uploading file into db stored in tbl_upload

upload.php

  if(move_uploaded_file($file_loc,$folder.$final_file)) {
      $sql="INSERT INTO tbl_uploads(emp_id,file,ext,size)
      VALUES('$file_id','$final_file','$file_type','$new_size')";
      mysql_query($sql);

and i already stored the id from tbl_employee and now my question is how can i view the specific id from view table

view.php

$sql="SELECT * FROM tbl_uploads";
    $result_set=mysql_query($sql);
    while($row=mysql_fetch_array($result_set))

this is where the files going $folder="uploads/"; im thinking foreign key but i dont know where to start. please help. thanks in advance

Answer 1

You can get the last autoincremented ID using mysql_insert_id(). Filtering results by specific row (ID in your case) is done by WHERE clause.

$id_upload = mysql_insert_id();
$sql="SELECT * FROM uploads WHERE id = ".(int)$id_upload." LIMIT 1";