Need some login form help

Need some login form help

First of all create the html page with name of login.php as below

<form action="login_process.php" method="POST">

   USERNAME:<input type="text" name="name"><br />

   Password:<input type="password" name="password" ><br />

   <input type="submit" name="submit" value="LOG IN">

</form>

Then create the login_process.php page as below

<?php

include 'db_connect.php';



$name=$_POST['name'];

$password=$_POST['password'];

$sql="SELECT * FROM user_info WHERE user_name='$name'and password='$password'";

$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count==1)

{

    header("location:newpost.php");



}

else{

    echo "Wrong Username or Password";

}



?>

where db_connect.php page is

<?php

        $a="localhost";

        $b="root";

        $c="";



        $con = mysql_connect($a,$b,$c);



        if(!$con)

        {

            die('Could not connect:' . mysql_error());

        }



        mysql_select_db("wblog", $con);

        

?>

where user_name and password are tables in the database wblog…

Hope you got the answer if you are smart enough or used php and mysql before..

P.S. if you get any trouble with this ..do inform me..

Thanks

Need some login form help

Connection.php



<?php

Mysql_connect(“localhost”,”root”,””);

Mysql_select_db(“user”);

Here you have to give your database name.



?>



Registration.php



<?php

if(isset($_POST['submit']))

{

include("include/connection.php");

$a=$_POST["name"];

$b=$_POST["email"];

$c=$_POST["password"];

$d=$_POST["country"];

$e=$_POST["state"];



$query=mysql_query("insert into reg (name,email,password,country,state)

values ('”.$a.”','”.$b.”','”.$c.”','”.$d.”','”.$e.”')")or

die(mysql_error());



if($query)

{

echo "ok inserted";

}

else

{

echo "wrong";

}}

?>





This is the related html coding



<form action="" method="post"name="form">

<table width="200" border="0">

  <tr>

    <td>name:</td>

    <td><label>

      <input type="text"name="name">

    </label></td>

  </tr>

  <tr>

    <td>email:</td>

    <td><label>

      <input type="text"name="email">

    </label></td>

  </tr>

  <tr>

    <td>password:</td>

    <td><label>

      <input type="password"name="password">

    </label></td>

  </tr>

  <tr>

    <td>country:</td>

    <td><label>

      <select name="country">

 <option>india   </option>

<option>pakistan  </option>

 <option>china   </option>

 <option>

russia   </option>

 <option>england   </option>

 <option>bhutan   </option>

 <option>

 nepal   </option>

      </select>

    </label></td>

  </tr>

  <tr>

    <td>state:</td>

    <td><label>

      <select name="state">

 <option>

 haryana   </option>

 <option>

 bihar   </option>

        </select>

    </label></td>

  </tr>

  <tr>

<td>

</td><td>

      <input type="submit"name="submit" value="Submit">

    </label></td>

  </tr>

  <tr>

  <td>  </td>

  </tr>



</table></form>



Login.php



 <formaction="login_check.php"method="POST">

   USERNAME:<input type="text"name="name"><br />

   Password:<input type="password"name="password" ><br />

   <input type="submit" name="submit" value="LOG IN">

</form>



Then create the

login_check.php page as below



<?php

include 'connectionphp';

$name=$_POST['name'];

$password=$_POST['password'];

$sql="SELECT * FROM reg WHERE  name='$name'and password='$password'";

$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count==1)

{

echo “login successfully”;

}

else{

    echo "Wrong Username or Password";

}

?>