<?php include("config/main_function.php"); date_default_timezone_set("Asia/Bangkok"); $connection = connectDB("30!dkxpGq1%21l"); $userId = $_POST["userId"]; $sql_check = "SELECT lr.*, lt.temp_menu, w.username, w.worker_name FROM tbl_line_register lr LEFT JOIN tbl_line_temp lt ON lt.worker_id = lr.worker_id AND lt.line_id = lr.line_id LEFT JOIN tbl_worker w ON w.worker_id = lr.worker_id WHERE lr.line_id = '$userId' AND w.resign_date IS NULL;"; $rs_check = mysqli_query($connection, $sql_check); $cmt_check = mysqli_num_rows($rs_check); $row_check = mysqli_fetch_array($rs_check); if($cmt_check > 0){ $result = 1; }else{ $result = 0; } $arr['worker_id'] = $row_check["worker_id"]; $arr['username'] = $row_check["username"]; $arr['worker_name'] = $row_check["worker_name"]; $arr['result'] = $result; echo json_encode($arr); ?>