<?php
$dt=confirm($p4);
echo json_encode($dt);

function confirm($js){
  global $ar,$db;
  $dt=array();
  //$dt['js']=$js;
  if($js!='') {
    $sql9="SELECT id,nama_member from `member` where confirm_token='".$js."' and confirm_expire>".time()."";
    $dt['sql'][0]=$sql9;
    
    $res9=mysqli_query($db,$sql9);
    if(mysqli_num_rows($res9)==0) {
      $dt['error']=true;
      $dt['message']="Maaf link konfirmasi tidak terdaftar/kadaluarsa";    
    } else {
      if(mysqli_num_rows($res9)==1) {
        $sql8="UPDATE `member` set `confirm_email`=2 where `confirm_token`='".$js."'";
        //$dt['sql'][1]=$sql8;
        $res8=mysqli_query($db,$sql8);
        $dt['success']=true;
        //$dt['user']['data']=$r8;
      }
    }
  } else {
    $dt['error']=true;
    $dt['message']="Maaf link konfirmasi salah";        
  }
  return $dt;
  $db->close();
}
?>