prepare("select * from allotee_biodata where regno =:on") ; $querry->bindparam(":on",$reg) ; $querry->execute() ; $rw = $querry->fetch(PDO::FETCH_ASSOC); $custodian = $rw['custodian'] ; $creg = $rw['company_regno'] ; $idmeans = $rw['identification_means'] ; $idno = $rw['id_no'] ; $nationality = $rw['nationality'] ; $state = $rw['state'] ; $lga= $rw['lga'] ; $pone = $rw['allote_phone'] ; $email = $rw['allote_email'] ; $office= $rw['allote_office'] ; $uporder = new USER(); //$neworder->neworder( //update allotee_biodata set custodian =:b,company_regno =:c, identification_means =:d, id_no =:e, nationality =:f, state =:g, lga =:h, allote_phone =:i, allote_email =:j, allote_office =:k where regno =:a if(isset($_POST['submit'])) { // //set the section $cust = trim($_POST['bname']); $cregup = trim($_POST['cregno']); $idemeansup = trim($_POST['ident']); $idnoup = trim($_POST['idno']); $nationup = trim($_POST['nation']); $stateup = trim($_POST['astate']); $lgaup = trim($_POST['lga']); $phoneup = trim($_POST['aphone']); $emailup = trim($_POST['aemail']); $officeup = trim($_POST['aoffice']); //$stat = $_SESSION['stat']; //$uporder->updatestall($fmno, $reg,$eno,$marketn, $mtown,$mlga,$msec,$mzone,$mline,$mstall,$stype,$certno, $certdate,$basis,$ansi,$admin) ; if($uporder->updatebio($reg,$cust,$cregup,$idemeansup,$idnoup,$nationup,$stateup,$lgaup,$phoneup,$emailup,$officeup)) { ?> Admin

Dashboard

Editing Allotee Biodata