Posts by berserk Page 4

berserk 60 Junior Poster

10 Years Ago

Re: need help getting this login form to work right

thank you very much i appreciate the help and assistence

Web Development php

berserk 60 Junior Poster

10 Years Ago

Re: need help getting this login form to work right

ok i got it working but im sure its one big security risk lol, i changed the verified header to the form header and it worked, this is basically what i needed.

Web Development php

berserk 60 Junior Poster

10 Years Ago

Re: need help getting this login form to work right

THIS WORKED FINALLY!!

however i can tseem to get it to go to the right page after the evaluation has passed.

here is my current code but it doesnt work.

<html>
<body>
<!-- End Page Content -->
<?php
$con = mysqli_connect("localhost", "root", "", "numbers") or die(mysqli_error($con));
if(isset($_POST['login']))
{
//$myusername = $_GET['name'];
//$mypassword = $_GET['password'];
$myusername=mysqli_real_escape_string($con,$_POST['username']);
$mypassword=mysqli_real_escape_string($con,$_POST['password']);
//$sql="SELECT * FROM admin WHERE username='".$myusername."' AND password='".$mypassword."'";
$sql="SELECT username, password FROM admin WHERE username='".$myusername."' AND password='".$mypassword."'";
$check= mysqli_query($con,$sql);
$row = mysqli_fetch_row($check);
if($row[0]!="" && $row[1] !="")
{
//echo "Successful Login";
//echo "<META http-equiv=' refresh' ;URL='form.php'>";
    //echo 'Successful Login<br/>';
    //echo "<META http-equiv=' refresh' ;URL='form.php'>";
    header('location: form.php');
    exit();
}
else
{
 $error="Your Login Name or Password is invalid";
echo "$error";
//echo "<META http-equiv=' refresh' ;URL='index.php'>";
}
}
?>
<form action="index.php" method="post">
<head>
<!-- Basics -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Login</title>
<!-- CSS -->
<link rel="stylesheet" href="css/reset.css">
<link rel="stylesheet" href="css/animate.css">
<link rel="stylesheet" href="css/styles.css">
</head>
<!-- Main HTML -->
<!-- Begin Page Content -->
<div id="container">
<form>
<label for="name">Username:</label>
<input type="name" name="username" id="username">
<label for="username">Password:</label>
<p><a href="#">Forgot your password?</a>
<input type="password" name="password" id="password">
<div id="lower">
<input type="checkbox"><label class="check" for="checkbox">Keep me logged in</label>
<input type="submit" value="Login" name="login" id="login">
</div>
</form>
</div>
</body>
</form>
</html>

I have used header which didnt work and throws an error about being unable to change the header information, i have also tried the meta tag and that did nothing either so im kinda at a lose on how to redirect the user to the desired form page. are there any other ways …

Web Development php

berserk 60 Junior Poster

10 Years Ago

Re: need help getting this login form to work right

I changed those but it still logs in automatically without verifiying if the login information is correct. What gives?

here is the newly modified code.

<html>
<body>   

    <!-- End Page Content -->

<?php

$con = mysqli_connect("localhost", "root", "", "numbers") or die(mysqli_error($con));


if(isset($_POST['login']))
{
    $myusername = $_GET['name'];
    $mypassword = $_GET['password'];

    $myusername=mysqli_real_escape_string($con,$_POST['name']); 
    $mypassword=mysqli_real_escape_string($con,$_POST['password']);

    //$sql="SELECT * FROM admin WHERE username='".$myusername."' AND password='".$mypassword."'";

    $sql="SELECT username FROM admin WHERE username='".$myusername."' AND password='".$mypassword."'";
    $check=  mysqli_query($con,$sql);

    $row = mysqli_fetch_row($check);


    if($row[0]!="")
    {
        //echo "Successful Login";
        echo "<META http-equiv=' refresh' ;URL='form.php'>";

    }
    else 
    {
        //$error="Your Login Name or Password is invalid";
        //echo "$error";
        echo "<META http-equiv=' refresh' ;URL='index.php'>";

    }
}


?>

<form action="form.php" method="post">
<head>
    <!-- Basics -->  
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">   
    <title>Login</title>
    <!-- CSS --> 
    <link rel="stylesheet" href="css/reset.css">
    <link rel="stylesheet" href="css/animate.css">
    <link rel="stylesheet" href="css/styles.css">    
</head>
    <!-- Main HTML -->   
    <!-- Begin Page Content -->  
    <div id="container">     
        <form>       
        <label for="name">Username:</label>       
        <input type="name" name="username" id="username">        
        <label for="username">Password:</label>       
        <p><a href="#">Forgot your password?</a>       
        <input type="password" name="password" id="password">        
        <div id="lower">     
        <input type="checkbox"><label class="check" for="checkbox">Keep me logged in</label>       
        <input type="submit" value="Login" name="login" id="login">
        </div>       
        </form>
    </div>


</body>
</form>
</html>

Web Development php

berserk 60 Junior Poster

10 Years Ago

Re: need help getting this login form to work right

okay so i have narrowed my code down some more and have rid myself of many errors but im still not getting the desired result.

here is my code now.

<html>
<body>   

    <!-- End Page Content -->

<?php

$con = mysqli_connect("localhost", "root", "", "numbers") or die(mysqli_error($con));


if(isset($_POST['login']))
{
    $myusername = $_GET['name'];
    $mypassword = $_GET['password'];

    $myusername=mysqli_real_escape_string($con,$_POST['name']); 
    $mypassword=mysqli_real_escape_string($con,$_POST['password']);

    $sql="SELECT * FROM admin WHERE username='".$myusername."' AND password='".$mypassword."'";
    $check=  mysqli_query($con,$sql);

    $row = mysqli_fetch_row($check);


    if($row[0] == 0)
    {
        //echo "Successful Login";
        echo "<META http-equiv=' refresh' ;URL='form.php'>";

    }
    else 
    {
        //$error="Your Login Name or Password is invalid";
        //echo "$error";
        echo "<META http-equiv=' refresh' ;URL='index.php'>";

    }
}


?>

<form action="form.php" method="post">
<head>
    <!-- Basics -->  
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">   
    <title>Login</title>
    <!-- CSS --> 
    <link rel="stylesheet" href="css/reset.css">
    <link rel="stylesheet" href="css/animate.css">
    <link rel="stylesheet" href="css/styles.css">    
</head>
    <!-- Main HTML -->   
    <!-- Begin Page Content -->  
    <div id="container">     
        <form>       
        <label for="name">Username:</label>       
        <input type="name" name="username" id="username">        
        <label for="username">Password:</label>       
        <p><a href="#">Forgot your password?</a>       
        <input type="password" name="password" id="password">        
        <div id="lower">     
        <input type="checkbox"><label class="check" for="checkbox">Keep me logged in</label>       
        <input type="submit" value="Login" name="login" id="login">
        </div>       
        </form>
    </div>


</body>
</form>
</html>

it still doesnt check the username and password values and just logs in anyway, what is WRONG with my code lol

Web Development php

berserk 60 Junior Poster

10 Years Ago

need help getting this login form to work right

I cant seem to get this login form to work right I have the login form come up and i can use it to get to the form.php page that i try to access but my problem is that its not verifying any login information, it just goes on through to the form page regardless. Let me give some more detail to clerify some things, im running this program over a local network so i dont need anything encrypted and also my login form is based entirely on an admin changable user name and password in phpmyadmin, my boss will have access to this page and be able to change the username and password to what he sees fit all i need to do is make sure that it reads the username and password from the database and checks to see if the entered ones are the same, if so then go to the form. here is the code i have, im sure its wrong but what i dotn understand is i have a similar function in another project that work exactly like it should with code set up like what i have here, also im getting this error that im sending the header before this is executed and it cant change the header again, which is weird cause i have commented out all the echos and so it shouldnt be giving me this error. Help please.

<html>

<form action="form.php" method="post">

<head>
    <!-- Basics -->  
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> …

Web Development php

berserk 60 Junior Poster

10 Years Ago

How to deploy php project

Ok i know this question might be riddled with ignorance but please bare with me. How to i go about deploying my php application i have developed, do i make it into an executable that can be installed on user machines, or do i just set it up like a website and host it via server, im a little confused because i have read that you can do both depending on the application you have and what it does. Mine is simple, its just a search engine that will allow you to search a database that is uploaded by the admin and is searchable to the users, there is also some other pages that are used that do other functionaility like making the data in the database deletable and i even added a login page for that page, but do i load all this into an executable file? i wouldnt think i would have to since its web based and is all handled by a server. Then again i could be literally so off that its laughable, regardless any assistence on this subject would be greatly appreciated and will be documented for later use. Thank you for your time.

Web Development client-server php

berserk 60 Junior Poster

10 Years Ago

Re: how to check to see if value is already in database before inserting new

Thank you so much urtrivedi, this is exactly what i needed. I bow to your wisdom cause i still dont fully understand but i am reading more into it as well as something on creating a login page so i will go from there. Thanks again for all the help you gave me. it was very much appreciated