function build_school_dropdown_list() { $schools = get_schools(); $script = "<option value=''>----</option>"; foreach ($schools as $school) { $script .= "<option value='" . $school->name . "'>" . $school->name . "</option>"; } // $script .= ";"; return $script; }
<div id="out_of_sync_tab"> </div> </div> </div> <!-- check-status--> </div> <!-- set_up app login --> <div class="row-fluid"> <div id="set_up_app_login"> <div class="row-fluid"> <div id="set_up_school"> <select id="set_up_school_id" onchange=""> <? $schools = get_schools(); $options = "<option value='0'>Select School</option>"; foreach ($schools as $school_id => $school_name) { $options.="<option value='$school_id'>$school_name</option>"; } echo $options; ?> </select> </div> <div id="generate_pass"> <button class="btn" type="button" onclick="gen_pass()">Generate password</button> </div> </div>
require $_CONF['webRoot'] . 'functionLib.php'; $start = microtime_float(); $today = date('Y-m-d'); // Connect to DB $db = new mysqli($_CONF['DB_host'], $_CONF['DB_user'], $_CONF['DB_pass'], $_CONF['DB_name']); if (mysqli_connect_errno()) { die("There was an error connecting to the database: " . mysqli_connect_error()); } $q3aitStudentsUname = make_assoc_array_from_sql(getCurrentStudentsForSMS(), 'u_name', 'my'); //displayArray($q3aitStudentsUname);exit; $smsStudents = make_assoc_array_from_sql(getCurrentStudentsFromSMS(), 'STGUID', 'ms'); //displayArray($smsStudents);exit; $q3aitStudents = make_assoc_array_from_sql(getCurrentStudentsForSMS(), 'STGUID', 'my'); //displayArray($q3aitStudents);exit; $edCenters = make_assoc_array_from_sql(get_edCenters(), 'smsBuildingID', 'my'); $schools = make_assoc_array_from_sql(get_schools(), 'BEDSCode', 'my'); $smsCourses = make_assoc_array_from_sql(getCoursesFromSMS(), 'SectionID', 'ms'); $smsTeachers = make_assoc_array_from_sql(getCurrentTeachersFromSMS(), 'username', 'ms'); $q3aitTeachers = make_assoc_array_from_sql(getCurrentTeachersForSMS(), 'email', 'my'); $smsClassRosters = make_array_from_sql(getClassRostersFromSMS(), 'ms'); $q3aitClassRosters = make_assoc_array_from_sql(getClassRostersForSMS(), 'SectionID', 'my'); $q3aitUsers = make_assoc_array_from_sql(getCurrentStudentsForSMS(), 'STGUID', 'my'); $q3aitCourses = make_assoc_array_from_sql(getCoursesForSMS(), 'SectionID', 'my'); //displayArray($smsTeachers);exit; //displayArray($smsStudents);exit; //displayArray($q3aitTeachers);exit; //displayArray($smsCourses);exit; //displayArray($q3aitStudents);exit; //get_school_year_info(6, 1); //getSMSStudentAttendance(171,6,1); $msg = '';