本文整理汇总了PHP中mysqli_result函数的典型用法代码示例。如果您正苦于以下问题:PHP mysqli_result函数的具体用法?PHP mysqli_result怎么用?PHP mysqli_result使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysqli_result函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: getResult
function getResult($query)
{
return mysqli_result($this->conn, $query);
}
开发者ID:roshanmadhushanka,项目名称:Environment-Monitoring-System,代码行数:4,代码来源:DBase.php
示例2: read_invitations
function read_invitations()
{
global $TABLE_PREFIX, $admintpl, $language, $CURUSER, $STYLEPATH, $btit_settings;
$scriptname = htmlspecialchars($_SERVER["PHP_SELF"] . "?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=invitations");
$addparam = "";
$res = get_result("SELECT COUNT(*) as invites FROM {$TABLE_PREFIX}invitations", true);
$count = $res[0]["invites"];
list($pagertop, $pagerbottom, $limit) = pager('15', $count, $scriptname . "&");
$admintpl->set("inv_pagertop", $pagertop);
$admintpl->set("inv_pagerbottom", $pagerbottom);
$results = get_result("SELECT * FROM {$TABLE_PREFIX}invitations ORDER BY id DESC {$limit}", true);
$invitees = array();
$i = 0;
foreach ($results as $id => $data) {
$res = do_sqlquery("SELECT username FROM {$TABLE_PREFIX}users WHERE id = " . $data["inviter"], true);
if (mysqli_num_rows($res) > 0) {
$inviter_name = mysqli_result($res, 0, 0);
} else {
$inviter_name = 'Unknown';
}
$invitees[$i]["inviter"] = "<a href=\"index.php?page=userdetails&user=" . $data["inviter"] . "\">" . $inviter_name . "</a>";
$invitees[$i]["invitee"] = unesc($data["invitee"]);
$invitees[$i]["hash"] = unesc($data["hash"]);
$invitees[$i]["time_invited"] = $data["time_invited"];
$invitees[$i]["delete"] = "<a href=\"index.php?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=invitations&action=delete&id=" . $data["id"] . "\" onclick=\"return confirm('" . AddSlashes($language["DELETE_CONFIRM"]) . "')\">" . image_or_link("{$STYLEPATH}/images/delete.png", "", $language["DELETE"]) . "</a>";
$i++;
}
$admintpl->set("invitees", $invitees);
$admintpl->set("language", $language);
}
开发者ID:Karpec,项目名称:gizd,代码行数:30,代码来源:admin.invitations.php
示例3: user_id_from_username
function user_id_from_username($username)
{
global $db;
$username = sanitize($username);
$query2 = mysqli_query($db, "SELECT (`id`) FROM `users` WHERE `username` = '{$username}'");
return mysqli_result($query2, 0, 'id');
}
开发者ID:AleksandarGjorgievski,项目名称:biblioteka,代码行数:7,代码来源:users.php
示例4: book_exists
function book_exists($bookname)
{
global $db;
$bookname = sanitize($bookname);
$query = mysqli_query($db, "SELECT COUNT(`title`) FROM `books` WHERE `title` = '{$bookname}'");
return mysqli_result($query, 0) == 1 ? true : false;
}
开发者ID:AleksandarGjorgievski,项目名称:biblioteka,代码行数:7,代码来源:general.php
示例5: product_picture
function product_picture($product_id)
{
$connect = Database();
$picture_result = mysqli_result(mysqli_query($connect, "SELECT picture_type FROM product_pictures WHERE product_id='{$product_id}';"));
$picture_type = $picture_result['picture_type'];
$picture_url = "../@pages/images/products/" . $product_id . "_1." . $picture_type;
return $picture_url;
}
开发者ID:ideagital,项目名称:jinuemall.com,代码行数:8,代码来源:function.php
示例6: plogger_stats_count_total_comments
function plogger_stats_count_total_comments()
{
$query = "SELECT COUNT(*) AS `n` FROM `" . PLOGGER_TABLE_PREFIX . "comments` WHERE approved = 1";
$result = run_query($query);
$num_comments = mysqli_result($result, 0, 'n');
echo $num_comments . ' ';
echo $num_comments == 1 ? plog_tr('comment') : plog_tr('comments');
}
开发者ID:nadams810,项目名称:ploto,代码行数:8,代码来源:theme_functions.php
示例7: user_count
function user_count()
{
// pentru a arata cati utilizatori inregistrati avem pe site
include 'core/db/db_connection.php';
$sql = "SELECT COUNT(user_id) FROM `_users` WHERE active = 1";
$data = mysqli_query($dbCon, $sql);
return mysqli_result($data, 0);
}
开发者ID:vpandichi,项目名称:worldtour_proiect,代码行数:8,代码来源:general.php
示例8: getScoreByStrategy
function getScoreByStrategy($roundId, $strategyId)
{
$link = getDBConnection();
if (mysqli_select_db($link, getDBName())) {
$roundId = intval($roundId);
$strategyId = intval($strategyId);
return mysqli_result(mysqli_query($link, "SELECT score FROM scores WHERE round = {$roundId} AND strategy = {$strategyId}"), 0);
}
}
开发者ID:CSchool,项目名称:AIBattle,代码行数:9,代码来源:procStrategies.php
示例9: login
function login($username, $password)
{
require 'core/database/connect.php';
//file that connects to database
$user_id = user_id_from_username($username);
$username = sanitize($username);
// $password = md5($password); ideally we want to encrypt the password when the user registers
return mysqli_result(mysqli_query($connect, "SELECT COUNT(`ID`) FROM `users` WHERE `UserName` = '{$username}' AND `Password` = '{$password}'"), 0) == 1 ? $user_id : false;
}
开发者ID:abelhect,项目名称:merkdoenvio,代码行数:9,代码来源:user.php
示例10: tableExists
function tableExists($tablename, $database = false)
{
global $dbTmp;
if (!$database) {
$res = mysqli_query($dbTmp, "SELECT DATABASE()");
$database = mysqli_result($res, 0);
}
$res = mysqli_query($dbTmp, "SELECT COUNT(*) as count\n FROM information_schema.tables\n WHERE table_schema = '{$database}'\n AND table_name = '{$tablename}'");
return mysqli_result($res, 0) == 1;
}
开发者ID:macwinnie,项目名称:TeamPass,代码行数:10,代码来源:upgrade_ajax.php
示例11: grr_sql_query1
function grr_sql_query1($sql)
{
$r = mysqli_query($GLOBALS['db_c'], $sql);
if (!$r) {
return -1;
}
if (mysqli_num_rows($r) != 1 || mysqli_field_count($GLOBALS['db_c']) != 1 || ($result_ = mysqli_result($r, 0, 0)) == "") {
$result_ = -1;
}
mysqli_free_result($r);
return $result_;
}
开发者ID:Sirlefou1,项目名称:GRR2,代码行数:12,代码来源:mysql.inc.php
示例12: login
function login()
{
$db_host = 'localhost';
$db_username = 'root';
$db_password = '';
$db_name = 'Attendance';
$con = mysql_connect($db_host, $db_username, $db_password) or die(mysql_error());
mysql_select_db($db_name);
$query = "SELECT * FROM users WHERE email = '" . $_POST['email'] . "' AND password = '" . $_POST['password'] . "'; ";
mysqli_query($conn, $query);
if (mysqli_result()) {
header("Location: Attendace.php");
/* Redirect browser */
exit;
} else {
$credentials = false;
}
}
开发者ID:youcaf,项目名称:Laab_11_Web,代码行数:18,代码来源:LoginForm.php
示例13: read_styles
function read_styles()
{
global $TABLE_PREFIX, $language, $CURUSER, $admintpl, $STYLEPATH;
$sres = style_list();
for ($i = 0; $i < count($sres); $i++) {
$res = do_sqlquery("SELECT COUNT(*) FROM {$TABLE_PREFIX}users WHERE style = " . $sres[$i]["id"], true);
$sres[$i]["style_users"] = mysqli_result($res, 0, 0);
$sres[$i]["style"] = unesc($sres[$i]["style"]);
$sres[$i]["style_url"] = unesc($sres[$i]["style_url"]);
$sres[$i]["style_type"] = $sres[$i]["style_type"] == 1 ? $language["CLA_STYLE"] : ($sres[$i]["style_type"] == 2 ? $language["ATM_STYLE"] : ($sres[$i]["style_type"] == 3 ? $language["PET_STYLE"] : $language["UNKNOWN"]));
$sres[$i]["edit"] = "<a href=\"index.php?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=style&action=edit&id=" . $sres[$i]["id"] . "\">" . image_or_link("{$STYLEPATH}/images/edit.png", "", $language["EDIT"]) . "</a>";
$sres[$i]["delete"] = "<a href=\"index.php?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=style&action=delete&id=" . $sres[$i]["id"] . "\" onclick=\"return confirm('" . AddSlashes($language["DELETE_CONFIRM"]) . "')\">" . image_or_link("{$STYLEPATH}/images/delete.png", "", $language["DELETE"]) . "</a>";
}
$admintpl->set("style_add", false, true);
$admintpl->set("language", $language);
$admintpl->set("styles", $sres);
$admintpl->set("style_add_new", "<a href=\"index.php?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=style&action=add\">" . $language["STYLE_ADD"] . "</a>");
unset($sres);
mysqli_free_result($res) || is_object($res) && get_class($res) == "mysqli_result" ? true : false;
}
开发者ID:fchypzero,项目名称:cybyd,代码行数:20,代码来源:admin.styles.php
示例14: ishappyHour
function ishappyHour($n)
{
global $TABLE_PREFIX;
$happyHour = mysqli_result(mysqli_query($GLOBALS["___mysqli_ston"], "SELECT UNIX_TIMESTAMP(value_s) FROM {$TABLE_PREFIX}avps WHERE arg='happyhour'"), 0);
$happyDate = date("Y-m-d H:i", $happyHour);
$curDate = date("Y-m-d H:i");
$nextDate = date("Y-m-d H:i", $happyHour + 3600);
if ($n == "check") {
if ($happyDate < $curDate && $nextDate >= $curDate) {
return true;
}
}
if ($n == "time") {
$timeLeft = $happyHour + 3600 - time();
return NDF($timeLeft);
}
}
开发者ID:Karpec,项目名称:gizd,代码行数:17,代码来源:functions.php
示例15: unesc
$modules[$i]["module_activated"] = $language["NO"] . " -> <a href=\"index.php?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=module_config&action=change_to_yes&id=" . unesc($row_modules["id"]) . "\">" . $language["ACTIVATE"] . "</a>";
}
// yes
$modules[$i]["module_date_changed"] = unesc($row_modules["changed"]);
// when last switched on or off
$modules[$i]["module_date_created"] = unesc($row_modules["created"]);
// the date created
$i++;
}
$admintpl->set("modules", $modules);
$active_modules = do_sqlquery("SELECT COUNT(*) FROM {$TABLE_PREFIX}modules WHERE activated='yes'", true);
$admintpl->set("nr_active_modules", mysqli_result($active_modules, 0, 0));
$not_active_modules = do_sqlquery("SELECT COUNT(*) FROM {$TABLE_PREFIX}modules WHERE activated='no'", true);
$admintpl->set("nr_not_active_modules", mysqli_result($not_active_modules, 0, 0));
$total_modules = do_sqlquery("SELECT COUNT(*) FROM {$TABLE_PREFIX}modules", true);
$admintpl->set("nr_total_modules", mysqli_result($total_modules, 0, 0));
$admintpl->set("form_action", "index.php?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=module_config&action=add");
break;
// end of case 'manage'
// end of case 'manage'
case 'change_to_yes':
$id = max(0, $_GET["id"]);
$admintpl->set("language", $language);
do_sqlquery("UPDATE {$TABLE_PREFIX}modules SET activated='yes', changed=NOW() WHERE id={$id}", true);
redirect("index.php?page=admin&user=" . $CURUSER["uid"] . "&code=" . $CURUSER["random"] . "&do=module_config&action=manage");
die;
break;
case 'change_to_no':
$id = max(0, $_GET["id"]);
$admintpl->set("language", $language);
do_sqlquery("UPDATE {$TABLE_PREFIX}modules SET activated='no', changed=NOW() WHERE id={$id}", true);
开发者ID:Karpec,项目名称:gizd,代码行数:31,代码来源:admin.module_config.php
示例16: unesc
$tztpl["tz_combo"] .= "value=\"" . $timezone["difference"] . "\">" . unesc($timezone["timezone"]) . "</option>";
$tztpl["tz_combo"] .= $option;
}
unset($tres);
$usercptpl->set("tz", $tztpl);
if ($FORUMLINK == "" || $FORUMLINK == "internal") {
$usercptpl->set("INTERNAL_FORUM", true, true);
$profiletpl["topicsperpage"] = $CURUSER["topicsperpage"];
$profiletpl["postsperpage"] = $CURUSER["postsperpage"];
}
$profiletpl["torrentsperpage"] = $CURUSER["torrentsperpage"];
$profiletpl["commentpm"] = $CURUSER["commentpm"] == "true" ? "checked=\"checked\"" : "";
$profiletpl["frm_cancel"] = "index.php?page=usercp&uid=" . $uid . "";
$uid = $CURUSER['uid'];
$r = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT parked from {$TABLE_PREFIX}users where id = {$uid}");
$p = mysqli_result($r, 0, "parked");
if ($p != 0) {
$profiletpl["parked"] .= "<input name=\"park\" id=\"park\" type=\"radio\" value=\"0\" />\n " . $language["NO"] . "";
$profiletpl["parked"] .= "<input name=\"park\" id=\"park\" type=\"radio\" value=\"1\" checked=\"checked\" />\n " . $language["YES"] . "";
} else {
$profiletpl["parked"] .= "<input name=\"park\" id=\"park\" type=\"radio\" value=\"0\" checked=\"checked\" />\n " . $language["NO"] . "";
$profiletpl["parked"] .= "<input name=\"park\" id=\"park\" type=\"radio\" value=\"1\" />\n " . $language["YES"] . "";
$profiletpl["parked"] .= $option;
}
// Userbar
$res = do_sqlquery("SELECT * FROM {$TABLE_PREFIX}userbars", true);
while ($row = mysqli_fetch_array($res)) {
$bars[$row['id']] = array('desc' => $row['description'], 'img' => $row['img']);
}
$js_userbar = '';
foreach ($bars as $value => $key) {
开发者ID:Karpec,项目名称:gizd,代码行数:31,代码来源:usercp.profile.php
示例17: result
public function result($query, $row)
{
$query = @mysqli_result($query, $row);
return $query;
}
开发者ID:jackycgq,项目名称:wuzhicms,代码行数:5,代码来源:mysqli.class.php
示例18: mailbox_delete_mailbox
function mailbox_delete_mailbox($link, $postarray)
{
$username = mysqli_real_escape_string($link, $postarray['username']);
global $logged_in_role;
global $logged_in_as;
if (!mysqli_result(mysqli_query($link, "SELECT domain FROM mailbox WHERE username='" . $username . "' AND (domain NOT IN (SELECT domain from domain_admins WHERE username='" . $logged_in_as . "') OR 'admin'!='" . $logged_in_role . "')"))) {
$_SESSION['return'] = array('type' => 'danger', 'msg' => 'Permission denied');
return false;
}
if (!filter_var($username, FILTER_VALIDATE_EMAIL)) {
$_SESSION['return'] = array('type' => 'danger', 'msg' => 'Invalid mailbox');
return false;
}
$delete_user = "DELETE FROM alias WHERE goto='" . $username . "';";
$delete_user .= "UPDATE alias SET goto=REPLACE(goto, '," . $username . ",', ',');";
$delete_user .= "UPDATE alias SET goto=REPLACE(goto, '," . $username . "', '');";
$delete_user .= "UPDATE alias SET goto=REPLACE(goto, '" . $username . ",', '');";
$delete_user .= "DELETE FROM quota2 WHERE username='" . $username . "';";
$delete_user .= "DELETE FROM calendarobjects WHERE calendarid IN (SELECT id from calendars where principaluri='principals/" . $username . "');";
$delete_user .= "DELETE FROM cards WHERE addressbookid IN (SELECT id from calendars where principaluri='principals/" . $username . "');";
$delete_user .= "DELETE FROM mailbox WHERE username='" . $username . "';";
$delete_user .= "DELETE FROM sender_acl WHERE logged_in_as='" . $username . "';";
$delete_user .= "DELETE FROM users WHERE username='" . $username . "';";
$delete_user .= "DELETE FROM principals WHERE uri='principals/" . $username . "';";
$delete_user .= "DELETE FROM principals WHERE uri='principals/" . $username . "/calendar-proxy-read';";
$delete_user .= "DELETE FROM principals WHERE uri='principals/" . $username . "/calendar-proxy-write';";
$delete_user .= "DELETE FROM addressbooks WHERE principaluri='principals/" . $username . "';";
$delete_user .= "DELETE FROM calendars WHERE principaluri='principals/" . $username . "';";
if (!mysqli_multi_query($link, $delete_user)) {
$_SESSION['return'] = array('type' => 'danger', 'msg' => 'MySQL Error: ' . mysqli_error($link));
return false;
}
while ($link->next_result()) {
if (!$link->more_results()) {
break;
}
}
$_SESSION['return'] = array('type' => 'success', 'msg' => 'Deleted mailbox ' . htmlspecialchars($username));
}
开发者ID:jannickfahlbusch,项目名称:mailcow,代码行数:39,代码来源:functions.inc.php
示例19: do_sqlquery
$_GET['id'] = 0 + $_GET['id'];
}
if ($_GET['do'] == 'deny' and is_valid_id($_GET['id']) and $CURUSER["edit_users"] == "yes") {
do_sqlquery('UPDATE ' . $TABLE_PREFIX . 'shoutcastdj SET active = \'2\' WHERE id = \'' . (0 + $_GET['id']) . '\'', true);
if (mysqli_affected_rows($GLOBALS["___mysqli_ston"])) {
$Query = do_sqlquery('SELECT uid FROM ' . $TABLE_PREFIX . 'shoutcastdj WHERE id = \'' . (0 + $_GET['id']) . '\'', true);
send_pm(0, mysqli_result($Query, 0, 'uid'), sqlesc($language['subject']), sqlesc($language['dmsg']));
}
$_GET['do'] = 'list';
$_GET['id'] = 0 + $_GET['id'];
}
if ($_GET['do'] == 'kick' and is_valid_id($_GET['id']) and $CURUSER["edit_users"] == "yes") {
do_sqlquery('UPDATE ' . $TABLE_PREFIX . 'shoutcastdj SET active = \'3\' WHERE id = \'' . (0 + $_GET['id']) . '\'', true);
if (mysqli_affected_rows($GLOBALS["___mysqli_ston"])) {
$Query = do_sqlquery('SELECT uid FROM ' . $TABLE_PREFIX . 'shoutcastdj WHERE id = \'' . (0 + $_GET['id']) . '\'', true);
send_pm(0, mysqli_result($Query, 0, 'uid'), sqlesc($language['subject2']), sqlesc($language['kmsg']));
}
$_GET['do'] = 'list';
$_GET['id'] = 0 + $_GET['id'];
}
if ($_GET['do'] == 'request') {
$query = do_sqlquery('SELECT uid FROM ' . $TABLE_PREFIX . 'shoutcastdj WHERE uid = \'' . $CURUSER['uid'] . '\'', true);
if (0 < mysqli_num_rows($query)) {
stderr($language['ERROR'], $language['already']);
}
$Query = do_sqlquery('SELECT t.*, u.username, g.prefixcolor, g.suffixcolor FROM ' . $TABLE_PREFIX . 'shoutcastdj t LEFT JOIN ' . $TABLE_PREFIX . 'users u ON t.uid=u.id LEFT JOIN ' . $TABLE_PREFIX . 'users_level g ON u.id_level=g.id WHERE t.active=1', true);
if (mysqli_num_rows($Query)) {
$reqform = '<br />
<table width="100%" align="center" border="0" cellpadding="3" cellspacing="0">
<tr>
<td colspan="5" class="header"><center>' . $language['djlist'] . '</center></td>
开发者ID:Karpec,项目名称:gizd,代码行数:31,代码来源:dj.php
示例20: mailbox_delete_mailbox
function mailbox_delete_mailbox($link, $postarray)
{
$username = mysqli_real_escape_string($link, $_POST['username']);
global $logged_in_role;
global $logged_in_as;
if (!mysqli_result(mysqli_query($link, "SELECT domain FROM mailbox WHERE username='{$username}' AND (domain NOT IN (SELECT domain from domain_admins WHERE username='{$logged_in_as}') OR 'admin'!='{$logged_in_role}')"))) {
header("Location: do.php?event=" . base64_encode("Permission denied"));
die("Permission denied");
}
if (!filter_var($username, FILTER_VALIDATE_EMAIL)) {
header("Location: do.php?event=" . base64_encode("Mail address invalid"));
die("Mail address invalid");
}
$delete_user = "DELETE FROM alias WHERE goto='{$username}';";
$delete_user .= "UPDATE alias SET goto=REPLACE(goto, ',{$username},', ',');";
$delete_user .= "UPDATE alias SET goto=REPLACE(goto, ',{$username}', '');";
$delete_user .= "UPDATE alias SET goto=REPLACE(goto, '{$username},', '');";
$delete_user .= "DELETE FROM quota2 WHERE username='{$username}';";
$delete_user .= "DELETE FROM calendarobjects WHERE calendarid IN (SELECT id from calendars where principaluri='principals/{$username}');";
$delete_user .= "DELETE FROM cards WHERE addressbookid IN (SELECT id from calendars where principaluri='principals/{$username}');";
$delete_user .= "DELETE FROM mailbox WHERE username='{$username}';";
$delete_user .= "DELETE FROM users WHERE username='{$username}';";
$delete_user .= "DELETE FROM principals WHERE uri='principals/{$username}';";
$delete_user .= "DELETE FROM principals WHERE uri='principals/{$username}/calendar-proxy-read';";
$delete_user .= "DELETE FROM principals WHERE uri='principals/{$username}/calendar-proxy-write';";
$delete_user .= "DELETE FROM addressbooks WHERE principaluri='principals/{$username}';";
$delete_user .= "DELETE FROM calendars WHERE principaluri='principals/{$username}';";
if (!mysqli_multi_query($link, $delete_user)) {
header("Location: do.php?event=" . base64_encode("MySQL query failed"));
die("MySQL query failed");
}
while ($link->next_result()) {
if (!$link->more_results()) {
break;
}
}
header('Location: do.php?return=success');
}
开发者ID:efux,项目名称:mailcow,代码行数:38,代码来源:functions.inc.php
注:本文中的mysqli_result函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论