PHP - Staff 4 On 4 Off Rota

Hello!

Hello:

I am building a Staff list, that I want to use to allow the owner of a company to upload a photo, name, phone, and email of each person on his staff.

I am using this approach from a tutorial I found online:
Database:
Code: [Select]
CREATE TABLE employees (id int(5), name VARCHAR(30), email VARCHAR(30), phone VARCHAR(30), photo VARCHAR(30))

Form:
Code: [Select]
<form enctype="multipart/form-data" action="Add.php" method="POST">
Name: <input type="text" name="name"><br>
E-mail: <input type="text" name = "email"><br>
Phone: <input type="text" name = "phone"><br>
Photo: <input type="file" name="photo"><br>
<input type="submit" value="Add">
</form>

Add.php
Code: [Select]
<?php
include('include/myConn.php');
?>

...

<?php 

$target = "images/"; 
$target = $target . basename( $_FILES['photo']['name']); 

$name=$_POST['name']; 
$email=$_POST['email']; 
$phone=$_POST['phone']; 
$pic=($_FILES['photo']['name']); 
 
mysql_query("INSERT INTO `employees` VALUES ('$name', '$email', '$phone', '$pic')") ; 
 
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 
{
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
} 
else 
{ 

echo "Sorry, there was a problem uploading your file."; 
} 
?>

Display.php
Code: [Select]
<?php
include('include/myConn.php');
?>

...

<?php

$data = mysql_query("SELECT * FROM employees") or die(mysql_error()); 

while($info = mysql_fetch_array($data));

{
echo "<img src=images/".$info['photo'] ."> <br>"; 
echo "<b>Name:</b> ".$info['name'] . "<br> "; 
echo "<b>Email:</b> ".$info['email'] . " <br>"; 
echo "<b>Phone:</b> ".$info['phone'] . " <hr>";
} 

?>

I am not getting any errors and the photo is uploaded to the "images" folder, but none of the data displays ...

I do not see why ..

Any ideas?

Also, if any one has done something like this before and has a better approach to doing this, I am all ears.

I do want to allow the owner to edit and delete the profiles as well.

Thanks.

I have 3 staff members that need to pick vacation in a certain order.
Each have X weeks vacation and can pick off a calendar their choice 1-3 weeks  per round.
I'm trying to loop through the DB to find who is next to pick with weeks left

~~~~~~First round of picking~~~~~~
STAFF 1 - PICK ORDER 1 -  3 weeks available
STAFF 2 - PICK ORDER 2 -  5 weeks available
STAFF 3 - PICK ORDER 3 -  3 weeks available

Staff 1 takes 2 Weeks
Staff 2 takes 1 Weeks
Staff 3 takes 3 Weeks

~~~~~~Second round of picking~~~~~~
STAFF 1 - PICK ORDER 1 -  1 weeks available
STAFF 2 - PICK ORDER 2 -  4 weeks available
STAFF 3 - PICK ORDER 3 -  No weeks left

Staff 1 takes 1 Weeks
Staff 2 takes 3 Weeks
Staff 3 Skipped

~~~~~~Third round of picking~~~~~~
STAFF 1 - PICK ORDER 1 -  No weeks left
STAFF 2 - PICK ORDER 2 -  1 weeks available
STAFF 3 - PICK ORDER 3 -  No weeks left

Staff 1 Skipped
Staff 2 takes 1 Weeks
Staff 3 Skipped

~~~~~~~~~~~~
All staff 0 weeks left end

--calendar.php--
$year=2020;
$sql = "SELECT * FROM vac_admin WHERE pick_year='$year';
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
$row_admin = mysqli_fetch_assoc($result);
}
$current_pick_staff = $row_admin['current_pick_staff'];

$sql = "SELECT *  FROM vac_pick_order WHERE  pick_year='$year'  &&  pick_order = '$current_pick_staff'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
if($row['vac_c_counter'] < 0){
$emp_num = $row['emp_num'];
}ELSE{
??????????????????
goto next staff with weeks > 0
?????Somthing like
if ($current_pick_staff == 3){
	$current_pick_staff = 1;
}ELSE{
	$current_pick_staff++;
}
??????????????????  
}

~<FORM>~~~~~~~~~~~~~~~~~~~~~
Staff with $emp_num can now pick ~~~~~~ $_POST -> $date = XXXX-XX-XX; $num_weeks = X; $emp_num;
~</FORM>~~~~~~~~~~~~~~~~~~~~~

--process.php--
$year = 2020;
$date = $_POST['date'];
$num_weeks = $_POST['num_weeks'];
$emp_num = $_POST['emp_num'];

$sql = "INSERT INTO vac_picks (pick_year,emp_num,date) VALUES ($year,$emp_num,$date)";
$sql = "UPDATE vac_pick_order SET vac_c_counter=vac_c_counter - $num_weeks WHERE emp_num='$emp_num';
$sql = "UPDATE vac_admin SET pick_order=pick_order +1 WHERE pick_year='$year' ;

Then back to calendar.php until all weeks gone.