need help bad, going crazy

[twinrecords]

I am building a music community website, been working on it for over a month, I am now stuck.

The registration works fine, everything gets written to the database, including the id info, which is what I am having problems with.

I am using a flash header to login, the flash movie also uses a php script to detect wether or not u are logged in, if not it displays email and password fields, if u are logged in, it displays three buttons, view, edit, and logout, now here is where I am having problems, when I log in, go to the profile.php page, there is nothing, none of the info written to the database is showing up, it does show up if I manually put the id number into the page, but not through the php scripting, a couple of guys and myself have been trying to debug it over at sitepoint, but all we could figure out is that it is not grabbing and implementing the id properly, so I put in some code to show me where the id comes from and where it becomes invalid, and this is what it output:

id from SESSION:
id after ` filter: 0
Invalid member

now obviously this means that the session was never even started properly, so here is my php code for the profile.php page, I am omitting the html since that (as of yet) is not causing a problem.

<?php 
session_start(); 


include_once "scripts/connect_to_mysql.php";

$id = "";
$username = "";
$firstname = "";
$lastname = "";
$country = "";    

$state = "";
$city = "";
$zip = "";
$bio_body = "";
$bio_body = "";
$website = "";
$youtube = "";
$user_pic = "";
$blabberDisplayList = "";


if (isset($_GET['id'])) { 
     echo "id from GET: " . $_GET['id'] . "<br>"; //debug
     $id = (int) $_GET['id']; 

} else if (isset($_SESSION['id'])) { 
     echo "id from SESSION: " . $_SESSION['id'] . "<br>"; //debug     

     $id = (int) $_SESSION['id']; 

} else { 

   include_once "index.php"; 
   exit(); 
} 
$id = str_replace('`', '', $id);
     echo "id after ` filter: $id<br>"; //debug

$id = (int)$id; 
if( $id == 0 ) { 
  exit('Invalid member'); 
}    

$sql = mysql_query("SELECT * FROM myMembers WHERE id=$id");

while($row = mysql_fetch_array($sql)){


$username = $row["username"];
$firstname = $row["firstname"];
$lastname = $row["lastname"];
$country = $row["country"];	
$state = $row["state"];
$city = $row["city"];
$zip = $row["zip"];
$email = $row["email"];
//$email = "<a href=\"mailto:$email\"><u><font color=\"#006600\">Mail</font></u></a>";	
$sign_up_date = $row["sign_up_date"];
$sign_up_date = strftime("%b %d, %Y", strtotime($sign_up_date));
$last_log_date = $row["last_log_date"];
$last_log_date = strftime("%b %d, %Y", strtotime($last_log_date));	
$bio_body = $row["bio_body"];	
$website = $row["website"];
$youtube = $row["youtube"];

$check_pic = "members/$id/image01.jpg";
$default_pic = "members/0/image01.jpg";
if (file_exists($check_pic)) {
$user_pic = "<img src=\"$check_pic\" width=\"300px\" />";
} else {
$user_pic = "<img src=\"$default_pic\" width=\"300px\" />";
}

if ($youtube == "") {
$youtubeChannel = "<br />This user has no YouTube channel yet.";
} else {
$youtubeChannel = ' <script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/youtube.xml&amp;up_channel=' . $youtube . '&amp;synd=open&amp;w=290&amp;h=370&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;output=js"></script>  '; 
}	

} 
$style_sheet = "default";

?>

[samuelcook]

i know this may be a dumb question, but presumably you are setting the session['id'] variable on registration correct?

If so, are you ensuring that you are starting the session before you set the session['id'] variable in your registration?

If this isn't the problem, could there possibly be an issue with your flash->php files, where it is overwriting or unsetting the session, as "id" is a very common name. Same goes for your includes to your db_connect file.

[twinrecords]

samuelcook;10981270 wrote:

i know this may be a dumb question, but presumably you are setting the session['id'] variable on registration correct?

If so, are you ensuring that you are starting the session before you set the session['id'] variable in your registration?

If this isn't the problem, could there possibly be an issue with your flash->php files, where it is overwriting or unsetting the session, as "id" is a very common name. Same goes for your includes to your db_connect file.

the id variable gets written to the database during the registration, but the user is not automatically logged in, they must activate through email, then login. Now, if I manually put the id in the page, http://www.twinrecords.net/profile.php?id=1 that works just fine, but the php way doesn't. Might be something with the call $_SESSION somewhere in the login or checkuserlog file, my brain is so fried, I have no idea

[samuelcook]

and they log in through flash?

it has to be something within the flash to php module. i recommend reading up on the documentation for the "plugin/addon" that your using.

additionally try simple things like

<?
print_r( $_SESSION );
print_r( $_COOKIE );
?>

that might have some insight

[twinrecords]

yeah I've done that, as3 and php are working ok together, it's something else.

I'll try the code you posted and see where we end up

[twinrecords]

ok, I tried the code you posted this is the output, of course I will block some of it.

Array ( [id] => 2 [firstname] => Cory [email] => ***@.net ) Array ( [PHPSESSID] => 79b0277602eed355cf1efdc1a889d300 )

so it does seem to be getting the id then, I notice when I do login, it just goes to profile.php instead of profile.php?id=2

[samuelcook]

alright, so it does appear to be holding onto the session when the page loads.

and it is hitting the if( $_SESSION ) conditional statement

again, try posting the print_r( $_SESSION ) inside of the if statement, and make sure that it is still tehre.

if (isset($_GET['id'])) {
     echo "id from GET: " . $_GET['id'] . "<br>"; //debug
     $id = (int) $_GET['id'];

} else if (isset($_SESSION['id'])) {
     print_r( $_SESSION );
     echo "id from SESSION: " . $_SESSION['id'] . "<br>"; //debug     

     $id = (int) $_SESSION['id'];

} else {

   include_once "index.php";
   exit();
} 

additionally if it is automatically going to profile.php and the session is being held it appears it is doing what it is supposed to, correct?

and after $id make sure that $_SESSION['id'] is present. i see that you are using (int) when you set the id, and then again before you do your sql statement, trying removing the (int) in the if statement

[twinrecords]

ok, I tried putting the code in it's usual position, and it did not maintain the id, but if I put it just after the include_once for the db connect, it still had it there, although it gave me a warning abut the mysql resource, so when I put it back where it should be, it loses the id session

<?php 
session_start();
include_once "scripts/connect_to_mysql.php";

$id = "";
$username = "";
$firstname = "";
$lastname = "";
$country = "";    

$state = "";
$city = "";
$zip = "";
$bio_body = "";
$bio_body = "";
$website = "";
$youtube = "";
$user_pic = "";
$blabberDisplayList = "";

if (isset($_GET['id'])) { 
     echo "id from GET: " . $_GET['id'] . "<br>"; //debug 
     $id = (int) $_GET['id']; 

} else if (isset($_SESSION['id'])) { 
     print_r( $_SESSION ); 
     echo "id from SESSION: " . $_SESSION['id'] . "<br>"; //debug      

     $id = (int) $_SESSION['id']; 

} else { 

   include_once "index.php"; 
   exit(); 
}  


$sql = mysql_query("SELECT * FROM myMembers WHERE id=$id");

while($row = mysql_fetch_array($sql)){


$username = $row["username"];
$firstname = $row["firstname"];
$lastname = $row["lastname"];
$country = $row["country"];	
$state = $row["state"];
$city = $row["city"];
$zip = $row["zip"];
$email = $row["email"];
//$email = "<a href=\"mailto:$email\"><u><font color=\"#006600\">Mail</font></u></a>";	
$sign_up_date = $row["sign_up_date"];
$sign_up_date = strftime("%b %d, %Y", strtotime($sign_up_date));
$last_log_date = $row["last_log_date"];
$last_log_date = strftime("%b %d, %Y", strtotime($last_log_date));	
$bio_body = $row["bio_body"];	
$website = $row["website"];
$youtube = $row["youtube"];

$check_pic = "members/$id/image01.jpg";
$default_pic = "members/0/image01.jpg";
if (file_exists($check_pic)) {
$user_pic = "<img src=\"$check_pic\" width=\"300px\" />";
} else {
$user_pic = "<img src=\"$default_pic\" width=\"300px\" />";
}

if ($youtube == "") {
$youtubeChannel = "<br />This user has no YouTube channel yet.";
} else {
$youtubeChannel = ' <script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/youtube.xml&amp;up_channel=' . $youtube . '&amp;synd=open&amp;w=290&amp;h=370&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;output=js"></script>  '; 
}	

} 
$style_sheet = "default";

?>

[twinrecords]

and this is the output:

"Array ( [id] => [firstname] => [email] => ********@.net ) id from SESSION: "

[twinrecords]

I finally figured out what was wrong, I declared the id in my session so there was no need to call a variable for it, it was there from the session start and got overwritten by the variable, so I just commented out the $id = " "; line and it works just fine.

[samuelcook]

debugging is half the fun