PDO inserting data

Question

I'm new with PDO and I have little problem. Code is not inserting any data in my database, don't know why. Something wrong with binding or sth else?

<form action="" method= "POST">
    First name: <input type="text" name="data_name"><br>
    E-mail: <input type="email" name="data_mail"><br>
    City: <input type="text" name="data_city"><br>
    <input type="submit" value="Submit">
</form>

<?php

    $dsn = 'mysql:host=localhost;dbname=tabelaDB';
    $username = 'root';
    $password = 'pass';

    $db = new PDO($dsn, $username, $password);

    $name = $_POST['data_name'];
    $mail = $_POST['data_mail'];
    $city = $_POST['data_city'];

    $sql = $db->prepare( "INSERT INTO data ( data_name, data_mail, data_city ) VALUES ( :data_name, :data_mail, :data_city )");

    $sql->bindValue(':data_name', $name);
    $sql->bindValue(':data_mail', $mail);
    $sql->bindValue(':data_city', $city);

    $sql->execute();
?>

Read this to check error http://php.net/manual/en/pdo.errorinfo.php — Saty, Dec 28 '15 at 11:34
I think data might be a reserved word - try encapsulating in backticks - "insert into `data` ..." — Professor Abronsius, Dec 28 '15 at 11:38
@RamRaider yes but there is no **(R)** on `data` http://dev.mysql.com/doc/refman/5.7/en/keywords.html — Saty, Dec 28 '15 at 11:40

score 2 · Accepted Answer · edited May 23 '17 at 11:59

2

Surrond your PHP code with try - catch block as here: http://php.net/manual/en/pdo.error-handling.php then you get all information about your error.

Eidt: Here: PDO error message? is similar problem and another soultion.

edited May 23 '17 at 11:59

Community

1
1

answered Dec 28 '15 at 11:35

Blady214

729
6
19

Ok when i add try - catch to my code, It started to work and save data into database O.o So thank you – bonzo7aab Dec 28 '15 at 11:44
Bit weird but I am glad that I could help you :) – Blady214 Dec 28 '15 at 13:59

score 1 · Answer 2 · answered Dec 28 '15 at 11:37

First thing you should put the PHP block in a IF statement to check if the form is submited or a user just opens the page:

<?php
if(isset($_POST['submit'])){
$dsn = 'mysql:host=localhost;dbname=tabelaDB';
$username = 'root';
$password = 'pass';

$db = new PDO($dsn, $username, $password);

$name = $_POST['data_name'];
$mail = $_POST['data_mail'];
$city = $_POST['data_city'];

$sql = $db->prepare( "INSERT INTO data ( data_name, data_mail, data_city ) VALUES ( :data_name, :data_mail, :data_city )");

$sql->bindValue(':data_name', $name);
$sql->bindValue(':data_mail', $mail);
$sql->bindValue(':data_city', $city);

$sql->execute();
}
?>

To check for errors add before prepare :

$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );

Then add

print_r($db->errorInfo());

It started to work when I add try-catch. But when I add also your code It stopped wroking :D — bonzo7aab, Dec 28 '15 at 11:59

PDO inserting data

2 Answers2