firstname);
$sname = sanitizeString($data->surname);
$add = sanitizeString($data->address);
$pcode = sanitizeString($data->postalcode);
$ph = sanitizeString($data->phone);
$pos = sanitizeString($data->position);
$rela = sanitizeString($data->relation);
$ct = sanitizeString($data->contact);
$names = $fname ."".$sname ;
//$img = "nill" ;
/*
firstname: document.querySelector('#nfname').value,
surname: document.querySelector('#nsname').value,
address: document.querySelector('#naddress').value,
postalcode: document.querySelector('#npcode').value,
phone: document.querySelector('#nphone').value,
position: document.querySelector('#npos').value,
relation: document.querySelector('#nrelation').value,
contact: document.querySelector('#ncontact').value,
*/
if($fname == "" or $sname == "" or $add == "" or $ph == "" or $rela == "" or $ct == "" or $pos == "" or $pcode == "")
{
$msg = 'ALL FILED MUST BE FILL' ;
}
//check capcha code
if(empty($msg))
{
$sql = $DBcon->prepare("insert into reference(app_id,names,address,post_code,phones,position,relationship,contact_permit,unikid) values(:a,:b,:c,:d,:e,:f,:g,:h,:i)") ;
//$sql->bindparam(":uk",$uc) ;
$sql->bindparam(":a",$appid) ;
$sql->bindparam(":b",$names) ;
$sql->bindparam(":c",$add) ;
$sql->bindparam(":d",$pcode) ;
$sql->bindparam(":e",$ph) ;
$sql->bindparam(":f",$pos) ;
$sql->bindparam(":g",$rela) ;
$sql->bindparam(":h",$ct) ;
$sql->bindparam(":i",$unik) ;
if($sql->execute())
{
$sel = $DBcon->prepare("select * from reference where unikid= '$unik'") ;
$sel->execute() ;
?>
| SN |
NAMES |
ADDRESS |
PHONE |
POSITION |
RELATIONSHIP |
fetch(pdo::FETCH_ASSOC))
{
$ct++ ;
?>
|
|
|
|
|
|