cant insert data from forms into mysql

Question

Can anyone explain why this insert is not working?

if(isset($_POST['send'])){
    $query = 'INSERT INTO subsciber(data, ip, email) 
          VALUES(CURRENT_TIMESTAMP, "'.$_SERVER['REMOTE_ADDR'].'", "'.$_POST['email'].'")';
    $result =  @mysqli_query($dbc, $query);
}

And forms code looks like this:

<div class="row">
     <div class="col-md-4 col-md-offset-4 col-sm6-6 col-sm-offset-3 ">
         <form class="form-inline" role="form" method="post">
            <div class="form-group">
                <label class="sr-only" for="exampleInputEmail2">Email address</label>
                <input name='email' id="email" type="email" class="form-control transparent" placeholder="Your email here...">
            </div>
            <button type="submit" name='send' value='send' class="btn btn-danger btn-fill">Notify Me</button>
        </form>
    </div>
</div>

Show us `$dbc`. Do you have connection to database? Do you have any value in `$_POST['email']`? Is there any error at all? — S.I., Oct 18 '16 at 06:20
You should ON error reporting in developement mode. Never use @ to hide errors. — Ravi Hirani, Oct 18 '16 at 06:20
Remove the `@` since it silence's the error and then run it. Check if it is getting inside the if condition — Kinshuk Lahiri, Oct 18 '16 at 06:21
remove @ from @mysqli_query($dbc, $query); to get the exact error — AmmyTech, Oct 18 '16 at 06:21
Possible duplicate of [Syntax error due to using a reserved word as a table or column name in MySQL](http://stackoverflow.com/questions/23446377/syntax-error-due-to-using-a-reserved-word-as-a-table-or-column-name-in-mysql) — Irvin, Oct 18 '16 at 06:22
The problem here is that `data` is a `Reserved Word` that shouldn't be used as a `column name` unless you use `backticks`. — Irvin, Oct 18 '16 at 06:23
Try to use `mysql_real_escape_string()` to insert special characters in the database. — Keyur Mistry, Oct 18 '16 at 06:25
@Drew His column `data`. My bad, it is a `Keyword` not a `Reserved Word`. https://dev.mysql.com/doc/refman/5.7/en/keywords.html — Irvin, Oct 18 '16 at 06:30
@KinjalMistry No, he should use a prepared query and `bind_param`. — Barmar, Oct 18 '16 at 06:46

Passionate Coder · Accepted Answer · 2016-10-18T06:55:11.177

1

You should include mysqli error function to see your errors

    if(isset($_POST['send'])){
        $query = 'INSERT INTO subsciber(data, ip, email) 
              VALUES(CURRENT_TIMESTAMP, "'.$_SERVER['REMOTE_ADDR'].'", "'.$_POST['email'].'")';
//echo $query; to see query output
        $result =  mysqli_query($dbc, $query) or die(mysqli_error($dbc));
    }

Also data is mysqli keyword so use backtick around this

 $query = 'INSERT INTO subsciber(`data`, ip, email) 
                  VALUES(CURRENT_TIMESTAMP, "'.$_SERVER['REMOTE_ADDR'].'", "'.$_POST['email'].'")';

edited Oct 18 '16 at 06:55

answered Oct 18 '16 at 06:25

Passionate Coder

7,154
2
19
44

It's a keyword, but it's not reserved. – Barmar Oct 18 '16 at 06:45

score -1 · Answer 2 · answered Oct 18 '16 at 06:22

-1

Your form does not have an action property:

Do this:

<form action="the url to your PHP script">

answered Oct 18 '16 at 06:22

Abolarin stephen

358
2
9

The default is to use the same URL as the page itself. – Barmar Oct 18 '16 at 06:45
If the PHP script is in the same file as the HTML form – Abolarin stephen Oct 18 '16 at 06:46

score -2 · Answer 3 · answered Oct 18 '16 at 06:24

-2

Replace

@mysqli_query($dbc, $query);

with

mysqli_query($dbc, $query);

answered Oct 18 '16 at 06:24

mahethekiller

514
3
17

That won't help. `mysqli_query()` doesn't report MySQL errors automatically, you have to print `mysqli_error($dbc)`. – Barmar Oct 18 '16 at 06:44

score -2 · Answer 4 · edited Oct 18 '16 at 06:42

-2

instead of single quotation you can use doublequotation

Try This one

if(isset($_POST["send"])) {
    .....
}

edited Oct 18 '16 at 06:42

Barmar

741,623
53
500
612

answered Oct 18 '16 at 06:28

Mathan kumar

1
2

Why would that make a difference? There's nothing in `send` that behaves differently depending on the type of quotes. – Barmar Oct 18 '16 at 06:42
i have faced same problem one time then i changed single quotation to doublequotation it working fine – Mathan kumar Oct 18 '16 at 06:47
It must have been some other problem. See http://stackoverflow.com/questions/3446216/what-is-the-difference-between-single-quoted-and-double-quoted-strings-in-php – Barmar Oct 18 '16 at 06:48

cant insert data from forms into mysql

4 Answers4