organiser); $begindate = sanitizeString($data->begindate); $enddate = sanitizeString($data->enddate); $course = sanitizeString($data->course); $attain = sanitizeString($data->attain); //$img = "nill" ; if($organiser == "" or $begindate == "" or $enddate == "" or $course == "" or $attain == "") { $msg = 'ALL FILED MUST BE FILL' ; } //check capcha code if(empty($msg)) { $sql = $DBcon->prepare("insert into training(app_id,establishment,begin_date,end_date,course,attainment,unikid) values(:a,:b,:c,:d,:e,:f,:g)") ; //$sql->bindparam(":uk",$uc) ; $sql->bindparam(":a",$appid) ; $sql->bindparam(":b",$organiser) ; $sql->bindparam(":c",$begindate) ; $sql->bindparam(":d",$enddate) ; $sql->bindparam(":e",$course) ; $sql->bindparam(":f",$attain) ; $sql->bindparam(":g",$unik) ; if($sql->execute()) { $sel = $DBcon->prepare("select * from training where unikid = '$unik'") ; $sel->execute() ; ?> fetch(pdo::FETCH_ASSOC)) { $ct++ ; ?>
SN ORGANISERS FROM DATE TO DATE COURSE TAKEN ATTAINMENT