Write a PHP program to accept username and password from the user. Validate it against the login table in the database. If there is a mismatch between username and password, then, display the error message as ―invalid user name and password; else display the message as ―Login successful‖ on the browser.

Userpass.html
<html>
<body>
<form method=post action="Userpass.php">
Enter UserName : <input type=text name="t1"><br><br>
Enter Password   : <input type=text name="t2"><br><br>
<input type=submit value="Log In">
</form>
</body>
</html>
Userpass.php
<?php
          $user=$_POST['t1'];
          $pass=$_POST['t2'];
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("userpass") or die(mysql_error());
         $result=mysql_query("select * from login");
while($row=mysql_fetch_array($result))
         {
           if((strcmp($user,$row['user'])==0) && (strcmp($pass,$row['pass'])==0))
echo"Login Successful";
else
echo"Invalid user";
        }
?>

Comments

Post a Comment

Popular posts from this blog

Create an XML file which gives details of books available in “ABC Bookstore” from following categories. 1)      Technical 2)      Cooking 3)      Yoga And elements in each category are in the following format.     …….     …….     ……. Save the file as “Book.xml” Create an application that reads “Book.xml” file into simple XML object. Display attributes and elements. (Hint:- Use simple_xml_load_file() function). 

Book.XML <?xml version="1.0" encoding="utf-8"?> <ABCBOOK>         <Technical>         <BOOK>         <Book_PubYear>ABC</Book_PubYear>         <Book_Title>pqr</Book_Title>         <Book_Author>400</Book_Author>         </BOOK>         </Technical>          <Cooking>         <BOOK>         <Book_PubYear>ABC</Book_PubYear>         <Book_Title>pqr</Book_Title>         <Book_Author>400</Book_Author>         </BOOK>...
Read more

Write a simple PHP program which implements Ajax for addition of two numbers

Add.php <html> <head>    <script language="javascript" src="ajax.js">    </script> </head> <body> <div id="txt" name="txt"></div>    <form action="javascript:add(document.getElementById('frm'));" name="frm" id="frm">   <table>    <tr>      <td>Enter first number : </td>      <td><input type="text" id="num1"></td>      </tr>      <tr>      <td>Enter second number : </td>      <td><input type="text" id="num2"></td>      </tr>      <tr>        <td colspan="2"><input type="submit" name="button" value="show"></td>      </tr> </table> </form> </body> ...
Read more

Consider the following relational database: Project (P_Group_No, Project_Title) Student (Seat no, Name, Class, P_Group_No) Write a PHP script to accept project title and display list of students those who are working in a particular project.

Project.html <html> <body> <form method=get action="Project.php"> Enter Project Tittle : <input type=text name="pname"><br><br> <input type=submit value="Display"> </form> </body> </html> Project.php <?php          $pname=$_GET['pname']; mysql_connect("localhost","root","") or die(mysql_error()); mysql_select_db("userpass") or die(mysql_error());          $result=mysql_query("SELECT * FROM student WHERE pgno IN (SELECT pgno FROM project WHERE ptittle = '".$pname."')"); while($row=mysql_fetch_array($result))          { echo"Seat No = ".$row['sno']."  Name  = ".$row['name']; echo"  Class =  ".$row['class']." Proj. Group No. =  ".$row['pgno']."<br>";         } ?>
Read more