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

Linux, Apache, MySQL, PHP

 
QuestionOnly Home page opening after going live Pin
Member 1275803925-Sep-16 20:28
MemberMember 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
Membersamflex15-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
Membersamflex15-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 
samflex wrote:
First off, I am using a hash.
$pass = md5($pass);

An unsalted MD5 hash doesn't offer much protection:
Troy Hunt: Our password hashing has no clothes[^]


samflex wrote:
check whether username and / or password is correct and redirecting to appropriate page

As I said, use two steps:

1) Validate the username and password:
SQL
SELECT 
    u.empl_first, 
    u.username, 
    u.empl_first +' '+ u.empl_last as fullname, 
    e.Department, 
    e.UnitName, 
    e.empnum 
FROM 
    users u 
    INNER JOIN Employee e 
    ON u.Employee_Id = e.EmpNum 
WHERE 
    u.USERNAME = ? 
And 
    u.PASSWORD = ?

If no data is returned, then the username or password is invalid.


2) Check whether the user has completed the test:
SQL
SELECT Employee_Id FROM tblTBA WHERE Employee_Id = ?

If no data is returned, then the user has not taken the test.


NB: If the Employee record doesn't get created until the user has taken the test, then you'll need to move that part of the query from step 1 to step 2.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
samflex15-Sep-16 9:10
Membersamflex15-Sep-16 9:10 
GeneralRe: I am really stumped on how to check if user exists and redirects. Pin
samflex15-Sep-16 10:30
Membersamflex15-Sep-16 10:30 
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
Membersamflex15-Sep-16 11:14 
QuestionButton working on second click and not first. Pin
Member 1189879629-Aug-16 4:51
MemberMember 1189879629-Aug-16 4:51 
AnswerRe: Button working on second click and not first. Pin
Planet Thomas4-Jul-17 1:22
MemberPlanet Thomas4-Jul-17 1:22 
QuestionPassing Values to the next Page in PHP Pin
Androoidhotspot Hotspot19-Aug-16 2:28
MemberAndrooidhotspot Hotspot19-Aug-16 2:28 
AnswerRe: Passing Values to the next Page in PHP Pin
ZurdoDev19-Aug-16 3:26
professionalZurdoDev19-Aug-16 3:26 
QuestionBasic Join Not Working Pin
Django_Untaken19-Aug-16 0:43
MemberDjango_Untaken19-Aug-16 0:43 
SuggestionRe: Basic Join Not Working Pin
Richard MacCutchan19-Aug-16 2:00
mveRichard MacCutchan19-Aug-16 2:00 
GeneralRe: Basic Join Not Working Pin
Django_Untaken19-Aug-16 2:17
MemberDjango_Untaken19-Aug-16 2:17 
GeneralRe: Basic Join Not Working Pin
Richard MacCutchan19-Aug-16 3:14
mveRichard MacCutchan19-Aug-16 3:14 
GeneralRe: Basic Join Not Working Pin
johnjonny10-Oct-16 8:18
Memberjohnjonny10-Oct-16 8:18 
Questionassignment Pin
Eto'o3-Aug-16 12:15
MemberEto'o3-Aug-16 12:15 
AnswerRe: assignment Pin
Richard MacCutchan3-Aug-16 22:02
mveRichard MacCutchan3-Aug-16 22:02 
QuestionGoogle Translate facility Pin
Member 1264382519-Jul-16 18:51
MemberMember 1264382519-Jul-16 18:51 
AnswerRe: Google Translate facility Pin
Richard MacCutchan19-Jul-16 22:39
mveRichard MacCutchan19-Jul-16 22:39 

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.