PHP - Paged Data Retrieval Is Breaking My Session.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=358972.0

First of all... this is a GREAT forum. Been lurking around here for a long time and searched all over but still can't find a solution to a problem I'm facing.

Here's my cURL code - I am basically retrieving data from a web site:
<?php

$curl_handle=curl_init();
curl_setopt($curl_handle,CURLOPT_URL,'http://myprimemobile.com/update.html');
curl_setopt($curl_handle,CURLOPT_CONNECTTIMEOUT,2);
curl_setopt($curl_handle,CURLOPT_RETURNTRANSFER,1);
$buffer = curl_exec($curl_handle);
curl_close($curl_handle);

if (empty($buffer))
{
    print "Connection Timeout<p>";
}
else
{
    print $buffer;
}
?>

If you take a look at the site http://myprimemobile.com/update.html -- it will begin to update new information. I want to basically retrieve the data from that page but in my own way.

I want to loop through the page and search for all the names, addresses, and phone numbers only (not store hours or anything else), and want to put it in a variable so I can create a table with all that information on my page.

Based on the code, all the information is stored in the $buffer variable. I want to break this variable down to extract certain data in a 'div' or a 'table'. Please help me out. Thanks!

Ok guys and girls,

What I am tryting to do is when a user logs into my site and starts a session I would like to display some information about that user. The information displayed needs to be dynamic as this site will only have a few users buy I dont users viewing other users information.

So far I have this code to process the login and start the session:
<?php
include("php/dbconnect.php"); //connects to the database when connected

//get the username and password from the login form on the index page
$username=$_POST['username'];
$password=$_POST['password'];

//stop an MySQL Injection by removing slashes and real_escape
$myusername = stripslashes($username);
$mypassword = stripslashes($password);
$myusername = mysql_real_escape_string($username);
$mypassword = mysql_real_escape_string($password);

//Select users from the database that match the password and username
$sql="SELECT * FROM users WHERE username='$username' and password='$password'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row 
if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php" or such file
session_register("username");
session_register("password"); 
session_start();

//echo section test
//echo "details ok";

header("Location: http://webdev/schools/hhs/psy_bookings/memberspage.php");
}
else {
echo "Wrong Username or Password";
}
mysql_free_result($result);
?>

And when they successfuly login into the members page to keep the session active I have the following code:

<?php

//////////////////////check the the user has logged in and allowed to view the pages///////////////////////
session_start();

//check to make sure the session variable is registered
if(session_is_registered('username')){

//the session variable is registered, the user is allowed to see anything that follows

echo 'Welcome, you are still logged in.';//test echo
}
else{

//the session variable isn't registered, send them back to the login page
header( "Location: http://webdev/schools/hhs/psy_bookings/" );
}
////////////////////////////////////end of session data code///////////////////////////////////////////////

?>

What I would like is to be able to display the users name on the page and maybe call their email from the db. Thanks in advance as always

Trying to create a simple login page (and my code is embarassingly disgraceful at this point).

In simple terms, I have start_session on three pages.

The first page asks for name, the second for password, the third welcomes user.

The second page contains

$name=$POST['name'];
$_SESSION['name']= $name;

When I access the page 2, the name is echoed with a greeting and request for password.

But after a password submission (whether correct or incorrect) the $name disappears.

I am at a loss for why it is not being refreshed or maintained in the session.

Any ideas for me?

Hi, I have stored user data in the database, but I think I need to somehow grab the "id" of the username, and use that in a SESSION when they log in, so that I can pull up the user information in the database for that particular user when they log in. and do that for everyone when they log in. My idea is


user logs in

Something like "grab the user "id" linked to this user, and add that value to "$currentUser",

then somehow when it is time to show their user profile page, I do something like

"display all field data where username=$currentUser.


I don't know I am confused, any help plus code would be great if anyone can help, or just the pseudocode would be good. I hope I explained it right. thanks.

 

I run MAMP and would like to know where I can find and view the data stored in my Sessions?

Any ideas?

Thanks,


Debbie

merry christmas everybody   i have shopping basket, i put many items in it per session. i want get the heighst shipping1 value from session but i dont know how. i tryed last 3 day without success. now i get the following value for shipping1 2 3.90 5 6.90   but i see only 6.90 as it is the heighst shipping1 in basket.   thank you very much for your help   here is my code

foreach ($_SESSION["products"] as $cart_itm)
{
$inventor = $cart_itm["code"];
$shippall = $cart_itm["shipping1"];
$query1 = "SELECT MAX(shipping1) FROM $table1 WHERE inventar='$inventor'";
$result1 = $link1->query($query1) or die ("Database Error!");
$row = mysqli_fetch_row($result1);
echo $shippall."<br>";
}

Here is my code...

Code: [Select]
<?php
mysql_connect("localhost", "user", "pass")or die("cannot connect"); 
mysql_select_db("database")or die("cannot select DB");
 
$myemail = mysql_real_escape_string($_POST['myemail']);  
$mypassword = mysql_real_escape_string($_POST['mypassword']); 
$mypassword = md5($mypassword);

$myemail = stripslashes($myemail);
$mypassword = stripslashes($mypassword);

$sql="SELECT * FROM users WHERE email='$myemail' and password='$mypassword'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count==1){
session_start();  
$_SESSION["myemail"]= "$myemail"; 
header("location:home.php");
}
else {
header("location:fail.php");
}
?>
What can I do to this code so that it will also store first name from the database inside a session?

Alright, So i want to pass a session from www.mysite.com to mobile.mysite.com

And i'm doing so by calling this on the top of every page on each site:

<?php
session_set_cookie_params(360000, "/",".mysite.com");
session_start();
print_r($_SESSION);
?>


yet, the session data that is set on one subdomain is NOT printed on the other subdomain. I've even tried destroying the sessions several times to start over. But it won't work.

What could be up?

Thanks

Hello

I have included a simple login system into my website. When a user logs in, a session is started and he stays connected throughout the whole website until logging out again. The user logs in via his e-mailaddress and a password, which are stored in a mysql database.

Now I want to add a page on which a user that is logged in, can see and edit his own information (password, cellphone number, e-mail, etc.). Or easier: instead of showing "Welcome!" showing "Welcome, John!".

I thought about storing the e-mailaddress into the session, and then trying to access it to select the correct record (to edit afterwards). But so far, I haven't booked any success. I have to say that this is the first time I'm working with sessions as well, so this is very new to me.

Thank you in advance for any help!

warning: I'm a self taught advanced newbie.

I'm working on a multipage PHP app that has need to pass values between pages, usually very small text strings or small integers.  I've designed it primarily using _SESSION variables to pass these bits of data.  Some of them are written to SQL, but most of them are temporary in nature.

Is using _SESSION variables in this capacity considered reasonable?  Is there something else or a different way to go about this?

(Page A writes a value into $_SESSION['myvalue'], and then page B grabs that data and does something with it.)

I want to use session to do a query and will I be able to do this?

I have a session that was gathered from login and now i was to use this session to do a query

If Yes, How?

Hey all,

I am having a situation where I have a singleton class with a static array in it.  I insert an element into that array, and then I redirect the user to another page.  At that page, I then retrieve that array (it's stored in the session vars), but the array is then empty when I retrieve it.  I can't figure out why.

Here are some pertinent code snippets.

First, the class with the static array:

class Logger
{

private static $instance = NULL;

private static $messages = array();

//Private constructor to prevent this class from being instantiated multiple times

private function __construct()

{

}

//The clone function is private to prevent cloning of this class

private function __clone()

{

}

//Returns the singleton instance of this class

public static function GetInstance()

{

if (!self::$instance)

{

self::$instance = new Logger;

}

return self::$instance;

}

public static function GetMessageCount()

{

return count(self::$messages);

}

public static function LogMessage($new_message)

{

self::$messages[] = $new_message;

}

public static function GetMessages()

{

return self::$messages;

}

public static function ClearMessages()

{

self::$messages = array();

}
}


Here is the code where I insert something into the aformentioned array (the process is that a user tries to log in, but the login fails, and so we insert a message into the array saying that the login credentials failed).


//Retrieve the message logging instance from the session data to be able to pass messages to the user.
$message_log = $_SESSION['user_messages'];
$user = $_SESSION['user_account'];

//Create a new instance of the database management class and
//try to connect to the database
$dbm = new DBM();
if ( !$dbm->isConnected() )
{

$message_log::LogMessage("We are sorry, but we are unable to access the database at this time.  Please try again later.");
}
else
{

//Retrieve the user login information

$useremail_dirty = $_POST['useremail'];

$password_dirty = $_POST['userpassword'];

//Check to see if the email we were given exists in the database, and if the password matches

$doesPasswordMatch = $dbm->doesPasswordMatch ( $useremail_dirty, $password_dirty );

if ( $doesPasswordMatch )

{

//Correct login information was received.  Login the user and redirect appropriately.

$user->Login();

header ( "Location: ".BASE_URL."/userpage.php" );

exit;

}

else

{

//If an incorrect email or password was given, report that information to the user.

$message_log::LogMessage("Incorrect login information.");

}
}

//The user has failed to login.  Redirect to the appropriate page.
header ( "Location: ".BASE_URL."/loginfailed.php" );


And finally, given an unsuccessful login attempt, this is where I pick back up the array of messages to display the messages to the user:

$message_log = $_SESSION['user_messages'];
$all_messages = $message_log::GetMessages();

print $message_log::GetMessageCount()."<br>";
print count($all_messages)."<br>";

foreach ($all_messages as $message_string)
{

$prepared_string = prepare_text_for_html_output($message_string);

echo $prepared_string."<br>";
}

$message_log::ClearMessages();


Unfortunately, the "all_messages" variable has nothing in it...it's like the messages that I logged in the previous PHP script never even existed.  I am calling session_start, so don't worry about that (even though it's not seen in these code snippets).  What could be going wrong?

Hello,
I've been hacking at this for about 5 hours, and have been unable to get my session data to pass through to the 3rd page. Here is my code. As you can see I've been trying all types of variation of retrieval. On page 2 I can pull the data from page 1 fine with REQUEST or the longer version.. But for some reason page 3 will not display the first_name and last_name... I'm desperate at this point. I have not been able to find a working answer. I'm running php 5 w/ trans... OFF (default) in .ini.

Page 1
Code: [Select]
<?php session_start(); ?>
<?php
$PHPSESSID = session_id();
echo "<strong>Session ID:</strong> $PHPSESSID"; "<br /><br />";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>0</title>
</head>
<body>
<form method="post" action="multi_page_post_2.php">
<label>First Name</label>
<input name="first_name" value="" width="50" type="text" />
<br /><br />
<label>Last Name</label>
<input name="last_name" value="" width="50" type="text" />
<br /><br />
<input type="submit" name="submit" value="Enter your Data - Continue to Step 2 >>" />
</form>
</body>
</html>
Page 2
Code: [Select]
<?php session_start(); ?>
<?php
$PHPSESSID = session_id();
echo "<strong>Session ID:</strong> $PHPSESSID";
$first_name = $_REQUEST['first_name'];
echo $first_name;
?>
<?php echo "<br /><br />"; print_r($_SESSION); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Step 2</title>
</head>
<body>
<h2>Step 2 - Is this data correct?</h2>
<hr />
<strong>First Name:</strong> <?php echo $_SESSION['first_name'] = $_POST['first_name']; ?>
<br /><br />
<strong>Last Name:</strong> <?php echo $_SESSION['last_name'] = $_POST['last_name']; ?>
<br /><br />
<form method="post" action="multi_page_post_3.php">
<label>Sons First Name: </label>
<input name="sons_first_name" value="" width="50" type="text" />
<br /><br />
<input type="submit" name="submit" value="YES! Continue to Step 3 >>" />
&nbsp;
<input type="hidden" name="PHPSESSID" value="<?php echo $PHPSESSID ?>" />
<input type="button" value="No! Back to Previous Page" onClick="javascript: history.go(-1)">
</form>
<br /><br />
<a href="" onclick="<?php session_destroy(); ?>">Session D E S T R O Y !</a>
</body>
</html>

Page 3
Code: [Select]
<?php session_start(); ?>
<?php
$PHPSESSID = session_id();
echo "<strong>Session ID:</strong> $PHPSESSID";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Step 3</title>
</head>
<body>
<h2>Step 3 - Is this data correct?</h2>
<hr />
<strong>First Name:</strong> <?php echo $_SESSION['first_name'] = $_REQUEST['first_name']; ?>
<br /><br />
<strong>Last Name:</strong> <?php echo $_SESSION['last_name']; ?>
<br /><br />
<strong>Sons First Name:</strong> <?php echo $_REQUEST['sons_first_name']; ?>
<br /><br />
<form method="post" action="multi_page_post_4.php">
<input type="hidden" name="PHPSESSID" value="<?php echo $PHPSESSID ?>" />
</form>
<br /><br />
<a href="" onclick="<?php session_destroy(); ?>">Session D E S T R O Y !</a>
</body>
</html>