I need to populate some default values on a table called ex. Book. I have a users table that has the name of the person group and student #. In asp see the following code below . I just grabbed the users table set the userid to session userid and sessioned all the fields that I needed from the users table. In PhP I am having problems : see below asp code......
str = "select * from Employees where Userid='" & Session("UserID") & "'"
Set rsTemp = server.CreateObject("ADODB.Recordset")
rsTemp.open str, dbConnection
Session("employeenumber")= rsTemp("employeenumber")
Session("Firstname") = rsTemp("Firstname")
Session("Lastname") = rsTemp("Lastname")
Session("DepartmentName") = rsTemp("DepartmentName")
Session("EmailName") = rsTemp("EmailName")
rsTemp.close : set rsTemp = nothing
Just thought I would start it as they logged in so it was global. Any ideas . this is blowing out " undefined $_Session variable error. example default value would be $_Session["fldnum"] returns null value or nothing.
PHP
function AfterSuccessfulLogin($username, $password, $data)
{
$_SESSION["fldnum"] = $data["fldnum"];
$_SESSION["fldgroup"] = $data["fldgroup"];
$_SESSION["fldteam"] = $data["fldteam"];
$_SESSION["fldlevel"] = $data["fldlevel"];
$_SESSION["fldemail"] = $data["fldemail"];
$_SESSION["fldfirst"] = $data["fldfirst"];
$_SESSION["fldlast"] = $data["fldlast"];
}
- Do I need to call the db here even after login
- The login table has all the field above
- To you need to start session and end session here or does phprunner do that auto.
- DO I need sql statement instead?
Thanks for the replies!