Cannot insert data into mysql table via php

Question

I'm sure this question has been asked a thousand times but after an hour of truly trying many examples on the web, I have failed to insert new data into my table. I have tried many methods as I said, the one I'm about to post is most recent. If anyone knows why my code is failing it would save so much stress. I have only so far managed to insert data via phpmyadmin. The database is called "test" and the table is called "getting". Please note that "key" is auto incremented.

Thank you

$username='****';
$password='****';
$database='test';



    $con= mysql_connect("localhost",$username,$password);

     mysql_select_db("test",$con);




    mysql_query("INSERT INTO getting (Key, Date, amount, tax, Extra) 
    VALUES ('', 'sept 26 2008', '35653', '46', '454')");

You should put between backticks keywords, format date as YYYY-MM-DD to be sure it's correctly taken and show us which error you are getting... — Marco
– Marco, Commented Jan 24, 2012 at 0:47

Marco · Accepted Answer · 2012-01-24 00:54:54Z

10

You should try

put keywords between backticks
format date as YYYY-MM-DD
don't use quotes for numbers
use NULL for auto-increment keys (you could also remove it from INSERT)
perform error checking

Try this query

$res = mysql_query(
    "INSERT INTO getting (`Key`, `Date`, amount, tax, Extra) 
    VALUES (NULL, '2008-09-26', 35653, 46, 454)");
if (!$res) {
    die('Invalid query: ' . mysql_error());
} else  {
    // Do here what you need
}

edited Jan 24, 2012 at 0:54

answered Jan 24, 2012 at 0:49

Marco

57.7k15 gold badges135 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Teddy13 Over a year ago

This worked! Thanks Marco. Will accept. I believe the issue was that I put quotes around amount, tax, and extra? Not sure though.

Marco Over a year ago

@Teddy13: if you perform error checking, an error will be printed on screen if query is wrong telling you which part is wrong, so making it easier to fix it! :)

Cheery · Accepted Answer · 2012-01-24 00:52:07Z

1

mysql_query("INSERT INTO getting (Key, Date, amount, tax, Extra) 
    VALUES ('', 'sept 26 2008', '35653', '46', '454')") or die(mysql_error());

What does it say after execution? If there is an error in request - you will see it.

edited Jan 24, 2012 at 0:52

answered Jan 24, 2012 at 0:46

Cheery

16.2k45 silver badges58 bronze badges

2 Comments

Cheery Over a year ago

@Marco Sorry, I'm here for the second day only ) It is not really a question, it is a hint.

Marco Over a year ago

Don't worry, after you edited adding or die part it's OK :)

Hayden Thring · Accepted Answer · 2012-01-24 01:06:11Z

0

my guess would have been "4. use NULL for auto-increment keys" by marco too

answered Jan 24, 2012 at 1:06

Hayden Thring

1,83019 silver badges26 bronze badges

Comments

Sergei Kutanov · Accepted Answer · 2012-01-27 18:10:35Z

0

I belive if the 'key' filed is autoincremented you may not even bother mentioning it in your insert statement. Something like this

INSERT INTO getting (Date, amount, tax, Extra) 
VALUES ('sept 26 2008', '35653', '46', '454')

answered Jan 27, 2012 at 18:10

Sergei Kutanov

8256 silver badges13 bronze badges

Collectives™ on Stack Overflow

Cannot insert data into mysql table via php

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Related