Getting data from session file

[adammc]

Hi guys,

Im a little stuck here and was hoping for some help if possible??

I am trying to extract a product code from a sessions file for use in a MYSQL database query.

This is sample line (entry) from the sessions file:

ABC123 item name 129.95 1 N;

How can i just extract the item number 'ABC123' so I can use it in the query ($inv_query) below?

$session_id = $_SESSION["sessionid"];

$fp = fopen ("./sessions/".$session_id.".dat", "r");
while ($data = fgetcsv ($fp, 500)) {

//setup values from array
    $item_id = $data[0]; //we'll test for this one below to ensure we don't bring in blank rows
    $item_qty = $data[3];

$inv_query = "SELECT * FROM Products_Test WHERE product_id='$item_id'"; 

Any help would be greatly appreciated.

[bhanson]

Hi guys,

Im a little stuck here and was hoping for some help if possible??

I am trying to extract a product code from a sessions file for use in a MYSQL database query.

This is sample line (entry) from the sessions file:

ABC123 item name 129.95 1 N;

How can i just extract the item number 'ABC123' so I can use it in the query ($inv_query) below?

$session_id = $_SESSION["sessionid"];

$fp = fopen ("./sessions/".$session_id.".dat", "r");
while ($data = fgetcsv ($fp, 500)) {

//setup values from array
    $item_id = $data[0]; //we'll test for this one below to ensure we don't bring in blank rows
    $item_qty = $data[3];

$inv_query = "SELECT * FROM Products_Test WHERE product_id='$item_id'"; 

Any help would be greatly appreciated.

I think you're close to what you want. I didn't do any testing, but try changing this line:

while ($data = fgetcsv ($fp, 500)) { 

to

while ($data = fgetcsv ($fp, 500, ' ')) { 

[stuffedbuggy]

if you know that the exact length of the string you're wanting to retrieve within a string, just use...

$stringtosearch ='ABC123 item name 129.95 1 N';
$stringtofind = substr($stringtosearch,0,6);
echo $stringtofind;

In $stringtofind the '0' refers to the starting point of the string, and the '6' refers to how many characters to search for..

[Mark Baker]

There should be absolutely no need to use fread() or its filesystem equivalents to access data in a session file. That's the purpose of $_SESSION

To extract a specific string from that session data, either restructure the way you hold your session data, or the code that stuffedbuggy has posted

[crmalibu]

You could also let php just load the data into $_SESSION for you.

I assume $session_id contains a different session id than the current one being used to associate with the data in _SESSION?

// close/save current session
session_write_close();
// temporarily tell php not to send sess cookies
ini_set('session.use_cookies', false);
// tell php which file to load data from
session_id($session_id);
// load it
session_start();
/*
...do what you may with it...
when you're done, you can close this session like we just did and reload the other one if needed.
*/ 

[maneetpuri]

Hi,

If the session file will always have the first element as the code then you can search in this string the first occurrence of space using stripos(). This will return you the position and now you can fetch a part of the string from the beginning till the position returned. You can use strstr() to get the sub string.

Hope this makes sense to you.

[Raju Gautam]

You could also let php just load the data into $_SESSION for you.

I assume $session_id contains a different session id than the current one being used to associate with the data in _SESSION?

// close/save current session
session_write_close();
// temporarily tell php not to send sess cookies
ini_set('session.use_cookies', false);
// tell php which file to load data from
session_id($session_id);
// load it
session_start();
/*
...do what you may with it...
when you're done, you can close this session like we just did and reload the other one if needed.
*/ 

Yes, I think this is the right way to work with sessions rather than reading the file directly with PHP file sytem functions and extract, etc. I don't know why you (OP) are compelled to do so to retrieve the sessions values by reading the file.