<?php
include 'vars.php';
set_time_limit(0);
putenv("TZ=Asia/Calcutta");
$conn = mysql_connect($hostname,$username,$pass)Or DIE ("Unable to connect to database");
mysql_select_db($dbname, $conn);
global $name,$pass,$userid,$sex,$nam,$password,$flag;
$userid = $_REQUEST['userid'];
$userid=strtoupper($userid);
$password = $_REQUEST['password'];
$query = "SELECT name,password,lastlogin FROM binaryusers where userid = '$userid'";
$res = mysql_query($query)or die ("Bad query: " . mysql_error() );
if (mysql_fetch_row($rs))
{
global $name, $pass, $sex, $nam,$lastlogin;
$nam = mysql_result($res,0,0);
$pass = mysql_result ($res,0,1);
$lastlogin=mysql_result ($res,0,2);
if ($pass==$password&&$userid!='')
{
global $userid,$pass,$lastlogin;
session_start();
$_SESSION['user'] = $userid;
$_SESSION['pass'] = $pass;
$_SESSION['pinlogin']=0;
$_SESSION['lastlogin']=$lastlogin;
$jtime=time();
$query="update binaryusers set lastlogin='$jtime' where userid='$userid'";
mysql_query($query);
echo "<meta http-equiv=\"REFRESH\" content=\"0;url=memberlogin.php\">";
}
else
{
  echo "userid or password is incorrect";
}
}
else
{
  echo "userid or password is incorrect";
}
?>

Recommended Answers

@vinodpaul

No database selected error Plz help

You know it would be nice if you can discussed more about the issue rather than just showing the code?

Jump to Post

All 4 Replies

Member Avatar

@vinodpaul

No database selected error Plz help

You know it would be nice if you can discussed more about the issue rather than just showing the code?

Are you sure $dbname contains the right database name?

hi
please indent your code. Makes it easier to read.
Check the following variables and verify they are correct.
$dbname
$pass
$username
$hostname
One of them must be wrong!
Post back if this works or when you get a solution.

Try Adding The Following after the first line of code

mysql_select_db("nameofdatabase") or die("Connection Error");
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.