');
print('UserId:');
print('');
print('');
print('');
return;
}
$userId=$_POST['userId'];
// setup MySql DB
$link = mysqli_connect('localhost', 'root', '');
if (!$link) die('Cannot connect DB'.mysqli_error());
$db_selected = mysqli_select_db($link, 'opengatem');
if (!$db_selected) die('cannot select DB'.mysqli_error());
mysqli_set_charset($link, 'utf8');
// if data is posted, update DB
$i=0;
while(isset($_POST['macAddress'][$i])){
if($_POST['status'][$i]=='D'){
// on delete
// UPDATE macaddrs SET status="D",device="postdata",limitdate=now(),mailAddress="postdata"
// WHERE macAddress="postdata" and userId="postdata" and status!="D"
$result = mysqli_query($link, 'UPDATE macaddrs SET status="'.$_POST['status'][$i]
.'", device="'.$_POST['device'][$i].'", limitDate=now()'
.', mailAddress="'.$_POST['mailAddress'][$i].'" WHERE macAddress="'
.$_POST['macAddress'][$i].'" and userId="'.$userId.'" and status!="D"');
if (!$result) die('Fail update query'.mysqli_error());
}else if($_POST['status'][$i]=='A'||$_POST['status'][$i]=='I'){
// other cases
// UPDATE macaddrs SET status="D",device="postdata",limitdate="postdata",mailAddress="postdata"
// WHERE macAddress="postdata" and userId="postdata" and status!="D"
$result = mysqli_query($link, 'UPDATE macaddrs SET status="'.$_POST['status'][$i]
.'", device="'.$_POST['device'][$i].'", limitDate="'.$_POST['limitDate'][$i]
.'", mailAddress="'.$_POST['mailAddress'][$i].'" WHERE macAddress="'
.$_POST['macAddress'][$i].'" and userId="'.$userId.'" and status!="D"');
if (!$result) die('Fail update query'.mysqli_error());
}else{
print("Illegal status value");
}
$i++;
}
// get data from DB to show on web
$result = mysqli_query($link, 'SELECT macAddress,status,device,limitDate,mailAddress FROM macaddrs where userId="'
.$userId.'"');
if (!$result) die('Fail select query'.mysqli_error());
// print html form
print('');
$close_flag = mysqli_close($link);
?>