Hello, good people. I come here after much searching and trying different things...and basically pulling my hair out.
I want to do what I thought was a simple thing.
On all my PHP pages (outside of phpMyEdit), users have to login. Thus, they have all have a session ID which is referred to as $_SESSION['user_id'] on all of my PHP pages. I always use this in the "where" variable so that they only see their stuff.
When it came time that they needed a form not only to view but to edit data, I turned to phpMyEdit.
However, I can't for the life of me figure out how to do this.
I implemented the "WHERE" filter so I got the first page to display just their data.
However, if they go to add record or change a record, it does not use the where filter and provides them the option of adding data to anybody's userID (I tried hiding this field but this fails...it also then doesn't seem to know what ID field to use).
The docs do say that using this "filter" is for "any generated SELECT statement". Does this mean that it does not apply for an update or insert?
Is is possible to do what I want to do or am I using the wrong program?
Thanks in advance. Any help is great appreciated.
--Tyler
|