prepare("SELECT * FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE (videos.tags REGEXP ? OR videos.description REGEXP ? OR videos.title REGEXP ? OR users.username REGEXP ?) AND videos.privacy = 1 AND videos.converted = 1 AND videos.rejected = 0 AND users.termination = 0 ORDER BY uploaded DESC"); $vidocount->execute([$search, $search, $search, $search]); $vidocount = $vidocount->rowCount(); $relatedt = $conn->prepare("SELECT * FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE (videos.tags REGEXP ? OR videos.description REGEXP ? OR videos.title REGEXP ? OR users.username REGEXP ?) AND videos.privacy = 1 AND videos.converted = 1 AND users.termination = 0 AND videos.rejected = 0 ORDER BY (INSTR(LOWER(description), LOWER(?)) > 0) DESC LIMIT $ppv OFFSET $offs"); $relatedt->execute([$search, $search, $search, $search, $search]); foreach($relatedt as $newtag) { $related_tags = array_merge($related_tags, explode(" ", $newtag['tags'])); } if(empty($_GET['search'])) { $videos = $conn->prepare("SELECT * FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE (videos.tags REGEXP ? OR videos.description REGEXP ? OR videos.title REGEXP ? OR users.username REGEXP ?) AND videos.privacy = 1 AND videos.converted = 1 AND users.termination = 0 AND videos.rejected = 0 ORDER BY (INSTR(LOWER(description), LOWER(?)) > 0) DESC LIMIT $ppv OFFSET $offs"); $videos->execute([$search, $search, $search, $search, $search]); }else{ $res_title = "Tag"; $res_rlted = "Related results"; $real_search = htmlspecialchars(trim($_GET['related'])); $videos = $conn->prepare("SELECT * FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE (videos.tags REGEXP ? OR videos.description REGEXP ? OR videos.title REGEXP ? OR users.username REGEXP ?) AND videos.privacy = 1 AND videos.converted = 1 AND users.termination = 0 AND videos.rejected = 0 ORDER BY (INSTR(LOWER(tags), LOWER(?)) > 0) DESC LIMIT $ppv OFFSET $offs"); $videos->execute([$search, $search, $search, $search, $search]); } } else { $res_title = "Tag"; class videos { // Placeholder class when search is empty function rowCount() { return 0; } } $videos = new videos; } } if($_GET['search_users'] == 'Search Users') { $profile = $conn->prepare("SELECT * FROM users WHERE users.username = ?"); $profile->execute([$_GET['search']]); if($profile->rowCount() == 0) { //user search idk } else { redirect("/profile?user=".$_GET['search']); } } ?>

Related Tags: ,

//	0) { ?> 0) { echo htmlspecialchars(trim($offs)); } else { echo "1"; } ?>- $ppv) { $nextynexty = $offs + $ppv; } else {$nextynexty = $vidocount; } echo htmlspecialchars($nextynexty); ?> of for ''. ( seconds)

100) ? substr($description, 0, 100) . '...' : $description; echo $description; ?>

Tags // '.htmlspecialchars($tag).' : '; ?>

Added: by

Channels //

Runtime: | Views: | Comments:

$ppv) { ?>

Result Page: < Previous ' . $i . ''; } else { echo '' . $i . ''; } } ?> Next >

Found no videos matching "". Do you have one? Upload it!