Jump to content

Unserialize returning false?


nuglobe

Recommended Posts

Alright so this is the entry that was stored in the database:

a:1:{s:6:"Andrew";s:17:"me@gmail.com";}

Here is the function that serializes it. Note - $_SESSION['stateEmails'] is passed through as the request array.

[code]function submit_request($uID, $requestArray){

$players = serialize($requestArray);
$status = 1;


$query = "INSERT INTO requests (uID, playersID, status) VALUES ('$uID', '$players', '$status')";
mysql_query ($query) or die ('Could not submit request!.');

}[/code]


Here is the code that creates the array.

[code]$_SESSION['stateEmails'][$rowprof['uFName']] = $rowprof['uEmail'];[/code]

Its in a loop, so there cool be more to it then the one posted at the top.

And finally here is the function I am trying to use to pull from the database, unserialize and display.

[code]
function get_open_requests($uID)
{

$status = 1;

$query = "SELECT playersID FROM requests WHERE uID = $uID AND status = $status";
$pull = mysql_query($query);

$players = unserialize($pull);

print_r($players);

}[/code]

What am I doing wrong?
Link to comment
Share on other sites

Hello the problem lies in this section of your code

Your code:
[quote]
function get_open_requests($uID)
{

$status = 1;

$query = "SELECT playersID FROM requests WHERE uID = $uID AND status = $status";
$pull = mysql_query($query);

$players = unserialize($pull);

print_r($players);

}
[/quote]

Completed fixed code:
[quote]
function get_open_requests($uID)
{
$status = 1;
$query = "SELECT playersID FROM requests WHERE uID = '$uID' AND status = '$status'";
$pull = mysql_query($query);
$row = mysql_fetch_assoc($pull);
$players = unserialize($row['playersID']);
print_r($players);
}
[/quote]

always remember a mysql_query stored into a variable storeds its RESOURCE ID # not the values obtained from the table. And always encapsulate your variables in a select or insert statment with ' ' single quotes

Hope this helps ya
cheers
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.