i have following sql database and html page where i want to put username and password. if database have that username then it will say following user is in database and if not then it will say no matches. how can i do with php?
CREATE TABLE module4.password (
eid INT( 10 ) NOT NULL ,
username VARCHAR( 40 ) NOT NULL ,
password VARCHAR( 40 ) NOT NULL
) ENGINE = MYISAM ;
INSERT INTO module4.password (
eid ,
username ,
password
)
VALUES (
'1', 'Aparna', 'passmenow'
), (
'2', 'Arif', 'passme'
), (
'3', 'Hridoy', 'heart'
), (
'4', 'Mithun', 'mypass001'
), (
'5', 'Shimu', 'shimukhan'
);