prepare("select * from markets where NAMES =:a ") ; $gtc->bindparam(":a",$mk) ; $gtc->execute() ; $row = $gtc->fetch(pdo::FETCH_ASSOC) ; $aco = $row['codename'] ; //stall details //set the section $marketn = $_SESSION['marketname'] ; $mtown = $_SESSION['markettown'] ; $mlga = $_SESSION['mlga']; $msec = $_SESSION['marketsection'] ; $mzone = $_SESSION['mzone']; $mline = $_SESSION['lineno'] ; $mstall = $_SESSION['mstall'] ; $stype = $_SESSION['stype']; $certno = $_SESSION['certno']; $certdate = $_SESSION['certdate']; $basis = $_SESSION['basis']; $eno = $aco.'-'.$_SESSION['enno'] ; $ansi = $_SESSION['ansid'] ; $fmno = $_SESSION['fmno'] ; $stat = $_SESSION['stat']; $pao = $_SESSION['pao']; $pan = $_SESSION['pan']; $pad = $_SESSION['pad']; $pao2 = $_SESSION['pao2']; $pan2 = $_SESSION['pan2']; $pad2 = $_SESSION['pad2']; $pao3 = $_SESSION['pao3']; $pan3 = $_SESSION['pan3']; $pad3 = $_SESSION['pad3']; // // biodata $fullname = $_SESSION['fname'] ; $emails = $_SESSION['emails'] ; $aphone = $_SESSION['aphone'] ; $astate = $_SESSION['statevalue'] ;//$_SESSION['states'] ; $acity = $_SESSION['city'] ; $nation = $_SESSION['nation']; $creg = $_SESSION['creg'] ; $mid = $_SESSION['mid'] ; $idno = $_SESSION['idno'] ; $aoffice = $_SESSION['office']; // //next of kin //set the section $kfullname = $_SESSION['kname'] ; $relation = $_SESSION['relation'] ; $kaphone = $_SESSION['kphone'] ; //check if the En No has been there before $geteno = $DBcon->prepare("select * from stall_details where en_no =:ab") ; $geteno->bindparam(":ab",$eno) ; $geteno->execute() ; if($geteno->rowcount() > 0) { $message = "SORRY THERE IS A RECORD WITH THIS EN NO IN THE DATABASE, CHECK YOUR RECORD AND TRY AGAIN" ; } else { if($client->stalldetails( $fmno,$client_id, $eno,$marketn,$mtown,$mlga,$msec,$mzone,$mline,$mstall,$stype,$certno,$certdate,$basis,$pao,$pan,$pad, $pao2,$pan2,$pad2,$pao3,$pan3,$pad3,$ansi,$admin)) { if($client->biodata($client_id,$fullname,$creg,$mid,$idno,$nation,$astate,$acity,$aphone,$emails,$aoffice,$admin)) { if($client->nextkin($client_id,$kfullname,$relation,$kaphone,$admin)) { $acts = $admin ."--Registered a Client with Reg No/Unique No--".$client_id ; if($client->monitor($acts)) { $message = "SUCCESS" ; //header("location: upc.php?pwd=$pwd") ; } } } } } //echo $message ; ?>