CODEWITHSUNDEEP
phphtmlmysql
Miessau
Miessau

Reputation: 21

Form Data will not insert to database

I have connected my website to my database successfully when i submit the form it goes through but nothing is getting inserted into the database.

Code Below:

    <?php
if( $_POST )
{
  $con = mysql_connect("server","user","pass");

  if (!$con)
  {
    die('Could not connect: ' . mysql_error());
  }

  mysql_select_db("buycruisesdb", $con);

  $users_name = $_POST['name'];
  $users_email = $_POST['email'];

  $users_name = mysql_real_escape_string($users_name);
  $users_email = mysql_real_escape_string($users_email);

  $query = "
  INSERT INTO `website_subscribers`(`name_sub`, `email_sub`) VALUES ([$users_name],[$users_email])";

  mysql_query($query);

  echo "<h2>Thank you for subscribing!</h2>";
  echo $query;
  echo $users_name;
  echo $users_email;

  mysql_close($con);
}
?>

buycruisesdb = database
website_subscribers = table inside the database
name_sub/email_sub = columns inside the table

the form html is below:

!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>
    <form action="php/subscriber.php" id="form" method="post" name="form">
       <input id="name_sub" name="name" placeholder="Name" type="text">
       <input id="email_sub" name="email" placeholder="Email" type="text">
       <input type="submit" value="Submit" name="f_submit">
    </form>
</body>
</html>

Not sure exactly why this is not inputing anyone have an idea?

it says that it is inserting the proper values and into the proper tables Image

Upvotes: 1

Views: 70

Answers (2)

user6214813
user6214813

Reputation:

change it to:

$query = "
  INSERT INTO website_subscribers (name_sub,email_sub) VALUES ('".$users_name."','".$users_email."') ";

just copy the code and try it out

Upvotes: 1

Barmar
Barmar

Reputation: 780714

Square brackets are not valid in MySQL queries. You should be using quotes around the strings.

$query = "INSERT INTO `website_subscribers` (`name_sub`, `email_sub`) VALUES ('$users_name', '$users_email')";

Upvotes: 1

Related Questions