PHP MYSQL if field equals checked echo

Question

Each user in the databased is assigned a level, their is a table for levels and each level has permissions eg "view-clients" at login the user's level is made into $_SESSION['level'] i need to make an if statement that will echo code if the user's level "view-clients" is "checked".

This is the code is have but it wont echo it even when it is checked.

<?php
$level = mysql_real_escape_string($_SESSION['level']);
include("include/config.php");
$con=mysql_connect($db_host,$db_uname,$db_pwd,$db_name);
mysql_select_db($db_name);
$query = "SELECT * FROM levels WHERE name='$level'";

            $result=mysql_query($query);
            while($rows = mysql_fetch_array($result)){
                $a1=$rows['0'];
                $a2=$rows['1'];
                $a3=$rows['2'];
                $a4=$rows['3'];
                $a5=$rows['4'];
                $a6=$rows['5'];
                $a7=$rows['6'];
                $a8=$rows['7'];


if ($a5=="checked") { 

echo "Clients"; 

     }

 }

?>

I have tried a few things such as not using a variable as the session. I am thankful for any help.

So name is unique in levels? Did you try var_dump($row[5]); inside the loop to see if you're getting anything at all? — kero
– kero, Commented May 19, 2014 at 17:28
I guess this is where im going wrong, its not outputting anything. I have triple checked everything and it is spelled correctly? — James
– James, Commented May 19, 2014 at 17:44

Community · Accepted Answer · 2017-05-23 11:57:13Z

0

I guess you forgot to start session.

try that

  <?php
  session_start();
  $level = mysql_real_escape_string($_SESSION['level']);
  ....

your query will not find and result while $level is not defined.

also chanage this

 mysql_fetch_array

to

mysql_fetch_row

Look here the difference betwen fetch row and fetch array and fetch assoc

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered May 19, 2014 at 17:28

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

James Over a year ago

Its not displaying any

echo_Me Over a year ago

try make this in top of page ini_set('display_errors',1); or in your php.ini locate and do this display_errors = on

echo_Me Over a year ago

if nothing happen , then you have to check if you are really submitting having value for $_SESSION['level'] , if not , then check that you made session_start() also in the file you defining this variable.

James Over a year ago

added, still not displaying any, it used to display errors but then i found what was wrong and fixed them.

echo_Me Over a year ago

as i said check the other file where you defining session['level'] and check if you have session_start().

|

Collectives™ on Stack Overflow

PHP MYSQL if field equals checked echo

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related