eclass.unmer.ac.id

<?php
	session_start();
	
	require 'conexao/funcao.inc.php';
	require 'conexao/config.php';
	require 'conexao/conn.php';
	require 'conexao/function.php';
	
	$iddp 	= $_POST['iddp'];
	$ndp 	= $_POST['ndp'];

$querycd = "SELECT id_setor_crm FROM cw_setor_crm WHERE user_setor_crm='$iddp' AND nome_setor_crm='$ndp'";
	$linkcd   = DBConnect();
	$resultcd = @mysqli_query($linkcd, $querycd) or die(mysqli_error($linkcd));

if (mysqli_num_rows($resultcd) > 0) { ?>
		
	<script language="javascript">
	alert ("SETOR JÁ CADASTRADO NESTA USUÁRIO!");
	</script>

<div class="col-lg-12 animation-efect-links">
                                        
      <?php
      $query = "SELECT * FROM cw_setor_crm WHERE user_setor_crm='$iddp' ORDER BY nome_setor_crm";
      $link   = DBConnect();
      $result = @mysqli_query($link, $query) or die(mysqli_error($link));
        while($res = mysqli_fetch_assoc($result)){ ?>    
                        
                        
                        <button type="button" class="btn btn-white deletar-nsetores" id="<?php echo $res['id_setor_crm']; ?>"> <i class="fa fa-check-circle"></i> <?php echo $res['nome_setor_crm']; ?> </button>
                        
      <?php } ?>

</div>

<?php	
		}else{

$setor_crm = array(
		//nome do campo da tabela que vai atualizar => o valor que vai receber
		'user_setor_crm'	=> "$iddp",
		'nome_setor_crm'	=> "$ndp"
	
	);
	$grava = DBCreate('setor_crm', $setor_crm);
		
?> 
	<div class="col-lg-12 animation-efect-links">
                                        
      <?php
      $query = "SELECT * FROM cw_setor_crm WHERE user_setor_crm='$iddp' ORDER BY nome_setor_crm";
      $link   = DBConnect();
      $result = @mysqli_query($link, $query) or die(mysqli_error($link));
        while($res = mysqli_fetch_assoc($result)){ ?>    
                        
                        
                        <button type="button" class="btn btn-white deletar-nsetores" id="<?php echo $res['id_setor_crm']; ?>"> <i class="fa fa-check-circle"></i> <?php echo $res['nome_setor_crm']; ?> </button>
                        
      <?php } ?>

</div>

<?php 
	}
 ?>