<?php
session_start();
if(!$_SESSION['researcher_id']) {
    exit;
}
require_once 'db.function.php';


// insert information into experiment table
$_GET = array_map('strip_tags', $_GET);
$db = getDB();
if(!trim($_GET['exp_date'])) {
    $_GET['exp_date'] = date('Y-m-d H:i:s');
} else {
    $_GET['exp_date'] = date('Y-m-d H:i:s', strtotime($_GET['exp_date']));
}
$_GET['researcher_id'] = $_SESSION['researcher_id'];

$qmarks = array_fill(0, count($_GET), '?');
$db->query("insert into experiment (". join(',', array_keys($_GET)) . ") values (". join(',', $qmarks) . ")", array_values($_GET));

$db->commit();
$_GET['err'] = '';
$_GET['id'] = $db->getOne("select last_insert_id()");
$_GET['exp_date'] = date('n/j/y', strtotime($_GET['exp_date']));
print json_encode($_GET);

?>