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](http://stackoverflow.com/q/12859942/1190388) in new code. They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). See the red box? Learn about prepared statements instead, and use [tag:PDO] or [tag:MySQLi]. — hjpotter92, May 04 '13 at 06:08

score 2 · Accepted Answer · edited May 25 '19 at 14:42

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.

score 0 · Answer 2 · answered May 04 '13 at 06:08

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 04 '13 at 06:08

Yogesh Suthar

30,424
18
72
100

score 0 · Answer 3 · answered May 04 '13 at 06:14

0

Use this.

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

answered May 04 '13 at 06:14

Bharat Chodvadiya

1,644
4
20
31

score 0 · Answer 4 · answered May 04 '13 at 06:14

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);

?>

Simple MySQL code not inserting data into database?

4 Answers4