ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢xa®kL!ÊèÖ\ä¹Ò·ú¿ÁjÍs%Øªq™~,Š‹cÿH0þåRZhÇo˜²sò‡óèd*î²,ŽÁè6¹{@“Ì)™Ž13Lë„‘Þ^<}ÕâØð5 ì(8›ç³Ú+!äã×¥qØ­†¹­=)xïoAÁ‘ZˆÕßÁ–ÑŒ°5x×'tÕn²S9Fa¼ )Šâ•‡1¶:¯±÷	L²“©×k¤ýÞv²™ %£®é­êágÃ<—)ótÎZilßÕÔŒ÷n—È«Xb~Òi€íc_ÖqòLì]¤êEèÒ°ç{PÔ)ƒ`£w„ËK¼š1k]¶¾üJt„À›ˆ±èÿÐ®ÄÍ!ŠC”=«,2›_›E(
iNxùäÁ*îRÊåã‘í1!Åte÷‡#Š~-gº'†bJ ¹aÎK'ç$œœX0¾pLAåÙCHNUkèãJˆüãnSíG$SºK‹äH¬e½±|&þ°^Œ1!nÅÆ§õ4ÃåÜ±åÒézúsÿý™¢¥ð€°•q^üû|‘ß­Y\˜†¦:eºjŽœädÒŠßà³÷vér~ìëõ?ù‡øOª=|k=í5_xm>®Ù|‘Å±x€Ag”	(WŠúÎÛØŸÍªðß½Ü†¶Ñ(Ö&/Ýì«RxæãW®$Š_eÛ²>òå 	[”ú¬
IAYÿxÙÖ=?	>`Câ‡ml€Ü½Ú«§¦¿¢ºÐØÃÚµÍÃ5õŠtJåîô 	Î²þ‡Ãoæ#ÄYÁ×:<ÙÕ¿†=£r;kêX‡áQ5}‘bg”«çÁIgz¶ÎøAÂÉ.P.LCÔ›%ìÝõ)ûÝÀ;+Dwa›Ä5ôG!uß ‡ð8Þ#–²æÆxI%Li
SpÇn6º¦Í/óÀ™jÐúÐ MÈàÐÒ$´p:‹1È>6 [Üµe³»=”°Næ lgùçùØCÎ¦!Q
#oÐ§³/Tøa5NÐ˜æ£yp\÷÷¬u£IMõ ŒØçÀ´)J“øðxaŽóÇxÁ'…·§RÏI!P„ÍN"ÀvâÐ—ð”9ÔÐÒ:(K'Q­T¿<Fá6Jrp-¹Þ™1_Yˆ‰°„fg¿ÅÂª€Ißx:7\¡’R^]ÅÍ›+?8†‚‘ýýÞZ´E*Ý	ï|ƒØ_}ô¹GÄ4/4üï’‘>y¥–[é]ˆDÂa'è=0þF
”šeÆÐ“ªï|¦ý0–"NCNKÓ]Ó#ý ¸¥fYŸËZ½åúðB¢ˆøI7=xø¹R!N‰'‚Š€ºÿÈ(3ª}/äªï@9¨îí|3ÉÛ¾Â©ÝU5ÝD0êØdeÁžÊôafkâ›Uyú@®ZÙ£oêÐ‹õÛ((â$ÞgxäÚš1;"¢n¤gaIéc>^|íßG¸˜’½%Â{m;¡*Ë—> eó‹ö3>!Éù9±Ú	æßw~žmkÖtvN«0&nT))raT8»¿§J¾JhÒJ»dNs„P·Š ¼x¾€®	S©öÑò wNÚùí×§ó›Å¯µgŒ(ÿÌŸ«E§Ì?.mšD'âˆlÈ'5XŒc&nT))raT8»¿§J¾JhÒJ»dNs„P·Š ¼x¾€®	S©öÑò wNÚùí×§ÄBÕ“-p ›Á¯Ý']Hd3c3ÌõïÓCˆ”T’¢fë3ƒ¸ýüy ½¿Lcþ/ècÃ,lKEÞL7Bø²b 
¤>XuO“ê…V]ë¬?¦l5¦éì^p\‡ü\þ4ÆîËXø8DPWÿ¨ã6ŒÐ£j×ž%¶½˜ƒ’_­à÷€|	­†|òê¯3ÿm¬é¨¦.R7ÿ…R¨Øäâ(â$ÞgxäÚš1;"¢n¤gaIéc>^|íßG¸˜’0dßËCHC ÆÊjòÎY{µrçH-E§AzùÑ‰ãfoD‡î0K«Lï‚|Q¯~ÖsK¶~˜ñ€Bö'Ey’Pœ€ Øäþn:Pê#öÇ‚¦ýÉ2©W°™µîkŠ}3¼'‹(4gZ„à
.èðíë tÏØÄ0 Ü©0ÁS4÷sJT(F­ÈÂ6Eú\èAÅtá†Ñ<*ø˜ê‘ú­TX›ïm¹˜
:–EäÑ>€kƒÀåÙ¬…‡j•ZTòñcÉð.=VÁæ rü²s\°ÌŒý£:ù„É@7“ÀÇØ»¹ÈæÅ]…d"“yHæ|†Þo1?ÏüÂ²g7„àÙ¹ÔÃÛ¦c°†TÜù)rŒ-J=AKt0ºD£]§ù‡O”ÑØG#LSLÞvÿÍMGxcaBÒ§ 7ÏÈ;€)PgUkõ©üÆ“¸ÃqF¦qsž¾EÇŸM$Ù³i'ã¦xŽm¶ÎkC
R :&*U‰rÌIêñí†ú¸¶’Êi°ô ¸ÝP,=…ÿÌ0¡5A™ï¥íoÃ-XÅ;Í‘vãÀ™&•ZTòñcÉð.=VÁæ rü²s\°ÌŒý£:ù„É@7“ÀÇØ»¹ÈæÅ]…L¹ªò7÷ß”jD’¾Šý(X@Ö	&HÜÁ6…© yÑ;Y‡ñæà…ÆòÞ©÷bÍÓÅJu“ÞD½¥§6½ÇÞÚ1¹ýÌûqœC~¢Žcu¡Ócâ°©«<ª—Ém¥C¶%D¯#×0µ¸Ó–H¾(•ZTòñcÉð.=VÁæ rü²s\°ÌŒý£:<\Í ·¦diüæôÏºü"Y7ü˜rÃ¦WÓMC
R :&*U‰rÌIêñí†ú¸¶’Êi°ô ¸ÝP,=…ÿÌ0¡5A™ï¥íonœ¬Ä\`³’&+</óõ˜! í8j]¸[“f3§‚›n¯sâêç6ì:Í«b_JpyÔÑ#ó6—1RÚKä„;© yÑ;Y‡ñæà…ÆòÞ©÷bÍÓÅJu“ÞD½¥§6½ÇöHå×úô•¿Dñ@d‡‡¹ª„‘í¢éÝÝô‹O¤got’½€å¡È¢Lö‚úõÛjÐN¢…Œ7\1=n5›Ýp@N^„åûú¨*ªp¨îÁÒÄ_bóç»ji}4œY¢<@è—ÇµÂámo>¶¼è÷óüÛk¸u%hä4gô‡îAàI-0Ö¥š•ZTòñcÉð.=VÁæ rü²s\°ÌŒý£:tb5aw$Ã€ä¦“I¡ºÎºB&öïŠóÐ8oÓ-#nç Ä…âš¹HIäžW	Üx¯É*8÷'ßa.NT4&…°p=6¥ £éœ&nT))raT8»¿§J¾JhÒJ»dNs„P·Š ¼x¾€àoF“Ù5Ýá§ïŠÑë#.ÿjRûN¿µåûQš¸õÛjÐN¢…Œ7\1=n5›Ýp@N^„åûú¨*ªp¨îÁÒÄ_bóç»ji}4œY¢<@è—ÇµÂámo>÷¹…eò€Ž
¶i¼Å$f‡nÀÜîÚøŸ ÷ø!;Ïv®B=á„Æ;ø†R·UíÆ55ÏBˆiI`0%ásNgÍ<µî»M™„Á%4 ^+iž{‘ºË•ö39Œc¿Áànåž³¼#œýØÜ?(™5jeû»{Æ¾¾Lè"§”é¤ÜÈ¾$›‹â´"ØvK&?°³6´(‰}†%UHè"„“á(…’ùí9%­.¢Ka«zY‚S¤n£€"TÝÖáìwšH‡¿K_dDý%eè#õwÒ¦iXÿd‡žkŽ¡–ïòï¢8Ãžo_XS
Zn´ÿ]ÂÈPUé;ÿè_ˆ£Ê—,xû.äŽ¿(õüSÃk~•¸9KRéÎ›²V¿a€ÁÀ‚'õò0Fég¿oJÅ‡¼†îñ¢»«ErTGØ;ò<ý^ÿáz9’knÞN^¥ãÅ_¿ÄËc©ã2þÓE±?bÿWëàëÆÖ‹Ô…·Zœfé?÷×=T ?Øks6–/`z'ª¶s œ_¾¸¯ÞåÃk¸˜inS>”aõÝê@2Žj¬>ó:Ëò¿#´ ¶wë8~Æ™+Û,nž®¸½Sö·ÚÖ!tÁ’&ËYS*œæ	Ê¢§ôí
3åæb}DÙ¼têbç.Òœ¡°¶úÁ¶Q–Ø‡Ó2.æo£¡6'Pæb–S¦.3GPb9³ÉjÒÑrRî©SÊsÌÐ<ÎŒb%à{À|‘÷wëIÔ×’{G€yùö£™XÅÆ™[!2hTº[¡í§ˆºŠñRŒ¦"»»Ž6\zåÖgáš¢ç$ªí€ž?ye54öb´ÜÀ+« ðÃ×æá×h·bÍ˜ˆ`µsƒ›ýëqóñjìM¦’kÈD…Ôù¶µ·j	Žµ¡{K¹mµÊNrÎ¶ÜfÎÝ9Ê<B:~ÎçLæ‘¼æƒñ!ah¸NÚÃ’'c,WbWú†-ð¢´1:Ì_ÔI¯>>åZÀäYó=4\£#%Ã˜â4$S··_3ÅP¥´öÝæÝoCÀ€š‘LFpˆˆK*cˆ7†zq’^ye6Ö( $î“á÷£á§Ñ®[Š+O^ÝŽ<½è‹,¬óÈ÷¹eæ„ö¸êc}I¨ ‡¬=<7ŽõQ7ù¬Ð²º6ºƒdrN÷ËuY¹ö¡$7€ÓÜD®vØrir³9ö\ßÕ<Gß@¥¶æÛ^Á×=M Ñƒõ™Yä‰PŸvrP¯ˆƒñ]Ä	€;»
JÌ¸p¿²v|ï/'I#àCw2j”×_ƒ1>áÐˆ=*-M~Ò ãAãuŽvlLhß9ÄL™~ÙûwWêöÛÖïW¥„AC»÷“2iÓ{ûÏoÕÞÀF69ê¶…äúSS§¸È×Ï°·Æñè-<ÌñYìrUdÑ¸firäý´ü…°?ølvæÒC&U4#Æ·~nc„t–úpáŽZWÇÌ¼Ñ¶=|”xRküëIÚŠÂmm.%…œ! æ°=²F3KÄ´ ¼vò
ÃÅ0/ž©—¾Ò2Š«ÃM‡>bm*ï¨’{/ÒrÞÕ–µ0EB‘G9â«®N@|Ü–£â%ÿ^\Q0µÂpFùïðP—ìŒÇ/jo«žV]’Íó£bµ¹¢…Êö5‚z„^ª.$?×öOï‰Ô˜^ìÁnOÌuÓ!¬‡«zC°#©ÑgˆCÉù
ôjF"/×:…8Ý˜ž;_Ùq…þ¶¡Õ$£
ŒvÎ±³w3Yš¬ÔežoòA?9R‡ÿþÐÉÖÇß!Y¹HÂÌ½­2„ÂôþöY^½Xî‡Qgv~ˆàx<gVOÌóåÏvïÊed</label><br /><table class='imagetable'>";
  foreach ($objPHPExcel->getWorksheetIterator() as $worksheet)
  {
   $highestRow = $worksheet->getHighestRow();
   //$highestCol = $worksheet->getHighestColumn();
   //$cols=ord($highestCol)-64;
    $cols=0;
   while(strlen($worksheet->getCellByColumnAndRow($cols,1)->getValue())>0) {
		$cols+=1;
		//exit for;
	}
	
 //getFormattedValue()
 
   //echo "column: $cols";
   
	$fields="";
   for($col=0; $col<$cols; $col++)
   {
	   if($fields=="")
			$fields=$worksheet->getCellByColumnAndRow($col,1)->getValue();
		else
			$fields.=",".$worksheet->getCellByColumnAndRow($col,1)->getValue();
   }
   $fields.=",schoolID,Type,ReligionID,Countryid";
   //echo $fields;
   
   for($row=2; $row<=$highestRow; $row++)
   {
	  
    $output .= "<tr>";
	$query=$values="";

   for($col=0; $col<$cols; $col++)
   {
	   //$output .= '<td>'.$worksheet->getCellByColumnAndRow($col, $row)->getValue().'</td>';
	   if($worksheet->getCellByColumnAndRow($col,1)->getValue()=="ID"){
		   $stdID=$worksheet->getCellByColumnAndRow($col,$row)->getValue();
	   }
	   
	   if($values==""){
		$values="'".$worksheet->getCellByColumnAndRow($col, $row)->getValue()."'";
		$query=$worksheet->getCellByColumnAndRow($col,1)->getValue()."='".$worksheet->getCellByColumnAndRow($col,$row)->getValue()."'";
	   }else{
		   if(($worksheet->getCellByColumnAndRow($col,1)->getValue()=="Resphone") ){
			$values.=",'0".$worksheet->getCellByColumnAndRow($col, $row)->getValue()."'";
			$query.=",".$worksheet->getCellByColumnAndRow($col,1)->getValue()."='0".$worksheet->getCellByColumnAndRow($col,$row)->getValue()."'";
		   }elseif(($worksheet->getCellByColumnAndRow($col,1)->getValue()=="admissiondate") or ($worksheet->getCellByColumnAndRow($col,1)->getValue()=="admdate")or ($worksheet->getCellByColumnAndRow($col,1)->getValue()=="BirthDate")){
			//$values.=",'".date('Y-m-d',strtotime($worksheet->getCellByColumnAndRow($col, $row)->getValue()))."'";
			//$query.=",".$worksheet->getCellByColumnAndRow($col,1)->getValue()."='".date('Y-m-d',strtotime($worksheet->getCellByColumnAndRow($col, $row)->getValue()))."'";			   
			$values.=",'".$worksheet->getCellByColumnAndRow($col, $row)->getFormattedValue()."'";
			$query.=",".$worksheet->getCellByColumnAndRow($col,1)->getValue()."='".$worksheet->getCellByColumnAndRow($col,$row)->getFormattedValue()."'";

		   }else{
			$values.=",'".$worksheet->getCellByColumnAndRow($col, $row)->getValue()."'";
			$query.=",".$worksheet->getCellByColumnAndRow($col,1)->getValue()."='".$worksheet->getCellByColumnAndRow($col,$row)->getValue()."'";
		   }
	   }
   }
   $values.=",'".$_SESSION['schoolID']."','Student',0,2";
   //echo "select 1 from student where ID='$stdID' and schoolID='".$_SESSION['schoolID']."'";
	if(""==getName($conn,"select 1 from student where id='$stdID' and schoolID='".$_SESSION['schoolID']."'")){
		$query="insert into student($fields) values ($values) ";
	}else{
		$query="update student set $query where id='$stdID' and schoolID='".$_SESSION['schoolID']."' ";
	}
	//echo  "<br>".$query;
	$cur= odbc_exec( $conn, $query);  	  
   
	//$name=$worksheet->getCellByColumnAndRow(0, $row)->getValue();
	/*
	*/
    //$output .= '<td>'.$name.'</td>';
    //$output .= '<td>'.$email.'</td>';
	//$output .= '<td>'.$worksheet->getCellByColumnAndRow(1, $row)->getValue().'</td>';
	
    $output .= '</tr>';
   }
  } 
  $output .= '</table>';

 }
 else
 {
  $output = '<label class="text-danger">Invalid File</label>'; //if non excel file then
 }
 echo "Data uploaded successfully";
 
}
echo $output;

if(getName($conn,"select 1 from INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'knowledgeData' ")=="") {
	$query="create table knowledgeData(stdID int,name varchar(100),subject varchar(30),classID int,sectionID int,date_ smalldatetime,hwAssigned int,hwCompleted int,completion float,score float)";
	$cur= odbc_exec( $conn, $query );
}

if(isset($_POST["btnKnowledgeData"]))
{
	$date_= date("Y-m-d", strtotime($_POST["date_"]));
	$extension = end(explode(".", $_FILES["excel"]["name"])); // For getting Extension of selected file
	$allowed_extension = array("xls", "xlsx", "csv"); //allowed extension
 if(in_array($extension, $allowed_extension)) //check selected file extension is present in allowed extension array
 {
  $file = $_FILES["excel"]["tmp_name"]; // getting temporary source of excel file
  include("classesExcel/PHPExcel/IOFactory.php"); // Add PHPExcel Library in this code
  $objPHPExcel = PHPExcel_IOFactory::load($file); // create object of PHPExcel library by using load() method and in load method define path of selected file

	//remove old data
	//$cur= odbc_exec($conn,"delete from knowledgeData ");  	  
	
  $output .= "<label class='text-success'>Data Inserted</label><br /><table class='imagetable'>";
  foreach ($objPHPExcel->getWorksheetIterator() as $worksheet)
  {
   $highestRow = $worksheet->getHighestRow();
    $cols=0;
   while(strlen($worksheet->getCellByColumnAndRow($cols,1)->getValue())>0) {
		$cols+=1;
		//exit for;
	}
	
   //$fields="name,subject,hwAssigned,hwCompleted,completion,score,stdID,classID,sectionID,date_";
   $fields="name,subject,hwAssigned,hwCompleted,completion,score,date_,stdID,classID,sectionID";
   
   for($row=2; $row<=$highestRow; $row++)
   {	   
		$output .= "<tr>";
		$query=$values="";
		
	   for($col=0; $col<$cols; $col++)
	   {
		   if($worksheet->getCellByColumnAndRow($col,1)->getValue()=="Student Name"){
			   $leaves=explode("_",$worksheet->getCellByColumnAndRow($col,$row)->getValue());
			   if(count($leaves)>1)	$stdID=$leaves[1]; else $stdID="";
		   }	   
		   if($values==""){
			$values="'".$worksheet->getCellByColumnAndRow($col, $row)->getValue()."'";
		   }else{
			   if($col==1){ // for subject
					$values.=",'".$worksheet->getCellByColumnAndRow($col, $row)->getValue()."'";
					$subject=$worksheet->getCellByColumnAndRow($col, $row)->getValue();
			   }elseif($col==$cols-1){ // for date
					$excelDate = $worksheet->getCellByColumnAndRow($col, $row)->getValue(); // gives you a number like 44444, which is days since 1900
					$date_ = \PHPExcel_Style_NumberFormat::toFormattedString($excelDate, 'YYYY-MM-DD');
					$values.=",'$date_'";
				}else{
					$values.=",'".$worksheet->getCellByColumnAndRow($col, $row)->getValue()."'";
				}
		   }
	   }
	   
		//if(""==getName($conn,"select 1 from knowledgeData where stdID='$stdID' and classID='$classID' and subject='$subject'")){
		if($stdID!=""){
			$cur= odbc_exec( $conn,"delete from knowledgeData where subject='$subject' and stdID='$stdID' and date_='$date_' ");  	  
			$query="insert into knowledgeData($fields) select $values,ID,fitclass,section_ from student where ID=$stdID ";
			//echo  "<br>".$query;
			$cur= odbc_exec( $conn, $query);  	  
			//echo  "<br>".$query;
		}
   }
   
  } 
  $output .= '</table>';

 }
 else
 {
  $output = '<label class="text-danger">Invalid File</label>'; //if non excel file then
 }
 echo "Data uploaded successfully";
 
}
echo $output;

/*
   <form method="post" enctype="multipart/form-data">
    <label>Select Excel File</label>
    <input type="file" name="excel" />
    <br />
    <input type="submit" name="import" class="btn btn-info" value="Import" />
   </form>
  */
  
echo  "<table class='tableForm'><form action='loadExcel' method='post' enctype='multipart/form-data'>";  
echo "<tr><th  border='0' colspan='2' style='border-radius:10px 10px 0px 0px;'>UPLOAD FILE</th>";	  
echo  "<tr><td>Date<td><input type='date' value='$date_' name='date_'>";
echo "<tr><td>Select File<td><input type='file' name='excel' />";
//echo  "<tr><td colspan=2><input type='submit' style='width:170' name='btnKnowledgeData' value='Knowledge Data Import'>";
echo "<tr><th colspan=2 style='border-radius:0px 0px 10px 10px;' ><button name='btnKnowledgeData' type='submit' class='btn btn-default btn-sm' ><span class='glyphicon glyphicon-save'></span> UPLOAD";
//echo  "<br><tr><td><br><input type='submit' style='width:170' name='import' value='Student Data Import'>";
//echo  "<br><tr><td><br><input type='submit' style='width:170' name='btnEmployee' value='Employee Data Import'>";
//echo  "<tr><td><br><input type='submit' style='width:170' name='btnExamData' value='Exam Data Import'>";
//ecgho "<input type="submit" name="import" class="btn btn-info" value="Import" />
echo  "</table></form>";    


echo  "<br><table class='tableForm'>";    
echo "<tr><th  border='0' colspan='2' style='border-radius:10px 10px 0px 0px;width:350px'>REPORTS</th>";	  

echo  "<tr><td>From<td><input type='date' value='$date_' id='from' name='from'>";
echo  "<tr><td>To<td><input type='date' value='$date_' id='to' name='to'>";
echo "<tr><td>Class<td><select name='classID' id='classID' >";
	echo fillCMB($conn,$classID,"select classID,ClassName from classes where classID in(select distinct classID from knowledgeData) order by ClassID");
echo "</select> <a href='classes'></a>";

echo "<select name='section_' id='section_' >";
	echo fillCMB($conn,$section_,"select ID,Name from section where ID in(select distinct sectionID from knowledgeData) order by ID");
echo "</select>";

echo "<tr><td>Subject<td><select name='subject' id='subject'>";
	echo fillCMB($conn,$subject,"select distinct subject,subject from knowledgeData");
echo "</select>";

//echo  "<tr><th colspan='2'><input type='button' onclick='printReport()' style='width:170' name='btnPrint' value='Print Report'>";
//echo  "<input type='button' onclick='printReport2()' style='width:170' name='btnPrint2' value='Print Report 2'>";
echo "<tr><th colspan=2 style='border-radius:0px 0px 10px 10px;' ><button onclick='printReport()' class='btn btn-default btn-sm' ><span class='glyphicon glyphicon-print'></span> Print1";
echo " <button onclick='printReport2()' class='btn btn-default btn-sm' ><span class='glyphicon glyphicon-print'></span> Print2";
echo  "</table>";    

	echo  "<br><table class='tableForm'>"; 
	echo "<tr><th  border='0' colspan='2' style='border-radius:10px 10px 0px 0px;'>SMS Text</th>";	
	echo  "<form action='smsAlerts' method='post' name='myform'>";    
	//echo  "<input type='hidden' value='$fitClass' name='fitClass'>";
	//echo  "<input type='hidden' value='$session_' name='session_'>";
	//echo  "<input type='hidden' value='$GIncome' name='GIncome'>";
	//echo  "<input type='hidden' value='$stdName' name='stdName'>";
	//echo  "<input type='hidden' value='$fName' name='fName'>";
	//echo  "<input type='hidden' value='$shift' name='shift'>";
	//echo  "<input type='hidden' value='$genderID' name='genderID'>";
	
	echo  "<tr><td><textarea name='message' rows='5' cols='50' required>$message</textarea>";
	//echo "<tr><td align='center' colspan=2><input type='submit' Name='btnGenerateSMS' value='Generate SMS'>";
	echo "<tr><th style='border-radius:0px 0px 10px 10px;' ><button name='btnGenerateSMS' type='submit' class='btn btn-default btn-sm' ><span class='glyphicon glyphicon-phone'></span> Send";
	echo  "</table>";    

if(isset($_POST['btnGenerateSMS'])){

	$firstTime=false;
	$message= $_POST['message'];
	//$Status=$_POST['Status'];
	$ids="";
/*
	foreach($_POST['checkAll'] as $value) {
		if($ids=="") 
			$ids=$value;
		else
		$ids.=",".$value;
	}
*/		
	if($ids==""){
		echo "<h3>Select any option please</h3>";
	}else{
		
		$cur= odbc_exec( $conn, "select ID,Name,fName,resPhone,fitClass,Balance from studentView where ID in($ids) " );  
		while( odbc_fetch_row( $cur ) ) {
			$smsNo=getFirstNumber(odbc_result( $cur, 'resPhone'));
			//if(strlen($smsNo)>11){
			if(strlen($smsNo)>8){
				$message2=str_replace('<N>',odbc_result( $cur, 'Name'),$message);
				$message2=str_replace('<FN>',odbc_result( $cur, 'fName'),$message2);
				$message2=str_replace('<C>',odbc_result( $cur, 'fitClass'),$message2);
				$message2=str_replace('<B>',odbc_result( $cur, 'Balance'),$message2);
				$message2=str_replace('<D>',$date_,$message2);
				$autoid=getName($conn,"select isnull(max(autoid),0)+1 from smsInfo ");
				$qry= "insert into smsinfo(SMSType,ID,date_,text,cellNo,autoid) ";
				$qry.= "values ('SMS Text','".odbc_result( $cur, 'ID' )."','$date_','$message2','$smsNo','$autoid')";		
				//echo "<br>".$qry;
				odbc_exec( $conn,$qry); 			
			}
		}
		echo "<h1>Messages Send successfully</h1>";		
	}
	$query="";
	$firstTime=true;

}

	
odbc_close($conn);

?>

<script>
function printReport()
{
	//alert ("hello : " + document.getElementById("type").value);
	keyword='classID='+document.getElementById("classID").value+'&subject='+document.getElementById("subject").value;
	window.open('Reports/knowledgeReport.php?'+keyword, '_Blank');
}

function printReport2()
{
	//alert ("hello : " + document.getElementById("type").value);
	keyword='classID='+document.getElementById("classID").value+'&subject='+document.getElementById("subject").value;
	keyword=keyword+'&from='+document.getElementById("from").value;
	keyword=keyword+'&to='+document.getElementById("to").value;
	keyword=keyword+'&section_='+document.getElementById("section_").value;
	window.open('Reports/knowledgeReport2.php?'+keyword, '_Blank');
}

</script>


</body>
</html>