How to update a specific row in a mysql table using php ?

S

Sultan

New member
I'm trying to make a user friend request system in php.
I made a table in " friends " in mysql with these fields
iduser_idfriend_idstatusdate

id = auto increment
user_id = friend request receiver id
friend_id = friend request sender id
status = 0 (by default and should be UPDATE with 1 at acceptance of request)
date = at which request is sent

Now I wrote these two scripts.
I want that if I receive the request from id 2 and I click accept, the " status " should be update on that specific row
where friend_id is 2.

Please suggest me correct code.

friend _request.php code is here...

<?php

session_start();

require_once "connect_i.php";

mysql_connect("localhost","root","");
mysql_select_db("mydatabase");

?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<table border="0">
<form method="post" action="fraction.php">
<tr>
<td><b>Friend Rquests:</b></td>
<td>
<?php
$id = isset($_SESSION['id']);
$sqlCommand =
" SELECT COUNT(`id`) AS numbers FROM `friends`
WHERE `user_id` = '$id' AND `status`='0' ";
$query =
mysqli_query($myConnection, $sqlCommand)
or die (mysqli_error());
$result = mysqli_fetch_assoc($query);

$newrequests = $result['numbers'];

?>

You have
<?php echo $newrequests; ?>
friend requests.
</td>
</tr>
<tr>
<td>

<?php

$Members =
mysql_query(" SELECT friend_id FROM friends WHERE status='0'")
or die(mysql_error());
$numRowsMembers = mysql_num_rows($Members);

$one = mysql_fetch_array($Members);

for($count = 1; $count <= $numRowsMembers; $count++)
{
$name = mysql_fetch_array($Members);

echo '<b>From:</b>'.$name['friend_id'].'<br />
<input type="submit" name="accept" id="accept" value="Accept">
<input type="submit" name="reject" id="reject" value="Reject"><hr />';
}

?>

<input name="senddate" type="hidden" id="senddate" value="<?php echo date("l, jS F Y, g:i:s a"); ?>" />

</td>
</tr>
</form>
</table>

</body>
</html>

fraction.php code is here...

<?php

session_start();

mysql_connect("localhost","root","");
mysql_select_db("mydatabase");

if($_POST['accept']){
$id = $_SESSION['id'];
$date = $_POST['senddate'];
$sender = $_POST['friend_id'];

mysql_query(" UPDATE friends SET `status`='1' WHERE `user_id`='$id' AND `friend_id`= '$sender' ") or die(mysql_error());
echo "You accepted the friend request.";
} else if($_POST['reject']){
$id = $_SESSION['id'];
mysql_query("DELETE FROM friends WHERE `user_id`='$id' AND `friend_id`= '$sender' ");
echo "You rejected the friend request.";
}
else
die("Could not take action...");

?>
 
Back
Top