}
//insert creator of trip to participants table
$sql2 = "INSERT INTO participants (trip_id, user_id) VALUES ('{$trip_id}', '{$tripUserId}')";
if (mysqli_query($conn, $sql2)) {
} else {
echo "Error: " . $sql2 . "<br>" . mysqli_error($conn);
}
//Select the userID of the invited user
$part_id = getUserId($partEmail);
//Insert invited user ID, tripID to participants table
insertParticipant($trip_id, $part_id);
} else {
echo "Something is wrong!";
//Something wrong with the trip ID
}
$participants = getParticipants($trip_id);
//Display input for adding expenses
echo "<h1>" . $tripName . "</h1>";
echo "Add an expense below!";
echo '<form action="expenses/submit.php" method="post">';
echo 'Expense Name: <input type="text" name="expenseTitle" id="expenseTitle"><br>';
echo 'Cost: <input type="text" name="expenseCost" id="expenseCost"><br>';
echo 'Number of Purchasers: <input type="text" name="expensePurchasers" id="expensePurchasers"><br>';
echo 'Number of Users: <input type="text" name="expenseUsers" id="expenseUsers"><br>';
echo '<select name="purchasers" multiple>';
while ($info = mysqli_fetch_array($participants)) {
echo '<option value="' . $info['user_name'] . '[]">' . $info['user_name'] . '</option>';
}
echo '</select>';
echo '<input type="hidden" name="tripId" value="' . $trip_id . '">';
echo '<input type="submit">';
}
}
$comment = getComments($_GET['id']);
$contents['comment'] = $comment;
$i = 0;
foreach ($contents['comment'] as $commentateur) {
$commentateur_photo = getMembersPicture($commentateur['id']);
if ($commentateur_photo) {
$contents['comment'][$i]['picture'] = PHOTO_PROFIL . $commentateur_photo[0];
$i++;
} else {
$contents['comment'][$i]['picture'] = IMAGES . "photo_profil_defaut.jpg";
$i++;
}
}
$participants = getParticipants($_GET['id']);
$contents['participants'] = $participants;
$i = 0;
foreach ($contents['participants'] as $participant) {
$participant_photo = getMembersPicture($participant['id']);
if ($participant_photo) {
$contents['participants'][$i]['picture'] = PHOTO_PROFIL . $participant_photo[0];
$i++;
} else {
$contents['participants'][$i]['picture'] = IMAGES . "photo_profil_defaut.jpg";
$i++;
}
}
$adresse = getAdress($_GET['id']);
$contents['adresse'] = $adresse;
$contents['tarif'] = $event['tarif'];
