[help] login script php

**k0d0k** · 20-02-15

hello,can make login php for ex80?

thanks before

**MentaL**

**xlmansox** · 21-02-15

Code:

$username = $_POST['username'];
$getid = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username'");
$get = mssql_fetch_array($getid);
$password = md5($_POST['password'],$get['AccountID']);
$chk_sql = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username' AND Passphrase = '$password'");
$chk = mssql_fetch_array($chk_sql);
if(!$chk)
{
    echo "Username or password wrong.";
}
else
{
    echo "login success";
}

hope it help.

**k0d0k** · 21-02-15

Originally Posted by xlmansox

Code:

$username = $_POST['username'];
$getid = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username'");
$get = mssql_fetch_array($getid);
$password = md5($_POST['password'],$get['AccountID']);
$chk_sql = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username' AND Passphrase = '$password'");
$chk = mssql_fetch_array($chk_sql);
if(!$chk)
{
    echo "Username or password wrong.";
}
else
{
    echo "login success";
}

hope it help.

hello, function for login oldpass but not password.
why? example your login please

**xlmansox** · 21-02-15

1.config.php files

Code:

<?php$mssql_host		=	"kudo-pc\sqlexpress";
$mssql_user		=	"sa";
$mssql_pass		=	"123456";
$mssql_db		=	"WEB_DRAGONEST";


$connect = mssql_connect("$mssql_host","$mssql_user","$mssql_pass") or die("Cannot connect to Server");
$connect_db = mssql_select_db("$mssql_db") or die("Cannot connect to Database");


?>

2.login.php form

Code:

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

          <fieldset class="clearfix">


            <p><span class="fontawesome-user"></span><input name="username" type="text" required id="username" onFocus="if(this.value == 'Username') this.value = ''" onBlur="if(this.value == '') this.value = 'Username'" value="Username"></p> <!-- JS because of IE support; better: placeholder="Username" -->
            <p><span class="fontawesome-lock"></span><input name="password" type="password" required id="password" onFocus="if(this.value == 'Password') this.value = ''" onBlur="if(this.value == '') this.value = 'Password'"  value="Password"></p> <!-- JS because of IE support; better: placeholder="Password" -->
            <p><input type="submit" value="Login"></p>


          </fieldset>


        </form>

3.chklogin.php

Code:

<?phpinclude "config.php";
// Chk pass
$username = $_POST['username'];
$getid = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username'");
$get = mssql_fetch_array($getid);
$password = md5($_POST['password'],$get['AccountID']);
$chk_sql = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username' AND Passphrase = '$password'");
$chk = mssql_fetch_array($chk_sql);
if(!$chk)
{
	echo "<script langquage='javascript'>
window.location='login.php?a=fail';
</script>";
}
else
{
	$_SESSION['username'] = $chk['AccountName'];
	session_write_close();
	echo "<script langquage='javascript'>
window.location='index.php';
</script>";
}
?>

**k0d0k** · 21-02-15

Originally Posted by xlmansox

1.config.php files

Code:

<?php$mssql_host        =    "kudo-pc\sqlexpress";
$mssql_user        =    "sa";
$mssql_pass        =    "123456";
$mssql_db        =    "WEB_DRAGONEST";


$connect = mssql_connect("$mssql_host","$mssql_user","$mssql_pass") or die("Cannot connect to Server");
$connect_db = mssql_select_db("$mssql_db") or die("Cannot connect to Database");


?>

2.login.php form

Code:

        <form action="http://forum.ragezone.com/chklogin.php" method="post">

          <fieldset class="clearfix">


            <p><span class="fontawesome-user"></span><input name="username" type="text" required id="username" onFocus="if(this.value == 'Username') this.value = ''" onBlur="if(this.value == '') this.value = 'Username'" value="Username"></p> <!-- JS because of IE support; better: placeholder="Username" -->
            <p><span class="fontawesome-lock"></span><input name="password" type="password" required id="password" onFocus="if(this.value == 'Password') this.value = ''" onBlur="if(this.value == '') this.value = 'Password'"  value="Password"></p> <!-- JS because of IE support; better: placeholder="Password" -->
            <p><input type="submit" value="Login"></p>


          </fieldset>


        </form>

3.chklogin.php

Code:

<?phpinclude "config.php";
// Chk pass
$username = $_POST['username'];
$getid = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username'");
$get = mssql_fetch_array($getid);
$password = md5($_POST['password'],$get['AccountID']);
$chk_sql = mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '$username' AND Passphrase = '$password'");
$chk = mssql_fetch_array($chk_sql);
if(!$chk)
{
    echo "<script langquage='javascript'>
window.location='login.php?a=fail';
</script>";
}
else
{
    $_SESSION['username'] = $chk['AccountName'];
    session_write_close();
    echo "<script langquage='javascript'>
window.location='index.php';
</script>";
}
?>

thanksyou sir :)

oh yes, i try

**dahsyat** · 23-03-15

Then how to Change Password Script?

**xlmansox** · 23-03-15

changepass.php

Code:

<?php
				echo "<form name='chgpass' method='post' action='changepass.php'>
  <center>
    <strong>Change Password</strong>
  </center>
  <table class='normal_text' width='500' align='center'>
    <tr>
      <td width='184' align='right'>Old Password :</td>
      <td width='304'><label for='oldpass'></label>
      <input type='password' name='oldpass' id='oldpass'></td>
    </tr>
    <tr>
      <td align='right'>New Password :</td>
      <td><label for='pass1'></label>
      <input type='password' name='pass1' id='pass1'></td>
    </tr>
    <tr>
      <td align='right'>Re-New Password :</td>
      <td><label for='pass2'></label>
      <input type='password' name='pass2' id='pass2'></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type='submit' name='submit' id='submit' value='Change Pass'></td>
    </tr>
  </table>
</form>


";



				if($_POST['submit'])
				{
					echo "<center>";
					$password = md5(check($_POST['oldpass']),$user['AccountID']);
					$pass1 = check($_POST['pass1']);
					$pass2 = check($_POST['pass2']);
					// Check old pass
					$chkpass_sql = @mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '".$account."' And Passphrase = '$password'");
					$chkpass = @mssql_fetch_array($chkpass_sql);
					if(!$chkpass)
					{
						echo "Old password wrong.";
					}
					else if(empty($password))
					{
						echo "Please fill old password";
					}
					else if(trim($pass1) != $pass2)
					{
						echo "New password not match";
					}
					else if(strlen($pass1 | $pass2) <= 5)
					{
						echo "Please fill 6-32 character";
					}
					else
					{
						// Update Password
						$update = mssql_query("UPDATE dnmembership.dbo.Accounts
		SET Passphrase = dnmembership.dbo.FN_HashPassphrase2('$pass2', $account_id)
		WHERE AccountID = $account_id");
						echo "Change Password Success";
					}
					echo "</center>";
				}
?>

**dahsyat** · 23-03-15

Originally Posted by xlmansox

changepass.php

Code:

<?php
                echo "<form name='chgpass' method='post' action='http://forum.ragezone.com/changepass.php'>
  <center>
    <strong>Change Password</strong>
  </center>
  <table class='normal_text' width='500' align='center'>
    <tr>
      <td width='184' align='right'>Old Password :</td>
      <td width='304'><label for='oldpass'></label>
      <input type='password' name='oldpass' id='oldpass'></td>
    </tr>
    <tr>
      <td align='right'>New Password :</td>
      <td><label for='pass1'></label>
      <input type='password' name='pass1' id='pass1'></td>
    </tr>
    <tr>
      <td align='right'>Re-New Password :</td>
      <td><label for='pass2'></label>
      <input type='password' name='pass2' id='pass2'></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type='submit' name='submit' id='submit' value='Change Pass'></td>
    </tr>
  </table>
</form>


";



                if($_POST['submit'])
                {
                    echo "<center>";
                    $password = md5(check($_POST['oldpass']),$user['AccountID']);
                    $pass1 = check($_POST['pass1']);
                    $pass2 = check($_POST['pass2']);
                    // Check old pass
                    $chkpass_sql = @mssql_query("SELECT * FROM dnmembership.dbo.Accounts WHERE AccountName = '".$account."' And Passphrase = '$password'");
                    $chkpass = @mssql_fetch_array($chkpass_sql);
                    if(!$chkpass)
                    {
                        echo "Old password wrong.";
                    }
                    else if(empty($password))
                    {
                        echo "Please fill old password";
                    }
                    else if(trim($pass1) != $pass2)
                    {
                        echo "New password not match";
                    }
                    else if(strlen($pass1 | $pass2) <= 5)
                    {
                        echo "Please fill 6-32 character";
                    }
                    else
                    {
                        // Update Password
                        $update = mssql_query("UPDATE dnmembership.dbo.Accounts
        SET Passphrase = dnmembership.dbo.FN_HashPassphrase2('$pass2', $account_id)
        WHERE AccountID = $account_id");
                        echo "Change Password Success";
                    }
                    echo "</center>";
                }
?>

Thank you ..

to open this need login first or no ?

**childs** · 24-03-15

@xlmansox

im sorry sir . how to fix this ?

**xlmansox** · 25-03-15

<?php press enter.

**Sabillah** · 16-05-15

please upload in .rar or .zip :D

[help] login script php

Thread Tools

[help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Re: [help] login script php

Advertisement