PHP Form , session data not being stored

Question

we are working with php session data, but the data is not being stored in the database

login.php

<h2>Welcome</h2> <form action = "Customer.php" method = "POST"> Customer Name:<input type = "text" name="customerName"> <input type = "submit" name = "submit"> </form>

Customer.php

<?php session_start(); #include("Connection.php); if (isset($_POST['submit'])) { $name = $_POST['customerName']; $_SESSION['user'] = $name; } if (isset($_SESSION['user'])) { echo "Hello {$_SESSION['user']}, welcome to starbucks!"; } else { echo "walang tao"; $sql="INSERT INTO `customer`.`people` ('ID', `NAME`) VALUES ('','$name')"; mysql_query($sql); ?> <a href = "logout.php">Logout</a>

and logout.php

<?php session_start(); session_destroy(); ?> <a href = "index.php">Click me to return to login </a>

please tell me what's wrong

Is there a difference in saving the data to mysql when it is retrieved from session vs specified right in the code as string literals? — zerkms
– zerkms, Commented Aug 31, 2011 at 3:35
you're doing an insert inside of the condition of no session data, how do you expect that to get saved? or even it's outside of that else block, there is still no session data because you're depending on isset($_POST['submit']) to get something assigned to your session variable. — tradyblix
– tradyblix, Commented Aug 31, 2011 at 3:44

bumperbox · Accepted Answer · 2011-08-31 03:45:42Z

1

try displaying the mysql_error and see what the problem is

mysql_query($sql) or die(mysql_error());

answered Aug 31, 2011 at 3:45

bumperbox

10.2k6 gold badges46 silver badges66 bronze badges

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

2 Comments

Kyel john David Over a year ago

thanks but it gave this error INSERT command denied to user ''@'localhost' for table 'people

Ben Rowe Over a year ago

You have a permissions problem with mysql. Check your privileges!

Collectives™ on Stack Overflow

PHP Form , session data not being stored

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related