<?php include_once "template/global.php"; if (isset($_POST['nome']) and isset($_POST['valor']) and isset($_POST['qtd']) and isset($_POST['validade'])) { cadastro($_POST['nome'], $_POST['valor'], $_POST['qtd'], $_POST['validade']); } ?> <?php include_once "template/header.php"; ?> <form method="post"> <div class="row login"> <div class="large-12 small-12 medium-12 columns"> <label> Nome: <input type="text" name="nome" /> </label> </div> <div class="large-12 small-12 medium-12 columns"> <label> valor: <input type="text" name="valor" /> </label> </div> <div class="large-12 small-12 medium-12 columns"> <label> Quantidade: <input type="text" name="qtd" />
<?php //header('Access-Control-Allow-Origin: *'); //header('Access-Control-Allow-Methods: GET, POST'); require '../../banco/conexao.php'; require 'crud.php'; $seconds = 2; $acao = filter_input(INPUT_POST, 'acao', FILTER_SANITIZE_STRING); //sleep($seconds); switch ($acao) { case 'cadastro': $total = filter_input(INPUT_POST, 'total'); $data = filter_input(INPUT_POST, 'data'); $mes = filter_input(INPUT_POST, 'mes'); $ano = filter_input(INPUT_POST, 'ano'); if (cadastro($total, $mes, $data, $ano)) { echo 'cadastrou'; } break; //******************************************************************************** //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //******************************************************************************** //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR case 'edit': $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); $mes = filter_input(INPUT_POST, 'mes', FILTER_SANITIZE_STRING); $total = filter_input(INPUT_POST, 'total', FILTER_SANITIZE_STRING); $data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING); //$horas = filter_input(INPUT_POST, 'horas', FILTER_SANITIZE_STRING); if (atualizar($mes, $total, $data, $id)) { echo "atualizou";
<?php require '../funcoes/banco/conexao.php'; require '../funcoes/crud/rel_geral.php'; //$seconds = 2; $acao = filter_input(INPUT_POST, 'acao', FILTER_SANITIZE_STRING); //sleep($seconds); switch ($acao) { //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO case 'cadastro': $refeicao = filter_input(INPUT_POST, 'refeicao', FILTER_SANITIZE_STRING); $ml = filter_input(INPUT_POST, 'ml', FILTER_SANITIZE_STRING); $data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING); $horas = filter_input(INPUT_POST, 'horas', FILTER_SANITIZE_STRING); // if (cadastro($refeicao, $ml, $data, $horas)) { echo 'cadastrou'; } break; //******************************************************************************** //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //******************************************************************************** //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR case 'edit': $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); $refeicao = filter_input(INPUT_POST, 'refeicao', FILTER_SANITIZE_STRING); $ml = filter_input(INPUT_POST, 'ml', FILTER_SANITIZE_STRING); $data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING); $horas = filter_input(INPUT_POST, 'horas', FILTER_SANITIZE_STRING); if (atualizar($refeicao, $ml, $data, $horas, $id)) { echo "atualizou";
<?php require '../../banco/conexao.php'; require 'crud.php'; //$seconds = 2; $acao = filter_input(INPUT_POST, 'acao', FILTER_SANITIZE_STRING); //sleep($seconds); switch ($acao) { //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO //CADASTRAR NOVO case 'cadastro': $anota = filter_input(INPUT_POST, 'anota', FILTER_SANITIZE_STRING); if (cadastro($anota)) { echo 'cadastrou'; } break; //******************************************************************************** //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //******************************************************************************** //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR case 'edit': $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); $anota = filter_input(INPUT_POST, 'anota', FILTER_SANITIZE_STRING); if (atualizar($anota, $id)) { echo "atualizou"; } break; case 'edit_user': $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); $nome = filter_input(INPUT_POST, 'nome', FILTER_SANITIZE_STRING); $sobrenome = filter_input(INPUT_POST, 'sobrenome', FILTER_SANITIZE_STRING); $idade = filter_input(INPUT_POST, 'idade', FILTER_SANITIZE_STRING);
<?php include_once "template/header.php"; include_once "php/global.php"; include_once "php/produto.php"; include_once "php/usuario.php"; if (!estalogado()) { header("Location: /index.php"); } cadastro(); ?> <a href="sair.php">SAIR</a> <form method="post"> <div class="row login"> <div class="large-12 small-12 medium-12 columns"> <label> Nome: <input type="text" name="nome" /> </label> </div> <div class="large-12 small-12 medium-12 columns"> <label> Valor: <input type="text" name="valor" /> </label> </div> <div class="large-12 small-12 medium-12 columns"> <label> Quantidade: <input type="text" name="qtd" />
<?php //header('Access-Control-Allow-Origin: *'); //header('Access-Control-Allow-Methods: GET, POST'); require '../../banco/conexao.php'; require 'crud.php'; $seconds = 2; $acao = filter_input(INPUT_POST, 'acao', FILTER_SANITIZE_STRING); //sleep($seconds); switch ($acao) { case 'cadastro': $tml = filter_input(INPUT_POST, 'tml'); $data = filter_input(INPUT_POST, 'data'); $mes = filter_input(INPUT_POST, 'mes'); $ano = filter_input(INPUT_POST, 'ano'); if (cadastro($tml, $data, $mes, $ano)) { echo 'cadastrou'; } break; //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR //EDITAR ATULIZAR case 'edit': $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); $tml = filter_input(INPUT_POST, 'tml', FILTER_SANITIZE_STRING); $data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING); $mes = filter_input(INPUT_POST, 'mes', FILTER_SANITIZE_STRING); $ano = filter_input(INPUT_POST, 'ano', FILTER_SANITIZE_STRING); if (atualizar($tml, $data, $mes, $ano, $id)) { echo "atualizou"; } break;
<?php // Create connection $conn = mysqli_connect("localhost", "", "", "test"); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } print "conectou"; $v1 = "marcelo"; $v2 = "kle"; $v3 = "*****@*****.**"; $cadastrar = cadastro($v1, $v2, $v3); mysqli_query($conn, $cadastrar); function cadastro($login, $senha, $email) { $db = "insert into usuario (usuario, senha, email) values ('{$login}','{$senha}','{$email}')"; return $db; echo $db; }