本文整理汇总了PHP中mysql_fetch_all函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_fetch_all函数的具体用法?PHP mysql_fetch_all怎么用?PHP mysql_fetch_all使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_fetch_all函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: get_windows
function get_windows()
{
global $NICKNAME;
$o = array();
$r = mysql_fetch_all(mysql_query("SELECT * FROM windows WHERE\n\t\tnickname ='{$NICKNAME}'"));
foreach ($r as $row) {
$o[] = $row['title'];
}
return $o;
}
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:10,代码来源:irc.php
示例2: csvData
function csvData($table, $state_name, $col, $key)
{
$query = 'SELECT ' . $col . ' FROM ' . $table . ' WHERE ' . $key . '="' . $state_name . '" LIMIT 1';
$query_result = mysqli_query($query);
if (!$query_result) {
die('Invalid query: ' . mysql_error());
}
$query_result = mysql_fetch_all($query_result);
//$query_result = str_replace("’","'",$query_result); //clean dirty characters
return $query_result[0][$col];
}
开发者ID:202chaz,项目名称:angular-app,代码行数:11,代码来源:map_data.php
示例3: fetch_queue
function fetch_queue($NICKNAME, $window, $seen = FALSE, $limit = 200)
{
$r = mysql_fetch_all(mysql_query("SELECT * FROM queue WHERE nickname = '{$NICKNAME}' AND window = '{$window}' AND seen = " . ($seen ? 1 : 0) . " ORDER BY id DESC " . ($limit ? "LIMIT {$limit}" : "")));
$startid = $r[count($r) - 1]['id'];
$endid = $r[0]['id'];
if (!$seen) {
mysql_query("UPDATE queue SET seen = 1 WHERE nickname = '{$NICKNAME}' AND window = '{$window}' AND id >= '{$startid}' AND id <= '{$endid}'");
}
krsort($r);
return $r;
}
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:11,代码来源:read.php
示例4: mail_entry
function mail_entry($to, $subject, $uri, $page)
{
$r = mysql_query("select * from debug where uri = '{$uri}'");
$r = mysql_fetch_all($r);
if (count($r) == 0) {
mail($to, $subject, $uri . "\n" . $page);
print "Mailing {$to} about it...\n";
mysql_query("insert into debug (uri) values('{$uri}')");
/*} else {
print("Already mailed $to\n");*/
}
}
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:12,代码来源:cache_friends.php
示例5: get_messages
function get_messages($quals = NULL, $table = '')
{
global $messageboard_db, $messageboard_table;
if (!$messageboard_table) {
$messageboard_table = 'messages';
}
if (!$table) {
$ids = $quals;
if (!is_array($ids) or count($ids) == 0) {
return array();
}
} else {
unset($ids);
}
$q = "SELECT {$messageboard_table}.poster AS poster, {$messageboard_table}.subject AS subject,\n\t\t\t{$messageboard_table}.date AS date, {$messageboard_table}.body AS body\n\t\t\tFROM messages " . ($table ? ", {$table}" : "") . ($ids || $quals ? " WHERE " : "") . (is_array($ids) ? "{$messageboard_table}.messageid IN ('" . join("','", $ids) . "')" : "") . (is_array($quals) ? join(' AND ', $quals) : "") . " ORDER BY date";
print "<!-- {$q} -->";
return mysql_fetch_all(mysql_query($q, $messageboard_db));
}
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:18,代码来源:message.php
示例6: get_cached_friends
function get_cached_friends($username, $limit = 0)
{
if (!$limit) {
$limit = JOURNAL_FRIENDSENTRIES;
}
$r = mysql_fetch_all(mysql_query("SELECT * FROM cache \n\t\t\t\tINNER JOIN friends ON (friends.uri = cache.friend_uri)\n\t\t\t\tWHERE friends.username = '{$username}' \n\t\t\t\tORDER BY cache.date DESC \n\t\t\t\tLIMIT {$limit}"));
foreach ($r as $key => $row) {
$r[$key]['data'] = $row['body'];
if (ereg('opendiary.com', $r[$key]['friend_uri'])) {
$r[$key]['friend'] .= '(OD)';
} elseif (ereg('diaryland.com', $r[$key]['friend_uri'])) {
$r[$key]['friend'] .= '(DL)';
} elseif (ereg('livejournal.com', $r[$key]['friend_uri'])) {
$r[$key]['friend'] .= '(LJ)';
}
unset($r[$key]['body']);
}
return $r;
}
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:19,代码来源:friends.php
示例7: cart_customer_new
function cart_customer_new($ci)
{
extract($ci);
$id = FALSE;
if (mysql_query("INSERT INTO customers (name) VALUES ('" . $shipping['name'] . "')")) {
if ($r = mysql_query("SELECT last_insert_id() AS id")) {
$r = mysql_fetch_all($r);
$id = $r[0]['id'];
extract($shipping);
if (!mysql_query("INSERT INTO addresses \n\t\t\t\t\t(type, customerid, name, address, phone) VALUES \n\t\t\t\t\t('shipping', '{$id}', '{$name}', '{$address}', '{$phone}')")) {
print mysql_error();
}
extract($billing);
if (!mysql_query("INSERT INTO addresses \n\t\t\t\t\t(type, customerid, name, address, phone) VALUES \n\t\t\t\t\t('billing', '{$id}', '{$name}', '{$address}', '{$phone}')")) {
print mysql_error();
}
} else {
print mysql_error();
}
} else {
print mysql_error();
}
return $id;
}
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:24,代码来源:customer.php
示例8: dirname
<?php
require_once dirname(__FILE__) . "/../string.php";
require_once dirname(__FILE__) . "/irc.php";
print "<meta http-equiv='refresh' content='15; URL=\"" . purlencode($PHP_SELF) . "?NICKNAME={$NICKNAME}\"' />";
$r = mysql_fetch_all(mysql_query("SELECT * FROM windows WHERE nickname = '{$NICKNAME}'"));
$w = get_windows();
foreach ($w as $window) {
$o .= td("<a href='{$SCRIPT_NAME}/Windows/" . purlencode($window) . "?NICKNAME={$NICKNAME}' target='window'>{$window}</a>");
}
$o .= td("<a href='{$SCRIPT_NAME}/Logoff?NICKNAME={$NICKNAME}' target='_top'>Log Off</a>");
$o .= td("<a href='{$PHP_SELF}?NICKNAME={$NICKNAME}'>Refresh</a>");
print table(tr($o));
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:13,代码来源:windows.php
示例9: fetchAll
public function fetchAll($result)
{
try {
if ($this->config->connector == "mysql") {
return mysql_fetch_all($result, MYSQLI_ASSOC);
} elseif ($this->config->connector == "mysqli") {
return mysqli_fetch_all($result, MYSQLI_ASSOC);
}
} catch (exception $e) {
return $e;
}
}
开发者ID:BuddhiEash,项目名称:play_a_sport_oop,代码行数:12,代码来源:db.php
示例10: mysql_query
echo "<html>\n\t\t\t<head>\n \t\t\t<title>Chimi 1.0 - Print Schedule by Instructor</title>\n \t\t</head>\n \t<html>";
// get university name, semester details
$univ_result = mysql_query("SELECT * FROM University WHERE sessionID = '" . $sessionID . "'");
while ($university = mysql_fetch_assoc($univ_result)) {
echo "<br>";
echo "THE " . strtoupper($university['universityName']);
echo "<br>";
echo 'SEMESTER COURSE LISTING' . "<br><br>";
}
$building_result = mysql_query("SELECT * FROM Building WHERE sessionID='" . $sessionID . "'");
$buildings = mysql_fetch_all($building_result);
$dept_result = mysql_query("SELECT * FROM Department WHERE sessionID='" . $sessionID . "'");
$departments = mysql_fetch_all($dept_result);
for ($i = 0; $i < count($instructors); ++$i) {
$section_result = mysql_query("SELECT * FROM Section WHERE sessionID='" . $sessionID . "' AND instructorID='" . $instructors[$i]["instructorID"] . "'");
$sections = mysql_fetch_all($section_result);
echo $instructors[$i]["lastName"] . ", " . $instructors[$i]["firstName"];
echo "<br><br>";
start_schedule_table();
// only print the sections which belong to the containing department?
for ($j = 0; $j < count($sections); ++$j) {
$roomID = slotID_to_roomID($sections[$j]["slotID"], $num_of_slots_per_room);
$building = binary_search($buildings, "buildingID", $rooms[$roomID]["buildingID"]);
$course = binary_search($courses, "courseID", $sections[$j]["courseID"]);
$available = $sections[$j]["maxEnrollment"] - $sections[$j]["preliminaryEnrollment"];
$dayOfWeek = slotID_to_dayOfWeek($sections[$j]["slotID"], $num_of_slots_per_room, count($periods));
$period = get_period_from_slotID($sections[$j]["slotID"], $num_of_slots_per_room, $periods, count($periods));
$startTime = convert_int_to_standard_time($period["startTime"]);
$endTime = convert_int_to_standard_time($period["endTime"]);
echo "<tr>";
echo "<td>" . $building["buildingAbbr"] . "</td>";
开发者ID:parkestwins,项目名称:chimi,代码行数:31,代码来源:printByInstructor.php
示例11: trigger_error
}
if (!in_array($result_type, array(MYSQL_ASSOC, MYSQL_BOTH, MYSQL_NUM), true)) {
trigger_error(__FUNCTION__ . '(): result type should be MYSQL_NUM, MYSQL_ASSOC, or MYSQL_BOTH', E_USER_WARNING);
return false;
}
$rows = array();
while ($row = mysql_fetch_array($result, $result_type)) {
$rows[] = $row;
}
return $rows;
}
do {
mysql_select_db($database_homebank_conecta, $homebank_conecta);
$query_tipoacessomenu = "SELECT codmenu FROM acessomenutipo WHERE codtipo={$row_tipopermissao['id']}";
$tipoacessomenu = mysql_query($query_tipoacessomenu, $homebank_conecta) or die(mysql_error());
$row_tipoacessomenu = mysql_fetch_all($tipoacessomenu);
$array_column = array();
foreach ($row_tipoacessomenu as $key => $value) {
$array_column[] = $value['codmenu'];
}
$valores = implode(',', $array_column);
?>
<tr>
<td width="200" align="right" class="td3"><?php
echo $row_tipopermissao['descricao'];
?>
</td>
<td class="td4">
<input type="radio" name="tiposacessomenu" id="<?php
echo $valores;
?>
开发者ID:tvieira,项目名称:homebank,代码行数:31,代码来源:cadastrausuario.php
示例12: get_user_name
}
if (count($result) == 0) {
return $default_value;
}
return $result;
}
function get_user_name($userid)
{
$res = sql_query("SELECT `username` , `id` , `class`, `chatpost`, `leechwarn`, `warned`, `pirate`, `king`, `donor`, `enabled` FROM `users` WHERE `id` = {$userid} LIMIT 1") or sqlerr(__FILE__, __LINE__);
$username = mysql_fetch_assoc($res);
return $username;
}
$count1 = get_row_count('events');
$perpage = 15;
$pager = pager($perpage, $count1, 'staffpanel.php?tool=events&action=events&');
$scheduled_events = mysql_fetch_all("SELECT * from `events` ORDER BY `startTime` DESC " . $pager['limit'] . ";", array());
if (is_array($scheduled_events)) {
foreach ($scheduled_events as $scheduled_event) {
if (is_array($scheduled_event) && array_key_exists('startTime', $scheduled_event) && array_key_exists('endTime', $scheduled_event)) {
$startTime = 0;
$endTime = 0;
$overlayText = "";
$displayDates = true;
$startTime = $scheduled_event['startTime'];
$endTime = $scheduled_event['endTime'];
if (time() < $endTime && time() > $startTime) {
if (array_key_exists('overlayText', $scheduled_event)) {
$overlayText = $scheduled_event['overlayText'];
}
if (!is_string($overlayText)) {
$overlayText = "";
开发者ID:CharlieHD,项目名称:U-232-V2,代码行数:31,代码来源:events.php
示例13: mysql_connect
}
if (!$error) {
// only proceed if there is no error
$conn = mysql_connect($servername, $username, $password);
mysql_select_db($database_name, $conn);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$idPart = " ";
if ($id != "*") {
$idPart = "AND cdi.id = {$id}";
}
$sql = "SELECT cdi.uuid,UNIX_TIMESTAMP(cdt.last_seen)*1000 as last_seen, cdt.status\n\t\t\tFROM {$table_device_timing} cdt, {$table_device_info} cdi\n\t\t\tWHERE (last_seen BETWEEN '" . $from . "' AND '" . $to . "')\n\t\t\t{$idPart}\n\t\t\tAND cdi.id = cdt.tid \n\t\t\tAND char_length( cdi.uuid ) <= 17\n\t\t\tORDER BY cdt.tid,cdt.last_seen ASC";
// die($sql);
$query = mysql_query($sql) or die(mysql_error() . $sql);
$query = mysql_fetch_all($query, MYSQL_ASSOC);
if (count($query) <= 0 || !$query) {
// empty result
$error = true;
$result['error'] = 'No result found in database';
$result['solution'] = 'Try a different date';
} else {
$result['result'] = $query;
$result['sucess'] = true;
}
mysql_close();
echo json_encode($result);
} else {
echo json_encode($error_array);
}
} else {
开发者ID:greenspray,项目名称:wyndTv1,代码行数:31,代码来源:getTerminalStatusHistory.php
示例14: while
require_once '../app/functions.php';
while (true) {
$conn = mysql_connect($servername, $username, $password);
mysql_select_db($database_name, $conn);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
if (!mysql_set_charset('utf8', $conn)) {
echo "Error: Unable to set the character set.\n";
exit;
}
$devicesInfoInDatabase = mysql_query("Select distinct(uuid) from {$table_device_info} WHERE LENGTH(uuid)<18");
if (!$devicesInfoInDatabase) {
die('Invalid query: ' . mysql_error());
}
$devicesInfoInDatabase = mysql_fetch_all($devicesInfoInDatabase, MYSQL_ASSOC);
// filter just to get db
$dbDevices = array();
foreach ($devicesInfoInDatabase as $dbDevice) {
array_push($dbDevices, $dbDevice['uuid']);
}
// die(var_dump($dbDevices));
$databaseMatchingDevices = array();
$lostDevices = array();
//registered devices that are not online anymore
$newDevices = array();
// new devices in the network
$result = $pubnub->hereNow(null, false, true);
$connectedDevices = $result['payload']['channels'];
// $onlineDevices = $connectedDevices['connect']['uuids'];
/*First iteration check if the online devices exists in the database*/
开发者ID:greenspray,项目名称:wyndTv1,代码行数:31,代码来源:device_update.php
示例15: sidebars
<?php
if ($REQUEST_METHOD == 'POST') {
if ($data) {
$q = "REPLACE INTO sidebars (title, data, username) \n\t\t\t\tVALUES ('{$sidebar}', '{$data}', '" . JOURNAL_USERNAME . "')";
if (mysql_query($q)) {
print "Updated.";
} else {
print mysql_error();
}
} else {
print "You have to enter /something/.";
}
} else {
$r = mysql_fetch_all(mysql_query("SELECT * FROM sidebars WHERE username = '" . JOURNAL_USERNAME . "' \n\t\t\t\tAND title = '{$sidebar}'"));
extract($r[0]);
print "<form action='{$PHP_SELF}' method='POST'>";
print table(row1(heading(2, $sidebar)) . row1(textarea('data', $data)) . row1("<input type='submit' value='Add' />"));
print "</form>";
}
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:20,代码来源:editsidebar.php
示例16: microtime
$e = microtime(true);
echo "<h3>" . ($e - $s) . "</h3>";
break;
case "random":
if (!$memcached->get("data_user_rand")) {
$db = array();
$conn = mysql_connect("localhost", "root", "");
mysql_set_charset('utf8', $conn);
mysql_select_db("test_case", $conn);
$sql = "select * from user order by rand() ";
$query = mysql_query($sql);
if (mysql_num_rows($query) == 0) {
echo "Chua co du lieu";
die;
}
$query_rs = mysql_fetch_all($query);
$memcached->set("data_user_rand", $query_rs);
echo 'generate cache';
} else {
echo 'get cache';
}
$s = microtime(true);
$m = $memcached->get("data_user_rand");
$max = count($m);
foreach ($m as $key => $value) {
echo "<h3>" . $m[rand(1, $max)]["name"] . "</h3>";
if ($key > 10) {
break;
}
}
$e = microtime(true);
开发者ID:vihoangson,项目名称:Program_lesson,代码行数:31,代码来源:index.php
示例17: mysqli_free_result
mysqli_free_result($dbcolcontent);
}
echo '\\t\\t<WADB_COLUMN name="' . urlencode($value) . '"><![CDATA[' . json_encode($dballcols) . "]]></WADB_COLUMN>\n";
}
echo "\t</WADB_DATA>\n";
}
mysqli_free_result($dbcontent);
} else {
while ($row_dbcontent = mysql_fetch_assoc($dbcontent)) {
echo "\t<WADB_DATA>\n";
foreach ($row_dbcontent as $key => $value) {
$dbcolcontent = mysql_query("SHOW COLUMNS FROM `" . $value . "`", $connection);
if ($connection->connect_errno) {
die("<WADB_RESPONSE><WADB_ERROR code=\"5\"><![CDATA[Failed to execute sql: (" . $connection->connect_errno . ") " . $db_query . " : " . $connection->connect_error . "]]></WADB_ERROR></WADB_RESPONSE>");
}
$dballcols = mysql_fetch_all($dbcolcontent);
mysql_free_result($dbcolcontent);
echo '\\t\\t<WADB_COLUMN name="' . urlencode($value) . '"><![CDATA[' . json_encode($dballcols) . "]]></WADB_COLUMN>\n";
}
echo "\t</WADB_DATA>\n";
}
mysql_free_result($dbcontent);
}
break;
case "insert":
if (extension_loaded('mysqli')) {
echo "\t<WADB_DATA><![CDATA[" . mysqli_insert_id($connection) . "]]></WADB_DATA>\n";
} else {
echo "\t<WADB_DATA><![CDATA[" . mysql_insert_id($connection) . "]]></WADB_DATA>\n";
}
break;
开发者ID:JeisonSanchez,项目名称:LandingPT-Congre,代码行数:31,代码来源:WA_DBScript.php
示例18: mysql_query
print $query_movie . "\n";
}
$query_set = "select * from sets order by strSet";
$query_tag = "select * from tag order by strTag";
$query_taglink = "select idTag, idMedia, c00 as title, c07 as year ";
$query_taglink .= "from taglinks t, movie m where t.idMedia=m.idMovie ";
$query_taglink .= "and idTag={$s_idtag} order by idTag";
$res_movie = mysql_query($query_movie);
$res_set = mysql_query($query_set);
$res_tag = mysql_query($query_tag);
$res_taglink = mysql_query($query_taglink);
$movies = mysql_fetch_all($res_movie);
$sets = mysql_fetch_all($res_set);
$tags = mysql_fetch_all($res_tag);
if ($res_taglink) {
$taglinks = mysql_fetch_all($res_taglink);
}
#####################
# Close DB connections
#####################
mysql_close($link);
}
}
?>
<html>
<HEAD>
<TITLE>XBMC Sets</TITLE>
<LINK REL="stylesheet" HREF="../styles/buttons.css" TYPE="TEXT/CSS">
<LINK REL="stylesheet" HREF="../styles/fields.css" TYPE="TEXT/CSS">
<LINK REL="stylesheet" HREF="../styles/lists.css" TYPE="TEXT/CSS">
开发者ID:a8hnaios,项目名称:xbmc_maint,代码行数:31,代码来源:set_tag.php
示例19: mysql_query
$result = mysql_query($sql) or die(mysql_error() . $sql);
$result = mysql_fetch_array($result);
if (!$result) {
//A location update for new device
$sql = "INSERT INTO {$table_device_location} VALUES\n\t\t\t\t\t\t\t\t\t(NULL,{$deviceID},'{$time}','{$lat}','{$lng}')";
$result = mysql_query($sql) or die(mysql_error() . $sql);
} else {
$sql = "SELECT id from {$table_device_location} where tid={$deviceID} order by id LIMIT 1";
$result = mysql_query($sql) or die(mysql_error() . $sql);
$result = mysql_fetch_assoc($result);
$LocationID = $result['id'];
$sql = "UPDATE {$table_device_location} SET \n\t\t\t\t\t\t\t\t\t\t\t\tlat='{$lat}',\n\t\t\t\t\t\t\t\t\t\t\t\tlng='{$lng}',\n\t\t\t\t\t\t\t\t\t\t\t\tutime='{$time}'\n\t\t\t\t\t\t\t\t\t\tWHERE id={$LocationID}";
$result = mysql_query($sql) or die(mysql_error() . $sql);
}
}
}
});
$sql = "SELECT cdt.uuid, dl.lat, dl.lng, dl.utime FROM {$table_device_location} dl, {$table_device_info} cdt where cdt.id=dl.tid";
if ($id != '*') {
$sql .= " and tid={$id}";
}
$conn = mysql_connect($servername, $username, $password);
mysql_select_db($database_name, $conn);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$result = mysql_query($sql) or die(mysql_error() . $sql);
$result = mysql_fetch_all($result, MYSQL_ASSOC);
mysql_close();
echo json_encode($result);
}
开发者ID:greenspray,项目名称:wyndTv1,代码行数:31,代码来源:getPositions.php
示例20: ob_end_clean
ob_end_clean();
if (!$action) {
$action = 'latest';
}
//$XMLPREFIX = 'journal:';
if ($action == 'latest') {
//header("Content-type: application/x-php-serialized");
header("Content-type: text/plain");
if (!$limit) {
$limit = 6;
}
$q = "SELECT date, subject, data, contenttype FROM journal WHERE username = '" . JOURNAL_USERNAME . "' ORDER BY date DESC LIMIT {$limit}";
$r = mysql_query($q);
if ($r) {
$r = mysql_fetch_all($r);
$o = array();
foreach ($r as $row) {
$o[] = xmlize_entry($row);
}
print "<{$XMLPREFIX}journal>\n" . join("\n", $o) . "</{$XMLPREFIX}journal>\n";
}
}
exit;
function xmlize_entry($e)
{
global $XMLPREFIX;
extract($e);
return "<{$XMLPREFIX}entry time='{$date}'>\n" . xml_subject($subject) . "\t<{$XMLPREFIX}content type='{$contenttype}'>" . base64_encode($data) . "</{$XMLPREFIX}content>\n" . "</{$XMLPREFIX}entry>\n";
}
function xml_subject($s)
开发者ID:nbtscommunity,项目名称:phpfnlib,代码行数:30,代码来源:auto.php
注:本文中的mysql_fetch_all函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论