xx

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "biogrid_datacenter";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$f=fopen("var","a+");

//$val="aaa001#ecg#-10#2016#3#27#78075604#492#492#491#1023#491#492#493#1022#492#490#485#481#479#481#490#1022#528#550#566#1023#560#537#508#1023#468#465#470#1022#484#488#491#1022#495#495#496#496#496#496#496#496#497#497#497#497#497#498#498#1022#498#499#499#500#500#500#501#501#502#502#502#1023#503#503#503#";

foreach ( $_POST as $key => $val )
{


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


$accel;
$heart_rate;
	fwrite($f,"$val\n");
    $arr=explode('#',$val);
    $user=$arr[0];

    $query="INSERT INTO ";

    if ($arr[1]=="ecg")
	$query = $query . "mp_00_waveforms (device_id, ecg, timestamp) VALUES ('BGP_ECG_002', $arr[7], '$today')";


	if ($arr[1]=="general")
	{
		//$query_value = $query . "mp_00_values (accel, device_id, heart_rate, timestamp) VALUES ('$arr[11]', 'BGP_ECG_002', '$arr[7]', '$today')";
		(float)$accel=$arr[11];
		$heart_rate=$arr[7];

	}


	if ($arr[1]=="rr")
	{
		//$query_value = $query . "mp_00_values (accel, device_id, heart_rate, timestamp) VALUES ('$arr[11]', 'BGP_ECG_002', '$arr[7]', '$today')";
		$query_value="INSERT INTO mp_00_values (accel, device_id, heart_rate, timestamp,r_r_interval) VALUES ($accel, 'BGP_ECG_002', $heart_rate, '$today', $rr_val)";
		for ($i=8; $i<count($arr)-2; $i++)
		{

			if ($arr[$i] < 4000)
			{$rr_val=$arr[$i];
				$query_value =$query_value . ",($accel, 'BGP_ECG_002', $heart_rate, '$today', $rr_val)";
			}
    }
	}

    for ($i=8; $i<count($arr)-2; $i++)
    {
	$val=$arr[$i];
	if ($val < 1000 && $val > 200)
		{
			$query =$query . ",('BGP_ECG_002', $val, '$today')";
		}
    }
    mysqli_query($conn, $query);
	mysqli_query($conn, $query_value);
	//mysqli_query($conn, $query);

    fwrite($f,"$query\n");

}
fclose($f);



mysqli_close($conn);
?>