[rid]

Dear all...,
I have develop script, but I have a problem to get an access per menu item.
Every menu item have a difference level access.
The lower level is "0", and the higher level is "9". If the menu item have access "0123456789", so all user include guest, have an access to these menu item.

SQL data table:
(see attached image below)

PHP menu script (original):

PHP Code:

<?php

$_m_q = "SELECT * FROM cogo_menu";
$_m_r = mysql_query($_m_q);
if (mysql_num_rows($_m_r) > 0) {
    $_m = '<ul>';
    while($_m_i = mysql_fetch_row($_m_r)) {
        $_m.= '<li><a href="'.$_m_i[2].'>'.$_m_i[1].'</a></li>';
    }
    $_m.= '</ul>';
}

?>

PHP menu script (modified):

PHP Code:

<?php

$_m_q = "SELECT * FROM cogo_menu";
$_m_r = mysql_query($_m_q);
if (mysql_num_rows($_m_r) > 0) {
    $_m = '<ul>';
    while($_m_i = mysql_fetch_row($_m_r)) {
        if (strpos($_m_i[3], $_SESSION['user_level']) === false) {
            $_m.= '';
        } else {
            $_m.= '<li><a href="'.$_m_i[2].'>'.$_m_i[1].'</a></li>';
        }
    }
    $_m.= '</ul>';
}

?>

When using the modified script, all of menu items will not display.
Help me please....
Why I confused with that logical....?

[landing]

strpos() will match a string. I'm assuming the value of $_SESSION['user_level'] is an integer?

Taken from the PHP manual on strpos

If needle is not a string, it is converted to an integer and applied as the ordinal value of a character.

Easy solution though. Just convert your user_level to a string whenever you require

PHP Code:

$_m_q = "SELECT * FROM cogo_menu";
$_m_r = mysql_query($_m_q);
if (mysql_num_rows($_m_r) > 0) {
    $_m = '<ul>';
    while($_m_i = mysql_fetch_row($_m_r)) {
        if (strpos($_m_i[3], strval($_SESSION['user_level']))) === false) { // See strval()
            $_m.= '';
        } else {
            $_m.= '<li><a href="'.$_m_i[2].'>'.$_m_i[1].'</a></li>';
        }
    }
    $_m.= '</ul>';
} 

[rid]

thanks landing....
please help me to solve my problem...

[landing]

I did. Look at my code.

[Nico]

I think strpos() is actually smart enough to convert the integer.

I guess the error is a missing double quote, which could make the link "invisible" in the HTML output (not the actual source code).

This:

PHP Code:

$_m.= '<li><a href="'.$_m_i[2].'>'.$_m_i[1].'</a></li>'; 

... should be:

PHP Code:

$_m.= '<li><a href="'.$_m_i[2].'">'.$_m_i[1].'</a></li>'; 

[rid]

dear nico, sorry, i forgot to add a double-quote, but it can't fixing my problem. none of the menu item is appear.

[sorry 4 my poor english]

[Nico]

Did you echo both, $_SESSION['user_level'] and $_m_i[3] to make sure they actually contain the expected values?

[rid]

yes...
i want all menu items have a different access for different user level.
e.g: menu "Dashboard" have level access for user level: 1, 2, 3, 4, 5, 6, 7, 8, 9 but not for guest (guest level is zero "0") so these menu item is just for user with user level 1, 2, 3, 4, 5, 6, 7, 8 and 9.

[landing]

I ran your original code and as you said the menu didn't appear.

I ran it again this time strval($_SESSION['user_level']) and it worked fine.

I did forcefully set $_SESSION['user_level'] however, so as Nico says if it doesn't carry the expected value it won't work either.

[rid]

dear landing,
i've got an error msg like below when i inserted the strval() function:

Code:

Warning:  strpos(): Empty delimiter. in W:\www\project\includes\menu.php on line 8