INSERT INTO doesn't execute

Question

ı'm using a code block which ı already used in a different insert data process, but ı don't know why, it doesn't work. it sends me contact.php?in=error. what is the problem with my codes?

<?php 

if(@$_POST['submit']){

    $gizlicap = $_POST['hcaptcha'];
    $code = $_POST['captcha'];

    if($code == $gizlicap){
        $name = htmlspecialchars($_POST['ad'], ENT_QUOTES, 'utf-8');
        $email = htmlspecialchars($_POST['eposta'], ENT_QUOTES, 'utf-8');
        $yazi = htmlspecialchars($_POST['text'], ENT_QUOTES, 'utf-8');

        $snd = $db->prepare("INSERT INTO `contactform` (`message_id`, `message_ad`, `message_email`, `message`) VALUES (NULL, :ad, :email, :yazi) ");
        $snd->bindValue(":ad", $name, PDO::PARAM_STR);
        $snd->bindValue(":email", $email, PDO::PARAM_STR);
        $snd->bindValue(":yazi", $yazi, PDO::PARAM_STR);

        if($snd->execute()) {
            @header("Location: contact.php?in=success");
        } else {
            @header("Location: contact.php?in=error");
        }
    } else {
        echo 'Check security code!!';
    }
}
?>

Have you thought of logging the actual error message from the SQL? — Nigel Ren, May 11 '20 at 09:28
`htmlspecialchars()` should be used to sanitize data being displayed on a web page, it's not for database data. — Barmar, May 11 '20 at 09:28
Side note: please get rid of those `@`s. Instead debug your code, use exceptions etc — B001ᛦ, May 11 '20 at 09:30
ı delete @s but it is same and when ı delete htmlspecialchars() again it is same these are not solution... — Kimse, May 11 '20 at 13:17

score -1 · Answer 1 · answered May 11 '20 at 09:45

-1

Do you have $db variable definied? Use try-catch instruction to handle exceptions, so you'll get message what is wrong.

answered May 11 '20 at 09:45

user13215415

23
5

1

It makes no sense to use try-catch instruction to handle exceptions, because exceptions report themselves – Your Common Sense May 11 '20 at 09:52
yes ı have $db variable and same code is working when ım trying to add blog essey into table... I seriously can't understand what is problem – Kimse May 11 '20 at 13:16
ı forgot to make id column autoincrement, so thats why codes didn't work. Thank you all – Kimse May 11 '20 at 19:08

INSERT INTO doesn't execute

1 Answers1