Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post - What is the easiest way to practise using PHP and mySQL?
View Single Post
Old 08-19-2010, 12:44 AM   #8 (permalink)
sandy_j_sam
Junior Member
 
Join Date: Aug 2010
Posts: 23
Default Re: What is the easiest way to practise using PHP and mySQL?

Hi, As we know that PHP is Server Side Scripting Language that, help for making Dynamic Web Application. before going to implementation you must install like WAMP
[Window + Apache + MySql + PHP].

PHP Script Run on Server through Web Browser. and here we mention code That's help you for PHP connection with MySql Just see them Login Script

<?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>
and is you have doubt then just mention here, I'll try to solve it.
sandy_j_sam is offline   Reply With Quote
Sponsored Links