MySQL Forums
Forum List  »  PHP

Help with php cannot find whats wrong with this code its urgent
Posted by: ritik rastogi
Date: October 27, 2017 01:05AM

index.php page



<?php
/*session_start();
include('dbconnection.php');
if(isset($_POST['login']))
{
$ret=mysql_query("SELECT * FROM userinfo WHERE email='".$_POST['username']."' and password='".$_POST['pwd']."'");
$num=mysql_fetch_array($ret);
if($num>0)
{
session_regenerate_id();
$member = mysql_fetch_assoc($result);
$_SESSION['User_Id'] = $member['id'];
$_SESSION['User_Name'] = $member['email'];
$extra="welcome.php";
echo "<script>window.location.href='".$extra."'</script>";
exit();
}
else
{
$errmsg_arr[] = 'Please Enter Correct Username And Password !!!!';
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
//$_SESSION['action1']="Invalid username or password";
$extra="index.php";
echo "<script>window.location.href='".$extra."'</script>";
exit();
}
}*/

?>
<?php
//Start session
session_start();
//Unset the variables stored in session
unset($_SESSION['User_Id']);
unset($_SESSION['User_Name']);
//unset($_SESSION['SESS_LAST_NAME']);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Support</title>
<!-- Bootstrap Core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Custom CSS -->
<style>
body {
padding-top: 100px;
/* Required padding for .navbar-fixed-top. Remove if using .navbar-static-top. Change if height of navigation changes. */
}
#header{height:60px;}.btn:focus {
outline: none;
}

</style>

</head>

<body>

<nav id="header" class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.php">
<img alt="EmagenTV Digital Signage Software" src=img/logo.png>
</a>
</div>
</div>

</nav>

<!-- Page Content -->
<div class="container">

<div class="row">
<div class="col-lg-12 text-center">
<h1>Login Here</h1>
<p style="color:red;">
<p style="color:red;"><?php
if( isset($_SESSION['ERRMSG_ARR']) && is_array($_SESSION['ERRMSG_ARR']) && count($_SESSION['ERRMSG_ARR']) >0 ) {
echo '<ul class="err">';
foreach($_SESSION['ERRMSG_ARR'] as $msg) {
echo '<li>',$msg,'</li>';
}
echo '</ul>';
unset($_SESSION['ERRMSG_ARR']);
}
?></p>
<form name="login" action="userlogin.php" method="post" >
<table align="center">
<tr height="50">
<td>User Name :</td>
<td><input type="text" name="username" id="opwd"></td>
</tr>
<tr height="50">
<td>Passowrd :</td>
<td><input type="password" name="pwd" id="pwd"></td>
</tr>
<tr height="50">
<td></td>
<td><input type="submit" name="login" Value="login"></td>
</tr>
</table>
</form>
</div>
</div>
<!-- /.row -->

</div>
<!-- /.container -->

<!-- jQuery Version 1.11.1 -->
<script src="js/jquery.js"></script>

<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.min.js"></script>

</body>

</html>


userlogin.php

<?php
//Start session
session_start();

//Include database connection details
include('dbconnection.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}

//Sanitize the POST values
$username = clean($_POST['username']);
$password = clean($_POST['pwd']);
//$username = $_POST['username'];
//$password = $_POST['pwd'];

//Input Validations
if($username =='') {
$errmsg_arr[] = 'Username missing';
$errflag = true;
}
if($password =='') {
$errmsg_arr[] = 'Password missing';
$errflag = true;
}


if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
header("location: index.php");
exit();
}

//Create query
$qry="SELECT * FROM userinfo WHERE email='$username' AND password='$password'";
//exit;
$result=mysql_query($qry);

//Check whether the query was successful or not
if($result) {
if(mysql_num_rows($result) > 0) {
//Login Successful
session_regenerate_id();
$member = mysql_fetch_assoc($result);
$_SESSION['User_Id'] = $member['id'];
$_SESSION['User_Name'] = $member['email'];
//$_SESSION['SESS_LAST_NAME'] = $member['password'];
//$_SESSION['SESS_Emp_type'] = $member['user_type'];
session_write_close();

header("location: welcome.php");
exit();

}else {?>
<script> alert('Please Enter Correct Username And Password !!!!');</script><?php
//Login failed
$errmsg_arr[] = 'Please Enter Correct Username And Password !!!!';
$errflag = true;
if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
header("location: index.php");
exit();
}
}
}
else {
die("Query failed");
}
?>

Options: ReplyQuote


Subject
Written By
Posted
Help with php cannot find whats wrong with this code its urgent
October 27, 2017 01:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.