/** * getPlaylistsForTrack function. * * @access public * @param mixed $db * @param mixed $track_uri * @return void */ function getPlaylistsForTrack($db, $track_uri) { $playlistsfortrack = ""; $getPlaylistsForTrack = "select distinct playlist_name from tracks where uri=:uri"; try { $stmt = $db->prepare($getPlaylistsForTrack); $stmt->bindValue(':uri', '' . $track_uri . ''); $stmt->execute(); $noresult = true; while ($playlist = $stmt->fetch()) { if ($noresult == true) { if ($playlist[0] == "") { $playlistsfortrack = $playlistsfortrack . " ● ♫ : " . 'Your Music'; } else { $playlistsfortrack = $playlistsfortrack . " ● ♫ : " . truncateStr($playlist[0], 30); } } else { if ($playlist[0] == "") { $playlistsfortrack = $playlistsfortrack . " ○ " . 'Your Music'; } else { $playlistsfortrack = $playlistsfortrack . " ○ " . truncateStr($playlist[0], 30); } } $noresult = false; } } catch (PDOException $e) { return ""; } return $playlistsfortrack; }
//end seo $pageroot = "controllers/photographyController.php"; } else { $pagename = "มุมช่างภาพ ลงโปรไฟล์ ลงภาพผลงาน"; $title = $pagename . ' : ' . "Pretty Mc Thailand พริตตี้เอ็มซี ไทยแลนด์ ฝากโปรไฟล์พริตตี้ สมัครสมาชิก ลงประกาศข่าว "; $description = "พริตตี้เอ็มซี ไทยแลนด์ ฝากโปรไฟล์พริตตี้ สมัครสมาชิก ลงประกาศข่าว ช่างภาพ งานพริตตี้,หาพริตตี้,เอ็มซี pretty modeling โมเดลลิ่ง"; $keyword = "พริตตี้เอ็มซีไทยแลนด์,pretty,modeling,mc,pretty,พริตตี้,ฝากโปรไฟล์พริตตี้ ,สมัครสมาชิก ,ลงประกาศข่าว ,ช่างภาพ"; $pageroot = "controllers/photographyController.php"; } } elseif ($get_part0 == "stylish") { if ($get_part1 != '') { $sqltext = "SELECT * FROM portfolio_stylish WHERE ps_id = '{$get_part1}' "; $qtext = $dbCon->query($sqltext) or die($dbCon->error); $retext = $qtext->fetch_object(); $txtname = $retext->ps_name; $txtdesc = truncateStr(strip_tags($retext->ps_detail), 600); $imageurl = $urlimg . '/images/stylish/portfolio/' . $retext->ps_img; $postid = $retext->ps_id; if (SUBSTR($retext->member_id, 0, 1) == "M") { $createname = selectdata('member_register', 'member_name', 'member_id', $retext->member_id); $createname2 = selectdata('member_register', 'member_surname', 'member_id', $retext->member_id); $img2 = selectdata('member_register', 'member_img', 'member_id', $retext->member_id); $rootimg = "{$url2}/images/member/tmp/{$img2}"; } else { $createname = selectdata('user', 'fullname', 'user_id', $retext->member_id); $img2 = selectdata('user', 'img', 'user_id', $retext->member_id); $rootimg = "{$url2}/@backend/images/user/tmp/{$img2}"; } //seo $title = $txtname; $description = $txtdesc;
/images/social_flat_rounded_rects_svg/line.png"></a></li> <li><a href="https://www.facebook.com/sharer/sharer.php?u=<?php echo $urlweb; ?> " title="Share on Facebook" target="_blank"><img src="<?php echo $site_dir; ?> /images/social_flat_rounded_rects_svg/Facebook.svg"></a></li> <li><a href="https://twitter.com/intent/tweet?source=<?php echo $urlweb; ?> &text=<?php echo $title; ?> :%20<?php echo truncateStr($description, 80); ?> เพิ่มเติม : <?php echo $urlweb; ?> " target="_blank" title="Tweet"><img src="<?php echo $site_dir; ?> /images/social_flat_rounded_rects_svg/Twitter.svg"></a></li> <li><a href="https://plus.google.com/share?url=<?php echo $urlweb; ?> " target="_blank" title="Share on Google+"><img src="<?php echo $site_dir; ?> /images/social_flat_rounded_rects_svg/Google+.svg"></a></li>
?> " alt=""> </div><!--/ Attachement --> </div><!-- top post --> <div class="content-single-post"> <h3><a href="<?php echo $url . 'post/' . $repost->post_id; ?> " title=""><?php echo $repost->post_name; ?> </a></h3> <p><?php echo truncateStr($repost->post_description, 300); ?> </p> <ul class="metas"> <li> <div class="user-avatar-small"><img src="images/profile.png" alt=""></div> <a href="#" title="">Salah Raddaoui</a> </li> <li><i class="fa fa-clock-o"></i> <?php echo convertdate($repost->post_datetime); ?> </li> </ul> </div><!-- content post -->