studentFactory> topical media & game development
topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

professional-php-05-class.studentFactory.php / php



  <?php
  class StudentFactory {
    
    public static function getStudent(id) {
      sql = "SELECT * from \"student\" WHERE \"studentid\" = id";
  
      data = db->select(sql); //pseudo code.  Assume it returns an
                                //array containing all rows returned
                                //by the query.
  
      if(is_array(data) && sizeof(data)) {
        return new Student(data[0]['studentid'], data[0]['name']);
      } else {
        throw new Exception("Student id does not exist.");
      }
    }
    
    public static function getCoursesForStudent(id, col) {
      sql = "SELECT \"course\".\"courseid\",
                     \"course\".\"coursecode\",
                     \"course\".\"name\"
              FROM \"course\", \"studentcourse\" WHERE
                     \"course\".\"id\" = \"studentcourse\".\"courseid\" AND 
                     \"studentcourse\".\"studentid\" = id";
  
      data = db->select(sql);  //same pseudo code in getStudent() 
  
      if(is_array(data) && sizeof(data)) {
        foreach(data as datum) {
          objCourse = new Course(datum['courseid'], datum['coursecode'], 
                                  datum['name']);
          col->addItem(objCourse, objCourse->getCourseCode());
        }
      }
  
    }
  }
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.