How to manage the entire db

KHRR

New Member
Hi everyone,

I'm using Fabrik 3 on Joomla 2.5 and i would like to manage all my tables from my database in one form ?
Can you tell me if it's possible or not, and if it's yes how to make it ?

Thanks a lot !
 
Hi,

You can use your phpmyadmin to create a view based on the different tables of your DB.
The obtained view can then be used to define a list in fabrik. finally this list will define a form from where you can use/read your tables data

To create a view use SQL: CREATE VIEW..... (for more info search the internet)
hope this help
 
Hi Rali,

Thanks a lot, that was helpfull !
I can now manage all my db with any problem.

See ya !
 
Finally i've got a problem,

when i've made my view and use it on my site, i can't add some informations by using a form.
I've got this message :

"Store row failed:
Can not modify more than one base table through a join view 'testfabriksa.v_db' SQL=INSERT INTO `v_db` ......."

Can't i manage all my tables from my db with this view ?
 
sorry but through views generally you can only read and display data from different tables. to solve your problem you need to use the php plugins which will present more challenges. you can find info at http://fabrikar.com/wiki/index.php/Main_Page
or http://fabrikar.com/wiki/index.php/Form_processing_plug-ins

A suggestion why don't ypou use many forms each one linked to one table let's say 4 forms and then put these forms in the same article using {fabrik view=form id=x}.
If the forms are put adjacent in a table, they will look like being one form.
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top