Click here to Skip to main content
15,917,618 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: OOP in PHP Pin
Member 1278820324-Nov-16 2:03
Member 1278820324-Nov-16 2:03 
GeneralRe: OOP in PHP Pin
Afzaal Ahmad Zeeshan24-Nov-16 2:19
professionalAfzaal Ahmad Zeeshan24-Nov-16 2:19 
GeneralRe: OOP in PHP Pin
kribo5-Dec-16 3:26
professionalkribo5-Dec-16 3:26 
AnswerRe: OOP in PHP Pin
Anurag Gandhi5-Dec-16 3:48
professionalAnurag Gandhi5-Dec-16 3:48 
AnswerRe: OOP in PHP Pin
Afzaal Ahmad Zeeshan24-Nov-16 2:21
professionalAfzaal Ahmad Zeeshan24-Nov-16 2:21 
GeneralRe: OOP in PHP Pin
Member 1278820324-Nov-16 3:21
Member 1278820324-Nov-16 3:21 
AnswerRe: OOP in PHP Pin
kribo5-Dec-16 3:32
professionalkribo5-Dec-16 3:32 
GeneralRe: OOP in PHP Pin
Member 127882035-Dec-16 6:30
Member 127882035-Dec-16 6:30 
QuestionRequest: Php 7 Tutorial/Course Recommendation From You Pin
Member 127834388-Oct-16 16:36
Member 127834388-Oct-16 16:36 
QuestionRun multiple PHP versions on same server Pin
manhfh7-Oct-16 6:14
manhfh7-Oct-16 6:14 
QuestionOnly Home page opening after going live Pin
Member 1275803925-Sep-16 20:28
Member 1275803925-Sep-16 20:28 
SuggestionRe: Only Home page opening after going live Pin
Richard Deeming26-Sep-16 2:07
mveRichard Deeming26-Sep-16 2:07 
AnswerRe: Only Home page opening after going live Pin
Richard MacCutchan26-Sep-16 2:48
mveRichard MacCutchan26-Sep-16 2:48 
AnswerRe: Only Home page opening after going live Pin
ZurdoDev26-Sep-16 3:18
professionalZurdoDev26-Sep-16 3:18 
QuestionI am really stumped on how to check if user exists and redirects. Pin
samflex15-Sep-16 7:08
samflex15-Sep-16 7:08 
AnswerRe: I am really stumped on how to check if user exists and redirects. Pin
Richard Deeming15-Sep-16 7:27
mveRichard Deeming15-Sep-16 7:27 
GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
samflex15-Sep-16 7:41
samflex15-Sep-16 7:41 
GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
Richard Deeming15-Sep-16 7:52
mveRichard Deeming15-Sep-16 7:52 
GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
samflex15-Sep-16 9:10
samflex15-Sep-16 9:10 
GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
samflex15-Sep-16 10:30
samflex15-Sep-16 10:30 
Sorry Richard,

I tried doing it separately like you spec'ed it out and it is just not working.

The first part which validates username/password works but when I added the second part, then it doesn't matter whether I have correct username and password, it just takes me to login page.

The code you see here shows I am doing them together again with if...else but that's just what I am trying since separating them isn't working.

PHP
 $user = trim($_POST["user"]);
 $pass = trim($_POST["pass"]);

     // hash to sanitize the input further

//	$tsql = md5($pass);

   $tsql = "SELECT u.empl_first, u.username, u.empl_first +' '+ empl_last as fullname FROM users u WHERE u.USERNAME = ? and u.PASSWORD = ? ";
	//echo $strSQL;
	$params = array($user, $pass);
    $result = sqlsrv_query( $con, $tsql, $params, array(), array( "Scrollable" => 'static' ));

    $row_count = sqlsrv_num_rows($result);
    //echo $row_count;

    if ($row_count == 0){
       header('location:login.php?msg=1');
       exit;

}

else
{
   $tSQL = "SELECT u.empl_first, u.username FROM users u inner join tblTBA t on u.Employee_Id = t.Employee_ID WHERE USERNAME = '".ms_escape_string($user)."'
	and PASSWORD = '".ms_escape_string($pass)."' ";
	echo $strSQL;
    //$params = array($user, $pass);
	$sqll = sqlsrv_query($con, $tSQL);
}
if ($objResult = sqlsrv_fetch_array($sqll, SQLSRV_FETCH_ASSOC)) {
    $firstname = $objResult["empl_first"];
 	$_SESSION["username"] = $objResult["username"];
	header('location:donetba.php?user=' . urlencode($firstname));
  }
  else
    header("location:registered.php?user='".ms_escape_string($user)."'&pass='".ms_escape_string($pass)."' ");
   // header("location:register.php?user=. urlencode($user)&pass=. urlencode($pass)");

sqlsrv_close($con);

?>

GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
Richard Deeming15-Sep-16 10:50
mveRichard Deeming15-Sep-16 10:50 
GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
samflex15-Sep-16 11:14
samflex15-Sep-16 11:14 
QuestionButton working on second click and not first. Pin
Member 1189879629-Aug-16 4:51
Member 1189879629-Aug-16 4:51 
AnswerRe: Button working on second click and not first. Pin
Planet Thomas4-Jul-17 1:22
Planet Thomas4-Jul-17 1:22 
QuestionPassing Values to the next Page in PHP Pin
Androoidhotspot Hotspot19-Aug-16 2:28
Androoidhotspot Hotspot19-Aug-16 2:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.