Hi, Before introduce an script, I just want to clear all basic concept to all of you,
How a php script Run ?
Web - Browser => Web - Server => PHP - Engine =>MySql Server.
In short I Explain here that, first you write source code in web - browser, then it send to server,which add some functionality in them, later it goes to php engine where that's check some php - syntax, html code, as well as it open Database Connection ,later it goes to mysql server, where all the query execute by that part, after that, we get output at Web Browser in that way.
Web - Browser <= Web - Server <= PHP - Engine <=MySql Server.
:)
Now the script save in C:/D:/E:/F:/Drive =>wamp =>www =>index_dir.php
*********************************
******************
*********
<?php
if(isset($_POST['posted']))
{
$name=$_POST['dir_username'];
$pass=$_POST['dir_password'];
$connect=mysql_connect('localhost','root','');
$db=mysql_select_db('dir_db',$connect);
$query=mysql_query('SELECT * FROM dir_login',$connect);
while($row=mysql_fetch_array($query))
{
$column1=$row['username'];
$column2=$row['password'];
if($column1 == $name && $column2 == $pass)
{
header('location:registration_dir.php');
}
else
{
echo('Sorry Username and password is mismatch');
exit();
}
}
}
?>
<form name="index_dir" method="post" action="index_dir.php">
<table align="center" border="">
<tr>
<td>
<b style="background-color:#063">USERNAME</b>
<input type="text" name="dir_username" value="USERNAME" style="background-color:#966">
</td>
</tr>
<tr>
<td><b style="background-color:#063">PASSWORD</b>
<input type="password" name="dir_password" value="*****" style="background-color:#966">
</td>
</tr>
<tr>
<td><input type="hidden" name="posted" value="true>"></td>
<td>
<input type="submit" name="dir_submir" value="GO" style="background-color:#063">
</td>
</tr>
</table>
</form>
I thinks that's enough for you.
:(