Advertisement
Guest User

Untitled

a guest
Jun 18th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. public function getProfileData($username){
  2. $data = TBWebcam::MySQLQurey("SELECT * FROM `new_user` WHERE `user_name` = "AndrewAubury";");
  3. if($data =! null){
  4. $userimage = $data["user_image"];
  5. if($userimage =! ""){
  6. $userimage = str_replace("%s","",$userimage);
  7. $userimage = "https://A LINK YOU DONT NEED TO KNOW.net/PF.Base/file/pic/user/".$userimage;
  8. }else{
  9. $userimage = null;
  10. }
  11.  
  12. $usergender = $data["gender"];
  13. if($usergender == "1"){
  14. $usergender = "Male";
  15. }else{
  16. $usergender = "Female";
  17. }
  18. //echo($data["user_id"]."<br><br><br><br>");
  19. $userData = array(
  20. "id" => $data["user_id"],
  21. "name" => $data["full_name"],
  22. "username" => $data["user_name"],
  23. "image" => $userimage,
  24. "gender" => $usergender,
  25. );
  26. echo("Data: ".$data."<br><br><br>");
  27. return($userData);
  28. }else{
  29. return null;
  30. }
  31. }
  32.  
  33. public function MySQLQurey($queryToDo){
  34. $servername = "my server";
  35. $username = "um my username :P";
  36. $password = "why do u need to know";
  37. $dbname = "the one i set it up on";
  38.  
  39. $conn = new mysqli($servername, $username, $password, $dbname);
  40.  
  41. if ($conn->connect_error) {return(null);}
  42.  
  43. $sql = $queryToDo;
  44. $result = $conn->query($sql);
  45. $mehArray = array();
  46. if ($result->num_rows > 0) {
  47. while($row = $result->fetch_assoc()) {
  48. $mehArray[] = $row;
  49. }
  50. return($mehArray);
  51. } else {
  52. return(null);
  53. }
  54. $conn->close();
  55. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement