<?php 
error_reporting(0);
include("connect/connect.php"); 
//insert
			if($_POST['check'] == 1){
				
				function name($id){
						$sql = "SELECT * FROM tblbranch WHERE branchId = '".$id."'";
						$query = mysql_query($sql) ;
						$_POST['major_name'];
						$_POST['minor_name'];
						
				}
				
				$field_insert = array(
				 'student_id',
				 'people_id' , 
				 'perfix_id' , 
				 'stu_fname',
		 		 'stu_lname',
		  		 'birthday' ,
		   		 'start_year' ,
				'schedu_id' , 
			 	'group_id', 
			 	'years' , 
			 	'major_id', 
				'major_name',
			  	'minor_name', 
				'BloodGroup',
				'school',
				'adress',
				'adress1',
				'idschool',
			);
			
			
			foreach($field_insert as $key){
				$field_insert_data[$key] = $_POST[$key];
			}
			
			$sql = "INSERT INTO tblstd_idcard (".implode(",",$field_insert).") VALUES ('".implode("','",$field_insert_data)."')";
			
		
				
				$query = mysql_query($sql) or die(mysql_error());
				if(!$query){
					echo "error insert data std connect admin";
				}
				
			}//end if
?>


<div style="width:500px;">
<center><h2>เพิ่มรายชื่อนักศึกษา</h2></center>
<form class="form-horizontal" action="#" method="post">
	<input value="1" type="hidden" name="check" />
	<span style="color:#F00">002 = ชาย || 003 = หญิง</span>
 <?php include("connect/connect.php"); 


function perfix(){
	$input = '<select name="perfix_id" id="select" class="form-control">
    <option value="">เลือก</option>
	<option value="002">นาย</option>
	<option value="003">นางสาว</option>';
	$input.='</select>';
	return $input;	
}


function major(){
	
	$sql = "SELECT * FROM tblbranch";
	$query = mysql_query($sql) ;
	$input = '<select name="major_id" id="select" class="form-control">
    <option value="">เลือก</option>';
	
	while($data = mysql_fetch_assoc($query)){
		$t = $data['level']." ".$data['coureId']." ".$data['branch']." || ".$data['major'];
		$input.= '<option value="'.$data['branchId'].'">'.$t.'</option>';
	}
	
	
	$input.='</select>';
	return $input;	
	
}

	$field = array(
		'student_id' => "รหัสนักศึกษา",
		 'people_id' => "รหัสบัตรประชาชน", 
		 'perfix_id' => "คำนำหน้า", 
		 'stu_fname'=>"ชื่อจริง",
		  'stu_lname'=>"นามสกุล",
		   'birthday' => "วันเดิอนปีเกิด",
		    'start_year' => "ปีเข้า",
			 'schedu_id' => "สาขางาน", 
			 'group_id'=> "รหัสกลุ่มเรียน", 
			 'years' => "ปีที่ปริ้นบัตร", 
			 'major_id'=> "สาขาวิชา", 
			 'major_name' =>"ชื่อสาขางาน",
			  'minor_name' => "ชื่อสาขาวิชา", 
			  'BloodGroup' => "หมู่โลหิต",
				'school' => "วิทยาลัย",
				'adress' => "ที่อยู่",
				'adress1' => "ตำบล,อำเภอ,จังหวัด",
				'idschool' => "รหัสวิทยาลัย",
			
	);
	foreach($field as $key => $value){
?>
 <div class="form-group">
    <label for="inputEmail3" class="col-sm-2 control-label"><?php echo $value;?></label>
    <div class="col-sm-10">
    <?php 
		if($key == "major_did"){
			echo major();
		}
		else if($key == "perfix_id"){
			echo perfix();	
		}else{
		?>
        
      <input type="text" class="form-control" name="<?php echo $key;?>" >
      <?php  }?>
    </div>
  </div>
<?php
	}
?>
  
  <div class="form-group">
    <div class="col-sm-offset-2 col-sm-10">
      <button type="submit" class="btn btn-default">บันทึก</button>
    </div>
  </div>
</form>