Exemple #1
0
function getthumbimagefromid($id)
{
    $cn = connect_db();
    $sql = "SELECT *,UNIX_TIMESTAMP(upload_time) as upload_time FROM `photo` WHERE id='" . $id . "'";
    $link = mysql_query($sql, $cn) or die("Error : " . mysql_error());
    $data = mysql_fetch_assoc($link);
    disconnect_db($cn);
    if ($data['thumb_url'] == "") {
        $str = get_domain_path() . "images/nophoto.gif";
    } else {
        $str = $data['thumb_url'];
    }
    return $str;
}
Exemple #2
0
 function getuserimage($uid)
 {
     $cn = connect_db();
     $sql = "select * from `users` where userid='" . $uid . "'";
     $link = mysql_query($sql, $cn) or die("Error : " . mysql_error());
     $data = mysql_fetch_assoc($link);
     disconnect_db($cn);
     if ($data['photoid'] == "0") {
         $str = get_domain_path() . "images/nophoto.jpg";
     } else {
         $str = getthumbimagefromid($data['photoid']);
     }
     return $str;
 }