Exemple #1
0
<?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');
Exemple #2
0
<?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">
Exemple #3
0
<?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>