');
print('UserId:');
print('');
print('');
print('');
return;
}
$userId=$_POST['userId'];
// setup MySql DB
$link = mysql_connect('localhost', 'root', '');
if (!$link) die('Cannot connect DB'.mysql_error());
$db_selected = mysql_select_db('opengatem', $link);
if (!$db_selected) die('cannot select DB'.mysql_error());
mysql_set_charset('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 = mysql_query('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'.mysql_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 = mysql_query('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'.mysql_error());
}else{
print("Illegal status value");
}
$i++;
}
// get data from DB to show on web
$result = mysql_query('SELECT macAddress,status,device,limitDate,mailAddress FROM macaddrs where userId="'
.$userId.'"');
if (!$result) die('Fail select query'.mysql_error());
// print html form
print('');
$close_flag = mysql_close($link);
?>