本文整理汇总了PHP中drawHeaderRow函数的典型用法代码示例。如果您正苦于以下问题：PHP drawHeaderRow函数的具体用法？PHP drawHeaderRow怎么用？PHP drawHeaderRow使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了drawHeaderRow函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: drawStaffList
function drawStaffList($where, $searchterms = false)
{
global $isAdmin, $_josh;
$return = drawJumpToStaff() . '<table class="left" cellspacing="1">';
if ($isAdmin) {
$colspan = 5;
$return .= drawHeaderRow(false, $colspan, "new", "add_edit.php");
} else {
$colspan = 4;
$return .= drawHeaderRow(false, $colspan);
}
$return .= '<tr>
<th class="image"></th>
<th>Name / Office</th>
<th>Title / Department</th>
<th class="r">Phone</th>';
if ($isAdmin) {
$return .= '<th></th>';
}
$return .= '</tr>';
$result = db_query("SELECT \n\t\t\tu.userID, \n\t\t\tu.lastname,\n\t\t\tISNULL(u.nickname, u.firstname) firstname, \n\t\t\tu.bio, \n\t\t\tu.phone,\n\t\t\tc.description corporationName,\n\t\t\tu.corporationID,\n\t\t\to.name office, \n\t\t\tu.title, \n\t\t\td.departmentName\n\t\tFROM intranet_users u\n\t\tLEFT JOIN intranet_departments d\tON d.departmentID = u.departmentID \n\t\tLEFT JOIN organizations c\t\t\tON u.corporationID = c.id\n\t\tLEFT JOIN intranet_offices o\t\tON o.id = u.officeID\n\t\tWHERE " . $where . "\n\t\tORDER BY u.lastname, ISNULL(u.nickname, u.firstname)");
$count = db_found($result);
if ($count) {
if ($count == 1 && $searchterms) {
$r = db_fetch($result);
$_josh["slow"] = true;
url_change("view.php?id=" . $r["userID"]);
} else {
while ($r = db_fetch($result)) {
$return .= drawStaffRow($r, $searchterms);
}
}
} else {
$return .= drawEmptyResult("No staff match those criteria.", $colspan);
}
return $return . '</table>';
}示例2: db_delete
include "../../include.php";
if (url_action("delete")) {
db_delete('board_members');
url_drop();
} elseif ($posting) {
$id = db_save('board_members');
url_change();
}
echo drawTop();
echo drawTableStart();
if ($page['is_admin']) {
$colspan = 2;
echo drawHeaderRow("Board Members", $colspan, "new", "#bottom");
} else {
$colspan = 3;
echo drawHeaderRow("Board Members", $colspan);
}
$result = db_query("SELECT\n\t\t\t\tm.id,\n\t\t\t\tm.firstname,\n\t\t\t\tm.lastname,\n\t\t\t\tm.board_position,\n\t\t\t\to.description organization\n\t\t\tFROM board_members m\n\t\t\tJOIN organizations o ON m.organization_id = o.id\n\t\t\tWHERE m.is_active = 1\n\t\t\tORDER BY o.description, m.lastname, m.firstname");
if (db_found($result)) {
?>
<tr>
<th align="left" width="60%">Name</th>
<th align="left" width="40%">Position on Board</th>
<?php
if ($page['is_admin']) {
echo "<th width='16'></th>";
}
?>
</tr>
<?php
$lastCorporation = "";示例3: url_query_require
<?php
include '../include.php';
url_query_require();
if (url_action('delete')) {
db_delete('press_clips', $_GET['delete_id']);
url_change('/press-clips/');
}
echo drawTop();
echo drawTableStart();
echo drawHeaderRow($page['breadcrumbs'] . $page['title'], 2, getString('edit'), 'edit/?id=' . $_GET['id'], getString('delete'), drawDeleteLink());
$r = db_grab('SELECT c.title' . langExt() . ' title, c.url, c.pub_date, c.publication' . langExtT() . ' publication, c.type_id, c.description' . langExt() . ' description, t.title' . langExt() . ' type FROM press_clips c JOIN press_clips_types t ON c.type_id = t.id WHERE c.id = ' . $_GET['id']);
?>
<tr>
<td class="left"><?php
echo getString('title');
?>
</td>
<td class='title'><?php
echo $r['title'];
?>
</td>
</tr>
<tr>
<td class="left"><?php
echo getString('category');
?>
</td>
<td><?php
echo draw_link('categories.php?id=' . $r['type_id'], $r['type']);
?>示例4: drawTop
<?php
include "../../include.php";
echo drawTop();
$r = db_grab("SELECT \n\t\tj.id,\n\t\tj.title,\n\t\tj.description,\n\t\tc.description corporationName,\n\t\to.name office,\n\t\tj.created_date, \n\t\tj.updated_date,\n\t\tj.deleted_date,\n\t\tu1.firstname created_userFirst,\n\t\tu1.lastname created_userLast,\n\t\tu2.firstname updated_userFirst,\n\t\tu2.lastname updated_userLast,\n\t\tu3.firstname deleted_userFirst,\n\t\tu3.lastname deleted_userLast\n\tFROM openings j\n\tLEFT JOIN organizations c ON j.corporationID = c.id\n\tLEFT JOIN offices o ON j.officeID = o.id\n\tLEFT JOIN users u1 ON j.created_user = u1.id\n\tLEFT JOIN users u2 ON j.updated_user = u2.id\n\tLEFT JOIN users u3 ON j.deleted_user = u3.id\n\t\n\tWHERE j.id = " . $_GET["id"]);
$r["created_user"] = $r["created_userFirst"] ? $r["created_userFirst"] . " " . $r["created_userLast"] : false;
$r["updated_user"] = $r["updated_userFirst"] ? $r["updated_userFirst"] . " " . $r["updated_userLast"] : false;
$r["deleted_user"] = $r["deleted_userFirst"] ? $r["deleted_userFirst"] . " " . $r["deleted_userLast"] : false;
?>
<table class="left" cellspacing="1">
<?php
if ($page['is_admin']) {
echo drawHeaderRow("View Position", 2, "edit", "position_edit.php?id=" . $_GET["id"]);
} else {
echo drawHeaderRow("View Position", 2);
}
?>
<tr>
<td class="left">Organization</td>
<td><?php
echo $r["corporationName"];
?>
</td>
</tr>
<tr>
<td class="left">Location</td>
<td><?php
echo $r["office"];
?>
</td>
</tr>示例5: drawTop
<?php
include "../../include.php";
echo drawTop();
?>
<table class="left">
<?php
echo drawHeaderRow("Long Distance Codes", 1);
?>
<?php
$codes = db_query("SELECT\n\tl.code\nFROM ldcodes l\nWHERE (SELECT COUNT(*) FROM users u WHERE u.is_active = 1 AND u.officeID = 1 AND u.longdistancecode = l.code) = 0\nORDER BY NEWID()");
while ($c = db_fetch($codes)) {
?>
<tr>
<td><?php
echo sprintf("%04s", $c["code"]);
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
echo drawBottom();示例6: url_query_require
<?php
include 'include.php';
url_query_require('skills.php');
if (!($skill = db_grab('SELECT title FROM skills where isActive = 1 AND id = ' . url_id()))) {
url_chagne('skills.php');
}
echo drawTop();
echo drawTableStart();
if ($isAdmin) {
echo drawHeaderRow($skill, 1, 'Edit', 'skill_add_edit.php?id=' . url_id());
} else {
echo drawHeaderRow($skill, 1);
}
if ($users = db_table('SELECT
u.userID,
u.firstName,
u.lastName
FROM users_to_skills u2s
JOIN intranet_users u ON u2s.user_id = u.userID
WHERE u2s.skill_id = ' . url_id() . ' AND u.isActive = 1
ORDER BY u.lastName, u.firstName')) {
?>
<tr>
<th>User</th>
</tr>
<?php
foreach ($users as $u) {
echo '<tr>
<td><a href="view.php?id=' . $u['userID'] . '">' . $u['firstName'] . ' ' . $u['lastName'] . '</a></td>
</tr>';示例7: file_download
//} else {
//$file .= "-";
}
$file .= '</td>';
}
$file .= '<td align="right">' . $counter . '</td></tr>';
}
$file .= '</table>';
//die($file);
file_download($file, $reportname, "xls");
}
echo drawTop();
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Percentages Report (without Vacation)", 2);
?>
<form method="post" action="<?php
echo $_josh["request"]["path_query"];
?>
">
<tr>
<td class="left">Start Date</td>
<td><?php
echo draw_form_select_month("start", "1/2005", false, false, "field", false, true);
?>
</td>
</tr>
<tr>
<td class="left">End Date</nobr></td>
<td><?php 示例8: format_date_time
echo format_date_time($r["createdOn"]);
?>
</td>
<td width="16"><?php
echo draw_img($locale . "images/icons/delete.gif", url_query_add(array("action" => "deletereq", "id" => $r["id"]), false));
?>
</td>
</tr>
<?php
}
} else {
echo drawEmptyResult("No pending requests!");
}
echo drawTableEnd();
echo drawTableStart();
echo drawHeaderRow("Never Logged In", 3, "invite them all", url_query_add(array("action" => "invite"), false));
$result = db_query("SELECT userid, lastname, firstname, createdOn FROM intranet_users WHERE lastlogin IS NULL AND isactive = 1 ORDER BY lastname");
if (db_found($result)) {
?>
<tr>
<th width="70%">Name</th>
<th width="30%" class="r">Created Date</th>
<th></th>
</tr>
<?php
while ($r = db_fetch($result)) {
?>
<tr>
<td><a href="view.php?id=<?php
echo $r["userid"];
?>示例9: db_query
db_query('DELETE FROM it_system_status');
db_query('INSERT INTO it_system_status ( message, updated_date, updated_user ) VALUES ("' . format_html($_POST['helpdesk_status']) . '", GETDATE(),' . user() . ')');
url_change('./');
}
echo drawTop();
echo lib_get('tinymce');
echo draw_javascript_src('/_intranet.seedco.site/lib/tinymce/tinymce_3_3_8/tiny_mce.js');
echo draw_javascript('form_tinymce_init("/css/tinymce-helpdesk-status.css", true);');
?>
<table class="left" cellspacing="1">
<form action="<?php
echo $request["path_query"];
?>
" method="post">
<?php
echo drawHeaderRow("Update Status Message");
?>
<tr>
<td><?php
echo draw_form_textarea("helpdesk_status", $helpdeskStatus, "tinymce", false);
?>
</td>
</tr>
<tr>
<td class="bottom"><?php
echo draw_form_submit("update message");
?>
</td>
</tr>
</form>
</table>示例10: db_save
<?php
include "../../include.php";
if ($posting) {
$id = db_save("wiki_topics");
db_checkboxes("tags", "wiki_topics_to_tags", "topicID", "tagID", $id);
url_change();
}
echo drawTop();
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Main Page", 4);
$topics = db_query("SELECT \n\t\tw.id,\n\t\tw.title,\n\t\tw.description,\n\t\tISNULL(u.nickname, u.firstname) first,\n\t\tu.lastname last,\n\t\tw.created_date\n\tFROM wiki_topics w\n\tJOIN wiki_topics_types t ON w.type_id = t.id\n\tJOIN users u ON w.created_user = u.id\n\tWHERE w.is_active = 1\n\tORDER BY w.created_date DESC");
if (db_found($topics)) {
?>
<tr>
<th width="16"></th>
<th align="left">Title</th>
<th align="left" width="100">Created By</th>
<th align="right" width="80">Created On</th>
</tr>
<?php
while ($t = db_fetch($topics)) {
?>
<tr height="36">
<td></td>
<td><a href="topic.php?id=<?php
echo $t["id"];
?>
"><?php 示例11: url_query_require
<?php
include "../../include.php";
url_query_require("types.php");
echo drawTop();
$r = db_grab("SELECT description FROM wiki_topics_types WHERE id = " . $_GET["id"]);
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("<a href='types.php' class='white'>Types</a> > " . $r["description"], 4);
$topics = db_query("SELECT \n\t\tw.id,\n\t\tw.title,\n\t\tw.description,\n\t\tISNULL(u.nickname, u.firstname) first,\n\t\tu.lastname last,\n\t\tw.created_date\n\tFROM wiki_topics w\n\tJOIN wiki_topics_types t ON w.type_id = t.id\n\tJOIN users u ON w.created_user = u.id\n\tWHERE w.is_active = 1 AND w.type_id = " . $_GET["id"]);
if (db_found($topics)) {
?>
<tr>
<th width="16"></th>
<th align="left">Title</th>
<th align="left" width="100">Created By</th>
<th align="right" width="80">Created On</th>
</tr>
<?php
while ($t = db_fetch($topics)) {
?>
<tr height="36">
<td></td>
<td><a href="topic.php?id=<?php
echo $t["id"];
?>
"><?php
echo $t["title"];
?>
</a></td>示例12: drawTop
<?php
include "../include.php";
drawTop();
$users = db_query("select \n\t\tISNULL(u.nickname, u.firstname) first,\n\t\tu.lastname last,\n\t\tu.userID,\n\t\tu.title,\n\t\td.departmentName,\n\t\tu.officeid,\n\t\tr.isPayroll,\n\t\tu.lastlogin, \n\t\tu.updatedOn, \n\t\t" . db_datediff("u.updatedOn", "GETDATE()") . " recent \n\tFROM intranet_users u\n\tJOIN intranet_departments d on u.departmentID = d.departmentID\n\tJOIN intranet_ranks r on u.rankID = r.id\n\tWHERE u.isactive = 1 and (u.homeaddress1 = '' OR u.homeaddress1 IS NULL)\n\tORDER BY lastname");
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Staff Profiles Needing Update (" . db_found($users) . ")", 4);
?>
<tr>
<th width="25%" align="left">email</th>
<th width="30%" align="left">department</th>
<th width="30%" align="left">title</th>
<th width="15%" align="right">last login</th>
</tr>
<?php
while ($u = db_fetch($users)) {
?>
<tr>
<td><a href="/staff/view.php?id=<?php
echo $u["userID"];
?>
"><?php
echo $u["first"];
?>
<?php
echo $u["last"];
?>
</a></td>
<td><?php 示例13: format_post_html
if ($posting) {
$userID = $isAdmin ? $_POST["createdBy"] : $user["id"];
format_post_html("description");
db_query("INSERT INTO intranet_jobs (\n \ttitle,\n \tdescription,\n\t\tcorporationID,\n\t\tofficeID,\n\t\tcreatedBy,\n\t\tcreatedOn,\n\t\tisActive\n\t) VALUES (\n\t\t'" . $_POST["title"] . "',\n\t\t" . $_POST["description"] . ",\n\t\t" . $_POST["corporationID"] . ",\n\t\t" . $_POST["officeID"] . ",\n\t\t" . $userID . ",\n\t\tGETDATE(),\n\t\t1\n );");
url_change();
}
drawTop();
?>
<table class="left" cellspacing="1">
<?php
if ($isAdmin) {
$colspan = 4;
echo drawHeaderRow("Open Positions", $colspan, "new", "#bottom");
} else {
$colspan = 3;
echo drawHeaderRow("Open Positions", $colspan);
}
?>
<tr>
<th align="left" width="50%">Title</th>
<th align="left" width="30%">Location</th>
<th align="right" width="20%"><nobr>Last Update</nobr></th>
<?php
if ($isAdmin) {
?>
<th></th><?php
}
?>
</tr>
<?php
$result = db_query("SELECT \n\t\t\t\t\t\t\tj.id,\n\t\t\t\t\t\t\tj.title,\n\t\t\t\t\t\t\tc.description corporationName,\n\t\t\t\t\t\t\to.name office,\n\t\t\t\t\t\t\tISNULL(j.updatedOn, j.createdOn) updatedOn\n\t\t\t\t\t\tFROM intranet_jobs j\n\t\t\t\t\t\tLEFT JOIN organizations c ON j.corporationID = c.id\n\t\t\t\t\t\tLEFT JOIN intranet_offices o ON j.officeID = o.id\n\t\t\t\t\t\tWHERE j.isActive = 1\n\t\t\t\t\t\tORDER BY c.description, j.title");示例14: db_query
//get addresses & send
$users = db_query("SELECT email FROM intranet_users WHERE isactive = 1");
while ($u = db_fetch($users)) {
mail($u["email"], $r["title"], $message, $headers);
}
}
syndicateBulletinBoard();
url_change();
}
drawTop();
echo drawSyndicateLink("bb");
?>
<table class="left" id="bb">
<thead>
<?php
echo drawHeaderRow("", 4, "new", "#bottom");
?>
<tr>
<th width="320">Topic</th>
<th width="120">Starter</th>
<th class="c">Replies</th>
<th class="r">Last Post</th>
</tr>
</thead>
<tbody>
<?php
echo drawBBPosts(15, drawEmptyResult("No topics have been added yet. Why not <a href='#bottom'>be the first</a>?", 4));
?>
</tbody>
<tfoot class="more">
<tr>示例15: db_query
db_query("INSERT INTO it_laptops_2_accessories (\r\n\t\t\t\tlaptopID,\r\n\t\t\t\taccessoryID\r\n\t\t\t) VALUES (\r\n\t\t\t\t" . $_GET["id"] . ",\r\n\t\t\t\t" . $accessoryID . "\r\n\t\t\t);");
}
}
url_change("laptop.php?id=" . $_GET["id"]);
}
echo drawTop();
if (isset($_GET["id"])) {
$r = db_grab("SELECT \r\n\t\t\t\t\t\tl.laptopName,\r\n\t\t\t\t\t\tl.laptopPurpose,\r\n\t\t\t\t\t\tl.laptopModel,\r\n\t\t\t\t\t\tl.laptopHomeID,\r\n\t\t\t\t\t\tl.laptopSerial,\r\n\t\t\t\t\t\tl.laptopExpressServiceCode,\r\n\t\t\t\t\t\tl.laptopServiceTag,\r\n\t\t\t\t\t\tl.laptopOS,\r\n\t\t\t\t\t\tl.laptopOffice,\r\n\t\t\t\t\t\tl.laptopIsWireless,\r\n\t\t\t\t\t\tl.laptopMACAddress\r\n\t\t\t\t\tFROM it_laptops l\r\n\t\t\t\t\tWHERE laptopID = " . $_GET["id"]);
$openEnded = empty($r["laptopEnd"]) ? true : false;
}
?>
<a name="closedtickets"></a>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Add Laptop", 2);
?>
<form method="post" action="<?php
echo $request["path_query"];
?>
">
<tr>
<td class="left">Laptop Name</td>
<td><?php
echo draw_form_text("laptopName", @$r["laptopName"]);
?>
</td>
</tr>
<tr>
<td class="left">Model #</td>
<td><?php