This topic is locked

Passing Parameters?

5/17/2007 2:23:09 PM
PHPRunner General questions
G
GeddyLee author

Using Version 3.1

Build 197
Hey all,
I would like to pass a parameter to phprunner to restrict results from the database to a user.
For example.

I have a table of vehicles, in this table i have a field called supplier_id.
amazingly this is a foreign key to a table called "Supplier". When a supplier comes to check out our vehicles, I don't want them seeing other supplier's vehicles.
Here's the catch, I already have a login system built and don't want to use the existing phprunner login. sorry.
My co-worker and I found a quick easy hack that's only one line of code, but, this means if I ever change the project, I have to re-add the hack because phprunner will overwrite my changes.
So, is there any way to pass parameters that won't be overwritten? even if it is a hack? Am I being clear enough?
Thanks in advance.

-Brent

Sergey Kornilov admin 5/17/2007

Brent,
use advanced security mode "Users can see and edit their own data only".

No hacks are required.

G
GeddyLee author 5/17/2007

Brent,

use advanced security mode "Users can see and edit their own data only".

No hacks are required.


Sorry I don't think I was clear enough. I have my own login system built, I don't want to use PHPRunner's login because it's being incorporated with an existing website. I'm assuming this is where the advanced security mode is found.
However I have found my solution. On the page I used the custom event and manipulated the SQL string given to me there to add in the appopriate where to select the supplier_id. Sorry to waste your time, I'm still new with the events and don't always think of them first.
Thanks,

-Brent