本文整理汇总了PHP中mysql_result函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_result函数的具体用法?PHP mysql_result怎么用?PHP mysql_result使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_result函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: findTrackData
function findTrackData($delta, $pic_time, $datum, $pic_id)
{
//Bestimmung des Trackpunktes mit der kleinsten zeitlichen Abweichung vom Aufnahme-Zeitpunkt:
include '../../share/global_config.php';
include $sr . '/bin/share/db_connect1.php';
if (!isset($i10)) {
$i10 = 0;
}
$delta = $delta - 1;
$start_time = date('H:i:s', strtotime("{$pic_time} - {$delta} seconds"));
$end_time = date('H:i:s', strtotime("{$pic_time} + {$delta} seconds"));
//echo "Zeitgrenzen fuer Trackdaten: ".$start_time." - ".$end_time."<BR>";
$result8 = mysql_query("SELECT * FROM {$table13} WHERE date = '{$datum}' AND (time = '{$start_time}' OR time = '{$end_time}')");
$num8 = mysql_num_rows($result8);
//Wenn mehrere Trackpunkte gefunden werden, werden willkuerlich die Daten des ersten verwendet:
$longitude = mysql_result($result8, 0, 'longitude');
$latitude = mysql_result($result8, 0, 'latitude');
$altitude = mysql_result($result8, 0, 'altitude');
//in der 'locations' gespeichert und mit dem Bild 'pic_id' verknuepft:
$result9 = mysql_query("INSERT INTO {$table12} (longitude, latitude, altitude) VALUES ('{$longitude}', '{$latitude}', '{$altitude}')");
echo mysql_error();
$result10 = mysql_query("SELECT max(loc_id) FROM {$table12}");
$loc_id = mysql_result($result10, $i10, 'max(loc_id)');
//echo "<".$loc_id." >";
$result11 = mysql_query("UPDATE {$table2} SET loc_id = '{$loc_id}' WHERE pic_id = '{$pic_id}'");
}
开发者ID:BackupTheBerlios,项目名称:pic2base-svn,代码行数:26,代码来源:geo_functions.php
示例2: selectrec
function selectrec($fields, $table, $cond = "")
{
$a = array();
$query = "select " . $fields . " from " . $table;
if (!($cond == "")) {
$query = $query . " where " . $cond;
}
//echo "<br>".$query;
$result = mysql_query($query);
//echo mysql_error();
//if (mysql_error()!="")
//echo "<br>".$query;
$numrows = mysql_num_rows($result);
$numfields = mysql_num_fields($result);
$i = $j = 0;
while ($i < $numrows) {
while ($j < $numfields) {
$a[$i][$j] = mysql_result($result, $i, mysql_field_name($result, $j));
$j++;
}
$i++;
$j = 0;
}
mysql_free_result($result);
return $a;
}
开发者ID:hscta,项目名称:Dynamo_Aviation_EPC_Demo,代码行数:26,代码来源:function.php
示例3: seleccionar_valor_condicion
public function seleccionar_valor_condicion($columna, $fila, $condicion, $c_valor)
{
$consulta = mysql_result(mysql_query("SELECT {$columna} FROM {$fila} WHERE {$condicion}='" . $c_valor . "' ", $this->link), 0);
echo $consulta;
mysql_free_result($consulta);
mysql_close($this->link);
}
开发者ID:redigaffi,项目名称:SimpleForum,代码行数:7,代码来源:practicas.php
示例4: upd_last_cast
function upd_last_cast($pl, $spell)
{
//$pl = preg_replace ('/[^a-z0-9_]/i', '', $pl);
//$spell = preg_replace ('/[^a-z0-9_]/i', '', $spell);
$now = time();
$id = is_player($pl);
if (!$id) {
put_error('npc cant cast spell');
}
$q = do_mysql("SELECT last FROM players WHERE id_player = '" . $id . "';");
$last = mysql_result($q, 0);
$last = explode('|', $last);
// vremja zaklinanija:
$q = do_mysql("SELECT timewait FROM magic WHERE fullname = '" . $spell . "';");
if (!mysql_num_rows($q)) {
put_error('there are no such spell: ' . $spell . '');
}
$tw = mysql_result($q, 0);
$last[3] = $now + $tw;
// obrabotka effektami:
#include_once ('modules/f_get_affected.php');
// effecty:
#$aff = get_affected ($LOGIN);
// primer: if (is_in ('oglushen', $aff)) $last[3] += 10;
$nlast = $last[0] . '|' . $last[1] . '|' . $last[2] . '|' . $last[3] . '|' . $last[4] . '|' . $last[5] . '|' . $last[6] . '|' . $last[7] . '|' . $last[8];
do_mysql("UPDATE players SET last = '" . $nlast . "' WHERE id_player = '" . $id . "';");
return 1;
}
开发者ID:nadvamir,项目名称:forgotten-story-mmorpg,代码行数:28,代码来源:f_upd_last_cast.php
示例5: Login
/**
* Logs this stake leader into the session given username and password
* @var $eml = The email address
* @var $pwd = The plaintext password (will be salted and hashed)
* @return If successful, the StakeLeader object. Otherwise null.
*/
public static function Login($eml, $pwd)
{
// Sanitize input
$eml = DB::Safe($eml);
// First, we need to obtain this stake leader's unique salt
$r = DB::Run("SELECT `Salt` FROM `Credentials` WHERE `Email`='{$eml}' AND `StakeLeaderID` > 0 LIMIT 1");
if (mysql_num_rows($r) == 0) {
return null;
}
$salt = mysql_result($r, 0);
// Now hash input according to our hashing algorithm and leader's salt
$pwd = hashPwd($pwd, $salt);
// See if the email/password combination are correct
$try = DB::Run("SELECT StakeLeaderID FROM Credentials WHERE Email='{$eml}' AND Password='{$pwd}' AND StakeLeaderID > 0 LIMIT 1");
if (mysql_num_rows($try) == 0) {
return null;
}
// At this point, valid credentials were entered. Proceed...
$stakeLeaderID = mysql_result($try, 0);
$stakeLeader = StakeLeader::Load($stakeLeaderID);
// Update LastActivity
$stakeLeader->UpdateLastActivity();
// Since they've logged in, no more need for existing
// password reset tokens. Delete any strays for security.
$q = "DELETE FROM PwdResetTokens WHERE CredentialsID={$stakeLeader->CredentialsID()}";
DB::Run($q);
// Save the session. This is the actual "logging in" part.
session_regenerate_id();
// Helps prevent session hijacking
$_SESSION["stakeLeaderID"] = $stakeLeaderID;
$_SESSION["timestamp"] = time();
$_SESSION["ipaddress"] = $_SERVER['REMOTE_ADDR'];
return $stakeLeader;
}
开发者ID:bluegate010,项目名称:ysaward,代码行数:40,代码来源:StakeLeader.php
示例6: affichage_liste_bulletins_normale
function affichage_liste_bulletins_normale($res)
{
global $charset, $dbh;
while ($tableau = mysql_fetch_array($res)) {
$sql = "SELECT COUNT(1) FROM explnum WHERE explnum_bulletin='" . $tableau["bulletin_id"] . "'";
$result = @mysql_query($sql, $dbh);
$count = mysql_result($result, 0, 0);
print "<span class='liste_bulletins'>";
if ($count) {
$padding = "";
print '<img src="./images/attachment.png">';
} else {
$padding = "style=\"padding-left:11px;\"";
}
print "<a href=./index.php?lvl=bulletin_display&id=" . $tableau['bulletin_id'] . " " . $padding . ">" . $tableau['bulletin_numero'];
if ($tableau['mention_date']) {
print pmb_bidi(" (" . $tableau['mention_date'] . ")\n");
} elseif ($tableau['date_date']) {
print pmb_bidi(" (" . formatdate($tableau['date_date']) . ")\n");
}
if ($tableau['bulletin_titre']) {
print pmb_bidi(" : " . htmlentities($tableau['bulletin_titre'], ENT_QUOTES, $charset) . "\n");
}
print "</a> ;";
print "</span>\n";
}
}
开发者ID:bouchra012,项目名称:PMB,代码行数:27,代码来源:bul_list_func.inc.php
示例7: displayBannedUsers
/**
* displayBannedUsers - Displays the banned users
* database table in a nicely formatted html table.
*/
function displayBannedUsers(){
global $database;
$q = "SELECT username,timestamp "
."FROM ".TBL_BANNED_USERS." ORDER BY username";
$result = $database->query($q);
/* Error occurred, return given name by default */
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0)){
echo "Error displaying info";
return;
}
if($num_rows == 0){
echo "Database table empty";
return;
}
/* Display table contents */
echo "<table align=\"left\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n";
echo "<tr><td><b>Username</b></td><td><b>Time Banned</b></td></tr>\n";
for($i=0; $i<$num_rows; $i++){
$uname = mysql_result($result,$i,"username");
$time = mysql_result($result,$i,"timestamp");
echo "<tr><td>$uname</td><td>$time</td></tr>\n";
}
echo "</table><br>\n";
}
开发者ID:rebot,项目名称:Rebot.net,代码行数:30,代码来源:admin.php
示例8: Siguiente_Etapa
public function Siguiente_Etapa($etapa)
{
$query = sprintf("select et_siguiente_etapa from etapas where et_id=%s", $etapa);
$rst = parent::consultar($query);
$etapa = mysql_result($rst, 0, 0);
return $etapa;
}
开发者ID:hackdracko,项目名称:belcorp,代码行数:7,代码来源:Etapa.php
示例9: index
public function index()
{
if ($this->session->userdata("login_id") == '') {
redirect("login");
}
if ($this->input->post("post_create_ad")) {
$this->postad_property_model->postad_creat();
}
$data = array("property_residential" => $this->category_model->property_residential(), "property_commercial" => $this->category_model->property_commercial(), "title" => "Classifieds", "content" => "postad_create_property");
$cat = $this->input->post('property_cat');
$sub_cat = $this->input->post('property_sub');
$sub_sub_cat = $this->input->post('property_sub_sub');
$sub_name = @mysql_result(mysql_query("SELECT * FROM `sub_category` WHERE sub_category_id = '{$sub_cat}'"), 0, 'sub_category_name');
$sub_sub_name = @mysql_result(mysql_query("SELECT * FROM `sub_subcategory` WHERE `sub_subcategory_id` = '{$sub_sub_cat}'"), 0, 'sub_subcategory_name');
if ($sub_name == '') {
redirect('post-a-deal');
}
$data['cat'] = $cat;
$data['sub_name'] = $sub_name;
$data['sub_sub_name'] = $sub_sub_name;
/*id for category*/
$data['sub_id'] = $sub_cat;
$data['sub_sub_id'] = $sub_sub_cat;
$data['login_id'] = $this->session->userdata("login_id");
$data['package_name'] = $this->category_model->package_name();
$data['free_pkg_list'] = $this->category_model->free_pkg_list();
$data['gold_pkg_list'] = $this->category_model->gold_pkg_list();
$data['ptm_pkg_list'] = $this->category_model->ptm_pkg_list();
$data['urgentlabel1'] = $this->category_model->urgentlabel1();
$data['urgentlabel2'] = $this->category_model->urgentlabel2();
$data['urgentlabel3'] = $this->category_model->urgentlabel3();
$data['free_likes'] = $this->category_model->free_likes();
$data['gold_likes'] = $this->category_model->gold_likes();
$this->load->view("classified_layout/inner_template", $data);
}
开发者ID:Anuragigts,项目名称:igts_classified,代码行数:35,代码来源:postad_create_property.php
示例10: decr_abstr_misc
function decr_abstr_misc($prot, $who, $count, $other = 0)
{
//$prot = preg_replace ('/[^a-z0-9_\.]/i', '', $prot);
$count = preg_replace('/[^0-9]/', '', $count);
//$who = preg_replace ('/[^a-z0-9_]/i', '', $who);
if (!is_player($who)) {
return 0;
}
if ($count < 1) {
return 0;
}
$q = do_mysql("SELECT on_take FROM items WHERE belongs = '" . $who . "' AND is_in = 'inv' AND realname = '" . $prot . "' AND type = 'm';");
if (!mysql_num_rows($q)) {
return 0;
}
$ci = mysql_result($q, 0);
if ($ci < $count) {
return 0;
}
$ci -= $count;
if ($ci) {
do_mysql("UPDATE items SET on_take = '" . $ci . "' WHERE belongs = '" . $who . "' AND is_in = 'inv' AND realname = '" . $prot . "';");
} else {
include_once 'modules/f_delete_item.php';
$q = do_mysql("SELECT fullname FROM items WHERE belongs = '" . $who . "' AND is_in = 'inv' AND realname = '" . $prot . "' AND type = 'm';");
$item = mysql_result($q, 0);
delete_item($item);
}
return 1;
}
开发者ID:nadvamir,项目名称:forgotten-story-mmorpg,代码行数:30,代码来源:f_decr_abstr_misc.php
示例11: login
function login($username, $password)
{
$user_id = user_id_from_username($username);
$username = sanitize($username);
$password = md5($password);
return mysql_result(mysql_query("SELECT COUNT(user_id) FROM users WHERE username = '{$username}' AND password = '{$password}'"), 0) == 1 ? $user_id : false;
}
开发者ID:rushoratiu,项目名称:horatiusirut,代码行数:7,代码来源:users.php
示例12: user_role
function user_role($username)
{
$username = sanitize($username);
$query = mysql_query("SELECT Role FROM user WHERE Username = '{$username}'");
$result = mysql_result($query, 0);
return $result;
}
开发者ID:kentmarionvg,项目名称:iicss,代码行数:7,代码来源:users.php
示例13: predict
function predict($userID, $itemID)
{
global $connection;
$denom = 0.0;
//denominator
$numer = 0.0;
//numerator
$k = $itemID;
$sql = "SELECT r.itemID, r.ratingValue FROM rating r WHERE r.userID='" . $userID . "' AND r.itemID <> '" . $itemID . "'";
$db_result = mysql_query($sql);
//for all items the user has rated
while ($row = mysql_fetch_assoc($db_result)) {
$j = $row["itemID"];
$ratingValue = $row["ratingValue"];
//get the number of times k and j have both been rated by the same user
$sql2 = "SELECT d.count, d.sum FROM dev d WHERE itemID1={$k} AND itemID2={$j}";
$count_result = mysql_query($sql2, $connection);
//skip the calculation if it isn't found
if (mysql_num_rows($count_result) > 0) {
$count = mysql_result($count_result, 0, "count");
$sum = mysql_result($count_result, 0, "sum");
//calculate the average
$average = $sum / $count;
//increment denominator by count
$denom += $count;
//increment the numerator
$numer += $count * ($average + $ratingValue);
}
}
if ($denom == 0) {
return 0;
} else {
return $numer / $denom;
}
}
开发者ID:AndreaBuffa,项目名称:recsys-nju,代码行数:35,代码来源:col-tables.php
示例14: login
function login($username, $password)
{
$user_id = user_id_from_username($username);
$username = sanitize($username);
$password = hash('sha512', $password);
return mysql_result(mysql_query("SELECT COUNT(`user_id`) FROM `bplay_users` WHERE `username`='{$username}' AND `password`='{$password}'"), 0) == 1 ? $user_id : false;
}
开发者ID:SDCore,项目名称:blue-play,代码行数:7,代码来源:users.php
示例15: login
function login($email, $password)
{
$user_id = user_id_from_email($email);
$email = sanitize($email);
$password = MD5($password);
return mysql_result(mysql_query("SELECT COUNT(user_id) FROM users WHERE email = '{$email}' AND password = '{$password}'"), 0) == 1 ? $user_id : false;
}
开发者ID:Jesster58,项目名称:Shoplift.ninja,代码行数:7,代码来源:users.php
示例16: page
function page($theme)
{
include "includes/smileyparse.php";
if (isset($_GET['page'])) {
$page = $_GET['page'];
$query = "SELECT * FROM pages WHERE id_string = '{$page}'";
$result = mysql_query($query);
$num = mysql_numrows($result);
if ($num == 0) {
echo '<div class="entry">No such page!</div>';
} else {
$id = mysql_result($result, 0, "id");
$title = mysql_result($result, 0, "title");
$page = mysql_result($result, 0, "page");
$page = parseSmiley($page);
$page = stripslashes($page);
echo '<div class="entry"><h3>';
echo $title;
echo '</h3><p>';
echo $page;
echo '</div>';
}
} else {
echo '<div class="entry">You must specify a page!</div>';
}
}
开发者ID:BackupTheBerlios,项目名称:fireblog-svn,代码行数:26,代码来源:page.php
示例17: AddNewChannelProgessingJob
/**
* Adds a new channel processing job to the data store
*
* @param \Swiftriver\Core\ObjectModel\Channel $channel
*/
public static function AddNewChannelProgessingJob($channel)
{
if (!isset($channel)) {
return;
}
$id = ereg_replace("[^A-Za-z0-9 _]", "", $channel->GetId());
$query = "SELECT COUNT(*) FROM channelprocessingjobs WHERE id = '" . $id . "';";
$result = self::RunQuery($query);
$result = mysql_result($result, 0);
if ($result > 0) {
return;
}
$type = $channel->GetType();
$updatePeriod = $channel->GetUpdatePeriod();
$nextrun = time() + $updatePeriod * 60;
$nextrun = date("Y-m-d H:i:s", $nextrun);
$rawParameters = $channel->GetParameters();
$parameters = "";
foreach (array_keys($channel->GetParameters()) as $key) {
$encodedKey = urlencode($key);
$encodedValue = urlencode($rawParameters[$key]);
$parameters .= $encodedKey . "," . $encodedValue . "|";
}
$parameters = rtrim($parameters, "|");
$query = "INSERT INTO channelprocessingjobs VALUES(" . "'" . $id . "'," . "'" . $type . "'," . "'" . $parameters . "'," . $updatePeriod . "," . "'" . $nextrun . "'," . "null," . "null," . "0," . "1);";
$result = self::RunQuery($query);
}
开发者ID:surflightroy,项目名称:SwiftriverCore,代码行数:32,代码来源:DataContext.php
示例18: display_dms_header
function display_dms_header($number_of_columns = 3)
{
global $xoopsDB;
$query = "SELECT data from " . $xoopsDB->prefix('dms_config') . " WHERE name='dms_title'";
$title = mysql_result(mysql_query($query), 'data');
print " <tr><td colspan='" . $number_of_columns . "' class='cHeader'><center><b><font size='2'>" . $title . "</font></b></center></td></tr>\r";
}
开发者ID:amjadtbssm,项目名称:website,代码行数:7,代码来源:inc_dms_functions.php
示例19: update_restaurant
function update_restaurant()
{
$dbc = mysql_connect('localhost', 'root', 'rishi');
if (!$dbc) {
die('NOT CONNECTED:' . mysql_error());
}
$db_selected = mysql_select_db("restaurant", $dbc);
if (!$db_selected) {
die('NOT CONNECTED TO DATABASE:' . mysql_error());
}
echo "<form name = \"form1\" action = \"update_restaurant_values.php\" method =\"post\" align=\"center\" onsubmit=\"return checkscript()\">" . "\n";
echo "<table style=\"text-align:center;\" align=\"center\" width=\"400\">" . "\n";
$query = "SELECT * from RESTAURANT;";
$rest = mysql_query($query);
$num_fields = mysql_num_fields($rest);
for ($i = 0; $i < $num_fields; $i++) {
echo "<tr>" . "\n";
echo "<td>" . "\n";
$field = mysql_field_name($rest, $i);
echo "<b>" . $field . "</b>" . "\n";
echo "</td>" . "\n";
echo "<td>" . "\n";
$res = mysql_result($rest, 0, $i);
if ($i) {
echo "<input type = \"text\" name = \"{$field}\" value=\"{$res}\">";
} else {
echo "<input type = \"text\" name = \"{$field}\" value=\"{$res}\" readonly=\"readonly\">";
}
echo "</td>" . "\n";
echo "</tr>" . "\n";
}
echo "</table>" . "\n" . "<br/>";
echo "<input type=\"submit\" name=\"submitbutton\" value=\"Update\">" . "\n";
echo "</form>" . "\n";
}
开发者ID:tjanh123,项目名称:Restaurant-Management-Ordering-System,代码行数:35,代码来源:update_restaurant.php
示例20: include_racestats_text
function include_racestats_text()
{
// Get Total Number of Tribes
$strSQL = "SELECT COUNT(*) as total " . "FROM " . TBL_STAT . " " . "WHERE " . ALLIANCE . " > 10";
$iTotal = mysql_result(mysql_query($strSQL), 0, 0);
$iTotal2 = 0;
// Get All Races
include_once 'inc/classes/clsRace.php';
$arrRaces = clsRace::getRaces();
$arrActiveRaces = clsRace::getActiveRaces();
// Begin Create Table
$strRaceStatsTable = '<table cellspacing="0" cellpadding="0" class="small">' . '<tr class="header">' . '<th colspan="2">' . "Racial Stats" . "</th>" . "</tr>" . '<tr class="subheader">' . "<th>" . "Race" . "</th>" . '<th class="right">' . "%" . "</th>" . "</tr>";
for ($i = 0; $i < count($arrRaces); $i++) {
// Give each 3rd row a border down
$strStyle = '';
//if (($i % 3) == 0) { $strStyle = ' class = "bsdown" '; }
if (!in_array($arrRaces[$i], $arrActiveRaces)) {
$strStyle = ' style="font-style:italic;"';
}
// Get Number of Tribes of the Current Race
$SQL = "SELECT id FROM " . TBL_STAT . " " . "WHERE " . RACE . " = '{$arrRaces[$i]}' AND " . ALLIANCE . " > 10";
$count[$i] = mysql_num_rows(mysql_query($SQL));
$iTotal2 += $count[$i];
$strRaceStatsTable .= '<tr class="data">' . "<th{$strStyle}>" . $arrRaces[$i] . "</th>" . "<td{$strStyle}>" . round($count[$i] / $iTotal * 100, 2) . " %</td>" . "</tr>";
}
$strRaceStatsTable .= '<tr class="data">' . "<th>" . "Unknown" . "</th>" . "<td>" . round(($iTotal - $iTotal2) / $iTotal * 100, 2) . " %</td>" . "</tr>" . "</table>";
echo $strRaceStatsTable;
}
开发者ID:BrorHolm,项目名称:Orkfia-2008,代码行数:28,代码来源:racestats.inc.php
注:本文中的mysql_result函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论