Use existing create/edit/delete procedures

3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 3, 2013   (RSS)

By rconring - January 2, 2013 - edited: January 2, 2013

I thought I saw some time ago somewhere in the forum a discussion on using the existing admin CRUD to manage a database view from the front end calling it with a link like http://somesite.com/cmsAdmin/admin.php?menu=sometable&action=edit&num=recordnumber.  This all works great, but I cannot figure out how to alter the redirect after save or cancel to go back from whence it came and reload the frontend page and cannot locate the discussion, if it did exist.

Is there a way to accomplish this without serious customization of the admin code?  I hate to complicate any future upgrades and this would allow me to present the data in highly customized views and not have to re-write the update procedures in the front end.

Ron Conring
Conring Automation Services
----------------------------------------
Software for Business and Industry Since 1987

By rconring - January 3, 2013

Thanks for your reply.  The answer to your first 3 questions is yes, yes and yes.  I am using CMSB to build the data framework for online business applications for some of the clients that I have done sites for.  I have, in the past, used AppGini from Bigprof Software since that is what is is designed to do but have used CMSB to build some fairly complex apps.  The rub is that I have no problem writing the code for some fairly complex and interactive data views but find it extremely tedious to write the update procedures with my limited knowledge of PHP and MySQL. 

For the most part the complexities lie in the views but the existing back end CRUD procedures usually suffice.  I discovered that I could create the links in the front end view to call the back end update so all I need now is the redirect back to the calling view.

No, I haven't delved into plugins yet, but I guess the time has come to tackle that.  If I get stumped (a relative certainty) I will get with consulting.  In the meantime, if someone out there has done this I would like to hear from you.

Ron Conring
Conring Automation Services
----------------------------------------
Software for Business and Industry Since 1987