<?php
date_default_timezone_set("Asia/Bangkok");
    require("config.php");
    $stmt ="select * from employee1";
    $query = sqlsrv_query( $conn, $stmt);
    if($stmt === false){
        die(print_r(sqlrv_errors(),true));
    }

        $txt =  "\nวันนี้เป็นวันคล้ายวันเกิดของ ";
        $irows=0;
        while ($result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)){

        if($irows <=15)  
        {
            $txt .=  "\n - คุณ$result[Name1]  $result[Lastname1] ($result[Nickname]) $result[positionn] $result[Dept] $result[branch] " ;

            if ($result[Comment] != null){
            $image=$result[Comment] ;
            }

        }
        $irows =  ($irows+1)  ;
        
    }
    $txt .="\nขอเชิญพี่น้องครอบครัวเวลเกรด ร่วมอวยพรวันเกิดกันค่ะ";
?>

<?php
$lineapi ="xxxxx";
$message =$txt;

$chOne = curl_init();
curl_setopt( $chOne, CURLOPT_URL, "https://notify-api.line.me/api/notify");
curl_setopt( $chOne, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt( $chOne, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt( $chOne, CURLOPT_POST, 1);
curl_setopt( $chOne, CURLOPT_POSTFIELDS, $message);
curl_setopt( $chOne, CURLOPT_POSTFIELDS, "message=$message&imageThumbnail=$image&imageFullsize=$image");
curl_setopt( $chOne, CURLOPT_FOLLOWLOCATION, 1);
$headers = array( 'Content-type: application/x-www-form-urlencoded', 'Authorization: Bearer '.$lineapi.'', );  
curl_setopt($chOne, CURLOPT_HTTPHEADER, $headers);
curl_setopt( $chOne, CURLOPT_RETURNTRANSFER, 1);
$result = curl_exec( $chOne );
if(curl_error($chOne)) { echo 'error:' . curl_error($chOne); }
else { $result_ = json_decode($result, true);
echo "status : ".$result_['status']; echo "message : ". $result_['message']; }
curl_close( $chOne );
echo "\r\n";

?>