Jump to content

Recommended Posts

Hello I'm currently working on a staff page for my website and I'm having trouble with a function not working corrrectly. The function is supposed to display an error message if the logged in user isn't a high enough level however it doesn't seem to be correctly getting the users rank level correctly cause in the error message it returns "You have a rank of" instead of "You have a rank of x". Here are my codes below

maindir/header.php

$username = $_SESSION['username'];
$sql = "SELECT * FROM users WHERE username=? LIMIT 1"; // SQL with parameters
$stmt = $link->prepare($sql); 
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result(); // get the mysqli result
$user = $result->fetch_assoc(); // fetch data  

function verify_staff() {

  if ($user['rank'] <= '2') {
  
    echo "
    <div class='alert alert-danger' role='alert'>
     You're not supposed to be here. You have a rank of " . $user['rank'] . "
     </div>
     ";
    exit;
   
   }
 }

 

/maindir/staff/index.php

<?php
require '../header.php';


verify_staff();

echo "Staff panel";

require '../footer.php';

?>

 

Edited by Nematode128
Link to comment
https://forums.phpfreaks.com/topic/310576-function-help/
Share on other sites

8 minutes ago, NotSunfighter said:

Why are you pulling everything from the db with the * when all you want is the rank?

In your echo you are putting a double quote inside a double quote.  => You have a rank of " . $user['rank'] . "

I'm getting username, email and a few other things later on. 

Link to comment
https://forums.phpfreaks.com/topic/310576-function-help/#findComment-1576834
Share on other sites

11 minutes ago, gw1500se said:

First do not use * in your query. Only ask for the columns you intend to use.

As for your question, you need to make sure the query is returning what you expect. Do this to verify it:


echo "<pre>";
print_r($user);
echo "</pre>";

I know $user is returning other values because it can echo $user['username'], $user['email']; etc from the table no problem

 

Link to comment
https://forums.phpfreaks.com/topic/310576-function-help/#findComment-1576835
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.