1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / pattklvg / public_html / registration / php /
Filename : new.php
back
<?php
ob_start();
session_start();
include "../../admin/dist/resources/config.php";
$fn = $_POST['fn'];
$ln = $_POST['sankh'];
$gd = $_POST['gd'];
$email = $_POST['email'];
$ps = "Member";
$ins = $_POST['ins'];
$sankh = $_POST['sankh'];
$pankh = $_POST['pankh'];

$fatherhusband = $_POST['fatherhusband'];
$dob = $_POST['dob'];
$phone = $_POST['phone'];
$whatsapp = $_POST['whatsapp'];
$facebook = $_POST['facebook'];
$marital = $_POST['marital'];
$business = $_POST['business'];
$businessname = $_POST['businessname'];
$business_details = $_POST['business_details'];
// $town = $_POST['town'];
$others = $_POST['others'];
// $country = $_POST['country'];
$surname = $_POST['surname'];
$postal_physical_address = $_POST['postal_physical_address'];

$native = $_POST['native'];

$rec_mail = $_POST['rec_mail'];
$rec_mail_all = $_POST['rec_mail_all'];

$personphoto = $_FILES['personphoto']['name'];
$businessphoto = $_FILES['businessphoto']['name'];

$st="Inactive";


$sql = "SELECT town,country FROM institute WHERE institute.inst_id='$ins' ";
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) {
        // output data of each row
        while($rowcomm = $result->fetch_assoc()) {
            $town = $rowcomm["town"];
            $country = $rowcomm["country"];
        }
    }



date_default_timezone_set("Africa/Nairobi");



if($personphoto !=''){
list($txt, $ext) = explode(".", $personphoto);
	$length=8;
	$ran = substr(str_shuffle("abcdefghijklmnopqrstuvwxyz"), 0, $length);
	$ph = $ran.".".$ext;
	$tmp = $_FILES['personphoto']['tmp_name'];
	$imn = "http://localhost/files/".$ran.".".$ext;
}


if($businessphoto !=''){
list($txt, $ext) = explode(".", $businessphoto);
	$length=8;
	$ran = substr(str_shuffle("abcdefghijklmnopqrstuvwxyz"), 0, $length);
	$ph2 = $ran.".".$ext;
	$tmp2 = $_FILES['businessphoto']['tmp_name'];
	$imn2 = "http://localhost/files/".$ran.".".$ext;
}


$now = date("Y-m-d h:i:sa");

// if($fn != null && $ln != null && $gd != null && $email != null && $ps != null && $ins != null && $sankh != null){

        if($personphoto !=''){
	        move_uploaded_file($tmp, '../images/'.$ph);
            }
            
        if($businessphoto !=''){
	        move_uploaded_file($tmp2, '../images/'.$ph2);
            }
// $stmt = $conn->prepare("INSERT INTO members VALUES ('',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
// $stmt->bind_param('sssssssssssssssssssss', $ln, $fn, $gd, $email, $ps, $ins,$sankh, $st,$fatherhusband,$dob,$ph,$phone,$whatsapp,$facebook,
//                   $marital,$business,$businessname,$business_details,$ph2,$town,$others );
                   
$stmt = "INSERT INTO members (l_name,f_name,gender,email,position,institute_id,sankh_id,
status,fatherhusband,dob,personphoto,phone,whatsapp,facebook,marital,business,businessname,
business_details,businessphoto,town,others,country,surnamename,postal_physical_address,pankh_id,native,rec_mail,rec_mail_all) 
  VALUES ('$ln','$fn','$gd','$email','$ps','$ins','$sankh','$st','$fatherhusband','$dob','$ph','$phone',
  '$whatsapp','$facebook','$marital','$business','$businessname','$business_details','$ph2','$town','$others','$country','$surname','$postal_physical_address','$pankh','$native','$rec_mail','$rec_mail_all')";

// if($stmt->execute()){
if($conn->query($stmt)== TRUE){
$_SESSION['nins']='<div class="alert alert-success alert-dismissible" role="alert">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Registration Successfully!</strong>
</div>';

} else{
$_SESSION['nins']='<div class="alert alert-danger alert-dismissible" role="alert">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Failed!! A Member with Similar Email Already Exists.</strong>
</div>';

}
// } else{ 
// $_SESSION['nins']='<div class="alert alert-warning alert-dismissible" role="alert">
//   <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
//   <strong>Warning! Please fill all the fields</strong>
// </div>';

// }
header('location:../index.php');

?>