I am not able to enter data into the database, I was using PDO
, but now I started to use MySql
, because I was only able to list database data with MySql
, I am able to list the data, but I am not able to insert.
<?php
$host = "localhost";
$usuario = "root";
$senha = "";
$bd = "nise";
$mysqli = new mysqli($host, $usuario, $senha, $bd);
if($mysqli->connect_errno)
echo"Falha na conexão: (".$mysqli->connect_errno.")".$mysqli->connect_error;
?>
Here is the file PHP
<?php
include("includes/conexao.php");//conexão com o banco
$consulta = "SELECT id, data, descricao, imagem, id_bloco, qual_descricao, id_denuncia_oque FROM denuncia";
$con = $mysqli->query($consulta) or die ($mysqli->error);
if(!empty($_FILES['uploaded_file'])){
$query = "INSERT INTO resposta_denuncia (descricao_resposta, imagem, id_usuario)
VALUES (:descricao_resposta, :imagem, :id_usuario)";
$statement = $mysqli->prepare($query);
$path = "img_denuncia/";
$path = $path . basename( $_FILES['uploaded_file']['name']);
if(move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $path))
$valores = array();
$valores[':descricao_resposta'] = $_POST['descricao_resposta'];
$valores[':imagem'] = $_FILES['uploaded_file']['name'];
$valores[':id_usuario'] = 2;
if(!isset($_POST['descricao_resposta']) or empty($_POST['descricao_resposta'])) {
echo 0;
}elseif($result = $statement->execute($valores)) {
echo 1; // dados enviados com sucesso
} else {
echo 0; // erro ao tentar enviar dados
}
}
? >