<?php $toRoot = isset($toRoot) ? $toRoot : "../"; include_once $toRoot . "beans/Banco.class.php"; include_once $toRoot . "dao/DAOBanco.class.php"; include_once $toRoot . "utils/ConectarMySQL.class.php"; $conexao = new ConectarMySql($toRoot); $bean = new Banco(); $dao = new DAOBanco($bean, $conexao); $array = $dao->getBancoLista(); if ($array != NULL) { echo '<option value="---" selected="selected" >----------</option>'; foreach ($array as $temp) { $bean = $temp; echo '<option value="' . $bean->codigo . '" >' . $bean->nome . '</option>'; } } else { echo '<option value="---" selected="selected" >Não há bancos cadastrados!</option>'; } $conexao->fechar();
$variables = new Variables(); $connect = new Connect($variables->dbHost, $variables->dbUser, $variables->dbPassword, $variables->dbName); $connect->start(); session_start(); if (isset($_SESSION["usuario"]) == NULL && isset($_SESSION["senha"]) == NULL && isset($_SESSION["nivel"]) > 2) { header("Location: admin.php"); die; } $cadastrar = isset($_GET["cadastrar"]) ? $_GET["cadastrar"] : NULL; if ($cadastrar == "sim") { foreach ($_POST as $nomeCampo => $valor) { $comando = "\$" . $nomeCampo . "= antiSQL(isset(\$_POST['{$nomeCampo}']) ? '" . $valor . "' : NULL);"; eval($comando); } include_once "utils/ConectarMySQL.class.php"; $conexao = new ConectarMySql(); //------------------------------------------------------------------------------------------------------------------------------------------------- $sqlSEL = "select \r\n\t\t\t\t\t\tcar_con_codigo, \r\n\t\t\t\t\t\tcar_con_descricao\r\n\t\t\t\t\tfrom \r\n\t\t\t\t\t\tcontrachequeonline.cargo_contratado\r\n\t\t\t\t\twhere\r\n\t\t\t\t\t\tcar_con_descricao='" . $tfCargCont . "'"; $resultado = $conexao->selecionar($sqlSEL); if ($conexao->numeroLinhas($resultado) > 0) { $linha = mysqli_fetch_array($resultado); $cargContCODIGO = $linha["car_con_codigo"]; } else { $sqlINS = "insert into contrachequeonline.cargo_contratado \r\n\t\t\t\t\t\t\t(car_con_descricao)\r\n\t\t\t\t\t\tvalues\r\n\t\t\t\t\t\t\t('" . $tfCargCont . "')"; $conexao->executar($sqlINS); $resultado = $conexao->selecionar($sqlSEL); $linha = mysqli_fetch_array($resultado); $cargContCODIGO = $linha["car_con_codigo"]; } //------------------------------------------------------------------------------------------------------------------------------------------------- $sqlSEL = "select \r\n\t\t\t\t\t\tdis_codigo, \r\n\t\t\t\t\t\tdis_descricao\r\n\t\t\t\t\tfrom \r\n\t\t\t\t\t\tcontrachequeonline.disposicao\r\n\t\t\t\t\twhere\r\n\t\t\t\t\t\tdis_descricao='" . ${$tfDispos} . "'";