";
// echo "
Name: " . ($_POST['name'] ?? '');
// echo "
Status: " . ($_POST['status'] ?? '');
$num_assets = (int) ($_POST['no_asset_row'] ?? 0);
// echo "
Number of Asset Rows: " . $num_assets;
$num_members = (int) ($_POST['no_team_row'] ?? 0);
// echo "
Number of Member Rows: " . $num_members;
// echo "
";
// get all the assets and put them in an array
$assets = [];
for ($i = 0; $i <= $num_assets; $i++) {
$asset_value = $_POST["assigned_asset_$i"] ?? ' ';
if ($asset_value == ' ') {
continue;
} else {
$assets[] = ["assigned_assets" => $asset_value];
// echo "
INDEX: " . $i;
// echo "
Assets: " . $asset_value;
// echo " Added
";
}
}
$all_assets = array_column($assets, 'assigned_assets');
$assets_names = implode(", ", $all_assets);
// echo "
Asset Names : " . $assets_names;
// echo "
";
$members = [];
for ($j = 0; $j <= $num_members; $j++) {
$member_value = $_POST["team_members_$j"] ?? ' ';
// echo "
Member Value: " . $member_value;
echo "UPDATE users SET team_id = '{$_POST['name']}' WHERE username = '$member_value'";
$db->query("users", "UPDATE users SET team_id = '{$_POST['name']}' WHERE username = '$member_value'");
if ($member_value == ' ') {
continue;
} else {
$members[] = ["team_members" => $member_value];
// echo "
INDEX: " . $j;
// echo "
Team Members: " . $member_value;
// echo " Added
";
}
}
$all_members = array_column($members, 'team_members');
$member_name = implode(", ", $all_members);
// echo "
Member Names : " . $member_name;
// echo "
";
// echo "UPDATE `teams` SET `name`='{$_POST['name']}',`assigned_assets`='$assets_names',`team_members`='$member_name',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";
$res = $db->query("teams ", "UPDATE `teams` SET `name`='{$_POST['name']}',`assigned_assets`='$assets_names',`team_members`='$member_name',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");
if ($res) {
echo "";
} else {
echo 0;
}