Simple MySQL code not inserting data into database?

Question

I've been working at this for hours, and can't seem to get these few lines of code to work. This is the first time I've worked with MySQL, so bear with me.

<?php

$con = mysql_connect("localhost","usernamewitheld","passwordwithheld");
if (!$con){die('Could not connect: ' . mysql_error());}
mysql_select_db("splashpage");
mysql_query("INSERT INTO 'email' ('emailaddress') VALUES ('$_POST[email]');", $con);
mysql_close($con);

?>

The code executes without any errors from apache, but the database remains unaffected. Any ideas?

EDIT: Table structure is as follows:

Field   Type    Null    Key Default Extra
emailaddress    text    NO  MUL NULL     
timesubmitted   timestamp   NO      CURRENT_TIMESTAMP

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use pdo or mysqli. — hjpotter92
– hjpotter92, Commented May 4, 2013 at 6:08

Zoe - Save the data dump · Accepted Answer · 2019-05-25 14:42:19Z

2

Remove semi colon, use bacticks instead of single quotes in query.

mysql_query("INSERT INTO `email` (`emailaddress`) VALUES ('$_POST[email]')", $con)
or     
die(mysql_error());

Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25, 2019 at 14:42

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered May 4, 2013 at 6:08

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

Comments

Yogesh Suthar · Accepted Answer · 2013-05-04 06:08:03Z

0

use backtick ` here around column name not '

mysql_query("INSERT INTO 'email' ('emailaddress') VALUES ('$_POST[email]');", $con);

should be

mysql_query("INSERT INTO `email` (`emailaddress`) VALUES ('$_POST[email]')", $con);

answered May 4, 2013 at 6:08

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Comments

Bharat Chodvadiya · Accepted Answer · 2013-05-04 06:14:04Z

0

Use this.

<?php
mysql_query("INSERT INTO email (emailaddress) VALUES ('".$_POST[email]."')", $con);
mysql_close($con);
?>

answered May 4, 2013 at 6:14

Bharat Chodvadiya

1,6484 gold badges20 silver badges31 bronze badges

Comments

themhz · Accepted Answer · 2013-05-04 06:14:36Z

0

try

<?php

$con = mysql_connect("localhost","usernamewitheld","passwordwithheld");
if (!$con){die('Could not connect: ' . mysql_error());}
mysql_select_db("splashpage",$con);
mysql_query("INSERT INTO 'email' ('emailaddress') VALUES ('$_POST[email]');", $con);
 echo mysql_errno($con) . ": " . mysql_error($con) . "\n";
mysql_close($con);

?>

answered May 4, 2013 at 6:14

themhz

8,43622 gold badges86 silver badges109 bronze badges

Collectives™ on Stack Overflow

Simple MySQL code not inserting data into database?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related