My cookie wont work! PHP + Mysql + Cookies

Question

0.00/5 (No votes)

See more:

Hi there! I have a login page on my website. If the password and username is correct it creates a cookie :

PHP

//create cookie
$date_of_expiry = time() + 300 ;
setcookie( "userlogin", " ". $_POST['myusername'] ."", $date_of_expiry );

and after it creates a cookie it redirects the user: header('location:shopowner.php');

On shopowner.php the code is supposed to display MySQL data using the value of the cookie:

PHP

<?php

$connect = mysql_connect("localhost", "root") or die (mysql_error());

mysql_select_db("dresses", $connect);
echo "Welcome " . $_COOKIE['userlogin'] . "<br>";

$sql = "SELECT * FROM data WHERE Username = '" . $_COOKIE['userlogin']  . "'";
$result = mysql_query($sql, $connect);
echo 'MyData:<br>';
while ($row = mysql_fetch_array($result)) {
echo   "" . $row['Shop'] . "<br>" ;
}

?>

There are no error messages that come up. the cookies work because it echo's: Welcome Admin(the value of the cookie) but no MySQL data gets displayed. If anyone would be kind enough te help me figure out what the problem is.

Posted 11-Oct-13 19:56pm

UlrichvL

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Homero Rivera · Accepted Answer · 2013-10-11T20:07:00

Solution 1

Seems like the value of the cookie is an empty space concatenated with the username:

PHP

" ". $_POST['myusername'] .""

Is your username in database 'admin' or ' admin'?

Change your code when setting the cookie to this simpler version:

PHP

//create cookie
$date_of_expiry = time() + 300 ;
setcookie( "userlogin", $_POST['myusername'], $date_of_expiry );

Posted 11-Oct-13 20:07pm

Homero Rivera

Updated 11-Oct-13 20:13pm

v2

Comments

UlrichvL 12-Oct-13 2:10am

The username in database is admin.

Homero Rivera 12-Oct-13 2:12am

because of how you are setting your cookie, you are telling the database to look for ' admin' instead of 'admin'. ' admin' does not exist, so your database returns no results.

UlrichvL 12-Oct-13 2:13am

Wil go and check it out and wil return back to you with the result

UlrichvL 12-Oct-13 2:12am

If the empty space is taken away an error message appears:
Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\xampp\htdocs\Dropshop\Main home\signin.php on line 108

UlrichvL 12-Oct-13 2:17am

Thank you very much for you're kind help! You were right! It works now that I took away the empty space, I wouldn't have seen that on my own. Many thanks.
Ulrichvl

Homero Rivera 12-Oct-13 2:23am

Have you try flushing away your cookies in your browser before trying again?

UlrichvL 12-Oct-13 2:24am

Yes, I have. Thanks a lot!!

Homero Rivera 12-Oct-13 2:24am

Please consider clicking the Green button "Accept as solution". Thanks!

UlrichvL 12-Oct-13 2:26am

I did ;)