<?php // Geting Sis Func Class require "sis/sis.php"; $reclame = 'active'; // CLASSES $query = new Connect(); $var = new ValidarVariavel(); $query = $query->open(); $busca_query = $query->prepare("SELECT ins_id, ins_nome FROM instituicao_ins where ins_ativo = 1"); $busca_query->bindValue(1, "%{$consulta}%", PDO::PARAM_STR); $valid = $busca_query->execute(); $instituicao = $busca_query->fetchAll(PDO::FETCH_ASSOC); $busca_query = $query->prepare("SELECT cur_idcurso, cur_nome FROM curso_cur"); $busca_query->bindValue(1, "%{$consulta}%", PDO::PARAM_STR); $valid = $busca_query->execute(); $curso = $busca_query->fetchAll(PDO::FETCH_ASSOC); $busca_query = $query->prepare("SELECT cur_idcurso, cur_nome FROM curso_cur"); $busca_query->bindValue(1, "%{$consulta}%", PDO::PARAM_STR); $valid = $busca_query->execute(); $cidade = $busca_query->fetchAll(PDO::FETCH_ASSOC); $acao = $var->get('acao', 'string'); if ($acao == 'Salvar') { $nome = $var->get('nome', 'string'); $sobrenome = $var->get('sobrenome', 'string'); $email = $var->get('email', 'string'); $pass = $var->get('pass', 'string'); $pass2 = $var->get('pass2', 'string'); $sexo = $var->get('sexo', 'string'); $cpf = $var->get('cpf', 'string'); $id_cidade = $var->get('id_cidade', 'int');
<?php // Geting Sis Func Class require "sis/sis.php"; $reclame = 'active'; // CLASSES $query = new Connect(); $var = new ValidarVariavel(); $acao = $var->get('acao', 'string'); if ($id) { $id = $var->get('id', 'int'); $query = $query->open(); $busca_query = $query->prepare("SELECT * FROM instituicao_ins WHERE ins_id = :id"); $busca_query->bindValue(':id', $id); $valid = $busca_query->execute(); $dados = $busca_query->fetch(PDO::FETCH_ASSOC); // new sis_debug($dados); } ?> <!DOCTYPE html> <html lang="en"> <?php require 'html_form/header.php'; ?> <body> <!-- Fixed navbar --> <?php require "html_form/menu.php"; ?> <!-- /.navbar --> <div class="container">
<?php // Geting Sis Func Class require "sis/sis.php"; $reclame = 'active'; // CLASSES $query = new Connect(); $var = new ValidarVariavel(); $acao = $var->get('acao', 'string'); if ($acao == 'buscar') { $consulta = $var->get('consulta', 'string'); $query = $query->open(); $busca_query = $query->prepare("SELECT * FROM instituicao_ins WHERE ins_nome LIKE ? "); $busca_query->bindValue(1, "%{$consulta}%", PDO::PARAM_STR); $valid = $busca_query->execute(); $row = $busca_query->fetchAll(PDO::FETCH_ASSOC); } ?> <!DOCTYPE html> <html lang="en"> <?php require 'html_form/header.php'; ?> <body> <!-- Fixed navbar --> <?php require "html_form/menu.php"; ?> <!-- /.navbar --> <div class="container"> <br>