하루에 한번만 insert 채택완료

</p>

<p><?php

$conn = mysqli_connect("localhost", "**", "**", "**");

 </p>

<p>

function executeQuery($conn, $sql) {

    if (!mysqli_query($conn, $sql)) {

        echo "에러: " . $sql . "
" . mysqli_error($conn);

        exit;

    }

}</p>

<p>    

function insertWorkTime($conn, $zzzz, $time, $ip) {</p>

<p>

    $insert_sql = "INSERT INTO very_work_time (work_id, work_name, work_group, work_intime, work_outtime, work_datetime, work_ip, work_total)

                   SELECT id, work_name, work_group, '$time', '', '$time', '$ip', '$zzzz'

                   FROM very_work_list

                   WHERE work_hp = '$zzzz'";</p>

<p>

    executeQuery($conn, $insert_sql);

}

 

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

    $update_sql = "UPDATE very_work_time SET work_outtime = '$time' WHERE id = '$id'";

    executeQuery($conn, $update_sql);

}

 

$zzzz = $_GET['cccc'];

$time = date("Y-m-d H:i:s");

$today = date("Y-m-d");

$ip = $_SERVER['REMOTE_ADDR'];

 

$check_sql = "SELECT id, work_name, work_intime, work_outtime FROM very_work_time WHERE work_total = '$zzzz' AND DATE(work_datetime) = '$today' ORDER BY work_datetime DESC LIMIT 1";

$check_result = mysqli_query($conn, $check_sql);</p>

<p>$result = mysqli_query($conn,"SELECT work_name, aaaa, bbbb FROM very_work_list where work_hp='$zzzz' ");</p>

<p>$row = mysqli_fetch_array($result);

$data = $row[0];

$data1 = $row[1];

$data2 = $row[2];

 

if ($check_result && mysqli_num_rows($check_result) > 0) {

    $row = mysqli_fetch_assoc($check_result);

    if (empty($row['work_outtime'])) {

        updateWorkOutTime($conn, $row['id'], $time);

        echo $data,"6", $data2;

    } else {

        insertWorkTime($conn, $zzzz, $time, $ip);

        echo $data,"6", $data1;</p>

<p>

    }

} else {

    insertWorkTime($conn, $zzzz, $time, $ip);

    echo $data,"6", $data1;</p>

<p>

}

?></p>

<p>