•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 402,001 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,424 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 1185 | Replies: 4
![]() |
•
•
Join Date: Aug 2006
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Hello I want to pass the database retrieved username after user logs on & hence to check login correctness I am using php & jsp
But am unable to transfer the usrname so that I can welcome him in next page
php Syntax (Toggle Plain Text)
<?php $conn= mysql_connect("localhost", "root", ""); if(!$conn){ exit("Error in SQL"); } mysql_select_db("college", $conn); $val1=$_REQUEST['login1']; $val2=$_REQUEST['password1']; $sql = "SELECT * FROM tlogin WHERE tid='$val1' AND tpasswd='$val2'"; $rt = mysql_query($sql, $conn); $num = mysql_num_rows($rt); if($num==0){ print("<script language='javascript'>"); print("window.location='index.html';"); print("alert(\"Incorrect username or password...\")"); print("</script>"); } else { mysql_select_db("college", $conn); $row= mysql_fetch_array($rt); $tname=$row['$tname']; $_POST['$tname']; URL=http://172.31.81.150/teacher.php?exvar='$tname'; //$sql = "SELECT sname FROM register WHERE regno=$val1"; //$rt=mysql_query($sql,$conn); //$a_row = mysql_fetch_array( $rt ); //$sname=stripslashes($a_row['sname']); //echo urlencode($_GET['sname']); //session_register("username"); //username = "$sname"; //$_SESSION[$sname]="$sname"; setcookie("auth", "1", 0, "/", "", 0); //print("<script language='javascript'>"); //print("window.location='teacher.php';"); //print("</script>"); } ?>
Last edited by iamthwee : Jul 1st, 2007 at 4:06 am.
Member of: F-ugly code club
Join today don't delay!
Join today don't delay!
•
•
Join Date: Aug 2006
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
unable to find correct solution
I guess a simple example would be...
pass.php
temp.php
Which should display the word hello, which is passed from pass.php (the first url) to the second url.
Straight from php man
http://ca3.php.net/variables.external
pass.php
<a href="temp.php?var=hello">test</a>temp.php
<?
echo $_GET['var'];
?>
Which should display the word hello, which is passed from pass.php (the first url) to the second url.
Straight from php man
http://ca3.php.net/variables.external
Last edited by iamthwee : Jul 2nd, 2007 at 3:32 pm.
Member of: F-ugly code club
Join today don't delay!
Join today don't delay!
•
•
Join Date: Jul 2007
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Before you can use. set, unset, etc any session variables you must first on each page using sessions.
This is required and no session vars can be used otherwise. Its good practice to have at the top of your pages so you don't forget it.
Assuming that your query is pulling the correct data, define the session variable without the dollar sign and with single quotes like: .
Retrieving it to display on any other page is now as simple as or for use however.
php Syntax (Toggle Plain Text)
<? session_start(); ?>
This is required and no session vars can be used otherwise. Its good practice to have at the top of your pages so you don't forget it.
Assuming that your query is pulling the correct data, define the session variable without the dollar sign and with single quotes like:
php Syntax (Toggle Plain Text)
$_SESSION['sname'] = $sname;
Retrieving it to display on any other page is now as simple as
php Syntax (Toggle Plain Text)
echo $_SESSION['sname'];
![]() |
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Similar Threads
- Cast from type 'DBNull" to type 'String' is not valid (ASP.NET)
- passing session object from login page to next page (JSP)
- Losing session variable problem...help! (ASP)
- Passing data from forms from one page to another (JavaScript / DHTML / AJAX)
Other Threads in the PHP Forum
- Previous Thread: reviews,news script
- Next Thread: What's suitable for a MySQLi CALL Statement?



Linear Mode