2. PHPRunner General questions
  3. How to copy data from database table
This topic is locked

How to copy data from database table

 		11/26/2007 5:22:21 AM
PHPRunner General questions
W
 wlodek author

Hi,
How to copy data from database table user:
First name

Last name
Alexey admin 11/26/2007

Wlodek,
add this code to After Successful Login event:

$_SESSION["lastname"]=@$data["Last name"];

$_SESSION["firstname"]=@$data["First name"];


Then put this line to List page: Before displayevent:

$smarty->assign("userid",$_SESSION["firstname"]." ".$_SESSION["lastname"]);
W
 		wlodek author 11/26/2007

add this code to After Successful Login event:

$_SESSION["lastname"]=@$data["Last name"];

$_SESSION["firstname"]=@$data["First name"];



Then put this line to List page: Before displayevent:

$smarty->assign("userid",$_SESSION["firstname"]." ".$_SESSION["lastname"]);



Where add this code?
I'm sorry , I know English language faintly
I greet,
W
 		wlodek author 11/28/2007

I ask, help me!
J
 		Jane 11/28/2007

Wlodek,
add this code to your page on the Visual Editor tab --> HTML mode:

First Name: {$firstname}<br/>

Last Name: {$lastname}<br/>

Then add List page: Before display event on the Events tab.

Here is a sample:

global $conn;

$rs = db_query("select FirstName,LastName from UsersTable where UserName='".$_SESSION["UserID"]."'",$conn);

if ($data = db_fetch_array($rs))

{

$smarty->assign("firstname",$data["FirstName"]);

$smarty->assign("lastname",$data["LastName"]);

}



where FirstName, LastName and UserName are your actual field names, UserName is user login name.
W
 		wlodek author 11/28/2007

Yes, yes, yes!!! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=23724&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Very, it thanks very.
I greet