0

Hello I want to pass the database retrieved username after user logs on & hence to check login correctness I am using php & jsp

<?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>");
 }
?>

But am unable to transfer the usrname so that I can welcome him in next page

3
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by doubledub
0

Before you can use. set, unset, etc any session variables you must first

<? session_start(); ?>

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:

$_SESSION['sname'] = $sname;

.

Retrieving it to display on any other page is now as simple as

echo $_SESSION['sname'];

or for use however.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.