Administration Area for Pages Created Using DataAssist & SecurityAssist

Dear Support:

Okay I created a series of pages using DataAssist & Security Assist on my testing server. I want the client when they login using the admin_login.php page to see a interface with the tables (currently 3 tables in use) or pages that they are able to edit?? Not sure how to create this portion, please I feel I am so close to completing just hit a wall.

Can you provide a simple "how to solution" for this in layman's terms please?

Thanks in advance!

Best,
Renea

Originally Said By: reneas.email303886

  Dear Support:

Okay I created a series of pages using DataAssist & Security Assist on my testing server. I want the client when they login using the admin_login.php page to see a interface with the tables (currently 3 tables in use) or pages that they are able to edit?? Not sure how to create this portion, please I feel I am so close to completing just hit a wall.

Can you provide a simple "how to solution" for this in layman's terms please?

Thanks in advance!

Best,
Renea  

Can someone please address my question

Thanks!

Renea

To understand correctly, you are trying to the tables of your database once the user logs in.

One way to do this would be to create an update page which will require you have three different record sets for each of the table, and then add three DA update server behaviors.

If you just want to view the tables, you can use tables and add use the DA Repeat Selection Server Behavior to loop over your tables.

You can also look at this url:

dataassist/

and look under the solution recipes, and click the Updating multiple records (Interactive Tutorial) tutorial.

Originally Said By: Dani Chankhour

  To understand correctly, you are trying to the tables of your database once the user logs in.

One way to do this would be to create an update page which will require you have three different record sets for each of the table, and then add three DA update server behaviors.

If you just want to view the tables, you can use tables and add use the DA Repeat Selection Server Behavior to loop over your tables.

You can also look at this url:

dataassist/

and look under the solution recipes, and click the Updating multiple records (Interactive Tutorial) tutorial.  

Dani:

Not sure if we understand one another. I created pages using DataAssist and SiteAssist for example events_update, events_delete, events_results, etc. When the admin logins in how do they navigate to each table or page to maintain their website? Need something similiar in nature to PowerCMS Admin Panel which I do own. Can you please tell me how to create the interface that the Admin will use to modify or maintain their website using the pages created in DataAssist. Thanks!

Best,
Renea

You would store their userID in the database along with any of the records they are able to update. Then you can filter the recordset by that UserID so that each person can only update their own records.

Ray:

Okay I have my DataAssist pages created and SecurityAssist, as well as, the HTML Editor installed for certain fields. What I need to know is how do I tie all Admin pages together with site navigation so that the admin once logged in has the ability to edit??

Do I need to use SiteAssist?? If so how do I apply my DataAssist code to the pages that SiteAssist generates??

Please provide detailed instruction on how to achieve this...Thanks in advance.

Best,
Renea

Site Assist sets a Session variable with the UserID of the logged in user. Now you just create navigation just like you would on any other site and create insert and update pages in that navigation. The only difference is that on those pages you can use the stored UserID in the session to filter the results from any recordsets you create or to insert into any rows that are added so that you can show only the results for a particular user. It is all done with the Recordset Filter and stored Session variables.