mysql - Get unique image for every user when call default image from query -

-

sorry, long title. have list registered users, profile pic, without. problem if user 1 logged in. in user list, has same profile image user 1.

but if remove default caller query, every user gets own picture, default.jpg image doesn't work. remove query , use if statement on page, want avoid that. 

            function fetch_users($uid){             $query = $this->link->query( "select user.id, user.username, user.email,              userdetails.profile_img,userdetails.firstname,             userdetails.lastname,userdetails.location,following.follow_id             user             left join   userdetails on user.id = userdetails.user_id             left join   following on user.id = following.follow_id                   user.id != '{$uid}' ");             $users = array();             while(($row = $query->fetch(pdo::fetch_assoc)) !== false) {     #the row mess things#----->$row['profile_img'] = file_exists("img/{$uid}.jpg") ? "img/{$uid}.jpg" :  "img/default.jpg" ;             $users[] = $row;         }                return $users;         }

you mixing stuff lot. in query fetch file name table, in comment row use uid construct name. former work default image, use

select …   ifnull(userdetails.profile_img, "img/default.jpg") profile_img, …

this replace null values in table path of default image.

if wanted construct image paths user ids, should use id result row, not 1 of current user:

while(($row = $query->fetch(pdo::fetch_assoc)) !== false) {    $imgpath = "img/" . $row['id'] . ".jpg";   if (!file_exists($imgpath)) $imgpath = "img/default.jpg";   $row['profile_img'] = $imgpath;   $users[] = $row; }

this create image path based on user id, , fall default if no such file exists.

you combine them both:

select …   ifnull(userdetails.profile_img,          concat("img/", user.id, ".jpg") profile_img, … 
while(($row = $query->fetch(pdo::fetch_assoc)) !== false) {    if (!file_exists($row['profile_img']))     $row['profile_img'] = "img/default.jpg";   $users[] = $row; }

this use stored image path set, path constructed uid otherwise. use file named in fashion, default if no such file exist.


Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

-
this question has answer here: delimiter must not alphanumeric or backslash , preg_match 5 answers this question has been asked don't know how fix problem in situation. getting following php errror: php message: php warning: preg_match(): delimiter must not alphanumeric or backslash in... on line 227 line 227 following: if (preg_match($match, $_server['http_user_agent'])) and function: $oslist = array ( 'windows 3.11' => 'win16', 'windows 95' => '(windows 95)|(win95)|(windows_95)', 'windows 98' => '(windows 98)|(win98)', 'windows 2000' => '(windows nt 5.0)|(windows 2000)', 'windows xp' => '(windows nt 5.1)|(windows xp)', 'windows server 2003' => '(windows nt 5.2)', 'windows vista' => '(windows nt 6.0)', 'w...
Read more

Delphi interface implements -

-
i expect reference counting should work on outer aggregating object in interface implementation. if can refer example: clarity in classes implementing multiple interfaces (alternative delegation): here minimal reproduction of behaviour: program so16210993; {$apptype console} type ifoo = interface procedure foo; end; tfooimpl = class(tinterfacedobject, ifoo) procedure foo; end; tcontainer = class(tinterfacedobject, ifoo) private ffoo: ifoo; public constructor create; destructor destroy; override; property foo: ifoo read ffoo implements ifoo; end; procedure tfooimpl.foo; begin writeln('tfooimpl.foo called'); end; constructor tcontainer.create; begin inherited; ffoo := tfooimpl.create; end; destructor tcontainer.destroy; begin writeln('tcontainer.destroy called');//this line never runs inherited; end; procedure main; var foo : ifoo; begin foo := tcontainer.create; foo.foo; end; begin main; readln...
Read more

css - invalid property value for padding -

-
i getting invalid property value padding , don't know why. code written in ruby btw. when check browser has right value pixels, crossed out w line , isn't reading attribute. in advance. <% mywaldo = mapping::mywaldos.sample %> <!doctype html> <html> <head> <title>sinatra single-serve</title> <link href="css/bootstrap.css" rel="stylesheet" type="text/css"/> <style> div { width: 1024px; height: 768px; background-image: url("img/waldos/<%= mywaldo[0]%>") ; } #waldo { position:absolute; top: <%= mywaldo[2]%>; left: <%= mywaldo[1]%>; padding: <%= mywaldo[3]%>, <%= mywaldo[4]%>; } </style> </head> <body> <div> <a id="waldo" href="">aa</a> </div> <%= yield %> </body> ...
Read more