PHP 2 table for admin and user log in

[ribbit]

ask ko lang mga ser baka meron kayo alam sa login pag na pag user nang nag log in sa index mapupunta. at kapag admin naman deretcho sa admin panel

<?php
require('db.php');
session_start();
// If form submitted, insert values into the database.
if (isset($_POST['UserName'])){
// removes backslashes
 $UserName = stripslashes($_REQUEST['UserName']);
 $UserName = mysqli_real_escape_string($con,$UserName);
 $Password = stripslashes($_REQUEST['Password']);
 $Password = mysqli_real_escape_string($con,$Password);
 //Checking is user existing in the database or not
 $query = "SELECT * FROM `user` WHERE UserName='$UserName' and Password='".md5($Password)."'";
 $result = mysqli_query($con,$query) or die(mysql_error());
 $rows = mysqli_num_rows($result);
       if($rows==1){
              $_SESSION['UserName'] = $UserName;
              // Redirect user to index.php
              header("Location: index.php");
                     }
       else{
              echo "<div class='form'>
              <h3>UserName/Password is asdasdasdsaincorrect.</h3>
              <br/>Click here to <a href='login.php'>Login</a></div>";
       }
}
else{}
?>

eto yung code ko sa login php ko kaso sa user lang siya

pa help naman po sa php TIA

 

[skapar]

Mas bet gawan mo nalang log-in page para sa Admin log-in... Table only for admins Yung query.

Kung gusto mo naman isang log-in page Lang sa isang table..

gawan mo nang isang column kung admin ba sya o user..

username | password | superuser
user1 | pass1 | 0
Admin1 | admin1 | 1
user2 | user2 | 0
Admin2 | admin2 | 1


*After nya ma query na True yung superuser means Admin yung nag log-in, redirect mo nalang sa Admin page get that ID Ni admin para query mo ulit sa table 2...

Happy coding

 

[PHC-Xes]

Mas bet gawan mo nalang log-in page para sa Admin log-in... Table only for admins Yung query.

Kung gusto mo naman isang log-in page Lang sa isang table..

gawan mo nang isang column kung admin ba sya o user..

username | password | superuser
user1 | pass1 | 0
Admin1 | admin1 | 1
user2 | user2 | 0
Admin2 | admin2 | 1


*After nya ma query na True yung superuser means Admin yung nag log-in, redirect mo nalang sa Admin page get that ID Ni admin para query mo ulit sa table 2...

Happy coding

Up dito okay rin to gawan mo ng role kumbaga if =ROLE dun sya mag proceed na panel.

 

[dmartinez_01]

Mas simplier,
1. dagdag ka sa user table mo ng field na Roles
2. sa user registration bago mo ipasok mga user, i-assign mo na kung anong user role like author, admin, content editor etc...
3. ngaun sa login registration mo, after mo ma-validate ung user ng credentials nya i-pull mo ngaun ung role data nya like:

switch ($user["roles"]) {
case "admin":
header(Location: admin.php);
break;
case label2:
header(Location: author.php);
break;
case label3:
header(Location: content-editor.php);
break;

default:
code to be executed if n is different from all labels;
}