db 데이터 변수 저장 채택완료

</p>

<p> </p>

<p>$zzzz = $_GET['cccc'];</p>

<p> </p>

<p> </p>

<p> </p>

<p>function updateWorkOutTime($conn, $id, $time) {</p>

<p>    $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];</p>

<p>    $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);</p>

<p>    

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

    executeQuery($conn, $update_sql);

}</p>

<p> </p>

<p>