PHP and frames

pranik

Hello everybody, I've got the following problem: I use frames to have
a menu bar at the left of every page I want to display, and at the right
I've got many different php pages to query a MySql database, and one of the
tables contains usernames for each one of which I want to allow access
to an individual area. But implementing that with a query string like
<a href="../path/index.php?showrecord=(username)"> the index.php
addressed shows an empty table because evidently $_GET('showrecord') gets a NULL variable. I guess this happens because the complete URL is hidden when you use frames, is there a workaround to solve this problem? Thanks a lot😕

xeel

I'd recommend to read the menus from a profile parameter. For example:
- create two tables in the database: 1 for the profiles, 1 for menus names, links and permissions for each profile;
- on the menu-frame page load the menus by querying the database by profile type;
- when selecting a user/profile save its type parameter in the session so it could be used to make a query to select the menus by this profile

If you do it this way you'd have a dynamic menu list which depends on current profile. Is that what you wanted?

pranik

xeel;10916467 wrote:
I'd recommend to read the menus from a profile parameter. For example:
- create two tables in the database: 1 for the profiles, 1 for menus names, links and permissions for each profile;
- on the menu-frame page load the menus by querying the database by profile type;
- when selecting a user/profile save its type parameter in the session so it could be used to make a query to select the menus by this profile

If you do it this way you'd have a dynamic menu list which depends on current profile. Is that what you wanted?

No, actually it's not exactly what I wanted: anyway, thanks a lot for your
answer xeel, I found the solution, I was making a stupid mistake in posting
the variable, instead of writing:

SELECT --whatever-- FROM table WHERE id='$showrecord' (right syntax)

I was doing:

SELECT --whatever-- FROM table WHERE id=' . $showrecord.' (wrong syntax)

of course loading the php page addressed the variable showrecord wasn't
parsed correctly, I just took off my mind!

Thank you very much, I appreciate

🙂