001.<?php include('header.php');?>
002.<div id="page-wrapper">
003. <div class="container-fluid">
004. <div class="row bg-title">
005. <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
006. <h3 class="page-title">เพิ่มข้อมูลห้องเรียน</h3>
007. </div>
008. <!-- /.col-lg-12 -->
009. </div>
010. <div class="col-md-12 col-sm-12">
011. <div class="white-box">
012.
013. <div class="row">
014. <div class="col-sm-12 col-xs-12">
015. <form method="post">
016. <div class="form-group">
017. <label for="school_id">โรงเรียน</label>
018. <div class="input-group">
019. <div class="input-group-addon"><i class="ti-pencil-alt"></i></div>
020.
021. <select class="form-control" name="school_id" id="school_id">
022. <?php
023. $sql=" select * from tb_school";
024. $result=$cls_conn->select_base($sql);
025. while($row=mysqli_fetch_array($result))
026. {
027. ?>
028. <option value="<?=$row['school_id'];?>"><?=$row['school_year'];?></option>
029. <?php
030. }
031. ?>
032.
033. </select>
034. </div>
035. </div>
036.
037. <div class="form-group">
038. <label for="teacher_id">ครู</label>
039. <div class="input-group">
040. <div class="input-group-addon"><i class="ti-pencil-alt"></i></div>
041.
042. <select class="form-control" name="teacher_id" id="teacher_id">
043. <?php
044. $sql=" select * from tb_teacher";
045. $result=$cls_conn->select_base($sql);
046. while($row=mysqli_fetch_array($result))
047. {
048. ?>
049. <option value="<?=$row['teacher_id'];?>"><?=$row['teacher_name'];?></option>
050. <?php
051. }
052. ?>
053.
054. </select>
055. </div>
056. </div>
057.
058. <div class="form-group">
059. <label for="room_id">ระดับชั้น</label>
060. <div class="input-group">
061. <div class="input-group-addon"><i class="ti-pencil-alt"></i></div>
062.
063. <select class="form-control" name="room_id" id="room_id">
064. <?php
065. $sql=" select * from tb_room";
066. $result=$cls_conn->select_base($sql);
067. while($row=mysqli_fetch_array($result))
068. {
069. ?>
070. <option value="<?=$row['room_id'];?>"><?=$row['room_primary'];?></option>
071. <?php
072. }
073. ?>
074.
075. </select>
076. </div>
077. </div>
078.
079. <div class="form-group">
080. <label for="student_id">รายชื่อนักเรียน</label>
081. <div class="input-group">
082. <div class="input-group-addon"><i class="ti-pencil-alt"></i></div>
083.
084. <select class="form-control" name="student_id" id="student_id ">
085. <?php
086. $sql=" select * from tb_student";
087. $result=$cls_conn->select_base($sql);
088. while($row=mysqli_fetch_array($result))
089.
090. {
091.
092. ?>
093. <option value="<?=$row['student_id'];?>"><?=$row['student_prename'];?><?=$row['student_firstname'];?> <?=$row['student_lastname'];?></option>
094. <?php
095. }
096. ?>
097.
098. </select>
099. </div>
100. </div>
101.
102. <button type="submit" name="submit" class="btn btn-success waves-effect waves-light m-r-10">Submit</button>
103. <button type="reset" name="reset" class="btn btn-inverse waves-effect waves-light">Cancel</button>
104. </form>
105. <?php
106. if(isset($_POST['submit']))
107. {
108. $school_id=$_POST['school_id'];
109. $teacher_id=$_POST['teacher_id'];
110. $room_id=$_POST['room_id'];
111. $school_id=$_POST['school_id'];
112. $student_id=$_POST['student_id'];
113.
114. $sql=" insert into tb_classroom(school_id,teacher_id,room_id,student_id)";
115. $sql.=" values ('$school_id','$teacher_id','$room_id','$student_id')";
116. if($cls_conn->write_base($sql)==true)
117. {
118. echo $cls_conn->show_message('บันทึกข้อมูลสำเร็จ');
119. echo $cls_conn->goto_page(1,'show_classroom.php');
120. }
121. else
122. {
123. echo $cls_conn->show_message('บันทึกข้อมูลไม่สำเร็จ');
124. echo $sql;
125. }
126. }
127.
128. ?>
129. </div>
130. </div>
131. </div>
132. </div>
133.
134. </div>
135. <!-- /.container-fluid -->
136.</div>
137.<?php include('footer.php');?>
