<?php
	include ('config.php');
	$fp = fopen('php://input', 'r');
	$raw = stream_get_contents($fp);
	//$raw = file_get_contents('php://input');
	$dblineid = mysqli_connect($LID_url, $LID_username, $LID_password) or trigger_error(mysqli_error(),E_USER_ERROR); 
	mysqli_select_db($dblineid,$LID_db);
	mysqli_set_charset($dblineid,"utf8");
	$json_a = json_decode($raw,true);
	echo '<br><br> Hospital : '.$json_a['HospID'].'<br>';
	foreach ($json_a['data'] as $key) {
		$pname = $key['pname'];
		$lname =$key['lname'];
		if (empty($lname)) {
			$nAt = strpos($pname,' ');
			if ($nAt > 0) {
				$lname = trim(substr($pname,$nAt+1));
				$pname = substr($pname,0,$nAt);
			}
		}
		// สำหรับรับใหม่
		$_sql = "Insert into user_line (line_id,cid,pname,lname,hn,tel,hospregist) value ('".$key['line_id']."','".$key['cid']."','{$pname}','{$lname}','".$key['hn']."','".$key['tel']."','".$json_a['HospID']."')";
		//สำหรับ ปรับปรุง
		//$_sql = "update user_line set hospregist='".$json_a['HospID']."' where cid='".$key['cid']."'  and line_id = '".$key['line_id']."'";
		echo 'SQL : '.$_sql;
		if (mysqli_query($dblineid,$_sql)) echo ' -> บันทึก<br/>';
		else echo " ->  ไม่บันทึก<br/>";
	}
?>