Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- $selectProfilesQuery = 'SELECT profile_id, user_id, profile_name, profile_picture_50, profile_tile_cover FROM profile WHERE user_id = :user_id';
- $prepSelectProfiles = $conn->prepare($selectProfilesQuery);
- $prepSelectProfiles->bindParam(':user_id', $uid, PDO::PARAM_INT);
- $prepSelectProfiles->execute();
- $profilesResult = $prepSelectProfiles->fetchAll();
- }
- catch(PDOException $e) {
- $conn = null;
- header('Location: ../errors/error_101.html');
- }
- while ($profiles = $profilesResult->fetch(PDO::FETCH_ASSOC)) {
- $profileId = $profiles['profile_id'];
- $profileTileBg = $profiles['profile_tile_cover'];
- $profileImage = $profiles['profile_picture_50'];
- $profileName = $profiles['profile_name'];
- }
- while ($profiles = $profilesResult->fetch(PDO::FETCH_ASSOC)) {
- foreach($profilesResult as $profiles) {
- //...
- }
- $profilesResult = $prepSelectProfiles->fetchAll();
- while ($profiles = $profilesResult->fetch(PDO::FETCH_ASSOC)) {
- while ($profiles = $prepSelectProfiles->fetch(PDO::FETCH_ASSOC)) {
- $profilesResult = $prepSelectProfiles->fetchAll();
- $sql = 'SELECT profile_id, user_id, profile_name, profile_picture_50, profile_tile_cover '
- . 'FROM profile WHERE user_id = :user_id';
- $stmt = $conn->prepare($sql);
- $stmt->execute([$uid]);
- $profiles = $stmt->fetchAll();
- while (foreach $profiles as $row) {
- extract($row);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement