本文整理汇总了PHP中Transaction::fetch方法的典型用法代码示例。如果您正苦于以下问题：PHP Transaction::fetch方法的具体用法？PHP Transaction::fetch怎么用？PHP Transaction::fetch使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Transaction的用法示例。
在下文中一共展示了Transaction::fetch方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: mobbo_settings
public static function mobbo_settings($var)
{
$var2 = Security::injection($var);
$sql = Transaction::query("SELECT valuer FROM `mobbo_settings` WHERE `variabler` LIKE '{$var2}'");
$return = Transaction::fetch($sql);
return $return['valuer'];
}示例2: while
</form></table></div><br />
<div class='tableborder'>
<div class='tableheaderalt'><center>Equipe staff</center></div>
<table cellpadding='4' cellspacing='0' width='100%'>
<tr>
<td class='tablesubheader' width='20%'>Nome</td>
<td class='tablesubheader' width='30%'>Email</td>
<td class='tablesubheader' width='20%'>IP</td>
<td class='tablesubheader' width='20%'>Cargo</td>
<td class='tablesubheader' width='1%' align='center'>Editar</td>
</tr>
<?php
while ($row = Transaction::fetch($get_users)) {
$rank = Transaction::query("SELECT * FROM ranks WHERE id = '" . $row['rank'] . "' ");
$rank = Transaction::fetch($rank);
?>
<tr>
<td class='tablerow1' align='left'><?php
echo $row['username'];
?>
(ID: <?php
echo $row['id'];
?>
)</td>
<td class='tablerow1' align='left'><?php
echo $row['mail'];
?>
</td>
<td class='tablerow1' align='left'><?php
echo $row['ip_last'];示例3: while
<tr>
<td class='tablesubheader' width='1%' align='center'>ID</td>
<td class='tablesubheader' width='20%'>Ttulo</td>
<td class='tablesubheader' width='12%' align='left'>Data</td>
<td class='tablesubheader' width='10%' align='left'>Autor</td>
<td class='tablesubheader' width='1%' align='center'>Editar</td>
<td class='tablesubheader' width='1%' align='center'>Remover</td>
</tr>
<?php
$query_min = $page * 50 - 50;
if ($query_min < 0) {
// Page 1
$query_min = 0;
}
$get_articles = Transaction::query("SELECT * FROM mobbo_news ORDER BY id DESC LIMIT " . $query_min . ", 50");
while ($row = Transaction::fetch($get_articles)) {
?>
<tr>
<td class='tablerow1' align='center'><?php
echo $row['id'];
?>
</td>
<td class='tablerow2'><strong><?php
echo Security::textFilterHK($row['title']);
?>
</strong><div class='desctext'><?php
echo $row['longstory'];
?>
</div></td>
<td class='tablerow2' align='left'><?php 示例4: date
$m = date('m');
$d = date('d');
$Y = date('Y');
$j = date('j');
$n = date('n');
// start the user system
if (isset($_SESSION['id'])) {
$rawname = htmlentities($_SESSION['id']);
$usersql = Transaction::query("SELECT * FROM users WHERE id = '" . $rawname . "' LIMIT 1");
$myrow = Transaction::fetch($usersql);
$ban = Transaction::query("SELECT * FROM bans WHERE value = '" . $myrow['username'] . "' AND bantype = 'user' or value = '" . $remote_ip . "' AND bantype = 'ip' LIMIT 1");
$bancheck = Transaction::num_rows($ban);
if ($myrow['ip_reg'] == "0") {
Transaction::query("UPDATE users SET ip_reg = '" . $remote_ip . "' WHERE id = '" . $myrow['id'] . "'");
} elseif ($bancheck > 0) {
$bandata = Transaction::fetch($ban);
$timestamp = time();
if ($bandata['expire'] > $timestamp) {
session_destroy();
header("Location: index.php");
exit;
} else {
Transaction::query("DELETE FROM bans WHERE value = '" . $name . "' AND bantype = 'user' or value = '" . $remote_ip . "' AND bantype = 'ip' LIMIT 1");
}
}
$rawhotel = 0;
$rawhotel = md5($myrow['id'] + $myrow['username'] + $myrow['password'] + Security::getUserIP());
if (isset($_COOKIE['rawsessionhotel'])) {
if ($_COOKIE['rawsessionhotel'] == $rawhotel) {
$logged_in = true;
$name = mobbo::HoloText($myrow['username']) != 0 ? mobbo::HoloText($myrow['username']) : "Guest";示例5: getdefault
private function getdefault()
{
$query = Transaction::query("SELECT * FROM mobbo_templates WHERE active = '1' LIMIT 1;");
$row = Transaction::fetch($query);
$this->path = $row['path'];
}示例6: while
<div class='tableborder'>
<div class='tableheaderalt'><center>Usurios VIP atualmente</center></div>
<table cellpadding='4' cellspacing='0' width='100%'>
<tr>
<td class='tablesubheader' width='20%' align='left'>Nome de usurio</td>
<td class='tablesubheader' width='15%' align='left'>E-mail</td>
<td class='tablesubheader' width='15%' align='left'>IP</td>
<td class='tablesubheader' width='5%' align='left'>Editar</td>
</tr>
<?php
$get_vip = Transaction::query("SELECT * FROM users WHERE rank = '2' ORDER BY lastonline");
while ($vip = Transaction::fetch($get_vip)) {
$get_user = Transaction::query("SELECT * FROM users WHERE id = '" . $vip['id'] . "'");
while ($row = Transaction::fetch($get_user)) {
if ($row['online'] >= 1) {
$online = "online";
} else {
$online = "offline";
}
?>
<tr>
<td class='tablerow1' align='left'><?php
echo $row['username'];
?>
(ID: <?php
echo $row['id'];
?>
)</td>示例7: COUNT
<div class='tableborder'>
<div class='tableheaderalt'><center>Emblemas (<?php
echo Transaction::evaluate("SELECT COUNT(*) FROM user_badges WHERE user_id = '" . $key . "'");
?>
) </div>
<table width='100%' cellspacing='0' cellpadding='5' align='center' border='0'>
<tr>
<td class='tablesubheader' width='1%' align='center'>Cdigo</td>
<td class='tablesubheader' width='14%' align='center'>Emblema</td>
</tr>
<?php
$sql = Transaction::query("SELECT * FROM user_badges WHERE user_id = '" . $key . "' ORDER BY badge_id");
while ($row = Transaction::fetch($sql)) {
?>
<tr>
<td class='tablerow1' align='center'><?php
echo $row['badge_id'];
?>
</td>
<td class='tablerow2'><img src="<?php
echo $cimagesurl . $badgesurl . $row['badge_id'];
?>
.gif"></div></td>
</tr>
<?php
}示例8: while
<tr>
<td class='tablesubheader' width='1%' align='center'>ID</td>
<td class='tablesubheader' width='10%' align='center'>Cdigo do emblema</td>
<td class='tablesubheader' width='10%' align='center'>Nome</td>
<td class='tablesubheader' width='10%' align='center'>Preo</td>
<td class='tablesubheader' width='10%' align='center'>Editar</td>
<td class='tablesubheader' width='12%' align='center'>Borrar</td>
</tr>
<?php
$query_min = $page * 50 - 50;
if ($query_min < 0) {
// Page 1
$query_min = 0;
}
$get_marktplatz = Transaction::query("SELECT * FROM mobbo_shop ORDER BY id DESC LIMIT " . $query_min . ", 50");
while ($row = Transaction::fetch($get_marktplatz)) {
?>
<tr>
<td class='tablerow1' align='center'><?php
echo $row['id'];
?>
</td>
<td class='tablerow2' align='center'><img src="http://127.0.0.1/c_images/album1584/<?php
echo $row['image'];
?>
.gif" alt="<?php
echo $row['image'];
?>
"></td>
<td class='tablerow2' align='center'><?php 示例9: while
while ($row = Transaction::fetch($get_users)) {
?>
<script language="JavaScript" type="text/javascript">
function openWin () {
var newWin = window.open ('', '', 'height=330, width=560');
newWin.document.close ();
}
</script>
<?php
$userdata = Transaction::query("SELECT * FROM users WHERE id = '" . $row['userid'] . "' LIMIT 1");
$userdata = Transaction::fetch($userdata);
if (!empty($row['targetid'])) {
$targetdata = Transaction::query("SELECT * FROM users WHERE id = '" . $row['targetid'] . "' LIMIT 1");
$targetdata = Transaction::fetch($targetdata);
} else {
$targetdata['username'] = "-/-";
}
if (!empty($row['note'])) {
$note = $row['note'];
} else {
$note = "<i>None given</i>";
}
?>
<tr>
<td class='tablerow1' align='left'><?php
echo $row['action'];
?>
</td>示例10: time
<td class='tablesubheader' width='10%' align='left'>Desde</td>
<td class='tablesubheader' width='10%' align='left'>Acaba</td>
<td class='tablesubheader' width='1%' align='left'>IP Banido</td>
</tr>
<?php
$query_min = $page * 50 - 50;
if ($query_min < 0) {
// Page 1
$query_min = 0;
}
$get_bans = Transaction::query("SELECT * FROM bans WHERE expire + 3600 > '" . time() . "' ORDER BY expire LIMIT " . $query_min . ", 50");
while ($row = Transaction::fetch($get_bans)) {
if ($row['bantype'] == 'user') {
$userdata = Transaction::query("SELECT * FROM users WHERE username = '" . $row['value'] . "'");
$users = Transaction::fetch($userdata);
$ip_last = $users['ip_last'];
} else {
$ip_last = '-/-';
}
$minuten = $row['expire'] - time();
if (time() >= $row['expire']) {
$stat = "Expira em";
$color = "green";
} elseif (time() + 3600 >= $row['expire']) {
if (date('i', $minuten) > 0) {
$stat = "(H " . date('i', $minuten) . " minutos)";
$color = "orange";
} else {
$stat = "(H " . date('s', $minuten) . " segundos)";
$color = "orange";示例11: while
<div class='tableborder'>
<div class='tableheaderalt'><center>Banners - Información general</center></div>
<table cellpadding='4' cellspacing='0' width='100%'>
<tr>
<td class='tablesubheader' width='1%' align='center'>ID</td>
<td class='tablesubheader' width='10%' align='center'>Texto</td>
<td class='tablesubheader' width='10%' align='center'>Imagen</td>
<td class='tablesubheader' width='10%' align='center'>URL</td>
<td class='tablesubheader' width='10%' align='center'>HTML</td>
<td class='tablesubheader' width='1%' align='center'>Editar</td>
<td class='tablesubheader' width='1%' align='center'>Borrar</td>
</tr>
<?php
$get_banners = Transaction::query("SELECT * FROM mobbo_banners ORDER BY id");
while ($row = Transaction::fetch($get_banners)) {
?>
<tr>
<td class='tablerow1' align='center'><?php
echo $row['id'];
?>
</td>
<td class='tablerow2' align='center'><?php
echo $row['text'];
?>
</td>
<td class='tablerow2' align='center'><?php
echo $row['banner'];
?>
</td>示例12: while
<table cellpadding='4' cellspacing='0' width='100%'>
<tr>
<td class='tablesubheader' width='1%' align='center'>ID</td>
<td class='tablesubheader' width='20%'>Tipo</td>
<td class='tablesubheader' width='20%' align='left'>ID da ao</td>
<td class='tablesubheader' width='20%' align='center'>Editar</td>
<td class='tablesubheader' width='1%' align='center'>Remover</td>
</tr>
<?php
$query_min = $page * 50 - 50;
if ($query_min < 0) {
// Page 1
$query_min = 0;
}
$get_recommended = Transaction::query("SELECT * FROM mobbo_recommended ORDER BY id DESC LIMIT " . $query_min . ", 50");
while ($row = Transaction::fetch($get_recommended)) {
?>
<tr>
<td class='tablerow1' align='center'><?php
echo $row['id'];
?>
</td>
<td class='tablerow2'><?php
if ($row['type'] == "room") {
echo 'Sala';
} else {
echo 'Grupo';
}
?>
</td>示例13: header
}
if ($user_rank > 4) {
if ($hkzone !== true) {
header("Location: index/?throwBack=true");
exit;
}
if (!mobbo::session_is_registered(acp)) {
header("Location: p/login");
exit;
}
$pagename = "Alertas";
$pageid = "alert";
if (isset($_POST['alert'])) {
$check = Transaction::query("SELECT * FROM users WHERE username = '" . Security::textFilter($_POST['name']) . "' LIMIT 1");
if (Transaction::num_rows($check) > 0) {
$userdata = Transaction::fetch($check);
Transaction::query("INSERT INTO mobbo_alerts (userid,alert) VALUES ('" . $userdata['id'] . "','" . Security::textFilter($_POST['alert']) . "')");
$msg = "<div class='rounded rounded-green'><center>Alerta enviada a " . Security::textFilter($_POST['name']) . " (ID: " . $userdata['id'] . ") <img src=\"./w/images/check.gif\"></center></div>";
} else {
$msg = "<div class='rounded rounded-red'><center>Oops! este usurio no foi encontrado. <img src=\"./w/images/del.gif\"></center></div>";
}
}
@(include 'subheader.php');
if (isset($msg)) {
?>
<p><strong><?php
echo $msg;
?>
</strong></p><?php
}
?>示例14: header
}
if ($user_rank > 5) {
if ($hkzone !== true) {
header("Location: index.php?throwBack=true");
exit;
}
if (!mobbo::session_is_registered(acp)) {
header("Location: index.php?p=login");
exit;
}
$pagename = "Banimentos";
$pageid = "ban";
if (isset($_POST['value']) && $_POST['length'] && $_POST['reason']) {
$check_exists = Transaction::query("SELECT * FROM bans WHERE value = '" . Security::textFilter($_POST['value']) . "' AND bantype = '" . Security::textFilter($_POST['type']) . "'");
$get_cc = Transaction::query("SELECT * FROM users WHERE username = '" . $_POST['value'] . "'");
$userdata = Transaction::fetch($get_cc);
if (Transaction::num_rows($check_exists) > 0) {
Transaction::query("UPDATE bans SET expire = expire + '" . Security::textFilter($_POST['length']) . "' WHERE value = '" . Security::textFilter($_POST['value']) . "' AND bantype = '" . Security::textFilter($_POST['type']) . "'");
$msg = "<div class='rounded rounded-green'><center>El ban (" . Security::textFilter($_POST['type']) . " - " . Security::textFilter($_POST['value']) . ") ha sido actualizado. <img src=\"./w/images/check.gif\"></center></div>";
} else {
if (Transaction::num_rows($get_cc) > 0 && $_POST['type'] == "user") {
Transaction::query("INSERT INTO bans (bantype,value,reason,expire,added_by,added_date) VALUES ('" . Security::textFilter($_POST['type']) . "','" . Security::textFilter($_POST['value']) . "','" . Security::textFilter($_POST['reason']) . "','" . time() . "' + '" . Security::textFilter($_POST['length']) . "','" . $name . "','" . time() . "')");
Transaction::query("UPDATE users SET auth_ticket = '' WHERE username = '" . Security::textFilter($_POST['value']) . "' LIMIT 1");
$msg = "<div class='rounded rounded-green'><center>" . $_POST['value'] . " foi banido <img src=\"./w/images/check.gif\"></center></div>";
} elseif (Transaction::num_rows($get_cc) < 1 && $_POST['type'] == "user") {
$msg = "<div class='rounded rounded-red'><center>No foi possvel encontrar o usurio <img src=\"./w/images/del.gif\"></center></div>";
} elseif ($_POST['type'] == "ip") {
Transaction::query("INSERT INTO bans (bantype,value,reason,expire,added_by,added_date) VALUES ('" . Security::textFilter($_POST['type']) . "','" . Security::textFilter($_POST['value']) . "','" . Security::textFilter($_POST['reason']) . "','" . time() . "' + '" . Security::textFilter($_POST['length']) . "','" . $name . "','" . time() . "')");
Transaction::query("UPDATE users SET auth_ticket = '' WHERE username = '" . Security::textFilter($_POST['value']) . "' LIMIT 1");
$msg = "<div class='rounded rounded-green'><center>O IP " . Security::textFilter($_POST['value']) . " foi banido! <img src=\"./w/images/check.gif\"></center></div>";
}示例15: while
<td class='tablesubheader' width='20%' align='left'>Descrio</td>
<td class='tablesubheader' width='10%' align='left'>Imagem (50% do tamanho original)</td>
<td class='tablesubheader' width='10%' align='left'>URL</td>
<td class='tablesubheader' width='7%' align='left'>Boto</td>
<td class='tablesubheader' width='1%' align='center'>Editar</td>
<td class='tablesubheader' width='1%' align='center'>Excluir</td>
</tr>
<?php
$query_min = $page * 50 - 50;
if ($query_min < 0) {
// Page 1
$query_min = 0;
}
$get_hotcampaigns = Transaction::query("SELECT * FROM mobbo_hotcampaigns ORDER BY id DESC LIMIT " . $query_min . ", 50");
while ($row = Transaction::fetch($get_hotcampaigns)) {
?>
<tr>
<td class='tablerow1' align='center'><?php
echo $row['id'];
?>
</td>
<td class='tablerow2'><?php
echo $row['caption'];
?>
</td>
<td class='tablerow2' align='left'><?php
echo $row['descr'];
?>
</td>