I can custom modify the SQL queries within the application and have fore some custom stuff and could put some conditions there? I am just not seasoned in this and reaching out to the group for some direction, possibilities and or solutions. I plan on using Joomla CMS for my front end at least to the point that after sign up it directs folks to the actual PHP MySql database generated with PHPMaker. My fear is that I will need to break out into some custom PHP code. If user = John then allow "City", Buffalo, New York If user = Dave then allow "City", Buffalo, Syracuse That sounds interesting as I could potentially say something like: Now with that said a friend of mine told me that he heard of a way to customize access based on the users login. The max functionality of security levels is either to have the user own the record by themselves or levels of access where each level has access to more and more data. PHPMaker and many other code generators that I have seen do not allow this sort of customization. There are in reality dozens of different cities and records for the same cities that use the "City" field Now another user may need access to "Syracuse" and "Buffalo" or any combination. In other words out of the following cities: New York, Syracuse, Buffalo, Pelham I want to just let the user access records for "Syracuse". What I want to do in a perfect world is to restrict access to this data (from a larger database) based on the "City" or the "County" that the user has been authorized for so that only authorized city data is available to display, search etc. I have a database that for simplicity sake has records that contain the following fields: I use a PHP code generator called PHPMaker. First of all I do not consider myself fluent in PHP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |