Advertisement
Guest User

Untitled

a guest
Apr 21st, 2014
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. try {
  2. $selectProfilesQuery = 'SELECT profile_id, user_id, profile_name, profile_picture_50, profile_tile_cover FROM profile WHERE user_id = :user_id';
  3. $prepSelectProfiles = $conn->prepare($selectProfilesQuery);
  4. $prepSelectProfiles->bindParam(':user_id', $uid, PDO::PARAM_INT);
  5. $prepSelectProfiles->execute();
  6. $profilesResult = $prepSelectProfiles->fetchAll();
  7. }
  8. catch(PDOException $e) {
  9. $conn = null;
  10. header('Location: ../errors/error_101.html');
  11. }
  12.  
  13. while ($profiles = $profilesResult->fetch(PDO::FETCH_ASSOC)) {
  14. $profileId = $profiles['profile_id'];
  15. $profileTileBg = $profiles['profile_tile_cover'];
  16. $profileImage = $profiles['profile_picture_50'];
  17. $profileName = $profiles['profile_name'];
  18. }
  19.  
  20. while ($profiles = $profilesResult->fetch(PDO::FETCH_ASSOC)) {
  21.  
  22. foreach($profilesResult as $profiles) {
  23. //...
  24. }
  25.  
  26. $profilesResult = $prepSelectProfiles->fetchAll();
  27.  
  28. while ($profiles = $profilesResult->fetch(PDO::FETCH_ASSOC)) {
  29.  
  30. while ($profiles = $prepSelectProfiles->fetch(PDO::FETCH_ASSOC)) {
  31.  
  32. $profilesResult = $prepSelectProfiles->fetchAll();
  33.  
  34. $sql = 'SELECT profile_id, user_id, profile_name, profile_picture_50, profile_tile_cover '
  35. . 'FROM profile WHERE user_id = :user_id';
  36. $stmt = $conn->prepare($sql);
  37. $stmt->execute([$uid]);
  38. $profiles = $stmt->fetchAll();
  39. while (foreach $profiles as $row) {
  40. extract($row);
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement