I want to use multiple table query for login

Question

Here is my code that i am trying to query from multiple table but same column data, but not execute this code for success. please help me.

$stmt = $conn->prepare("
    SELECT id, name, department, session, username, email, rudf_position 
    FROM member, executive 
    WHERE username = ? AND mobile = ? ");

What error are you getting? See https://stackoverflow.com/questions/22662488/how-to-get-mysqli-error-in-different-environments — Barmar, Oct 26 '19 at 09:36
if try to login with member table info its OK, but by executive table is not OK. — Saklayen Ahmed, Oct 26 '19 at 09:44
if try to login with membe or executive table , there is no incorrect password or email. just showing nothing — Saklayen Ahmed, Oct 26 '19 at 09:49
You mean the user might be in one table or the other, not both? — Barmar, Oct 26 '19 at 09:50

score 0 · Accepted Answer · answered Oct 26 '19 at 09:51

0

You need to use UNION to search both tables independently.

SELECT id, name, department, session, username, email, rudf_position 
FROM member
WHERE username = ? AND mobile = ?
UNION
SELECT id, name, department, session, username, email, rudf_position 
FROM executive
WHERE username = ? AND mobile = ?

answered Oct 26 '19 at 09:51

Barmar

741,623
53
500
612

not working. show nothing, not showing any incorrect message. – Saklayen Ahmed Oct 26 '19 at 10:00
If you're not getting an error message and it's not returning any results, then there must not be any matches for the username and mobile. – Barmar Oct 26 '19 at 10:01
but from individually table get result successfully – Saklayen Ahmed Oct 26 '19 at 10:05
Did you remember to duplicate the arguments to `bind_param`, since there are now 4 placeholders? – Barmar Oct 26 '19 at 10:06
$stmt->bind_param("ss",$username, $mobile); ...its one line – Saklayen Ahmed Oct 26 '19 at 10:11
But now there are 4 placeholders, it needs to be `$stmt->bind_param("ssss", $username, $mobile, $username, $mobile);` – Barmar Oct 26 '19 at 10:14

I want to use multiple table query for login

1 Answers1