data are not stored in the Database

Asked

Viewed 29 times

0

Good morning, I made a text editor with php js and a little jquery for the link slide effect. However it is not storing in the database and does not accuse me no error anyone can tell me how to fix? Thanks in advance

<?php 

require "bd.php";

if (!empty($_POST['titulo']) && !empty($_POST['corpo'])) {
    $titulo = addslashes($_POST['titulo']);
    $post = htmlentities($_POST['corpo'], ENT_QUOTES);
    $data = date('d-m-Y');

    $sql = $pdo->prepare("INSERT INTO post (titulo, conteudo, data) VALUES 
    (:titulo, :conteudo, NOW())");
    $sql->bindValue(":titulo", $titulo);
    $sql->bindValue(":conteudo", $post);
    $sql->bindValue(":data", $data);
    $sql->execute();

    header ("location: dashboard.php");
    exit;
}else{
    echo "ainda não deu certo";
}
?>

<!DOCTYPE html>

Post 

    <div id="eda" >

        <div id="edmenu">
                <button id="b" onclick="bold()"><b>B</b></button>
                <button id="i" onclick="italic()"><i>I</i></button>
                <button id="u" onclick="under()"><u>U</u></button>
                <button id="link">Link</button><br>

                <ul id="fl">
                    <li><input type="text" name="linke" placeholder="coloque 
                a URL" id="vlink" value="http://www."></li>
                    <li id="ok" onclick="linkar()" ><button >Ok</button> 
                </li>

                </ul>
                <select id="fonts" onclick="fontFam();">
                    <option></option>
                    <option value="Times New Roman">Times new Roman</option>
                    <option value="Tahoma">Tahoma</option>
                    <option value="Consolas">Conolas</option>
                    <option value="Monospace">Monospace</option>
                    <option value="Sans-Serif">Sans-Serif</option>
                    <option value="Calibri">Calibri</option>
                </select>
                <select id="fontsize" onclick="fontTam();">
                    <option value="1">1</option>
                    <option value="2">2</option>
                    <option value="3">3</option>
                    <option value="4">4</option>
                    <option value="5">5</option>
                    <option value="6">6</option>
                </select>
                <label for="file-input" id="imagem">
                        <img src="imageicon.jpg"width="30" height="30" 
 name="imagem">
                </label>
            </div>
        <form method="POST" id="fte" name="fte">
        <input type="text" name="titulo" placeholder="Titulo" id="titulo"> 
 <br>
        <textarea id="corpo" name="corpo" style="display: none"></textarea>
        <iframe id="conteudo" name="conteudo" >
        </iframe><br>
        <input type="submit" name="enviar" id="enviar" onclick="envie();">
    </div>
    </form>
    <script type="text/javascript" src="editor.js"></script>
</section>
<footer>
</footer>

The arch js

function iframe() {
conteudo.document.designMode = 'on';

}

function bold(){
conteudo.document.execCommand('bold', false, null);
}

function italic(){
conteudo.document.execCommand('italic', false, null);
}

function under(){
conteudo.document.execCommand('underline', false, null);
}

function fontTam(){
var se = document.getElementById('fontsize').value;

conteudo.document.execCommand('fontSize', false, se);

}

function fontFam(){
var fa = document.getElementById('fonts').value;

conteudo.document.execCommand('fontName', false, fa);

}

function linkar(){
var vl = document.getElementById('vlink').value;

conteudo.document.execCommand('createLink', false, vl);

}

function envie(){
document.getElementById("corpo").value = 
window.frames['conteudo'].document.body.innerHTML;
document.getElementById("fte").submit();
}
php database post

  • enters if the values are not empty and executes the Insert should at least enter, but even clicking on the form’s Submit it does not store and did not appear those messages in orange error

  • 1

    In SQL you define the date column as NOW() and below tries to set a variable in :data but it doesn’t exist

1 answer

0

try that code. NOTE: DON’T FORGET TO OPEN THE DB CONNECTION.

/* Prepare an insert statement */
$query = "INSERT INTO post (titulo, conteudo, data) VALUES (?,?,?)";
$stmt = $mysqli->prepare($query);

$stmt->bind_param("sss", $val1, $val2, $val3);

$val1 = '$titulo';
$val2 = '$post';
$val3 = '$data';

/* Execute the statement */
$stmt->execute();

Browser other questions tagged php database post

You are not signed in. Login or sign up in order to post.