PHP login form

Question

Hi friends, I want to know, I was connecting my php login form with mysql ,i was having a problem can you provide me a solution of my problem or login form connectivity with mysql ?

Satyapriya Nayak · Answer

Hi Mike, config.php /* Database Connection */ $sDbHost = 'localhost'; $sDbName = 'test'; $sDbUser = 'root'; $sDbPwd = ''; $dbConn = mysql_connect ($sDbHost, $sDbUser, $sDbPwd) or die ('MySQL connect failed. ' . mysql_error()); mysql_select_db($sDbName,$dbConn) or die('Cannot select database. ' . mysql_error()); ?> Login.php session_start(); include("config.php"); if($_REQUEST["btn_login"]=="submit") { $uname=$_POST["txt_login"]; $password=$_POST["txt_pwd"]; $sql="select * from user where user='".$uname."' and password='".$password."'"; //echo $sql; //exit; $res=mysql_query($sql); if($rs=mysql_num_rows($res)>0) { $_SESSION["uname"]=$uname; //echo $_SESSION["uname"]; //exit; //echo $rs; //exit; echo " location.href='welcome.php' "; } else { echo " location.href='Login.php?qs=invalid' "; } } ?> function validate() { if(document.frm_login.txt_login.value=="") { alert("please Enter your user name"); document.frm_login.txt_login.focus(); return false; } if(document.frm_login.txt_pwd.value=="") { alert("please Enter your password"); document.frm_login.txt_pwd.focus(); return false; } return true; } LOGIN FORM     if($_REQUEST["qs"]=="invalid") { echo " Invalid Username or Password "; } ?> Username: Password:     welcome.php session_start(); ?> Welcome Welcome: '.$_SESSION["uname"]; ?> Running the application Run the WampServer then write the below line in the Url http://localhost/Login/ Thanks If this post helps you mark it as answer

PHP login form

Answers (1)