0)
$val="ST".str_pad($id,8, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='teacher')
{
if($id>0)
$val="TR".str_pad($id,6, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='parent')
{
if($id>0)
$val="PT".str_pad($line['id'],6, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='course')
{
if($id>0)
$val="CE".str_pad($line['id'],4, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='level')
{
if($id>0)
$val="GR".str_pad($line['id'],4, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='batch')
{
if($id>0)
$val="BH".str_pad($line['id'],6, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='payment')
{
if($id>0)
$val="PM".str_pad($line['id'],3, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='tutorial')
{
if($id>0)
$val="TU".str_pad($line['id'],4, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='assignment')
{
if($id>0)
$val="AS".str_pad($line['id'],4, "0", STR_PAD_LEFT);
return $val;
}
elseif($type=='exam')
{
if($id>0)
$val="EX".str_pad($line['id'],4, "0", STR_PAD_LEFT);
return $val;
}
}
// to list course with level
function func_courselist($selectedcourse)
{
$res=mysql_query("select tbl_course.*,level from tbl_course inner join tbl_level on (tbl_course.levelid=tbl_level.id) where tbl_course.status='1'");
if($rows=mysql_num_rows($res))
{
while($row=mysql_fetch_assoc($res))
{
if($row['id']==$selectedcourse)
$chk='selected';
else
$chk='';
?>
An Internal Error has Occured. Please report following error to the webmaster.
".$sql."
".mysql_error()."'");
return $result;
}
function date_ddmmyyyy($date)
{
if($date!='0000-00-00' && $date!=''){
list($y,$m,$d)=explode("-",$date);
return date("d/m/Y",mktime(0,0,0,$m,$d,$y));
}
else
return false;
}
function date_mmddyyyy($date)
{
if($date!='0000-00-00' && $date!='')
{
//list($y,$m,$d)=explode("-",$date);
//return date("m-d-Y",mktime(0,0,0,$m,$d,$y));
list($y,$m,$d)=explode("-",$date);
return date("d-M-Y",mktime(0,0,0,$m,$d,$y));
}
else
return false;
}
function date_yyyymmdd($date)
{
list($d,$m,$y)=explode("/",$date);
return date("Y-m-d",mktime(0,0,0,$m,$d,$y));
}
function getSingleResult($sql)
{
$response = "";
$result = mysql_query($sql) or die("An Internal Error has Occured. Please report following error to the webmaster.
".$sql."
".mysql_error()."'");
if ($line = mysql_fetch_array($result)) {
$response = $line['0'];
}
return $response;
}
$SITE_TITLE="Welcome to Class Room";
$ADMIN_HTML_TITLE="Class Room - Secure Administration Suite";
function executeUpdate($sql)
{
mysql_query($sql) or die("An Internal Error has Occured. Please report following error to the webmaster.
".$sql."
".mysql_error()."'");
}
function state_combo($combo_name = 'state', $sel_value = '', $extra = '', $choose_one = '')
{
global $str_country_combo;
$choose_one='-------- Select --------';
$sql = "select state, state from state order by state";
$str_state_combo = make_combo($sql, $combo_name, $sel_value, $extra, $choose_one);
return $str_state_combo;
}
function adjustAfterDecimal($param)
{
if(strpos($param,'.')== "")
{
$final_value=$param.".00";
return $final_value;
}
$after_decimal = substr($param , strpos($param,'.')+1, strlen($param) );
$before_decimal = substr($param,0 , strpos($param,'.'));
if(strlen($after_decimal)<2)
{
if(strlen($after_decimal)==1)
{
$final_value=$param."0";
}
if(strlen($after_decimal)==0)
{
$final_value.="$param.00";
}
}
else
{
$trim_value = substr($after_decimal,0,2);
$final_value.=$before_decimal.".".$trim_value;
}
return $final_value;
}
function decimal ($p )
{
$i=strpos($p,".");
if($i)
{
if(strlen(substr($p,$i+1))==1)
$p.="0";
}
else
{
$p.=".00";
}
return $p;
}
function mysql_time($hour, $minute, $ampm)
{
if($ampm=='PM'){ $hour += 12;}
if($ampm=='AM' && $hour=='12'){ $hour = '00';}
$mysql_time =$hour.':'.$minute.':00';
return $mysql_time;
}
function getCurrentPath()
{
global $_SERVER;
return "http://" . $_SERVER['HTTP_HOST'] . getFolder($_SERVER['PHP_SELF']);
}
function price_format($price,$currency='')
{
global $sess_currency;
if($sess_currency==''){
$sess_currency='USD';
}
if($currency==''){
$currency=$sess_currency;
}
$price = number_format($price,2);
return '$'.$price;
}
function two_zero($price)
{
if($price!=''){
return number_format($price, 2,'.','');
}
if($price==0){
return number_format($price, 2,'.','');
}
}
function makeCheckbox($manutmp, $checkname, $checksel='', $cols, $missit, $style='', $tableattr='')
{
if($style!=""){
$style="class='".$style."'";
}
$colwidth=100/$cols;
$colwidth=round($colwidth,2);
$j=1;
foreach($manutmp as $key => $value){
$tochecked="";
if(is_array($checksel) && in_array( $key,$checksel)) {
$tochecked="checked";
}
if($key!=$missit){
if($value!=""){
if($j==1){
$checkstr.="";
return $checkstr;
}
function country_combo($combo_name = 'country', $sel_value = '', $extra = '', $choose_one = '')
{
global $str_country_combo;
//$choose_one='-------- Select --------';
$con_arr[]='-------- Select --------';
$con_arr['US']='United States';
$con_arr['UK']='United Kingdom';
$con_arr['NL']='The Netherlands';
$con_arr[]='----------------';
$sql = "select country from country order by country asc";
$result=executeQuery($sql);
while($line=mysql_fetch_array($result)){
$con_arr[$line['country']]=$line['country'];
}
$str_country_combo=array_combo( $con_arr, $sel_value, $combo_name, $choose_one);
//$str_country_combo = make_combo($sql, $combo_name, $sel_value, $extra, $choose_one);
return $str_country_combo;
}
function make_combo($sql, $combo_name, $sel_value = '', $extra = '', $choose_one = '')
{
$result = executeQuery($sql);
if (mysql_num_rows($result) > 0) {
$arrAlbum = Array();
$strAlbumCombo = "";
}
return $strAlbumCombo;
}
function array_combo( $arr, $sel_value='', $name='', $choose_one='')
{
$combo="