i have the following form:
User Name: |
|
Password: |
|
<tr>
<td>
<input type="submit" value="Submit"/>
</td>
<td>
<input type="reset" value="Clear"/>
</td>
</tr>
</table>
</form>
and have sql database:
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’
);
if i will input username and password froom database it will say log otherwise it will say invalied data or loging