当前位置: 首页>>代码示例>>PHP>>正文


PHP COMMONFUNC::selectTableOrder方法代码示例

本文整理汇总了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;
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:AtheleteStat-newadditions2.php

示例2:

			&nbsp;
			</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">
			&nbsp;
			</td>
			</tr>
			
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:30,代码来源:ADCollegeAdd.php

示例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>
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADCollegeCoachDetails.php

示例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&amp;v=2.x&amp;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"));
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:Window-Terms-and-Conditions.php

示例5:

			<td valign="top" class="normalwhite_14" colspan=3 align="center">
			&nbsp;
			</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">
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADAthleteCatagoryEdit.php

示例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>&nbsp; &nbsp;<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>';
    ?>
 
								
								&nbsp;&nbsp;<a href="ADAthleteCatagoryAdd.php">Add New</a>
								
								</td>
								
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:30,代码来源:ADAthleteCatagoryList.php

示例7:

			
			</select></td>
			</tr>
			<tr height="20">
			<td valign="top" class="normalwhite_14" colspan=3 align="center">
			&nbsp;
			</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 
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:30,代码来源:ADEvent.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}");
    }
}
?>

开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:29,代码来源:Athtonetwork.php

示例9:

			</tr>
			<tr>
			<td height="35" colspan="3" align="right" class="normalblack_12"><FONT color="Red">Fields marked with * are mandatory&nbsp;</FONT></td>
			</tr>
			<tr height="20">
			<td valign="top" class="normalwhite_14" colspan=3 align="center">
			&nbsp;
			</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 
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADAthleteStatEdit.php

示例10:

			</td>
			</tr>
			<tr height="20">
			<td valign="top" class="normalwhite_14" colspan=4 align="center">
			&nbsp;
			</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">
			&nbsp;
			</td>
			</tr>
			<tr height="20">
			<td valign="top" align="right" class="normalblack_12" width="30%">First Name<font color="red"> *</font> </td>
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADCollegeCoach.php

示例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;
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:collegeNeed.php

示例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;
 }
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:19,代码来源:AthleteSearchHelper.php

示例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">
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:myaccount.php

示例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" > : &nbsp; </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'];
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:addcollage.php

示例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.";
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ViewCalender.php


注:本文中的COMMONFUNC::selectTableOrder方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。