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


PHP DBQuery::is_empty方法代码示例

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


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

示例1: BadTimeSemanticException

 function __construct($crn, $begin_change, $end_change, $day_change = '')
 {
     // precondition check on begin and end times
     if (intval($begin_change) >= intval($end_change)) {
         throw new BadTimeSemanticException("begin time must be earlier than end time");
     }
     // this is the change description for the section (potentially)
     $this->desc = array($begin_change, $end_change, $day_change);
     // look up the section by CRN; use the selected term code
     $use_term = self::$term_id;
     $opt = self::$term_id != '' ? "AND term_code = {$use_term}" : "";
     $q = new DBQuery("SELECT id, begin_time, end_time, dow FROM banner.section WHERE crn = {$crn} {$opt};");
     if ($q->is_empty()) {
         throw new SectionNotFoundException();
     }
     if ($q->get_row_cnt() > 1) {
         // this should not occur given preconditions of the database
         throw new HandlerException("more than one section found given input CRN");
     }
     // remember important attributes about the section
     $row = $q->get_next_row();
     // the query should have only retrieved one query
     $this->sid = $row[0];
     $this->curdesc = array($row[1], $row[2], $row[3]);
     // if no dow was supplied in the section change description, then use the current dow for the course
     // this is important as it allows a correct REGEX to be generated by 'generate_sql_where_dow_overlap'
     if ($day_change == '') {
         $this->desc[2] = $this->curdesc[2];
     }
 }
开发者ID:starbuck93,项目名称:14F_CS374_Team2,代码行数:30,代码来源:libhandler.php

示例2: exit

if (!isset($_GET) || !array_key_exists('noBackLink', $_GET) || $_GET['noBackLink'] == 'false') {
    echo "<a style= \"margin-top:10px;margin-left:10px;\" class=\"pure-button pure-button-primary\" href=\"/index.html\">Banner Main</a></div>";
}
if (!isset($_GET) || !array_key_exists('crn', $_GET)) {
    echo "<p><strong>Bad request</strong></p>\n";
    exit(0);
}
$crn = $_GET['crn'];
if (!is_numeric($crn)) {
    echo "<p>{$crn} is not a valid CRN value</p>";
    exit(0);
}
// get the course title information
$q1 = new DBQuery("SELECT subject_code, number, title, begin_time, end_time, dow, first_name, last_name FROM banner.course\nINNER JOIN banner.section ON section.course_id = course.id AND crn={$crn}\nINNER JOIN banner.professor ON professor.id = professor_id;");
if ($q1->is_empty()) {
    echo "<p>No results for CRN={$crn}</p>";
    exit(0);
}
$heading = $q1->get_next_row();
$q2 = new DBQuery("SELECT student.id, first_name, middle_name, last_name, classification FROM banner.section\nINNER JOIN banner.student_section ON crn={$crn} AND section.id = section_id\nINNER JOIN banner.student ON student_id = student.id\nORDER BY student.classification, last_name;");
if ($q2->is_empty()) {
    // section shouldn't be empty
    echo "<p>No students where associated with the specified section</p>";
    exit(0);
}
echo "<h1>Section listing for {$heading[0]} {$heading[1]} {$heading[2]} [CRN={$crn}]</h1>" . "<h2>Start Time: {$heading[3]}<br />End Time: {$heading[4]}<br />Meeting Days: {$heading[5]}<br />Professor: {$heading[6]} {$heading[7]}</h2>" . $q2->htmlitize();
?>

  </center></body>
</html>
开发者ID:starbuck93,项目名称:14F_CS374_Team2,代码行数:30,代码来源:show-section.php


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