BossBey File Manager

Editing: insert_relatorio.php

<?php
session_start();
// Include do arquivo de conexão
include_once "connection.php";
//var_dump($_POST);

// Dados recebidos via POST
$id_acessoFicha = $_POST['id_acessoFicha'];
$titulo = $_POST['titulo'];
$mes = $_POST['mes'];
$ano = $_POST['ano'];
$obj = $_POST['objetivogeral'];
$obs = $_POST['observacoesimportantes'];
$q1 = $_POST['q1'];
$q2 = $_POST['q2'];
$q3 = $_POST['q3'];
$q4 = $_POST['q4'];
$q5 = $_POST['q5'];
$q6 = $_POST['q6'];
$q7 = $_POST['q7'];
$q8 = $_POST['q8'];
$q9 = $_POST['q9'];
$q10 = $_POST['q10'];
$q11 = $_POST['q11'];
$q12 = $_POST['q12'];
$q13 = $_POST['q13'];
$q14 = $_POST['q14'];
$q15 = $_POST['q15'];
$q16 = $_POST['q16'];
$q17 = $_POST['q17'];
$q18 = $_POST['q18'];
$q19 = $_POST['q19'];
$q20 = $_POST['q20'];
$q21 = $_POST['q21'];
$q22 = $_POST['q22'];
$q23 = $_POST['q23'];
$q24 = $_POST['q24'];
$q25 = $_POST['q25'];
$q26 = $_POST['q26'];
$q27 = $_POST['q27'];
$q28 = $_POST['q28'];
$q29 = $_POST['q29'];
$q30 = $_POST['q30'];
$q31 = $_POST['q31'];
$q32 = $_POST['q32'];
$q33 = $_POST['q33'];
$q34 = $_POST['q34'];
$q35 = $_POST['q35'];
$q36 = $_POST['q36'];
$q37 = $_POST['q37'];
$q38 = $_POST['q38'];
$q39 = $_POST['q39'];
$q40 = $_POST['q40'];

// Conexão com o banco de dados usando PDO
try {

// Inserção dos dados na tabela (substitua 'sua_tabela' pelo nome correto da tabela)
    $sql = "INSERT INTO relatorio (id_acessoFicha, titulo, mes, ano, obj, obs, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10, q11, q12, q13, q14, q15, q16, q17, q18, q19, q20, q21, q22, q23, q24, q25, q26, q27, q28, q29, q30, q31, q32, q33, q34, q35, q36, q37, q38, q39, q40)
            VALUES (:id_acessoFicha, :titulo, :mes, :ano, :obj, :obs, :q1, :q2, :q3, :q4, :q5, :q6, :q7, :q8, :q9, :q10, :q11, :q12, :q13, :q14, :q15, :q16, :q17, :q18, :q19, :q20, :q21, :q22, :q23, :q24, :q25, :q26, :q27, :q28, :q29, :q30, :q31, :q32, :q33, :q34, :q35, :q36, :q37, :q38, :q39, :q40)";
    $stmt = $pdo->prepare($sql);

// Binde dos parâmetros
    $stmt->bindParam(':id_acessoFicha', $id_acessoFicha);
    $stmt->bindParam(':titulo', $titulo);
    $stmt->bindParam(':mes', $mes);
    $stmt->bindParam(':ano', $ano);
    $stmt->bindParam(':obj', $obj);
    $stmt->bindParam(':obs', $obs);
    $stmt->bindParam(':q1', $q1);
    $stmt->bindParam(':q2', $q2);
    $stmt->bindParam(':q3', $q3);
    $stmt->bindParam(':q4', $q4);
    $stmt->bindParam(':q5', $q5);
    $stmt->bindParam(':q6', $q6);
    $stmt->bindParam(':q7', $q7);
    $stmt->bindParam(':q8', $q8);
    $stmt->bindParam(':q9', $q9);
    $stmt->bindParam(':q10', $q10);
    $stmt->bindParam(':q11', $q11);
    $stmt->bindParam(':q12', $q12);
    $stmt->bindParam(':q13', $q13);
    $stmt->bindParam(':q14', $q14);
    $stmt->bindParam(':q15', $q15);
    $stmt->bindParam(':q16', $q16);
    $stmt->bindParam(':q17', $q17);
    $stmt->bindParam(':q18', $q18);
    $stmt->bindParam(':q19', $q19);
    $stmt->bindParam(':q20', $q20);
    $stmt->bindParam(':q21', $q21);
    $stmt->bindParam(':q22', $q22);
    $stmt->bindParam(':q23', $q23);
    $stmt->bindParam(':q24', $q24);
    $stmt->bindParam(':q25', $q25);
    $stmt->bindParam(':q26', $q26);
    $stmt->bindParam(':q27', $q27);
    $stmt->bindParam(':q28', $q28);
    $stmt->bindParam(':q29', $q29);
    $stmt->bindParam(':q30', $q30);
    $stmt->bindParam(':q31', $q31);
    $stmt->bindParam(':q32', $q32);
    $stmt->bindParam(':q33', $q33);
    $stmt->bindParam(':q34', $q34);
    $stmt->bindParam(':q35', $q35);
    $stmt->bindParam(':q36', $q36);
    $stmt->bindParam(':q37', $q37);
    $stmt->bindParam(':q38', $q38);
    $stmt->bindParam(':q39', $q39);
    $stmt->bindParam(':q40', $q40);
    $stmt->execute();

echo "<script>
    alert('Relatório criado com sucesso!');
    window.location.href = 'relatorio.php';
    </script>";
    exit();
}
catch (PDOException $e) {
    echo "Erro ao inserir o relatório: " . $e->getMessage();
}
$conn = null;
?>

Cancel