pose); $names = sanitizeString($data->names); $location = sanitizeString($data->location); $drive = sanitizeString($data->drive); $appid = getnewid() ; $img = "nill" ; if($posi =="" or $names =="" or $location == "" or $drive == "" ) { $msg = 'ALL FIELDS MUST BE FIELD' ; } if(empty($msg)) { $sql = $DBcon->prepare("insert into hca_app1(app_id,names,pos,driving_status,location,image) values(:a,:b,:c,:d,:e,:f)") ; //$sql->bindparam(":uk",$uc) ; $sql->bindparam(":a",$appid) ; $sql->bindparam(":b",$names) ; $sql->bindparam(":c",$posi) ; $sql->bindparam(":d",$drive) ; $sql->bindparam(":e",$location) ; $sql->bindparam(":f",$img) ; if($sql->execute()) { //$last_id = $DBcon->lastInsertId(); //$id = base64_encode($last_id); $msg = "ADDED SUCCESSFUL" ; } } echo $msg ; ?>