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


PHP COMMONFUNC::selectTableOrdergroupby方法代码示例

本文整理汇总了PHP中COMMONFUNC::selectTableOrdergroupby方法的典型用法代码示例。如果您正苦于以下问题:PHP COMMONFUNC::selectTableOrdergroupby方法的具体用法?PHP COMMONFUNC::selectTableOrdergroupby怎么用?PHP COMMONFUNC::selectTableOrdergroupby使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在COMMONFUNC的用法示例。


在下文中一共展示了COMMONFUNC::selectTableOrdergroupby方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: count

        $Countahtlete_pending = "(<font style='color:red;'>" . $Countahtlete_pending . " Pending</font>)";
    } else {
        $Countahtlete_pending = "";
    }
    ?>

								<p><img src="img/bullet-grey.gif"><a href="CoachAthapprove.php">Athlete Approval <?php 
    echo $Countahtlete_pending;
    ?>
</a> 

								</p>

								<?php 
    //Count Pending Athlete Stats
    $ahtlete_stat_pending = $func->selectTableOrdergroupby(TBL_ATHELETE_STAT, "fldAtheleteId,fldStatus,fldPrograme", "fldPrograme", "where fldCoachId='" . $_SESSION['Coach_id'] . "' and fldStatus = '0'");
    $Countahtlete_stat_pending = count($ahtlete_stat_pending);
    if ($Countahtlete_stat_pending > 0) {
        $Countahtlete_stat_pending = "(<font style='color:red;'>" . $Countahtlete_stat_pending . " Pending</font>)";
    } else {
        $Countahtlete_stat_pending = "";
    }
    ?>

								<p><img src="img/bullet-grey.gif"><a href="ViewAthletesStats.php">Athlete Stats Approval <?php 
    echo $Countahtlete_stat_pending;
    ?>
</a>

								</p>
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:30,代码来源:myaccount.php

示例2: selectTableOrdergroupby

    echo $fldHSCoachName;
    ?>
">
			</span><font color="#0000ff">&nbsp;*</font>		</p>
		<p>
		<label>High School:</label>
		<span> 
			<select name="fldSchool" id="fldSchool" style="width:276px" >
			<!--onchange="select_val(this.value)"-->
			<option value="select" class="selectgrey">Select High School</option>
		   <?php 
    #$categorylist = $func -> selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldState");
    #for ($i = 0; $i < count($categorylist); $i++) {
    #echo '<option value ="' . $categorylist[$i]['fldId'] . '" >' . $categorylist[$i]['fldSchoolname'] . '</option>';
    #}
    $statelist = $func2->selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldState", "fldState", "WHERE fldStatus='ACTIVE'");
    for ($x = 0; $x < count($statelist); $x++) {
        echo '<optgroup label="========' . $statelist[$x]['fldState'] . '========">';
        #echo '<option value ="' . $statelist[$x]['fldState'] . '" >' . $statelist[$x]['fldState'] . '</option>';
        $whereclaus = "WHERE fldState = '" . $statelist[$x]['fldState'] . "' ";
        $categorylist = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldSchoolname", $whereclaus);
        for ($i = 0; $i < count($categorylist); $i++) {
            ?>
<option value ="<?php 
            echo $categorylist[$i]['fldId'];
            ?>
"<?php 
            if ($categorylist[$i]['fldId'] == $fldSchool) {
                ?>
 selected="selected" <?php 
            }
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:Registration-Special-Event.php

示例3: 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

示例4: validate

     $query1 = "SELECT fldSport from " . TBL_ATHELETE_REGISTER . "  WHERE fldUsername='" . $username . "'";
     $db1->query($query1);
     $db1->next_record();
     $fldSport = $func->output_fun($db1->f('fldSport'));
     if ($_SESSION['mode'] == 'coach' || $_SESSION['mode'] == 'college') {
         echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
         echo "<p><label>To:</label><span>";
         echo $strcombo = '<select name="to" style="width:276px">';
         echo $strcombo = '<option value="">----- Please Select -----</option>';
         $coachlist = $func->selectTableOrder(TBL_HS_AAU_COACH, "fldId,fldName,fldLastName,fldUsername", "fldLastName");
     } else {
         echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
         echo "<p><label>To:</label><span>";
         echo $strcombo = '<select name="to" style="width:276px">';
         echo $strcombo = '<option value = "">----- Please Select -----</option>';
         $coachlist = $func->selectTableOrdergroupby("tbl_hs_aau_coach_sportposition cs, tbl_hs_aau_coach ac", "fldId,fldName,fldLastName,fldUsername", "ac.fldLastName", "where ac.fldId = cs.fldCoachNameId and cs.fldSportId = " . $fldSport);
     }
     for ($i = 0; $i < count($coachlist); $i++) {
         if (!in_array($coachlist[$i]['fldId'], $coachid)) {
             if ($_REQUEST['to'] == $coachlist[$i]['fldUsername']) {
                 echo '<option value ="' . $coachlist[$i]['fldUsername'] . '" selected="selected" >' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>';
             } else {
                 echo '<option value ="' . $coachlist[$i]['fldUsername'] . '">' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>';
             }
         }
     }
     echo $strcombo = '</select>';
 } else {
     if ($_REQUEST['value'] == 'athlete') {
         ##TO ATHLETE##
         echo "<h2 style='padding-left:160px;'>Send Message to an Athlete</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:Athmessage.php

示例5:

											<span>
												<input type="text" name="fldAlternativePhone" id="fldAlternativePhone" value="<?php 
echo $fldAlternativePhone;
?>
"
												>
											</span>
										</p>
										<hr class="line" />
										
										<p>
                                        <label>College:</label>
                                        <span> <?php 
echo $strcombo = '<select name="fldCollegename" id="fldSchool">';
echo $strcombo = '<option value="select" class="selectgrey">Select College</option>';
$statelist = $func2->selectTableOrdergroupby(TBL_COLLEGE, "fldState", "fldState", "WHERE fldStatus='1'");
for ($x = 0; $x < count($statelist); $x++) {
    echo '<optgroup label="========' . $statelist[$x]['fldState'] . '========">';
    $whereclaus = "WHERE fldState = '" . $statelist[$x]['fldState'] . "' ";
    $collegelist = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName", "fldName", $whereclaus);
    for ($i = 0; $i < count($collegelist); $i++) {
        echo '<option value ="' . $collegelist[$i]['fldId'] . '" >' . $collegelist[$i]['fldName'] . '</option>';
    }
    echo '<option value ="other" class="addcustom_normal">****Other (Add Your College) ****</option>';
    echo '</optgroup>';
}
echo '<option value ="other" class="addcustom">Not Listed? Add Your College</option>';
echo $strcombo = '</select>';
?>
</span><font color="#0000ff">*</font>
                                    </p>                                    
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:Registration-College-Coach.php


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