Sessions

[-Karl-]

So in my checklogin.php I have:

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername1");
session_register("mypassword1");
header("location:login_success.php");

}
else {
echo "Wrong Username or Password";
}

 

 

and in login_success.php:

<?
session_start();
if(!session_is_registered(myusername1)){
header( 'Location: ./login.php' ) ;
}
?>

This will then redirect them to the control panel, however, how could I call which username they used, in order to display the correct information as it's different per account. I just can't get my head around it.

 

[Pikachu2000]

Just FYI: session_register() is deprecated as of PHP 5.3.0

[-Karl-]

Oo, what would you suggest I use?

[PFMaBiSmAd]

You use session_start() and set and reference $_SESSION['....'] variables.

 

session_register, session_is_registered, and session_unregister() were depreciated in php4.2 when register_globals were turned off by default, finally throw a depreciated error in php5.3, and have been completely removed in php6.

[-Karl-]

print_r($_SESSION['myusername1']; will return the correct username, but I've tried creating a variable to use this in a MySQL query, but it just won't work >.>

[PFMaBiSmAd]

Define: "but it just won't work"

 

That could mean a dozen different things and be caused by almost an infinite number of different coding. Due to its' general purpose nature, there is not a "one symptom" only has "one cause" relation ship. No one can tell you what is causing your code to "but it just won't work" without seeing your code and knowing exactly what symptom you saw in front of you that makes you think that it is not working.

[-Karl-]

Okay so I've tried $username = print_r($_SESSION['myusername1'];

 

Then tried using that in a MySQL query, printing the Session normally returns the username.

 

But when placed in a Query, $sql = "SELECT * FROM database WHERE `username` = '$username'"; The page returns blank.

[SaMike]

Okay so I've tried $username = print_r($_SESSION['myusername1'];

 

Then tried using that in a MySQL query, printing the Session normally returns the username.

 

But when placed in a Query, $sql = "SELECT * FROM database WHERE `username` = '$username'"; The page returns blank.

Try this:

$username = $_SESSION['myusername1'];
$sql = "SELECT * FROM database WHERE `username` = '{$username}'";

[-Karl-]

So here's part of my code:

 

   // first grab the username
   $username = $_SESSION['myusername1'];
   
   // second query for that username
   $query = "SELECT * FROM `users` WHERE `username` = '{$username}'";
   $run = mysql_query($query);
   if($run){
      
      // third display the information
      $arr = mysql_fetch_assoc($run);{
?>

<div style="margin-left:20px; margin-top:20px; margin-bottom:20px;">
<fieldset>
<legend>Clan Specific Information</legend>
<label for="clanname">User Name:</label><input name="clanname" value="{$arr['username']}" type="text" id="clan" onkeyup="checkUsernameForLength(this);" />
<span class="hint">User names cannot be longer than 50 characters, this can be edited in the administrator section.</span>
</fieldset>

 

The thing is, the page loads, but there's nothing displayed, just a blank version of my template basically.

[SaMike]

Try this:

   $query = "SELECT * FROM `users` WHERE `username` = '{$username}'";
echo $query;

Then copy the query you got, go to phpmyadmin and run it to test if it returns any rows.

[-Karl-]

Try this:

   $query = "SELECT * FROM `users` WHERE `username` = '{$username}'";
echo $query;

Then copy the query you got, go to phpmyadmin and run it to test if it returns any rows.

The query echos correctly and it runs in PhpMyAdmin.

[SaMike]

do you have error reporting on? it would explain blank page if there's error in your coding.

You can test it by making new file debug.php :

<?php
ini_set("display_errors", 1);
error_reporting (E_ALL ^ E_NOTICE);
include('index.php');
?>

Just replace index.php with the file your working with. Does it still print out blank page?

[-Karl-]

do you have error reporting on? it would explain blank page if there's error in your coding.

You can test it by making new file debug.php :

<?php
ini_set("display_errors", 1);
error_reporting (E_ALL ^ E_NOTICE);
include('index.php');
?>

Just replace index.php with the file your working with. Does it still print out blank page?

 

It still prints out the template, with no information in it.

[-Karl-]

Also, what can I do about the deprecated function session_register?

[Pikachu2000]

I know that isn't the whole script, but I don't see where you call mysql_connect(), or mysql_select_db(). Are you sure the query is executing?

 

$run = mysql_query($query) or die( mysql_error() );

[Pikachu2000]

You replace session_register() by assigning session variables thusly: $_SESSION['variable'] = "value";