How come I can't set a $_POST value to a variable?

Question

I have a form in HTML, in which I am pulling values from with PHP. I would like to insert it into a database with SQL, but (from my experience with this issue, at least) you can't insert $_POST values with an SQL statement.

When the page is loaded on XAMPP, I get the following error of:

Notice: Undefined index: email in C:\xampp\htdocs\index.php on line 26

My code looks something like this:

<form method="post">
  <input type="text" placeholder="Firstname" name="email">
  <button class="btndef" name="submit">Submit</button>
  </form>

<?php
$email = $_POST['email'];
?>

Obviously something's wrong with it, but I have no idea what!

You get that when you initially load the page or after you submit the form? — Patrick Q, Feb 09 '18 at 18:57
Okay, so it doesn't exist because you haven't posted. What value would you expect it to have? — Patrick Q, Feb 09 '18 at 18:59
Right, and it _will_ have a value when submitted. But you haven't submitted yet. So it doesn't exist. — Patrick Q, Feb 09 '18 at 19:00

score 1 · Accepted Answer · answered Feb 09 '18 at 19:10

1

You can try this.

<?php if(isset($_POST['submit']){
    $email = $_POST['email']; 
?>

<form method="post" action="action-url">
  <input type="text" placeholder="Firstname" name="email">
  <button class="btndef" type="submit" name="submit">Submit</button>
</form>

Make sure you are doing validation while submitting the form

answered Feb 09 '18 at 19:10

BEingprabhU

1,450
1
17
26

Yes but I want to send to phpMyAdmin, so this wouldn't work for me – WillWam Feb 09 '18 at 22:04
PHPMyAdmin is just a User Interface for MySQL. It has nothing to do with your operation. Can you elaborate little that where you are getting the problem?? Any errors?? Please update your question. – BEingprabhU Feb 10 '18 at 04:32

How come I can't set a $_POST value to a variable?

1 Answers1