Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Steps for form development, connected to a database that dynamilcally generated Modules, Articles Catagories on a web page

Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America asked on
Web DevelopmentMySQL ServerJoomla
3 Comments1 Solution810 ViewsLast Modified:
I have a Joomla site www.reportsolutions.com and I myself and a small team of others work with Crystal Reports Developer, MS Access Reports and SQL Reporting Services and their related scheduling and distribution products out there. I have done this for 12 years.

The goal is to have a page like the one seen below that has embedded blob and longblob fields in a relatively generic modular page layout. As we add all the different products we have worked with ie( QuickBooks Peachtree, Lawson, Great Plains, MAS 90, MAS 200, Navision etc. ) We would like the pages to fill in automatically the content we need seen in the "ApplicationPage..Image" I assume we could do single words up to paragraphs of information?

One thing I need to know is what to do first? Is it ....
1.) Create database with fields I need first I use MySQL
2.) Then point a tool like Joomla forms  or Fabrik to the fields I created in the database to be accessed by admins on the Joomla site?They will use the Joomla forms or fabrik to input new application software we will take on frequently.
3.) Then embed those blob fields and longblob fields into those Modules, Articles or Categories on a web page? See image below.

 I have never embedded database fields into websites before. So I would need examples or sample code to show how one would place a blob field into a Modules, Articles or Category on a web page. Any thing you could show me as I think this question will get some traction....?
Many of the embedded fields will be in articles and categories in the form of sentences and individual words like QuickBooks that I will change periodically.

Finally it might be good to know how I might go into the database or Joomla form ( if possible ) to change content periodically for updates and or changes to the application software. Any suggestions on editing tools like that is appreciated. Unless you happen to know if this can be done in a Joomla form or Fabrik. I think I may have to get an editing toll for that.....but not sure?

Thank you for being here. This site has renewed my faith in human kindness and generosity.

SolarSentinel-layout.png
ApplicationsPage-WithEmbeddedFie.png
ASKER CERTIFIED SOLUTION
Avatar of j-b-t
j-b-tFlag of Australia image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers