Problem sending PHP data to the database

Question

Problem sending PHP data to the database

Navigation

#1 by (1 votes)
#2 by (0 votes)
#3 by (-1 votes)

1

I'm starting with PHP and I'm having trouble sending it to the database, unfortunately I can not find the error, if anyone can help, I'm grateful.

HTML looks like this:

<form method="post" action="blog.php"  >    
                    <input style="font-family:'open sans',sans-serif;font-size:20px;color:#212121"type="text" name="titulo" placeholder="Título" required />
                        <br>
                    <input type="text" name="texto" placeholder="Texto"  required />
                        <br>
                    <input style="background-color:red;color:white" type="submit" name="submit" value="enviar" />
                </form>

And PHP like this:

<?php
$titulo = $_POST ['titulo'];
$texto = $_POST ['texto'];
$imagem = "imagem";
echo "$titulo";

$conexao = mysqli_connect("localhost", "root", "", "blog");

mysqli_query($conexao, "INSERT INTO postagens (titulo,texto,imagem) VALUES ('$titulo','$texto,'$imagem')");

echo "Sucesso";
?>

The name of the database is 'Blog' and the 'post' table.

php html

asked by anonymous 07.10.2017 / 05:16

3 answers

0

A single quote is missing after $ text in the query, try to see if it works

mysqli_query($conexao, "INSERT INTO postagens (titulo,texto,imagem) VALUES ('$titulo','$texto','$imagem')");

07.10.2017 / 21:51

-1

<?php
$titulo = $_POST ['titulo'];
$texto = $_POST ['texto'];

$conexao = mysqli_connect("localhost", "root", "", "blog");

echo "Sucesso";

mysqli_query($conexao, "INSERT INTO postagens (titulo,texto) VALUES ("{$titulo}","{$texto}"));

Try this query , it should work, but take the image initially, because to do the upload of the image you need to make changes in both your HTML and PHP.

07.10.2017 / 13:35

Conversion of "query" an HTML form using .htaccess Jquery ajax load page in infinite loop

score 1 · Accepted Answer

<?php
// verificação do metodo post
if ( $_SERVER['REQUEST_METHOD'] == "POST" )
{
    // obtendo os dados do form
        $titulo = $_POST['titulo'];
        $texto  = $_POST['texto'];
        $imagem = "imagem";
        echo "Título: ".$titulo." <br />";

    // realizando a conexão
        $conexao = mysqli_connect("localhost", "root", "", "blog");
        $query   = mysqli_query($conexao, "INSERT INTO postagens(titulo,texto,imagem) VALUES ('$titulo','$texto','$imagem')");

    // se executar a query
        if ($query)
        {
            echo "Sucesso";

        }else
        {
            echo "[ERRO]: ".mysqli_connect_error($conexao);
        }
}
?>

See if this solves your problem.