🐘 PHP Log in problem

ribbit · Apr 2, 2022

wala nang error code ko pero hind siya dumederetcho sa hmtl ko???
sa login_run.php padin siya hind na pupunta sa html

Code:

<?php
include('connection.php');
session_start();
$usern='';
$passw='';
$usern = $_POST['usern'];
$passw = $_POST['passw'];
$_SESSION['admin'] = '';
$_SESSION['user'] = '';
$user_type='';

if (isset($_POST['submit'])) {
    
    
    $usern=$_POST['usern'];
    $passw=$_POST['passw'];
    $sql = " SELECT * FROM admin WHERE usern = '$usern' AND passw = '$passw'";
    $query=" SELECT * FROM users WHERE usern='$usern' AND passw='$passw' AND user_type='$user_type' ";
    $result=mysqli_query($con,$query);

    while($row=mysqli_fetch_array($result)){
        if($row['usern']==$usern && $row['passw']==$passw && $row['user_type']=='Admin' &&$row['verify_status']=='1'){
            header("Location: admin.html");
        }
        elseif($row['usern']==$usern && $row['passw']==$passw && $row['user_type']=='User' &&$row['verify_status']=='1'){
            header("Location: user.html");
        }
    }
}
else
{
    //walang laman
}
?>

eto naman sa log in page ko

Code:

<?php
include('connection.php');
?>
<!DOCTYPE html>
<html>
    <head>
        <title>Log In</title>
    </head>

<body>
    <form action="login_run.php" method="POST" >
        <table>
            <tr>
            <tr>
                <td>Username</td>
                <td><input type="text" name="usern" placeholder="Username"></td>
            </tr>
            <tr>
                <td>Password</td>
                <td><input type="password" name="passw"placeholder="Password"></td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td><input type="submit" name="submit" value="Log in"></td>
            </tr>
        </table>
    </form>
</body>
</html>

data base ko naman

Code:

id
user_type
usern
passw
f_name
l_name
pnum
addr
email
created_at
verify_token
verify_status

vhin le · Apr 2, 2022

di ko alam kung gagana pero pwedi mo pagtyagaan..Di ko pa natest yan kasi basi lang yan sa na post mo..

ribbit · Apr 2, 2022

na try ko na sir yung code mo eto po lumabas

vhin le · Apr 2, 2022

1. Check your connection variable
2. Since hindi nakapag run ng maayos yung program due to connection, walang pumasok na result that's why di siya nakapg-execute yung num_rows..

ribbit · Apr 2, 2022

Code:

<?php

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'obs');

$con = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);

?>

tama naman po yung variable ko sa connection

vhin le · Apr 2, 2022

$result = mysqli_query(...) dapat..check my code..

Iba kasi nalagay mo...

ribbit · Apr 2, 2022

thank you so much, sir <3

vhin le · Apr 2, 2022

ribbit said:
thank you so much, sir <3

View attachment 1882588

You're welcome! Keep it up!

ribbit · Apr 2, 2022

last question sir, bakit sa admin parin po pumapasok kahit admin na po pinapasok ko?

vhin le · Apr 2, 2022

admin pumapasok kahit user ang account? ganon ba tanong mo?

ribbit · Apr 2, 2022

kahit anong account po log in ko sa default parin po ang pasok

vhin le · Apr 2, 2022

screenshot mo ulit code mo and database mo para ma examine natin.

Yung table lang para sa users

ribbit · Apr 2, 2022

eto po sir

vhin le · Apr 2, 2022

once na gumamit ka kasi ng strtoupper() function, it converts your string to uppercase to make value or sting convenient to access and for conditional purposes..

gawin mong CAPS yan since ang laman ng $user_type ay CAPS letters, parati sa defualt papasok yan kasi nakalagay sa case mo ay 'Admin'

ribbit · Apr 2, 2022

eto po update sir

vhin le · Apr 2, 2022

Perform necessary debugging.
Ex: instead of executing the header(...) function to redirect, echo mo muna laman ng variables

Code:

$user_type = strtoupper($row['user_type']);
switch($user_type ){
    case 'ADMIN':
      echo $user_type ;
    break;
    defualt:
    echo $user_type ;
}

ikaw an bahala kung anong diskarte gagawin mo. Importante these concerns will contribute to your skills para next time you will have an idea of what to do if you encounter the same situation. Working for it increases your knowledge and skills. Good luck!

ribbit · Apr 2, 2022

vhin le said:
Perform necessary debugging.
Ex: instead of executing the header(...) function to redirect, echo mo muna laman ng variables

Code:

$user_type = strtoupper($row['user_type']); switch($user_type ){ case 'ADMIN': echo $user_type ; break; defualt: echo $user_type ; }

ikaw an bahala kung anong diskarte gagawin mo. Importante these concerns will contribute to your skills para next time you will have an idea of what to do if you encounter the same situation. Working for it increases your knowledge and skills. Good luck!

thank you so much sir ill update you po pag nagawa ko maraming samalamat po talaga

okay na sir salamat ulit

🐘 PHP Log in problem

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Eternal Poster

Attachments

Similar threads

About this Thread

Trending Topics

Online now

Forum statistics