db 데이터 변수 저장

$zzzz = $_GET['cccc'];

 

 

 

function updateWorkOutTime($conn, $id, $time) {

    $today = date("Y-m-d");
    $ssss= mysqli_query($conn, "SELECT work_in  FROM very_work_list WHERE work_id='$zzzz' ");
    $row = mysqli_fetch_array($ssss);
    $data41 = $row[0];

    $check_aa_sql = "SELECT id, work_name, work_intime, work_outtime FROM very_work_time WHERE id = '$id' ORDER BY work_datetime DESC LIMIT 1";
    $check_aa_result = mysqli_query($conn, $check_aa_sql);
    $result11 = mysqli_query($conn, "SELECT  work_intime FROM very_work_time WHERE id = '$id'");
     $row11 = mysqli_fetch_array($result11);
     $data11 = $row11[0];
 
    $datatime = ($data11);
      $time_diff = ((strtotime(date('Y-m-d H:i:s')) - strtotime($datatime)))/3600;
      $var = floor($time_diff);

    
    $update_sql = "UPDATE very_work_time SET work_outtime = ('$today $data41') WHERE id = '$id' AND dddd < '$var' ";
    executeQuery($conn, $update_sql);
}