classes help

[VistaBoy]

Hello i am trying to do this thing but it just dose not want to work

<?php

Class test
{
function call_function($value)
    {
$value = mysql_query("SELECT * FROM users WHERE `username` = '$_SESSION[username]' AND `id` = '$_SESSION[id]' AND `password` = '$_SESSION[password]'");
   $value = mysql_fetch_array($value);
   return $value;
    }
function call_function2($value)
    {
 $value = mysql_query("SELECT * FROM profile WHERE `username` = '$_SESSION[username]'");
   $value = mysql_fetch_array($value);
   return $value;
    }
}
 
$script = new test();

echo("$script->call_function(username)");

?>

But it dose not show the user name ??? when i echo $script->call_function(username)

[Invent]

<?php

class test
{
function call_function()
    {
$value = mysql_query("SELECT * FROM users WHERE `username` = '$_SESSION[username]' AND `id` = '$_SESSION[id]' AND `password` = '$_SESSION[password]'");
   $value = mysql_fetch_array($value);
   return $value;
    }
function call_function2($value)
    {
 $value = mysql_query("SELECT * FROM profile WHERE `username` = '$_SESSION[username]'");
   $value = mysql_fetch_array($value);
   return $value;
    }
}
 
$script = new test;

$var = $script->call_function();
echo $var;

?>

[VistaBoy]

how would that work if your not telling the call_function if to show the username or what ever out of the database.

[Dentafrice,]

because if $_SESSION[username] is set, you don't need to define it in the function, its in the session.

[VistaBoy]

yes but if you look its only SELECT * FROM ...

how will it know to show the username from the table or the userlevel or what ever i want to it show?

[Invent]

Change 'return $value;' to 'return $value["username"];' or something then.

[VistaBoy]

Okay i am trying this anther way

but i keep getting this error
Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';'

and this is the code

$user = mysql_query("SELECT * FROM users WHERE `username` = '$_SESSION[username]' AND `id` = '$_SESSION[id]' AND `password` = '$_SESSION[password]'");
   $user = mysql_fetch_array($user);
  Class abc
{
var $u;
$this->u = $user[username];
}
$script = new abc;

[Invent]

<?php

$query = "SELECT * FROM users WHERE `username` = '$_SESSION[username]' AND `id` = '$_SESSION[id]' AND `password` = 

'$_SESSION[password]'";

$user = mysql_query( $query );

$fetch = mysql_fetch_array( $user );

class abc
{

var $u;

}

$script = new abc;
$script->u = $user[username];

?>

You really need to sort out the way you code, it's horrible.

[Dentafrice,]

Its worse then mine... plus, why are you storing a password, in a session.. is it plaintext or encoded? Very bad security risk.

[Tomm]

As long as its hashed its not a security risk. The only way you can access a session is via PHP or the server and if one of them is compromised then I think you have more to worry about than a hashed password stored in a session.

Its worse then mine... plus, why are you storing a password, in a session.. is it plaintext or encoded? Very bad security risk.