Kann mir bitte jemand sagen, warum er die Anfrage 2x an die Datenbank sendet, wenn ich auf den "Send Friendship Request"-Link klicke?
Code:
if($getid != $userid)
{
$query = mysqli_query($con, "SELECT id FROM friends WHERE (user1_id = '$userid' AND user2_id = '$getid') OR (user1_id = '$getid' AND user2_id = '$userid')");
$numrows = mysqli_num_rows($query);
if($numrows == 1)
{
echo "<a href=''>Already Friends</a> | <a href=''>Delete Friendship</a>";
}
else
{
$from_query = mysqli_query($con, "SELECT id FROM friends_req WHERE from_id = '$getid' AND to_id = '$userid'");
$to_query = mysqli_query($con, "SELECT id FROM friends_req WHERE from_id = '$userid' AND to_id = '$getid'");
$from = mysqli_num_rows($from_query);
$to = mysqli_num_rows($to_query);
if($from > 1)
{
echo "<a href=''>Ignore</a> | <a href=''>Accept Friendship</a>";
}
else if($to > 1)
{
echo "<a href='friends_request.php?action=cancel&id=$getid'>Cancel Request</a>";
}
else
{
echo "<a href='friends_request.php?action=send&id=$getid'>Send Friendship Request</a>";
}
}
}
Code:
<?php date_default_timezone_set("Europe/Berlin") ?>
<?php require_once("style/top.php"); ?>
<?php
$action = $_GET['action'];
$getid = $_GET['id'];
if($action == 'send')
{
mysqli_query($con, "INSERT INTO friends_req (id, from_id, to_id) VALUES ('', $userid, '$getid')");
}
if($action == 'cancel')
{
mysqli_query($con, "DELETE FROM friends_req WHERE from_id = '$userid' AND to_id = '$getid'");
}
?>
Kommentar