本文整理汇总了PHP中COMMONFUNC::selectTableOrder方法的典型用法代码示例。如果您正苦于以下问题:PHP COMMONFUNC::selectTableOrder方法的具体用法?PHP COMMONFUNC::selectTableOrder怎么用?PHP COMMONFUNC::selectTableOrder使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类COMMONFUNC
的用法示例。
在下文中一共展示了COMMONFUNC::selectTableOrder方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: header
header("Location:index.php");
}
$func = new COMMONFUNC();
$db = new DB();
$flag = 0;
$query_Athlete = " Select * from " . TBL_ATHELETE_REGISTER . " where fldUsername ='" . $_SESSION['FRONTEND_USER'] . "'";
$db->query($query_Athlete);
$db->next_record();
$athemail = $db->f('fldEmail');
$coach_id = $db->f('fldApproveCoachId');
$userid = $db->f('fldId');
$fldSport = $db->f('fldSport');
$fldFirstname = $db->f('fldFirstname');
$fldLastname = $db->f('fldLastname');
if ($_GET['fldEventId']) {
$programe_event = $func->selectTableOrder(TBL_EVENT, "fldEventId,fldEventName", "fldEventId", "where fldEventId=" . $_GET['fldEventId']);
}
$AthleteName = $fldFirstname . " " . $fldLastname;
$EventName = $programe_event[0]['fldEventName'];
if ($_POST['isSubmit'] == 'save') {
if ($flag == 0) {
for ($cataStatcount = 0; $cataStatcount < count($_POST['category']); $cataStatcount++) {
$strDataArr = array('fldPrograme' => $programe_event[0]['fldEventId'], 'fldCategoryId' => $func->input_fun($_POST['categoryId'][$cataStatcount]), 'fldValue' => $func->input_fun($_POST['category'][$cataStatcount]), 'fldLabelname' => $func->input_fun($_POST['labelname'][$cataStatcount]), 'fldStatus' => 0, 'fldCoachId' => $coach_id, 'fldSportid' => $fldSport, 'fldAtheleteId' => $userid, 'fldAddDate' => date("y-m-d"));
$db->insertRec(TBL_ATHELETE_STAT, $strDataArr);
}
$msg = "Hello Coach, <br /><br />\r\r\n You are receiving this email because an Athlete on your team has posted Game Stats for a particular game/event. Please login to your Account at www.collegeprospectnetwork.com, and review these Stats @ 'My Account > Athlete Stats Approval' section.\r <br /><br /> \r <b>Athlete:</b> " . $AthleteName . "<br /> \r <b>Game / Event:</b> " . $EventName . "<br /> \r <br /> \r\r\n Thank you in advance Coach,<br />\r\r\n College Prospect Network<br />\r\r\n www.CollegeProspectNetwork.com";
$query_Coach_id = " Select fldEmail from " . TBL_HS_AAU_COACH . " where fldId ='" . $coach_id . "'";
$db->query($query_Coach_id);
$db->next_record();
$coachEmail = $db->f('fldEmail');
$toStre1 = $coachEmail;
示例2:
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Sport<font color="red"> *</font></td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<?php
echo $strcombo = '<select name="fldNeedType" style="width:200px">';
echo $strcombo = '<option value = "">Select Type</option>';
$categorylist = $func->selectTableOrder(tbl_sports, "fldId,fldSportsname", "fldId");
for ($i = 0; $i < count($categorylist); $i++) {
echo '<option value ="' . $categorylist[$i]['fldId'] . '" >' . $categorylist[$i]['fldSportsname'] . '</option>';
}
echo $strcombo = '</select>';
?>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
示例3:
$fldUserName = $func->output_fun($db->f('fldUserName'));
$fldAddDate = $func->output_fun($db->f('fldAddDate'));
$fldSubscribe = $func->output_fun($db->f('fldSubscribe'));
$fldPosition = $func->output_fun($db->f('fldPosition'));
$fldEmail = $func->output_fun($db->f('fldEmail'));
$fldExpiredate = $func->output_fun($db->f('fldExpiredate'));
$fldFirstName = $func->output_fun($db->f('fldFirstName'));
$fldLastName = $func->output_fun($db->f('fldLastName'));
$fldAlternativeEmail = $func->output_fun($db->f('fldAlternativeEmail'));
$fldPhone = $func->output_fun($db->f('fldPhone'));
$fldAlternativePhone = $func->output_fun($db->f('fldAlternativePhone'));
$fldDescriPation = $func->output_fun($db->f('fldDescriPation'));
$fldStatus = $func->output_fun($db->f('fldStatus'));
$fldSubscribe = $db->f('fldSubscribe');
if ($fldCollegeName != 'other') {
$college_address_before = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName,fldAddress,fldCity,fldState,fldZipCode,fldDivison", "fldId", "where fldStatus =1 and fldId=" . $fldCollegeName);
$fldCity = $college_address_before[0]['fldCity'];
$fldState = $college_address_before[0]['fldState'];
$fldAddress = $college_address_before[0]['fldAddress'];
$fldZipCode = $college_address_before[0]['fldZipCode'];
$fldDivison = $college_address_before[0]['fldDivison'];
}
$selquery = "select fldSportsname from " . TBL_SPORTS . " where fldId='" . $fldSport . "'";
$objQuery = mysql_query($selquery);
$numquery = mysql_num_rows($objQuery);
$resquery = mysql_fetch_array($objQuery);
$SportsName = $resquery['fldSportsname'];
?>
<table width="100%" cellpadding="3" cellspacing="5">
<tr>
示例4: COMMONFUNC
<?php
include_once "inc/common_functions.php";
//for common function
include_once "inc/page.inc.php";
require_once 'zipcode.class.php';
session_start();
$z = new zipcode_class();
$func = new COMMONFUNC();
$db = new DB();
$flag = 0;
$college_info = $func->selectTableOrder(TBL_COLLEGE, 'fldId,fldAddress,fldCity,fldState,fldZipCode', "fldId", "where fldId=" . $_GET['fldid']);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Google Maps For view Location</title>
<script src="//maps.google.com/maps?file=api&v=2.x&key=<?php
echo MAPS_APIKEY;
?>
" type="text/javascript"></script>
<script type="text/javascript">
var map = null;
var geocoder = null;
function initialize() {
if (GBrowserIsCompatible()) {
map = new GMap2(document.getElementById("map_canvas"));
示例5:
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Sport<font color="red">*</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<?php
echo '<select name="fldParentId" style="width:220px"><option value="">Please Select</option>';
$sport_list = $func->selectTableOrder(TBL_SPORTS, "fldId,fldSportsname", "fldSportsname", "where fldStatus='ACTIVE'");
/*$sport_list=$func->selectTableOrder(TBL_SPORTS,"fldId,fldSportsname","fldId");*/
for ($i = 0; $i < count($sport_list); $i++) {
if ($fldParentId == $sport_list[$i]['fldId']) {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" selected = "selected" >' . $sport_list[$i]['fldSportsname'] . '</option>';
} else {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" >' . $sport_list[$i]['fldSportsname'] . '</option>';
}
}
echo $strcombo = '</select>';
?>
</td>
</tr>
<tr height="20">
<td align="center" valign="top" colspan="3" class="normalwhite_14">
示例6: submitDeleteAll
} else {
$query = "Select * from " . TBL_ATHLETE_STATS_CATAGORY . " where fldStatus=1 " . $srchCond;
}
if ($_REQUEST['sportid'] != '') {
$srchCond1 = "AND fldParentId = " . $_REQUEST['sportid'];
$query = "Select * from " . TBL_ATHLETE_STATS_CATAGORY . " where 1=1 " . $srchCond1 . " ORDER BY fldName";
}
$db1->query($query);
$db1->next_record();
$totalPages = $db1->num_rows();
if ($totalPages > 0) {
?>
<tr> <td align="left" style="padding-left:7px;"colspan="10"><input type="checkbox" id="check_all" name="check_all" value="" onclick="javascript:checkAll();"> <b>Check All</b> <input type="button" name="delete" value="Delete Selected" onclick="return submitDeleteAll();"><?php
echo '<select name="fldParentId" style="width:220px" onChange="javascript:return formsubmit(this.value);" ><option value="">Select Sport</option>';
$sport_list = $func->selectTableOrder(TBL_SPORTS, "fldId,fldSportsname", "fldId");
for ($i = 0; $i < count($sport_list); $i++) {
if ($_REQUEST['sportid'] == $sport_list[$i]['fldId']) {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" selected = "selected" >' . $sport_list[$i]['fldSportsname'] . '</option>';
} else {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" >' . $sport_list[$i]['fldSportsname'] . '</option>';
}
}
echo $strcombo = '</select>';
?>
<a href="ADAthleteCatagoryAdd.php">Add New</a>
</td>
示例7:
</select></td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>-->
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Sport <font color="red">*</font></td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<select name="fldSport" id="fldSport" style="width: 220px;font-size:12px;"
>
<?php
$sportlist = $func->selectTableOrder(TBL_SPORTS, "fldId,fldSportsname", "fldSportsname", "where fldStatus='ACTIVE'");
?>
<option value = "select">Select Sport</option><?php
for ($i = 0; $i < count($sportlist); $i++) {
?>
<option value ="<?php
echo $sportlist[$i]['fldId'];
?>
" <?php
if (isset($_REQUEST['sportid']) and $_REQUEST['sportid'] == $sportlist[$i]['fldId']) {
?>
selected <?php
}
?>
><?php
示例8: header
//for common function
include_once "inc/page.inc.php";
include_once "inc/config.inc.php";
if ($_SESSION['FRONTEND_USER'] == "") {
header("Location:login.php");
}
//for paging
$func = new COMMONFUNC();
$db = new DB();
//$flag=1;
if ($_POST['isSubmit'] == 'save') {
if ($_REQUEST['collegeid'] == '') {
$error_msg[] = " Please Select College";
}
$collegeid = $func->input_fun($_POST['collegeid']);
$ath_name = $func->selectTableOrder(TBL_ATHELETE_REGISTER, "fldFirstname,fldLastname", "fldId", "where fldId='" . $_SESSION['Athlete_id'] . "' and fldStatus ='ACTIVE'");
$name = ucfirst($ath_name[0]['fldFirstname']) . ' ' . ucfirst($ath_name[0]['fldLastname']);
$strDataArr = array('collegeid' => $collegeid, 'athleteid' => $_SESSION['Athlete_id'], 'athname' => $name, 'status' => $func->input_fun($_POST['status']));
$whereClause = "athleteid='" . $_SESSION['Athlete_id'] . "' and collegeid = '" . $collegeid . "'";
if ($db->MatchingRec(TBL_ADDTONETWORK_REQUEST, $whereClause) > 0) {
$error_msg[] = 'You Have Already Send the Request!';
}
if (count($error_msg) == 0) {
$db->insertRec(TBL_ADDTONETWORK_REQUEST, $strDataArr);
$msg = "Your Request has been sent! Wait for Approval";
header("Location: myaccount.php?msg={$msg}");
}
}
?>
示例9:
</tr>
<tr>
<td height="35" colspan="3" align="right" class="normalblack_12"><FONT color="Red">Fields marked with * are mandatory </FONT></td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Game / Event<font color="red"> *</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<?php
$eventName = $func->selectTableOrder(TBL_EVENT, "fldEventId,fldEventName", "fldEventId");
?>
<select name="fldPrograme" style="width: 220px;">
<option value="select">Select Programe</option>
<?php
for ($i = 0; $i < count($eventName); $i++) {
?>
<option value="<?php
echo $eventName[$i]['fldEventId'];
?>
" <?php
if ($eventName[$i]['fldEventId'] == $fldPrograme) {
?>
selected<?php
示例10:
</td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=4 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">College Name<font color="red"> *</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12"> <?php
echo $strcombo = '<select name="fldCollegename" style="width:200px;">';
echo $strcombo = '<option value = "select">Select College</option>';
$collegelist = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName", "fldId", "where fldStatus =1");
for ($i = 0; $i < count($collegelist); $i++) {
echo '<option value ="' . $collegelist[$i]['fldId'] . '" >' . $collegelist[$i]['fldName'] . '</option>';
}
echo $strcombo = '</select>';
?>
</td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">First Name<font color="red"> *</font> </td>
示例11: die
if (!$db->query($query)) {
die(mysql_error());
$success = FALSE;
}
}
// TODO: Should the sport list be restricted to the sports that the coach has an active subscription to?
$query = 'SELECT tbl_sports.fldId, tbl_sports.fldSportsname ' . 'FROM tbl_sports INNER JOIN tbl_college_subscription ' . 'ON tbl_sports.fldId=tbl_college_subscription.fldSport ' . 'WHERE tbl_college_subscription.fldActive=1 ' . 'AND tbl_college_subscription.fldCoach=' . $coachId;
if (!$db->query($query)) {
die(mysql_error());
}
$fldSportList = array();
while ($db->next_record()) {
$fldSportList[$db->f('fldId')] = $db->f('fldSportsname');
}
$arrDistances = array('0', '10', '25', '50', '100', 'Any');
$fldClassList = $classlist = $func->selectTableOrder(TBL_CLASS, "fldId,fldClass", "fldId");
if ($_REQUEST['action'] == 'edit') {
$needId = $_REQUEST['id'];
$query = 'SELECT * FROM ' . TBL_COLLEGE_NEEDS . ' WHERE fldId=' . $needId;
if (!$db->query($query)) {
die(mysql_error());
}
$db->next_record();
$fldSport = $db->f('fldSportId');
$fldGradClass = $db->f('fldGradClass');
$fldMinHeight = intval($db->f('fldMinHeight') / 12) . '-' . intval($db->f('fldMinHeight') % 12);
$fldMaxHeight = intval($db->f('fldMaxHeight') / 12) . '-' . intval($db->f('fldMaxHeight') % 12);
switch ($db->f('fldMinWeight')) {
case 0:
$fldMinWeight = 'under140';
break;
示例12: getSchoolList
public static function getSchoolList()
{
$func = new COMMONFUNC();
$schoolList = array();
$groups = $func->selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldState", "fldState", "WHERE fldStatus='ACTIVE'");
for ($i = 0; $i < count($groups); $i++) {
$groupLabel = '========' . $groups[$i]['fldState'] . '========';
$schoolList[$groupLabel] = array();
//School Loop (in state)
$where = "WHERE fldState='" . $groups[$i]['fldState'] . "'";
$schools = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldSchoolname", $where);
for ($j = 0; $j < count($schools); $j++) {
$key = $schools[$j]['fldId'];
$value = $schools[$j]['fldSchoolname'];
$schoolList[$groupLabel][$key] = $value;
}
}
return $schoolList;
}
示例13: count
case 'coach':
//HS Coach ID
$UserID = $_SESSION['Coach_id'];
break;
case 'college':
//College Coach ID
$UserID = $_SESSION['College_Coach_id'];
//Check Subscription Status
$query = " Select fldSubscribe from " . TBL_COLLEGE_COACH_REGISTER . " where fldId ='" . $UserID . "' ";
$db->query($query);
$db->next_record();
$_SESSION['fldSubscribe'] = $db->f('fldSubscribe');
break;
}
#### PENDING NETWORK REQUESTS ####
$Pending_request = $func->selectTableOrder(TBL_NETWORK, "fldId", "fldId", "where fldReceiverid='" . $UserID . "' and fldReceiverType='" . $UserType . "' and fldStatus='Pending'");
if (count($Pending_request) > 0) {
$NetworkReq_Pending = "(<font style='color:red;'>" . count($Pending_request) . " Pending</font>)";
}
#### PENDING NETWORK REQUESTS ####
#### INBOX ####
$inboxinfo = $func->selectTableOrder(TBL_MAIL, "mail_id", "mail_id", "where UserTo='" . $_SESSION['FRONTEND_USER'] . "' and status ='unread'");
$Countinboxinfo = count($inboxinfo);
if ($Countinboxinfo > 0) {
$Countinboxinfo = "(<font style='color:red;'>" . $Countinboxinfo . " Unread</font>)";
} else {
$Countinboxinfo = "";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
示例14: COMMONFUNC
<?php
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
include_once "../inc/config.inc.php";
//for paging
$func = new COMMONFUNC();
$db = new DB();
$q = $_GET['q'];
if ($q == "other") {
$other_info = $func->selectTableOrder(TBL_OTHER, "fldId,fldName", "fldId", " where fldUserId ='" . $_GET['fldUserName'] . "'");
$college_address_other_info = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName,fldAddress,fldCity,fldState,fldZipCode", "fldId", "where fldStatus =0 and fldId='" . $other_info[0]['fldId'] . "'");
?>
<table align="center" border="0" align="center" width="60%">
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">College Name<font color="red"> *</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12" colspan=2>
<input type="text" name="txtfldName" id="txtfldName" style="width:200px;" value="<?php
echo $other_info[0]['fldName'];
示例15: header
//for common function
include_once "inc/page.inc.php";
session_start();
if ($_SESSION['FRONTEND_USER'] == "") {
header("Location:index.php");
}
//for paging
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$page = new Page();
//Create an instance of class Pate
$lnb = "2";
$error_msg = '';
$srchCond = '';
if ($_SESSION['mode'] == "athlete") {
$athlete_info = $func->selectTableOrder(TBL_ATHELETE_REGISTER, "fldId,fldUsername,fldSchool,fldSport", "fldId", " where fldUsername='" . $_SESSION['FRONTEND_USER'] . "'");
}
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldEventName like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
$fldEventId = $_REQUEST['fldEventId'];
$delete_query_details = "delete from " . TBL_EVENT . " where fldEventId=" . $fldEventId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Event successfully deleted.";