Nothing inserted in database using $_SESSION variables

Question

I have the following example usage:

  $insert = "
  INSERT INTO table (
      field
  ) VALUES (
      '".$_SESSION['field']."'
  )
  ";

For some reason it's inserting blanks and no data is being submitted. Is what I am doing the right way?

I do have multiple fields but they were too many so just shrunk the example to include only one field.

oops my bad. forgot. now after the form is submitted how can i end the session? — AAA
– AAA, Commented Dec 27, 2011 at 16:15
You should escape the variable with mysql_real_escape_string() — Mārtiņš Briedis
– Mārtiņš Briedis, Commented Dec 27, 2011 at 16:17
Well, obviously your variable $_SESSION['field'] does not contain a value that would not be converted into an empty string. — Gumbo
– Gumbo, Commented Dec 27, 2011 at 16:26

ppp · Accepted Answer · 2011-12-27 17:44:42Z

1

Use session_start() for starting the session before assigning anything to $_SESSION['field'].

After insertion you can delete session variables but not the session itself using session_unset(), or you can destroy the variables using session_destroy().

answered Dec 27, 2011 at 17:44

ppp

2,0519 gold badges33 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Nothing inserted in database using $_SESSION variables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related