user_friends_count - PHP Online
Form of PHP Sandbox
Enter Your PHP code here for testing/debugging in the Online PHP Sandbox. As in the usual PHP files, you can also add HTML, but do not forget to add the tag <?php
in the places where the PHP script should be executed.
Result of php executing
Full code of user_friends_count.php
- <?php
- function cot_social_remove_friend($userid, $friendid)
- {
- $sql1 = $db->query("SELECT * FROM $db_cot_social_friendslist WHERE userid = $userid AND friendid = $friendid LIMIT 1");
- $execute1 = $sql1->rowCount();
- $sql2 = $db->query("SELECT * FROM $db_cot_social_friendslist WHERE userid = $friendid AND friendid = $userid LIMIT 1");
- $execute2 = $sql2->rowCount();
- if($execute1 > 0){$data = $sql1->fetch();}
- if($execute2 > 0){$data = $sql2->fetch();}
- $db->delete($db_cot_social_friendslist, "id='".$data['id']."' LIMIT 1");
- $friendscount_userid = $db->query("SELECT user_friends_count FROM $db_users WHERE user_id=" . $userid)->fetchColumn();
- $friendscount_friendid = $db->query("SELECT user_friends_count FROM $db_users WHERE user_id=" . $friendid)->fetchColumn();
- if ($friendscount_userid>0)
- {
- $db->query("UPDATE $db_users SET user_friends_count=user_friends_count-1 WHERE user_id=" . $userid);
- }
- if ($friendscount_friendid>0)
- {
- $db->query("UPDATE $db_users SET user_friends_count=user_friends_count-1 WHERE user_id=" . $friendid);
- }
- }