Example #1
0
/**
 * 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;
Example #3
0
/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>
Example #4
0
    ?>
" 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 -->