I am a beginner in PHP. I have this function.
function create_group($name, $description, $invites){
global $link;
$name = mysqli_real_escape_string($link, $name);
$description = mysqli_real_escape_string($link, $description);
$names = mysqli_query($link, "SELECT `group_name` FROM `groups` WHERE `group_name` = '$name'");
if(mysqli_num_rows($names) == 0 && mysqli_num_rows($descriptions) == 0){
mysqli_query($link, "INSERT INTO `groups` (`group_name`, `group_description`) VALUES ('$name', '$description')");
}else{
print 'Group with that name/description already exists.';
}
$result = mysqli_query($link, "SELECT `group_id` FROM `groups` WHERE `group_name` = '$name'");
foreach($result as $resul){
foreach($resul as $resu){
$group_id = $resu;
}}}
$invitesarr = explode(',', $invites);
foreach($invites as $invite){
$idres = mysqli_query($link, "SELECT `user_id` FROM `users` WHERE `username` = '$invite'");
if(mysqli_num_rows($idres) == 0){
exit("1 or more of the users that you entered do(es) not exist!");
}else{
foreach($idres as $idarr){
foreach($idarr as $id){
mysqli_query($link, "INSERT INTO `group_members` (`group_id`, `user_id`, `confirmed?`) VALUES ('$group_id', '$id', 0)");
}}}}
$link is an existing database connection. I get the variables for the argument from this page:
<?php
include "function_inc.php";
if(isset($_POST['name'], $_POST['description'], $_POST['invites'])){
create_group($_POST['group_name'], $_POST['description'], $_POST['invites']);
}
?>
<html>
<body>
<form action="new_group.php" method="post">
<div>
<label for="group_name">Group Name: </label>
<input type="text" name="group_name" id="group_name" />
</div>
<div>
<label for="invites">Invite...</label>
<input type="text" name="invites" id="invites" />
</div>
<div>
<label for="description">Description: </label>
<textarea name="description" id="description"></textarea>
</div>
<div>
<input type="submit" value="Create" />
</div>
</form>
</body>
</html>
I don't understand why I then get the following messages:
Notice: Undefined variable: invites in /home/peter/Documents/Logarithm/function_inc.php on line 49
Notice: Undefined variable: invites in /home/peter/Documents/Logarithm/function_inc.php on line 50
Please help me; I have been looking at this for hours!
Thanks in advance.
EDIT: Thank you, Benjamin Such! I have now solved the variable message, however I have a new problem: Warning: Invalid argument supplied for foreach(). Any help would be much appreciated.