MySql/PHP Query Returning Empty

bione_x1

New Member
Here is my code:\[code\]$result = mysqli_query($dbconnection, Data::followUser($user_id, $followUser_id));\[/code\]\[code\]$result\[/code\] returns empty here.\[code\]followUser\[/code\] method in class \[code\]Data\[/code\] \[code\]public static function followUser($user_id, $followUser_id) { global $database; $query = " SELECT * FROM profile_follow WHERE user_id = '{$user_id}' AND follow_id = '{$followUser_id}';"; $result = $database -> query($query); $num = mysqli_num_rows($result); if ($num < 1) { $toast = "Follow"; $query = " INSERT INTO profile_follow (user_id, follow_id) VALUES ('{$user_id}', '{$followUser_id}');"; $result = $database -> query($query); } elseif ($num > 0) { $toast = "Unfollow"; $query = " DELETE FROM profile_follow WHERE user_id = '{$user_id}' AND follow_id = '{$followUser_id}';"; $result = $database -> query($query); } return $toast;}\[/code\]I have verified the function works correctly in echoing out $toast. It is either \[code\]Follow\[/code\] or \[code\]Unfollow\[/code\] based on condition. I don't think I am handling it right when it comes out?Supplemental:Here is what I am doing with $result:\[code\]if ($result == "Follow") { $output["result"] = "Follow"; echo json_encode($output); } elseif ($result == "Unfollow") { $output["result"] = "Unfollow"; echo json_encode($output); }\[/code\]
 
Back
Top