本文整理汇总了PHP中OpenTable函数的典型用法代码示例。如果您正苦于以下问题：PHP OpenTable函数的具体用法？PHP OpenTable怎么用？PHP OpenTable使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了OpenTable函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: _vereinteammatchlist
function _vereinteammatchlist($vid, $show = 'home')
{
global $dbi;
// step 1 collect the teams for this verein
// step 2 for each team we collect the schedule and create click-rows to the matchsheet
echo '<h3>Alle Vereins Teams und ihre Heim Spiele</h3>';
$RS = DB_listTeams($dbi, 0, 0, "", 1, "", $vid);
foreach ($RS as $row) {
if ($show == 'home') {
$MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", 1);
} elseif ($show = 'away') {
$MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", 0);
} elseif ($show = 'all') {
// this doesn't work ...
$MATCHLIST = DB_listMatches($dbi, 1, 0, $row[4], "", "", "", "", "logic");
}
$aTH = array("Runde", "Datum", "Spielort", "Status", "", "Sets", "Legs", "Team", "Teamname");
echo "<div class=\"sectionhead\">Team {$row['5']} in {$row['2']} (" . sizeof($MATCHLIST) . " Matches)</div><br/>";
echo '<div class="child">';
OpenTable();
echo ArrayToTableHead($aTH);
echo RecordsetToClickTable($MATCHLIST, 4, "ls_system.php?func=showmatch&vmkey=%P1%&eventid=%P2%", 3, 0);
CloseTable();
echo '</div><br/>';
}
}示例2: startjournal
function startjournal($sitename, $user)
{
global $module_name;
$user = filter($user, "nohtml");
$sitename = filter($sitename, "nohtml");
if (is_user($user)) {
$j_user1 = "<center>[ <a href=\"modules.php?name={$module_name}\">" . _JOURNALDIR . "</a> | <a href=\"modules.php?name={$module_name}&file=edit\">" . _YOURJOURNAL . "</a> ]</center>";
$j_user2 = "";
} else {
$j_user1 = "<center>[ <a href=\"modules.php?name={$module_name}\">" . _JOURNALDIR . "</a> | <a href=\"modules.php?name=Your_Account&op=new_user\">" . _CREATEACCOUNT . "</a> ]</center>";
$j_user2 = "<br><center><font class=\"tiny\">" . _MEMBERSCAN . "</font></center>";
}
title("{$sitename}: " . _USERSJOURNAL . "");
if (is_user($user)) {
include "modules/Your_Account/navbar.php";
OpenTable();
nav();
CloseTable();
echo "<br>";
}
OpenTable();
echo "<center><img src=modules/{$module_name}/images/bgimage.gif><br><font class=title><b>" . _USERSJOURNAL . "</b></font></center>";
echo "{$j_user1}";
echo "{$j_user2}";
CloseTable();
}示例3: fc_wrap
function fc_wrap($id)
{
global $xoopsDB, $xoopsConfig, $xoopsTheme, $xoopsOption;
OpenTable();
//query Database (returns an array)
$fc_item = fc_query_db_on_id($id);
//$id exists?
if (isset($fc_item['adress']) && $fc_item['adress'] != "") {
// include content
$fc_include = XOOPS_ROOT_PATH . "/modules/cjaycontent/content/" . $fc_item['adress'];
if (file_exists($fc_include)) {
include $fc_include;
// increment hitcounter (hits)
$res = $xoopsDB->queryF("UPDATE " . $xoopsDB->prefix() . "_cjaycontent SET hits=hits+1 WHERE id=\"" . $id . "\"");
} else {
echo _CC_FILENOTFOUND . $fc_include;
}
} else {
$fc_include = XOOPS_ROOT_PATH . "/modules/cjaycontent/content/DO_NOT_DELETE.php";
if (file_exists($fc_include)) {
include $fc_include;
// increment hitcounter (hits)
$res = $xoopsDB->queryF("UPDATE " . $xoopsDB->prefix() . "_cjaycontent SET hits=hits+1 WHERE id=\"" . $id . "\"");
} else {
echo _CC_FILENOTFOUND . $fc_include;
}
}
CloseTable();
return 1;
}示例4: hreferer
function hreferer()
{
global $bgcolor2, $prefix, $db, $admin_file;
include "header.php";
GraphicAdmin();
OpenTable();
echo "<center><font class=\"title\"><b>" . _HTTPREFERERS . "</b></font></center>";
CloseTable();
echo "<br>";
OpenTable();
echo "<center><b>" . _WHOLINKS . "</b></center><br><br>" . "<table border=\"0\" width=\"100%\">";
$row = $db->sql_fetchrow($db->sql_query("SELECT httprefmode from " . $prefix . "_config"));
$httprefmode = intval($row['httprefmode']);
$result = $db->sql_query("SELECT rid, url from " . $prefix . "_referer");
while ($row = $db->sql_fetchrow($result)) {
$rid = intval($row['rid']);
$url = filter($row['url'], "nohtml");
$url2 = urlencode($url);
$title = $url;
if ($httprefmode == 1) {
$url = explode("/", $url);
$url = "http://{$url['2']}";
}
echo "<tr><td bgcolor=\"{$bgcolor2}\"><font class=\"content\">{$rid}</td>" . "<td bgcolor=\"{$bgcolor2}\"><font class=\"content\"><a href=\"index.php?url={$url2}\" target=\"_new\" title=\"{$title}\">{$url}</a></td></tr>";
}
echo "</table>" . "<form action=\"" . $admin_file . ".php\" method=\"post\">" . "<input type=\"hidden\" name=\"op\" value=\"delreferer\">" . "<center><input type=\"submit\" value=\"" . _DELETEREFERERS . "\"></center>";
CloseTable();
include "footer.php";
}示例5: SERVICE_CMSOPEN_postnuke
function SERVICE_CMSOPEN_postnuke($authenticate_only)
{
global $phpnuke, $default_access, $web_root, $root_dir, $cms_user_access, $cms_type, $include_path;
if (!defined("LOADED_AS_MODULE") and $phpnuke == "false") {
die("You can't access this file directly...<br><br>Generally this means that Jinzora was " . "installed as a PostNuke module and you're trying to access it outside of PostNuke");
}
if (function_exists('pnSecAuthAction')) {
if (!pnSecAuthAction(0, 'Jinzora::', "::", ACCESS_READ)) {
include 'header.php';
die('Access Denied');
include 'footer.php';
}
}
// Now let's get the users name IF we need it
if (pnUserGetVar('uname') != "") {
$username = pnUserGetVar('uname');
} else {
$username = "anonymous";
}
// Ok, now let's authenticate this user
userAuthenticate($username);
// Now let's see if we only wanted the user access
if ($authenticate_only == true) {
return;
}
include_once "header.php";
// Now let's open the table
OpenTable();
}示例6: page_header
function page_header($text, $form_action = false, $form_name = "install")
{
global $phpbb_root_path, $phpEx;
OpenTable();
$form_action = $form_action ? $form_action : $phpbb_root_path . 'admin/install.' . $phpEx;
echo "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"10\" align=\"center\">\n";
echo " <tr>\n";
echo " <td width=\"100%\">\n";
echo " <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo " <tr>\n";
echo " <td>\n";
echo " <table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo " <tr>\n";
echo " <td>\n";
echo " </td>\n";
echo " <td align=\"center\" width=\"100%\" valign=\"middle\">\n";
echo " <font style=\"font-size:150%\"><b>" . $text . "</b></font>\n";
echo " </td>\n";
echo " </tr>\n";
echo " </table>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>\n";
echo " <br /><br />\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td align=\"center\">\n";
echo " <table width=\"80%\" cellpadding=\"2\" cellspacing=\"1\" border=\"0\">\n";
echo " <form action=\"" . $form_action . "\" name=\"" . $form_name . "\" method=\"post\">\n";
return;
}示例7: viewdownloadeditorial
function viewdownloadeditorial()
{
global $downloadsprefix, $db;
$lid = intval($_GET['lid']);
include "header.php";
downl_menu_tpl(1);
$result = $db->sql_query("SELECT adminid, editorialtimestamp, editorialtext, editorialtitle FROM " . $downloadsprefix . "_editorials WHERE downloadid = {$lid}");
$recordexist = $db->sql_numrows($result);
$displaytitle = ereg_replace("_", " ", $ttitle);
echo '<br />';
OpenTable();
echo "<center><font class=\"option\"><b>" . _DOWNLOADPROFILE . ": {$displaytitle}</b></font><br />";
downl_infomenu_tpl($lid, $ttitle);
if ($recordexist != 0) {
while (list($adminid, $editorialtimestamp, $editorialtext, $editorialtitle) = $db->sql_fetchrow($result)) {
ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $editorialtimestamp, $editorialtime);
$editorialtime = strftime("%F", mktime($editorialtime[4], $editorialtime[5], $editorialtime[6], $editorialtime[2], $editorialtime[3], $editorialtime[1]));
$date_array = explode("-", $editorialtime);
$timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]);
$formatted_date = date("F j, Y", $timestamp);
echo "<br /><br />";
OpenTable2();
echo "<center><font class=\"option\"><b>'{$editorialtitle}'</b></font></center>" . "<center><font class=\"tiny\">" . _EDITORIALBY . " {$adminid} - {$formatted_date}</font></center><br /><br />" . "{$editorialtext}";
CloseTable2();
}
} else {
echo "<br /><br /><center><font class=\"option\"><b>" . _NOEDITORIAL . "</b></font></center>";
}
echo "<br /><br /><center>";
downloadfooter($lid);
echo "</center>";
CloseTable();
include "footer.php";
}示例8: DoHead
function DoHead()
{
include "header.php";
OpenTable();
?>
<center><b><strong>
· <a href="<?php
echo $_SERVER['PHP_SELF'];
?>
">Administration Home</a> ·<br>
· <a href="<?php
echo $_SERVER['PHP_SELF'];
?>
?op=Accounting">Accounting Admin</a> ·
<?php
include "modules/Accounting/updater.php";
if (isUpdate()) {
?>
<br>··· <a href="http://moahosting.com/modules.php?name=Downloads&d_op=viewdownload&cid=2">An update is available!</a> ···<br>
<?php
}
?>
</strong></b></center>
<?php
CloseTable();
echo "<br>";
OpenTable();
// Create the accounting menu
DoMenu();
}示例9: show
function show($mode, $tablelist, $query)
{
global $db, $bgcolor2, $bgcolor3, $type, $dbname;
require_once 'header.php';
GraphicAdmin('_AMENU0');
OpenTable();
if ($query === null) {
echo 'Mode: <b>' . $mode . '</b> not available yet';
return;
}
if (count($tablelist)) {
$result = $db->sql_query($query);
$numfields = $db->sql_numfields($result);
echo '<span class="genmed"><strong>' . _DATABASE . ':</strong> ' . $dbname . '</span><br /><br />Here are the results of your ' . strtolower($type) . '<br /><br />
<table border="0" cellpadding="2"><tr bgcolor="' . $bgcolor2 . '">';
for ($j = 0; $j < $numfields; $j++) {
echo '<td><strong>' . $db->sql_fieldname($j, $result) . '</strong></td>';
}
echo '</tr>';
$bgcolor = $bgcolor3;
while ($row = $db->sql_fetchrow($result)) {
$bgcolor = $bgcolor == '' ? ' bgcolor="' . $bgcolor3 . '"' : '';
echo '<tr' . $bgcolor . '>';
for ($j = 0; $j < $numfields; $j++) {
echo '<td>' . $row[$j] . '</td>';
}
echo '</tr>';
}
echo '</table>';
}
CloseTable();
}示例10: showheader
function showheader()
{
global $pagetitle;
require 'header.php';
GraphicAdmin('_AMENU2');
OpenTable();
echo '<table border="0" width="100%"><tr><td valign="top">';
}示例11: group_head
function group_head()
{
global $lang;
require_once 'header.php';
GraphicAdmin('_AMENU2');
OpenTable();
echo '<div style="text-align:center;"><h1>Groups Administration</h1></div>';
}示例12: Choice
function Choice()
{
global $xoopsModule;
xoops_cp_header();
OpenTable();
echo "<a href='" . XOOPS_URL . "/modules/system/admin.php?fct=preferences&op=showmod&mod=" . $xoopsModule->getVar('mid') . "'>" . _IMP_Edit . "</a><br />";
CloseTable();
xoops_cp_footer();
}示例13: SiteSent
function SiteSent($fname)
{
include 'header.php';
$fname = stripslashes(FixQuotes(check_html(removecrlf($fname))));
OpenTable();
echo "<center><font class=\"content\">" . _FREFERENCE . " {$fname}...<br><br>" . _THANKSREC . "</font></center>";
CloseTable();
include 'footer.php';
}示例14: StorySent
function StorySent($title, $fname)
{
include "header.php";
$title = filter($title, "nohtml");
$fname = filter($fname, "nohtml");
OpenTable();
echo "<center><font class=\"content\">" . _FSTORY . " <b>{$title}</b> " . _HASSENT . " {$fname}... " . _THANKS . "</font></center>";
CloseTable();
include "footer.php";
}示例15: StorySent
function StorySent($title, $fname)
{
include "header.php";
$title = htmlspecialchars(urldecode(check_html($title, "nohtml")));
$fname = htmlspecialchars(urldecode($fname));
OpenTable();
echo "<center><font class=\"content\">" . _FSTORY . " <b>{$title}</b> " . _HASSENT . " {$fname}... " . _THANKS . "</font></center>";
CloseTable();
include "footer.php";
}