本文整理匯總了PHP中MySql::dbselect方法的典型用法代碼示例。如果您正苦於以下問題：PHP MySql::dbselect方法的具體用法？PHP MySql::dbselect怎麽用？PHP MySql::dbselect使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類MySql的用法示例。
在下文中一共展示了MySql::dbselect方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: get_jsonconfig
function get_jsonconfig($config_name, $file)
{
$table = str_replace('site', '', $file);
$file = CACHE_PATH . "config/{$file}" . CACHE_EXT;
$data = Cache::BEGIN_CACHE($file);
if (!$data) {
$arr = MySql::dbselect('config_name,config_content', "{$table}", "config_name != ''");
for ($i = 0; $i < count($arr); $i++) {
$_config_name = $arr[$i][0];
$_config_content = $arr[$i][1];
$data[$_config_name] = $_config_content;
}
$data = json_encode($data);
Cache::END_CACHE($data, $file);
}
$html = json_decode($data);
$rs = $html->{$config_name};
return $rs;
}示例2: AddLog
public static function AddLog($type, $text)
{
if (!IS_LOGIN) {
$arr = 'user';
} else {
if ($_SESSION["RK_Support"]) {
$arr = 'err';
} else {
$userid = $_SESSION["RK_Userid"];
$type = intval($type);
$content = RemoveHack($text);
$user = MySql::dbselect("username", "user", "id = '{$userid}'");
$username = $user[0][0];
if ($type == '1') {
$type = 'Báo lỗi phim';
} else {
if ($type == '2') {
$type = 'Báo lỗi video';
} else {
if ($type == '3') {
$type = 'Báo lỗi hệ thống';
} else {
if ($type == '4') {
$type = 'Yêu cầu chức năng';
} else {
if ($type == '5') {
$type = 'Lỗi Khác';
}
}
}
}
}
$title = $type . " | Gửi từ {$username}";
MySql::dbinsert("log", "title,content", "'{$title}','{$content}'");
$_SESSION["RK_Support"] = 1;
$arr = 'done';
}
}
return $arr;
}示例3: explode
$page = explode('-', $geturl[3]);
}
$page = $page[1];
$num = config_site('list_limit');
$num = intval($num);
$page = intval($page);
if (!$page) {
$page = 1;
}
$limit = ($page - 1) * $num;
if ($limit < 0) {
$limit = 0;
}
$arr = MySql::dbselect('tb_film.id,tb_film.title,tb_film.title_en,tb_film.thumb,tb_film.year,tb_film.big_image,tb_film_other.content,tb_film.quality,tb_film.year', 'film JOIN tb_film_other ON (tb_film_other.filmid = tb_film.id)', "{$sql} {$orderby} LIMIT {$limit},{$num}");
$bg_thumb = TEMPLATE_URL . 'images/grey.jpg';
$total = MySql::dbselect('tb_film.id', 'film JOIN tb_film_other ON (tb_film_other.filmid = tb_film.id)', "{$sql}");
$allpage_site = get_allpage(count($total), $num, $page, $url_page . 'page-');
?>
<div class="p-profile-cover"></div>
<div class="bread-crumb">
<ul xmlns:v="http://rdf.data-vocabulary.org/#">
<li typeof="v:Breadcrumb"><a href="<?php
echo SITE_URL;
?>
" rel="v:url" property="v:title">Peliculas</a></li>
<li typeof="v:Breadcrumb"><h2><a class="last" href="<?php
echo $url_page;
?>
" rel="v:url" property="v:title"><?php
echo $title_page;
?>示例4: display
public static function display($params)
{
$cururl = Url::curRequestURL();
# Actor de caché y el cine
Film_Model::CacheActorSeatch();
# Restablecer Vistas
Film_Model::ResetViewed();
# Get info url
$geturl = explode('/', $cururl);
$mode = $geturl[1];
// Film and cinema
if (in_array($mode, array('phim', 'xem-phim'))) {
$id = $geturl[2];
$id = explode('-', $id);
$id = $id[0];
if ($mode == 'phim') {
$arr = MySql::dbselect('tb_film.id,tb_film.title,tb_film.thumb,tb_film.year,tb_film.big_image,tb_film_other.content,tb_film.title_en,tb_film_other.keywords', 'film JOIN tb_film_other ON (tb_film_other.filmid = tb_film.id)', "id = '{$id}'");
//TITULO PRINCIPAL DE TODA LA WEB
$site_title = 'Pelicula ' . $arr[0][1] . ' | ' . $arr[0][6] . ' full HD';
$site_description = str_replace('"', '', CutName(RemoveHtml(UnHtmlChars($arr[0][5])), 200));
$site_keywords = FixTags($arr[0][7]);
$filmid = intval($arr[0][0]);
$epwatch = MySql::dbselect('id', 'episode', "filmid = '{$filmid}' order by id asc limit 1");
$epwatch = $epwatch[0][0];
} else {
if ($mode == 'xem-phim') {
$epid = MySql::dbselect('id,name,filmid,url,subtitle', 'episode', "id = '{$id}'");
$filmid = intval($epid[0][2]);
MySql::dbupdate('film', "viewed = viewed+100, viewed_day = viewed_day+1, viewed_week = viewed_week+1, viewed_month = viewed_month+1", "id = '{$filmid}'");
$arr = MySql::dbselect('tb_film.id,tb_film.title,tb_film.thumb,tb_film.year,tb_film.big_image,tb_film_other.content,tb_film.title_en,tb_film_other.keywords', 'film JOIN tb_film_other ON (tb_film_other.filmid = tb_film.id)', "id = '{$filmid}'");
$site_title = 'Pelicula ' . $arr[0][1] . ' Tập ' . $epid[0][1] . ' - Pelicula ' . $arr[0][6];
$site_description = 'Pelicula ' . $arr[0][1] . ' Tập ' . $epid[0][1] . ' | ' . $arr[0][6] . ' Ep ' . $epid[0][1] . '. Pelicula ' . $arr[0][1] . ' Tập ' . $epid[0][1] . ' Calidad HD.';
$site_keywords = FixTags('Pelicula ' . $arr[0][1] . ' Tập ' . $epid[0][1] . ', ' . $arr[0][1] . ' Tập ' . $epid[0][1] . ', ' . $arr[0][6] . ' Ep ' . $epid[0][1] . ', ' . $arr[0][7]);
}
}
if (!$arr) {
header('Location: ' . s404_URL);
}
$other_meta = '<meta property="og:image" content="' . $arr[0][2] . '">';
$other_meta2 = '<link href="' . SITE_URL . $cururl . '" rel="canonical">';
include View::TemplateView('film');
} else {
if (in_array($mode, array('danh-sach', 'the-loai', 'quoc-gia', 'search', 'tag'))) {
if ($mode == 'the-loai') {
$id = $geturl[2];
$arr = MySql::dbselect('id,name', 'category', "name_seo = '{$id}'");
$id = $arr[0][0];
$catid = $id;
$name = $arr[0][1];
$url_page = Url::get(0, $name, 'Thể loại');
$site_title = head_site($name, 'category_title');
$site_description = head_site($name, 'category_description');
$site_keywords = head_site($name, 'category_keywords');
$sql = "tb_film.category like '%,{$id},%'";
} else {
if ($mode == 'quoc-gia') {
$id = $geturl[2];
$arr = MySql::dbselect('id,name', 'country', "name_seo = '{$id}'");
$id = $arr[0][0];
$couid = $id;
$name = $arr[0][1];
$url_page = Url::get(0, $name, 'Pais');
$site_title = head_site($name, 'country_title');
$site_description = head_site($name, 'country_description');
$site_keywords = head_site($name, 'country_keywords');
$sql = "tb_film.country = '{$id}'";
} else {
if (in_array($mode, array('search', 'tag'))) {
$id = str_replace('-', ' ', urldecode($geturl[2]));
$name = $id;
$url_page = Url::get(0, $name, 'Search');
$site_title = head_site($name, 'search_title');
$site_description = head_site($name, 'search_description');
$site_keywords = head_site($name, 'search_keywords');
$sql = "tb_film.title like '%{$id}%' OR tb_film.title_en like '%{$id}%' OR tb_film_other.searchs like '%{$id}%' OR tb_film_other.keywords like '%{$id}%' OR tb_film.actor like '%{$id}%' OR tb_film.director like '%{$id}%'";
} else {
if ($mode == 'danh-sach') {
$id = $geturl[2];
if ($id == 'phim-moi') {
$name = 'Nuevas Películas';
$url_page = Url::get(0, $name, 'Danh sách');
$sql = "id != '0'";
$site_title = "Nuevas Películas y 2014, lista nueva géneros cinematográficos";
$site_description = "Lista de Cine Última actualización continua, consulte delicia y un número ilimitado de películas.";
$site_keywords = "Nuevas películas , una nueva película o, seleccionada nuevas películas";
} else {
if ($id == 'phim-de-cu') {
$name = 'Peliculas Nominadas';
$url_page = Url::get(0, $name, 'Danh sách');
$sql = "decu = '1'";
$site_title = "Película con alta calidad";
$site_description = "Las películas nominadas para el más caliente o 2014, se seleccionaron y evaluaron la más alta calidad.";
$site_keywords = "películas calientes, mejores películas, películas o 2014";
} else {
if ($id == 'phim-le') {
$filmlb = $id;
$name = 'Movie';
$url_page = Url::get(0, $name, 'Danh sách');
$sql = "filmlb = '0'";
$site_title = "Película con alta calidad";
//.........這裏部分代碼省略.........
示例5: rand
?>
</ul>
</div>
<div class="wrap_prev_block">
<a id="rand_film_control_prev" href="#" class="prev_block"></a>
</div>
<div class="wrap_next_block">
<a id="rand_film_control_next" href="#" class="next_block"></a>
</div>
</div>
</div>
<div class="watch-channel info_resize">
<div class="tv_list_page clearfix">
<ul>
<?php
$livetv = MySql::dbselect('id,symbol,name,quality,speed,thumb', 'tv', "id != 0 order by rand() desc limit 21");
for ($i = 0; $i < count($livetv); $i++) {
$id = $livetv[$i][0];
$name = $livetv[$i][2];
$symbol = $livetv[$i][1];
$thumb = $livetv[$i][5];
$url = get_url($id, $symbol, 'Live TV');
echo "<li><div class=\"pageSlide\">\n\t\t\t\t\t\t<a href=\"{$url}\" title=\"{$symbol} - {$name}\">\n\t\t\t\t\t\t\t<img src=\"{$thumb}\" alt=\"{$symbol} - {$name}\"/>\n\t\t\t\t\t\t\t<div class=\"maskMv\"></div>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t</div></li>";
}
?>
</ul>
</div>
</div>
<div class="watch-video">
<div id="mainVideo" class="main">
<div class="scroll">示例6: die
<?php
if (!defined('RK_MEDIA')) {
die("You does have access to this!");
}
include View::TemplateView('header');
$film = MySql::dbselect("tb_film.title,tb_film.title_en,tb_film.category,tb_film.release_time,tb_film.timeupdate,tb_film.thumb,tb_film.country,tb_film.director,tb_film.actor,tb_film.year,tb_film.duration,tb_film.viewed,tb_film_other.content,tb_film_other.keywords,tb_film.total_votes,tb_film.total_value,tb_film.trailer,tb_film.big_image,tb_film.quality,tb_film.filmlb", 'film JOIN tb_film_other ON (tb_film_other.filmid = tb_film.id)', "id = '{$filmid}'");
$tenphim = $film[0][0];
$tentienganh = $film[0][1];
$watchurl = get_url($epwatch, $tenphim, 'Xem Phim');
$breadcrumb = breadcrumb_menu($film[0][2]);
$urlfilm = get_url($filmid, $tenphim, 'Phim');
$phathanh = $film[0][3];
if (!$phathanh) {
$phathanh = GetDateT($film[0][4]);
}
$thumb = $film[0][5];
if (!$thumb) {
$thumb = TEMPLATE_URL . 'images/grey.jpg';
}
$theloai = category_a($film[0][2]);
$quocgia = country_a($film[0][6]);
$genre = category_ad($film[0][2]);
$country = country_ad($film[0][6]);
$daodien_a = CheckName($film[0][7]);
$daodien = Get_List_director($film[0][7]);
$dienvien = Get_List_actor($film[0][8]);
$year = CheckName($film[0][9]);
$duration = CheckName($film[0][10]);
$viewed = $film[0][11];
$loaiphim = $film[0][19];
$content = RemoveHtml(UnHtmlChars($film[0][12]));示例7: elseif
?>
' border=0 style="position: absolute;right: 5px;top: -1px;height: 20px;"/></span></li>
<li><label></label><span><input type="submit" value="¿Olvidastes tu contraseña?" class="button"/></span></li>
</ul>
</div>
</div>
<div class="middle_right" style="width:35%">
<label class="tit">Recuperar</label>
<div class="stat" style="color:#414141">
Porfavor ingrese su Email correcto para que pueda recuperar su cuenta.</div>
</div>
</div>
</div>
<?php
} elseif ($userid) {
$user = MySql::dbselect('username,email,lastlogin,lastreg,facebookid,fullname,ugroup,fav_feature,fav_playlist', 'user', "id = '{$userid}'");
$fullname = $user[0][5];
$username = $user[0][0];
$email = $user[0][1];
$lastlogin = GetDateT($user[0][2]);
$lastreg = GetDateT($user[0][3]);
$ugroup = LoginAuth::GroupUser($user[0][6]);
$facebookurl = $user[0][4];
if (!$image) {
$image = TEMPLATE_URL . 'images/noavatar.jpg';
}
?>
<div class="p-profile-cover">
<!-- <a href="javascript:void(0)" class="change-cover">Thay đổi ảnh bìa</a>-->
</div>
<div class="p-profile clearfix" id="edit_user">示例8: define
document.getElementById("thumb0").innerHTML=xmlhttp.responseText;
document.getElementById("status0").innerHTML="•";
}
}
xmlhttp.open("GET","http://saved-media.com/upload/upload1.php?url=http%3A%2F%2F4.bp.blogspot.com%2F-3A-vZ2ZjeY4%2FUV_hPd-jeqI%2FAAAAAAAARkc%2FLVOYwyGVQA4%2Fs1600%2FYLSLQni.png",true);
xmlhttp.send();
}
</script>
</head>
<body>
<?php
define('RK_MEDIA', true);
require 'init.php';
$episode = MySql::dbselect('id,title,thumb', 'film', "id = 1632");
echo "<table border='1'>\n<tr>\n<th>filmid</th>\n<th>name</th>\n<th>new thumb</th>\n<th>status</th>\n<th>old thumb</th>\n\n\n</tr>";
function kq($x, $y, $z, $i)
{
echo "<tr>";
echo "<td id=\"film" . $i . "\">" . $x . "</td>";
echo "<td>" . $y . "</td>";
echo "<td id=\"thumb" . $i . "\"></td>";
echo "<td id=\"status" . $i . "\"></td>";
echo "<td id=\"old" . $i . "\">" . $z . "</td>";
echo "</tr>";
}
$i = 0;
while ($episode[$i][1] != "") {
kq($episode[$i][0], $episode[$i][1], $episode[$i][2], $i);
$i++;示例9: ConfigName
public static function ConfigName($name)
{
$arr = MySql::dbselect('config_name,config_content', 'config', "config_name = '{$name}'");
return $arr[0][1];
}示例10: explode
if ($geturl[2]) {
$page = explode('-', $geturl[2]);
}
$page = $page[1];
$num = 12;
$num = intval($num);
$page = intval($page);
if (!$page) {
$page = 1;
}
$limit = ($page - 1) * $num;
if ($limit < 0) {
$limit = 0;
}
$arr = MySql::dbselect('id,name,url,duration,thumb', 'media', "id != 0 order by id desc LIMIT {$limit},{$num}");
$total = MySql::dbselect('id', 'media', "id != 0");
$allpage_site = get_allpage(count($total), $num, $page, SITE_URL . "/video/page-");
?>
<div class="hdvideo">
<div class="hdhwap">
<ul style="height:400px">
<?php
echo get_video('slide = 1', 7);
?>
</ul>
<div style="clear:both">
</div>
<a href="#" id="hvideo_control_prev" class="btn_pre_ft"></a><a href="#" id="hvideo_control_next" class="btn_next_ft"></a>
</div>
<script type="text/javascript">$(".hdhwap ul").carouFredSel({circular: false,infinite: false,auto : false,width: "100%",prev: {button: "#hvideo_control_prev",key: "left"},next: { button: "#hvideo_control_next",key: "right"},});</script>
<div class="videos">示例11: player
function player($epid, $type = '')
{
if ($type !== 'video') {
$episode = MySql::dbselect('id,name,filmid,url,subtitle,thumb', 'episode', "id = '{$epid}'");
$url = $episode[0][3];
$subtitle = $episode[0][4];
$filmid = $episode[0][2];
$nextid = one_data('id', 'episode', "id > '{$epid}' AND filmid = '{$filmid}'");
} else {
$url = $epid;
}
$player = "<script src=\"" . TEMPLATE_URL . "js/jwplayer.js\"></script><script>\$(document).ready(function(){onjwplayer('{$url}','{$subtitle}','{$nextid}');});</script>";
echo $player;
}示例12: define
<?php
define('RK_MEDIA', true);
require 'init.php';
header("Content-type: text/xml");
#$file = CACHE_PATH.'xml/sitemap'.CACHE_EXT;
#$xml = Cache::BEGIN_CACHE($file);
if (!$xml) {
$xml = "<?xml version=\"1.0\" encoding=\"UTF-8\"?><?xml-stylesheet type=\"text/xsl\" href=\"/sitemap.xsl\"?>\n\n\t\t\t<urlset xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd\" xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n\n\t\t\t<url>\n\n\t\t\t\t<loc>" . SITE_URL . "</loc>\n\n\t\t\t\t<changefreq>hourly</changefreq>\n\n\t\t\t\t<priority>1.00</priority>\n\n\t\t\t\t<lastmod>2013-09-01T00:03:12+07:00</lastmod>\n\n\t\t\t</url>\n";
$sitemap = MySql::dbselect("id,title,title_en,timeupdate", "film", "");
for ($i = 0; $i < count($sitemap); $i++) {
$title = $sitemap[$i][1];
$url_phim = Url::get($sitemap[$i][0], $title, 'Phim');
$lastmod = date('Y-m-d', $sitemap[$i][3]);
if ($i < 6) {
$priority[$i] = '0.9';
} elseif ($i < 20) {
$priority[$i] = '0.8';
} elseif ($i > 19) {
$priority[$i] = '0.6';
}
$xml .= "<url>\n<loc>{$url_phim}</loc>\n<changefreq>daily</changefreq>\n<priority>" . $priority[$i] . "</priority>\n<lastmod>" . $lastmod . "T00:00:00+07:00</lastmod>\n</url>\n";
}
$xml .= "</urlset>";
#Cache::END_CACHE($xml,$file);
}
echo $xml;示例13: buil_down
public static function buil_down($epid)
{
$episode = MySql::dbselect('url', 'episode', "id = '{$epid}'");
$url = $episode[0][0];
$url = str_replace('https', 'http', $url);
$is_picasa = preg_match('#picasaweb.google.com/(.*?)#s', $url);
// Picasaweb
$is_zingtv = preg_match("#tv.zing.vn/video/([^/]+)#", $url);
// Zing TV
$is_ggdocs = preg_match("#docs.google.com(.*?)#s", $url);
// Google Docs
$is_nct = preg_match("#nhaccuatui.com(.*?)#s", $url);
// Nhaccuatui
$is_dailymotion = preg_match("#dailymotion.com(.*?)#s", $url);
// Dailymotion
$is_youtube = preg_match("#youtube.com(.*?)#s", $url);
// Youtube
if ($is_picasa) {
$data = file_get_contents($url);
$mp4 = array();
$ht = explode('"media":{"content":', $data);
$code = explode('"description":', $ht[1]);
$link = explode('"url":"', $code[0]);
for ($i = 2; $i < count($link); $i++) {
$play = explode('"', $link[$i]);
if (substr_count($play[0], "itag=5&") > 0) {
array_push($mp4, "240p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=34&") > 0) {
array_push($mp4, "360p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=6&") > 0) {
array_push($mp4, "360p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=35&") > 0) {
array_push($mp4, "480p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=59&") > 0) {
array_push($mp4, "360p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=22&") > 0) {
array_push($mp4, "720p [HD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=37&") > 0) {
array_push($mp4, "1080p [HD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=38&") > 0) {
array_push($mp4, "Ful HD|-|" . $play[0]);
}
}
for ($i = 0; $i < count($mp4); $i++) {
$d = explode('|-|', $mp4[$i]);
$html .= "<a href=\"{$d['1']}\" title=\"Chất lượng {$d['0']}\" target=\"_blank\">{$d['0']}</a> - ";
}
$html = substr($html, 0, -7);
}
if ($is_zingtv) {
}
if ($is_nct) {
$html = file_get_contents($url);
$link = explode('&file=', $html);
$link = explode('"', $link[1]);
$url = $link[0];
$html = file_get_contents($url);
$link = explode('<![CDATA[', $html);
$link = explode(']]>', $link[3]);
$link = $link[0];
$html = "<a href=\"{$link}\" title=\"Chất lượng 360p [SD]\" target=\"_blank\">360p [SD]</a> - ";
$html = substr($html, 0, -7);
}
if ($is_ggdocs) {
$data = file_get_contents($url);
$mp4 = array();
$ht = explode('"fmt_stream_map":', $data);
$code = explode('"fmt_list"', $ht[1]);
$link = explode('|', urldecode(unescapeUTF8EscapeSeq($code[0])));
for ($i = 1; $i < count($link); $i++) {
$play = explode('"', $link[$i]);
if (substr_count($play[0], "itag=5&") > 0) {
array_push($mp4, "240p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=34&") > 0) {
array_push($mp4, "360p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=6&") > 0) {
array_push($mp4, "360p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=35&") > 0) {
array_push($mp4, "480p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=59&") > 0) {
array_push($mp4, "360p [SD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=22&") > 0) {
array_push($mp4, "720p [HD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=37&") > 0) {
array_push($mp4, "1080p [HD]|-|" . $play[0]);
}
if (substr_count($play[0], "itag=38&") > 0) {
//.........這裏部分代碼省略.........
示例14: Forgot
public static function Forgot($email, $captcha)
{
$email = RemoveHack($email);
$captcha = RemoveHack($captcha);
if ($captcha !== $_SESSION["security_code"]) {
$arr = 'captcha';
} else {
$user = MySql::dbselect("id,username,password,codesecurity", "user", "email = '{$email}'");
if (!$user) {
$arr = 'email';
} else {
$userid = $user[0][0];
MySql::dbupdate('user', "forgot = '1'", "id = '{$userid}'");
$arr = 'done';
}
}
return $arr;
}示例15: one_data
function one_data($item, $table, $con)
{
$arr = MySql::dbselect("{$item}", "{$table}", "{$con}");
$data = $arr[0][0];
return $data;
}