PHP - Stupid Problem With Basic Editnews.php

So like When somones enter my site it shows them as a guest, but then if they havn't clicked anywere for about 5minutes and then refresh or if somone else refresh it will delete from the active users list because it's been over 5 minutes, but then if that same person refreshes again my script wont catch them as a GUEST AGAIN!! It just shows no one online, none of my if's catch him and put him in the ibf_session table!


Code: [Select]
//check for cookies
//If no username, Is a Guest, Has COOKIE_ID and cookie USER_NAME and COOKIe PASSWORD
if(!isset($_SESSION['user_name']) && !isset($_SESSION['is_guest']) &&
 isset($_COOKIE['user_id']) && isset($_COOKIE['user_name']) && isset($_COOKIE['password'])){
$user_cond = "user_name='{$_COOKIE['user_name']}'";

$sql = "SELECT `id`,`user_name`,`approved` FROM users WHERE
           $user_cond
AND `pwd` = '{$_COOKIE['password']}' AND `banned` = '0'
";
$result = mysql_query($sql) or die (mysql_error());
$num = mysql_num_rows($result);
  // Match row found with more than 1 results  - the user is authenticated.
    if ( $num > 0 ) {
list($id,$full_name,$approved) = mysql_fetch_row($result);
if(!$approved) {
echo "YOU FREAKING HACKER";
exit();
}
$_SESSION['user_id']= $id; 
$_SESSION['user_name'] = $full_name;
$lol = session_id();
//$minute5 = 30 ? (time() - 30) : (time() - 3600);
           // mysql_query("DELETE FROM ibf_sessions WHERE running_time < {$minute5}");
mysql_query("INSERT INTO ibf_sessions (id, member_name, member_id, ip_address, running_time, location, member_group) ".
                       "VALUES ('".$lol."', '{$_SESSION['user_name']}', '{$_SESSION['user_id']}', '{$_SERVER['REMOTE_ADDR']}', '".time()."', ".
                       "'Index', '1')") or die(mysql_error());
unset($_SESSION['is_guest']);
   }
}
$lol = session_id();
//Thanks
if (!$id) { //Create Guest Session ~
if (!isset($_SESSION['user_id']) && @(!$_SESSION['is_guest']) && !isset($_COOKIE['password'])) {
//$minute5 = 39 ? (time() - 30) : (time() - 3600);
//echo $minute5;
           // mysql_query("DELETE FROM ibf_sessions WHERE running_time < {$minute5}");

mysql_query("INSERT INTO ibf_sessions (id, member_name, member_id, ip_address, running_time, location, member_group) ".
                       "VALUES ('".$lol."', 'Guest', '0', '{$_SERVER['REMOTE_ADDR']}', '".time()."', ".
                       "'Index', '0')") or die(mysql_error());
    $_SESSION['is_guest'] = 'yes';
}
}
if (isset($_SESSION['user_id']) && !isset($_SESSION['is_guest'])) {
 mysql_query("UPDATE ibf_sessions SET member_name='{$_SESSION['user_name']}',member_id='{$_SESSION['user_id']}',member_group='1', running_time='".time()."', in_forum='".$f."', in_topic='".$topicid."', location='".$act."' WHERE id='".$lol."'") or die(mysql_error());
  }
else {
mysql_query("UPDATE ibf_sessions SET member_name='Guest',member_id='0',member_group='0', running_time='".time()."', in_forum='".$f."', in_topic='".$topicid."', location='".$act."' WHERE id='".$lol."'") or die(mysql_error());

 
 }

Thanks, it might be confusing but re read

Hi, I'm very new to PHP so I hope this is not frustrating. I'm having trouble understanding how "isset" works. I'm trying to get it so that when I click a button, it returns two variables(in an array). This works, but I tried to use "Isset" to detect if a array was created, then alter the variable. It's not working... I'm not too sure where I'm going wrong, could anyone give me some advice? Thanks

<?php 


if(isset($_POST['name']))
{
	$userAnswer = $_POST['name'];
	if(isset($_SESSION['test'])){
			$_SESSION['test'][$userAnswer]['var1']++;
			$test = $_SESSION['test'][$userAnswer];
			foreach ($test as $key){
					echo json_encode($key);
						};
					}
	
	else {
	$test = $_SESSION['test'][$userAnswer]=array("var1" => 1, "var2" => 2);
	
	foreach ($test as $key){
				echo json_encode($key);
				};
	}
}


?>

$(document).ready(function(){
  $("button").click(function(){

                var test = "here";
                $.ajax({
				     url: 'info.php', 
				     type: "POST",
				     dataType:'json', 
				      data: ({name: test}),
				     success: function(data){
				     	     
					 $("#click").fadeOut(function() {
					 		 $(this).append(data);
					 		 
					 }).fadeIn();
					
				     }
				 
					});
  });
  
});

I have a table 'combo' with two fields, id and char. I want to populate a table, with the following query which fails. $sql = mysql_query("SELECT id,char FROM combo ORDER BY id DESC LIMIT 28");  I a bit rusty on sql but can't see what is wrong with this. Can anyone help please.

http://i.imgur.com/6olCy.png
The picture (in the imgur link) pretty much describes what I'm trying to do. As it stands, it would take too long to simply do everything manually with html and css (both of which I'm pretty good at I think), moving all img src and dates from one div tag to another whenever I wanna add something. So yeah, what's the most efficient way to simply submit a picture, and all my other pictures will move?

I know some of you guys will say to just learn php, but quite frankly, I don't have the time... and all the php books are ~1000pgs long which seems really daunting. I know, my problem's pretty basic and it'll probably be covered in the first 100pages or so, but still, like I said I don't have that much time for the moment.

When I do, however, can you guys recommend me the quickest guide/video series/book to learn practical php? Not the most comprehensive, as the stuff I'm going to be doing's not that complex.

One last thing, I've been hearing about CakePHP; what is it? I read that it's an "open source web application framework", but I still have little clue. I'm currently using dreamweaver for all my web stuff (no I do not use the WYSIWYG feature, I just grown accustom to using it). Should I "learn cakephp"?


Please answer any one of those questions (particularly the first one). Many thanks and I'll be sure to reply!

Hello there. Well this problem maybe basic but is kind of annoying me. I havea solution to it which I wil lexplain.

I have created a .php document which has html codes as well. It is a form that provides validation, for arguments sake lets say it is a form that validates if a user has entered their username and password, if not it will produce an error.

The problem I am having is I have embedded the code inside the echo
"
code is here
";
Now I have looked at escape characters and tried afew things, yet it still produces the same error on the same line.

Example

   echo

"      
   
   
   !!!!!!!<form action='book.php' method='post' onsubmit="return checkForm('flogin');">!!!!!!
   The reset of the form is here .....
   
   "";
   echo

The area highlighted in exclamation marks is where the area occurs, due to the quotes.


Any suggestions.


Thanks.