本文整理汇总了PHP中mysql_fetch_array函数的典型用法代码示例。如果您正苦于以下问题：PHP mysql_fetch_array函数的具体用法？PHP mysql_fetch_array怎么用？PHP mysql_fetch_array使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_fetch_array函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: fromOpenID2CardID
function fromOpenID2CardID($openid)
{
$mysql_host = SAE_MYSQL_HOST_M;
$mysql_host_s = SAE_MYSQL_HOST_S;
$mysql_port = SAE_MYSQL_PORT;
$mysql_user = SAE_MYSQL_USER;
$mysql_password = SAE_MYSQL_PASS;
$mysql_database = SAE_MYSQL_DB;
$mysql_table = "member";
$mysql_state = "SELECT * FROM " . $mysql_table . " WHERE `openid` = '" . $openid . "'";
$con = mysql_connect($mysql_host . ':' . $mysql_port, $mysql_user, $mysql_password, true);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_query("SET NAMES 'UTF8'");
mysql_select_db($mysql_database, $con);
$result = mysql_query($mysql_state);
$cardID = "";
while ($row = mysql_fetch_array($result)) {
$cardID = $row['cardid'];
break;
}
mysql_close($con);
return $cardID;
}
开发者ID:devsnippet，项目名称:WeChat-2，代码行数:25，代码来源:member.php
示例2: checkIndividually
function checkIndividually()
{
#----------------------------------------------------------------------
global $competitionCondition, $chosenWhich;
echo "<hr /><p>Checking <b>" . $chosenWhich . " individual results</b>... (wait for the result message box at the end)</p>\n";
#--- Get all results (id, values, format, round).
$dbResult = mysql_query("\n SELECT\n result.id, formatId, roundId, personId, competitionId, eventId, result.countryId,\n value1, value2, value3, value4, value5, best, average\n FROM Results result, Competitions competition\n WHERE competition.id = competitionId\n {$competitionCondition}\n ORDER BY formatId, competitionId, eventId, roundId, result.id\n ") or die("<p>Unable to perform database query.<br/>\n(" . mysql_error() . ")</p>\n");
#--- Build id sets
$countryIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Countries")));
$competitionIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Competitions")));
$eventIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Events")));
$formatIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Formats")));
$roundIdSet = array_flip(getAllIDs(dbQuery("SELECT id FROM Rounds")));
#--- Process the results.
$badIds = array();
echo "<pre>\n";
while ($result = mysql_fetch_array($dbResult)) {
if ($error = checkResult($result, $countryIdSet, $competitionIdSet, $eventIdSet, $formatIdSet, $roundIdSet)) {
extract($result);
echo "Error: {$error}\nid:{$id} format:{$formatId} round:{$roundId}";
echo " ({$value1},{$value2},{$value3},{$value4},{$value5}) best+average({$best},{$average})\n";
echo "{$personId} {$countryId} {$competitionId} {$eventId}\n\n";
$badIds[] = $id;
}
}
echo "</pre>";
#--- Free the results.
mysql_free_result($dbResult);
#--- Tell the result.
noticeBox2(!count($badIds), "All checked results pass our checking procedure successfully.<br />" . wcaDate(), count($badIds) . " errors found. Get them with this:<br /><br />SELECT * FROM Results WHERE id in (" . implode(', ', $badIds) . ")");
}
开发者ID:Baiqiang，项目名称:worldcubeassociation.org，代码行数:31，代码来源:check_results.php
示例3: retorna_imagem_perfil
function retorna_imagem_perfil($idusuario)
{
// globals ----------------------------------------------
global $tabela_banco;
// tabela de banco de dados
global $imagem_servidor;
// imagens de servidor
// --------------------------------------------------------
// query ------------------------------------------------
$query = "select *from {$tabela_banco['2']} where idusuario='{$idusuario}';";
// query
// --------------------------------------------------------
// comando -------------------------------------------
$comando = comando_executa($query);
// comando
// --------------------------------------------------------
// dados -----------------------------------------------
$dados = mysql_fetch_array($comando, MYSQL_ASSOC);
// dados
// --------------------------------------------------------
// imagem de perfil ----------------------------------
$imagem_perfil = $dados['imagem_perfil'];
// imagem de perfil
// --------------------------------------------------------
// imagem de servidor padrao ------------------------------
if ($imagem_perfil == null) {
$imagem_perfil = $imagem_servidor['usuario'];
// imagem de servidor padrao
}
// -----------------------------------------------------------------
// retorno -------------------------------------------------------
return $imagem_perfil;
// retorno
// -----------------------------------------------------------------
}
开发者ID:GuilhermeFelipe616，项目名称:Dinngle，代码行数:35，代码来源:retorna_imagem_perfil.php
示例4: candidatesArePeopleToo
function candidatesArePeopleToo()
{
$s = mysql_query("SELECT * FROM candidates");
while ($r = mysql_fetch_array($s)) {
$name = $r['name_cleaned'];
$sid = $r['id'];
if (strpos($r['url'], "http://") === 0) {
$url = $r['url'];
} else {
$url = 'http://www.alegeri-2008.ro' . $r['url'];
}
$idString = '<a href=' . $url . '>alegeri2008</a>';
$persons = getPersonsByName($name, $idString);
// If I reached this point, I know for sure I either have one
// or zero matches, there are no ambiguities.
if (count($persons) == 0) {
$person = addPersonToDatabase($name, $r['name_cleaned']);
} else {
$person = $persons[0];
info("Found {" . $name . "}");
}
// First and foremost, attempt to add this to the person's history.
addPersonHistory($person->id, "alegeri/2008", $url);
// Locate these people and update them in several tables now.
// We're mainly interested in updating the ID to the new ID that
// will be in the People database, from the previous ID that was
// the senator's ID in the senators table.
mysql_query("UPDATE candidates " . "SET idperson={$person->id} " . "WHERE id=" . $r['id']);
}
}
开发者ID:nightsh，项目名称:hartapoliticii，代码行数:30，代码来源:candidates_to_people.php
示例5: popup
function popup()
{
$page = CurrentPageName();
$tpl = new templates();
$users = new usersMenus();
$q = new mysql();
$sql = "SELECT * FROM officials_domains ORDER BY domain";
writelogs("{$sql}", __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
echo "<H2>{$q->mysql_error}</H2>";
}
while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) {
$domains[$ligne["domain"]] = $ligne["domain"];
}
$OverWriteRestrictedDomains = 0;
if ($users->OverWriteRestrictedDomains) {
$OverWriteRestrictedDomains = 1;
}
if ($OverWriteRestrictedDomains == 1) {
$over = "\n\t\t<hr>\n\t\t<div class=explain>{OverWriteRestrictedDomains_allow_text}</div>\n\t\t<table style='width:99%' class=form>\n\t<tr>\n\t\t<td class=legend>{domain}:</td>\n\t\t<td width=100%>" . Field_text("overwrite-domain", null, "font-size:16px;padding:3px;width:320px") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td colspan=2 align='right'><hr>" . button("{add}", "AddSubdomainOUOver()") . "</td>\n\t</tr>\n\t</table>\n\t\t";
}
$_GET["ou"] = urlencode($_GET["ou"]);
$domains[null] = "{select}";
$html = "\n\t<div id='add_subdomain_explain'></div>\n\t<div class=explain >{add_subdomain_explain}</div>\n\t\n\t<table style='width:99%' class=form>\n\t<tr>\n\t\t<td class=legend>{subdomain}:</td>\n\t\t<td width=50%>" . Field_text("subdomain", null, "font-size:16px;padding:3px;width:220px") . "</td>\n\t\t<td style='font-size:16px;padding:3px' width=1%><strong>.</strong></td>\n\t\t<td width=50%>" . Field_array_Hash($domains, "maindomain", null, "style:font-size:16px;padding:3px;") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td colspan=4 align='right'><hr>" . button("{add}", "AddSubdomainOU()") . "</td>\n\t</tr>\n\t</table>\n\t{$over}\n\t<script>\n\tvar x_AddSubdomainOU= function (obj) {\n\t\tvar results=obj.responseText;\n\t\tdocument.getElementById('subdomain').innerHTML='';\n\t\tif(results.length>3){alert(results);return;}\n\t\tYahooWin4Hide();\n\t\tLoadAjax('LocalDomainsList','domains.edit.domains.php?LocalDomainList=yes&ou={$_GET["ou"]}');\n\t}\t\t\n\t\t\n\t\tfunction AddSubdomainOU(){\n\t\t\tvar maindomain=document.getElementById('maindomain').value;\n\t\t\tvar subdomain=document.getElementById('subdomain').value;\n\t\t\tif(maindomain.length<3){return;}\n\t\t\tif(subdomain.length<3){return;}\n\t\t\tvar domain=subdomain+'.'+maindomain;\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('AddNewInternetDomain','{$_GET["ou"]}');\n\t\t\tXHR.appendData('AddNewInternetDomainDomainName',domain);\t\n\t\t\tAnimateDiv('add_subdomain_explain');\n\t\t\tXHR.sendAndLoad('domains.edit.domains.php', 'GET',x_AddSubdomainOU);\n\t\t\t\n\t\t}\n\t\t\n\t\tfunction AddSubdomainOUOver(){\n\t\t\tvar maindomain=document.getElementById('overwrite-domain').value;\n\t\t\tif(maindomain.length<3){return;}\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('AddNewInternetDomain','{$_GET["ou"]}');\n\t\t\tXHR.appendData('AddNewInternetDomainDomainName',maindomain);\t\n\t\t\tAnimateDiv('add_subdomain_explain');\n\t\t\tXHR.sendAndLoad('domains.edit.domains.php', 'GET',x_AddSubdomainOU);\t\t\t\n\t\t}\n\n\t</script>\n\t";
echo $tpl->_ENGINE_parse_body($html);
}
开发者ID:BillTheBest，项目名称:1.6.x，代码行数:27，代码来源:domains.add.localdomain.restricted.php
示例6: saveRatinglist
public function saveRatinglist()
{
foreach ($this->ratings as $player) {
//Controleren of speler al bestaat + ophalen id
$sql = "SELECT * FROM svn_leden WHERE knsb = " . $player["knsb"];
$query = mysql_query($sql);
if (mysql_num_rows($query) == 1) {
$data = mysql_fetch_assoc($query);
$player["id"] = $data["id"];
} elseif (mysql_num_rows($query) == 0) {
//Toevoegen van de speler
print_r($player);
}
//Controleren of de rating al bestaat
$sql = "SELECT * FROM svn_rating WHERE id = " . $player["id"] . " AND datum = '" . $this->ratingList . "'";
$query = mysql_query($sql);
if (mysql_num_rows($query) == 0) {
//Toevoegen rating
$sql = "INSERT INTO svn_rating VALUES ('',\"" . $this->ratingList . "\"," . $player["id"] . ",1," . $player["rating"] . ")";
mysql_query($sql);
}
}
$sql = "SELECT * FROM svn_leden WHERE knsb = " . $speler_geg["id"];
$result = mysql_query($sql);
$speler_dat = mysql_fetch_array($result);
if ($speler_geg["rating"] != "") {
$sql = "INSERT INTO svn_rating VALUES ('',\"" . $datum . "\"," . $speler_dat[0] . ",1," . $speler_geg["rating"] . ")";
//echo $sql;
mysql_query($sql);
}
}
开发者ID:haverver，项目名称:SVN，代码行数:31，代码来源:class.ratinglijst.php
示例7: getById
public static function getById($from, $id)
{
$sql = "SELECT * FROM `" . $from . "` WHERE `id` = '" . $id . "'";
$result = mysql_query($sql);
$info = mysql_fetch_array($result);
return $info;
}
开发者ID:bignunxd，项目名称:otog，代码行数:7，代码来源:library.php
示例8: select
/**
* 功能：数据库查询函数
* 参数：$sql SQL语句
* 返回：二唯数组或false
*/
public function select($sql = "")
{
if (empty($sql)) {
return false;
}
//如果SQL语句为空则返回FALSE
if (empty($this->CONN)) {
return false;
}
//如果连接为空则返回FALSE
try {
//捕获数据库选择错误并显示错误文件
$results = mysql_query($sql, $this->CONN);
} catch (Exception $e) {
$msg = $e;
echo $msg;
include ERRFILE;
}
if (!$results or empty($results)) {
//如果查询结果为空则释放结果并返回FALSE
@mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ($row = @mysql_fetch_array($results)) {
//把查询结果重组成一个二维数组
$data[$count] = $row;
$count++;
}
@mysql_free_result($results);
return $data;
}
开发者ID:BGCX261，项目名称:zlskytakeorder-svn-to-git，代码行数:38，代码来源:db.inc.php
示例9: getOneZLSelectResult
function getOneZLSelectResult($xmid, $pids = 0)
{
$result = mysql_query("select ids,xm_fl from czj_xm where ids='{$xmid}'");
$array = mysql_fetch_array($result);
$xmfl = $array['xm_fl'];
return mysql_query("select * from czj_xm_zl_select where xm_fl='{$xmfl}' and pids='{$pids}'");
}
开发者ID:ZH9009，项目名称:jjczj，代码行数:7，代码来源:xm_function.php
示例10: select
function select()
{
global $table;
$result = mysql_query('SELECT * from ' . $this->{$table} . ' limit 1;');
$row = mysql_fetch_array($result);
print_r($row);
}
开发者ID:sdgdsffdsfff，项目名称:qq_mail_login，代码行数:7，代码来源:DB.php
示例11: all
public function all($id)
{
$arr = array();
if ($id == '') {
$sql = "SELECT `venda`.`id`, `venda`.`nome`, `aula`.`endereco_video`, `aula`.`descricao`, `aula`.`curso_idcurso`, `aula`.`cliente_idcliente`, `curso`.`nome` AS `disciplina` FROM `aula` \n\t\tINNER JOIN `curso` ON `curso_idcurso`=`idcurso`;";
$vai = new MySQLDB();
$result = $vai->executeQuery($sql);
} else {
$sql = "SELECT `aula`.`idaula`, `aula`.`nome`, `aula`.`endereco_video`, `aula`.`descricao`, `aula`.`curso_idcurso`, `aula`.`cliente_idcliente`, `curso`.`nome` AS `disciplina` FROM `aula` \n\t\tINNER JOIN `curso` ON `curso_idcurso`=`idcurso` WHERE `aula`.`idaula` = {$id};";
$vai = new MySQLDB();
$result = $vai->executeQuery($sql);
}
while ($dados = mysql_fetch_array($result)) {
$cliente = new Aula();
$cliente->setidaula(array('idaula' => $dados['idaula']));
$cliente->setnome(array('nome' => $dados['nome']));
$cliente->setendereco_video(array('endereco_video' => $dados['endereco_video']));
$cliente->setdescricao(array('descricao' => $dados['descricao']));
$cliente->setcurso_idcurso(array('curso_idcurso' => $dados['curso_idcurso']));
$cliente->setcliente_idcliente(array('cliente_idcliente' => $dados['cliente_idcliente']));
$cliente->setdisciplina(array('disciplina' => $dados['disciplina']));
$arr[] = $cliente;
}
return $arr;
}
开发者ID:GlauberF，项目名称:Portal-curso-Online，代码行数:25，代码来源:venda.class.php
示例12: addm
function addm($char, $mes, $priv)
{
setlocale(LC_ALL, "ru_RU.CP1251");
if (!isset($char['sex']) || $char['sex'] == "male") {
$mes = preg_replace("/\\{([\\d\\w\\s]*?)\\|([\\d\\w\\s]*?)\\}/i", "\\1", $mes);
} else {
$mes = preg_replace("/\\{([\\d\\w\\s]*?)\\|([\\d\\w\\s]*?)\\}/i", "\\2", $mes);
}
$mes = '<span style="color:#FF2828;font-size:12px;">' . iconv("Windows-1251", "UTF-8//IGNORE", $mes) . '</style>';
$message = $mes;
$message = mysql_real_escape_string($message);
$sel = myquery("SELECT `count` FROM `game_bot_chat_resp` WHERE `id` = '" . $char['name'] . "';");
$n = mysql_fetch_array($sel);
if ($n['count'] <= 4) {
myquery("INSERT INTO `game_bot_chat_resp` (`id`,`count`) VALUES ('" . $char['name'] . "','1') ON DUPLICATE KEY UPDATE `count` = `count` + 1;");
$update_chat = myquery("insert into game_log (town,fromm,too,message,date,ptype) values (0,'-1','" . $char['user_id'] . "','" . $message . "','" . time() . "'," . $priv . ")");
} else {
$sel = myquery("SELECT `text` FROM `game_bot_chat_annoy` ORDER BY RAND() ASC LIMIT 1");
$mes = mysql_fetch_array($sel);
if (!isset($char['sex']) || $char['sex'] == "male") {
$mes = preg_replace("/\\{([\\d\\w\\s]*?)\\|([\\d\\w\\s]*?)\\}/i", "\\1", $mes);
} else {
$mes = preg_replace("/\\{([\\d\\w\\s]*?)\\|([\\d\\w\\s]*?)\\}/i", "\\2", $mes);
}
$message = mysql_real_escape_string('<span style="color:#FF2828;font-size:12px;">' . iconv("Windows-1251", "UTF-8//IGNORE", $mes['text']) . '</style>');
$update_chat = myquery("insert into game_log (town,fromm,too,message,date,ptype) values (0,'-1','" . $char['user_id'] . "','" . $message . "','" . time() . "'," . $priv . ")");
}
}
开发者ID:themiddleearth，项目名称:RPG.SU，代码行数:28，代码来源:index.php
示例13: autenticar
public function autenticar($email, $passwd)
{
$search = "SELECT * FROM `usuarios` WHERE `usuarios`.`email` = '" . $email . "' AND `usuarios`.`senha` = '" . md5($passwd) . "';";
$res = mysql_query($search);
if (!$res) {
die('Consulta inválidaaaaaaa! ' . $search);
}
if ($aux = mysql_fetch_array($res)) {
if ($aux['validation_status'] == 1) {
return -1;
} else {
if ($aux['validation_status'] == 2) {
return -2;
} else {
$this->authenticatedCPF = $aux['cpf'];
while (strlen($this->authenticatedCPF) < 11) {
$this->authenticatedCPF = "0" . $this->authenticatedCPF;
}
return $aux['nivel_acesso'];
}
}
} else {
$this->authenticatedCPF = 0;
return 0;
}
}
开发者ID:renatorroliveira，项目名称:algod，代码行数:26，代码来源:Database.php
示例14: getInsert
function getInsert($param, $name, $score)
{
$dbParams = get_object_vars($param);
$mysql_host = $dbParams['mysql_host'];
$mysql_user = $dbParams['mysql_user'];
$mysql_pass = $dbParams['mysql_pass'];
$dbName = $dbParams['dbName'];
$dbTable = $dbParams['dbTable'];
//connect
$link = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die('connection error: ' . mysql_error());
//select db
mysql_select_db($dbName) or die('DB error');
//check user highest score
$query_check_user = 'SELECT score FROM ' . $dbTable . ' WHERE name = ' . $name . ';';
$result_check_user = mysql_query($query_check_user) or die('Request down: ' . mysql_error());
$checkUser = mysql_fetch_array($result_check_user);
if ($checkUser['score'] < $score) {
//inserting new scores
$query_insert = 'INSERT INTO ' . $dbTable . '(name,score) VALUES (' . $name . ',' . $score . ') ON DUPLICATE KEY UPDATE score = VALUES(score);';
$result = mysql_query($query_insert) or die('Request insert down: ' . mysql_error());
}
return $result;
// clean
if (isset($result)) {
mysql_free_result($result);
}
// close
mysql_close($link);
}
开发者ID:queridoamigo，项目名称:querido-amigo，代码行数:29，代码来源:functions.php
示例15: user_email
function user_email($user_id)
{
global $DB, $LINK;
$RS = $DB->query("SELECT email FROM users WHERE id='" . $user_id . "'", $LINK);
$data = mysql_fetch_array($RS);
return $data["email"];
}
开发者ID:business-expert，项目名称:bellimodeling，代码行数:7，代码来源:common.php
示例16: getEvent
function getEvent($id, $info)
{
$result = mysql_query("SELECT {$info} FROM `UCPM_appointments` WHERE appID={$id}");
while ($row = mysql_fetch_array($result)) {
return $row[$info];
}
}
开发者ID:emircg，项目名称:UCPMv3.0，代码行数:7，代码来源:calendar.php
示例17: get_branch_name
function get_branch_name($branch_id)
{
$query = mysql_query("select branch_name as result from branches where branch_id = '{$branch_id}'");
$row = mysql_fetch_array($query);
$result = $row['result'];
return $result;
}
开发者ID:candradwiprasetyo，项目名称:rafli_resto，代码行数:7，代码来源:reserved_model.php
示例18: DrawPart
function DrawPart($parent, $pref)
{
$res = runsql("select t.{$this->id},t.Name_\$lang; as Name from {$this->table} t left outer join {$this->table} p on p.{$this->id}=t.{$this->id} where t.Parent='{$parent}' and t.{$this->id}<>t.Parent group by t.{$this->id} order by t.Name_\$lang;");
if (mysql_error()) {
print mysql_error();
exit;
}
while ($r = mysql_fetch_array($res)) {
$num++;
unset($str);
if ($pref) {
$str = "{$pref}";
}
if ($this->numbered == 1) {
$str .= "{$num}.";
} elseif ($parent != '0') {
$str .= " ";
}
if ($this->type == "select") {
print " <option value=\"{$r['0']}\"";
if ($r[0] == $this->val) {
print " selected";
}
print ">{$str} {$r['1']}</option>";
} else {
print "{$str} <a href=\"{$PHP_SELF}?id={$r['0']}\">{$r['1']}</a>";
print "<br>";
}
$r[types] += $this->DrawPart($r[0], $str);
}
return $r[types];
}
开发者ID:dapfru，项目名称:gladiators，代码行数:32，代码来源:cls_catalog.php
示例19: get_img_old
function get_img_old($id)
{
$query = mysql_query("select menu_img from menus \n\t\t\t\t\t\twhere menu_id = '" . $id . "'");
$result = mysql_fetch_array($query);
$row = $result['menu_img'];
return $row;
}
开发者ID:muguli22，项目名称:house_plan，代码行数:7，代码来源:menu_model.php
示例20: sqlQuery
function sqlQuery($sql)
{
global $db_conn;
// execute query
$db_result = mysql_query($sql, $db_conn);
// if db_result is null then trigger error
if ($db_result === null) {
trigger_error(mysql_errno() . ": " . mysql_error() . "\n");
exit;
}
// prepare result array
$resultSet = array();
// if resulted array isn't true and that is in case of select statement then open loop
// (insert / delete / update statement will return true on success)
if ($db_result !== true) {
// loop through fetched rows and prepare result set
while ($row = mysql_fetch_array($db_result, MYSQL_NUM)) {
// first column of the fetched row $row[0] is used for array key
// it could be more elements in one table cell
$resultSet[$row[0]][] = $row;
}
}
// return result set
return $resultSet;
}
开发者ID:hoodoogurus，项目名称:dotprojecteap，代码行数:25，代码来源:config.php
注：本文中的mysql_fetch_array函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论