temple_link.php

<?php 
include('config.php'); 
if(isset($_POST['link']))
{
    $officer_name = $_POST['name'];
    $officer_role = $_POST['officer_roll'];
    $officer_id = $_POST['user_id'];
    $temple_id = $_POST['temples'];

// $card_query = mysqli_query($conn,"SELECT iv_idcard_unique_id FROM iv_id_card WHERE iv_idcard_user_id ='$officer_id'");
    // $card_row = mysqli_fetch_assoc($card_query);

// $visit_id = $card_row['iv_idcard_unique_id'];

$temple_query = mysqli_query($conn,"SELECT iv_mem_temp_name,iv_mem_temp_id FROM iv_mem_details WHERE iv_mem_details_id='$temple_id'");
    $temple_row = mysqli_fetch_assoc($temple_query);

$temple_name = $temple_row['iv_mem_temp_name'];
    // $temple_id = $temple_row['iv_mem_temp_id'];

$query = mysqli_query($conn,"INSERT INTO iv_link_officer_temple(off_visit_id,off_visit_name,assigned_temple_id,
    assigned_temple_name,officer_roll) VALUES('$officer_id','$officer_name','$temple_id','$temple_name','$officer_role')");

if($query == 1)
    {
        $_SESSION['link'] = 'You Are Linked To This Temple After Admin Approval Is Done';
        header('location:../link-to-temple');
    }
    else
    {
        $_SESSION['link'] = 'Something Went Wrong';
        header('location:../link-to-temple');
    }
}
 ?>

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/officer/includes

	.	4096
	..	4096
X	config.php	140
X	contact.php	1139
X	delete_account.php	3223
X	delete_temple.php	586
X	donations.php	1175
X	dont_dis_temple.php	783
X	dont_display.php	657
X	event_create.php	3102
X	forget_password.php	1498
X	logout.php	79
X	request_idcard.php	1031
X	request_permission.php	1014
X	sidemenu.php	5398
X	subscription.php	1025
X	temple_link.php	1316
X	temple_reg.php	7906
X	verify_otp.php	1006