Multiple database update on article submit.

Hello everybody, am a programmer since 14 years in windows technology and I've used PHP a bit but am far from being an expert in PHP. Anyhow this to say that here's what I want to do:
Joomla 1.5.15.

I have 16 sites on subdomains that are running ( at this moment ) an exact copy of each others. So same site on 16 different subdomains all running on they're own separate database. On one of this subdomain, from the FRONT END we could log in and edit the articles ( cannot add just edit them ). Now what I want to do is add under the METADATA section another section that would list the 15 other websites with a check box beside. Once the article edited the user will checkmark the sites that he/she wants to have this article publish to also.  So basically if I checkmark the 15 website well when I will hit the save button I want to insert this articles in the 15 other database as well.

Pretty simple in theory but I have no clue on how to do it in Joomla cause am all confused with the extensions.. modules.. plugins.. and so on..

Can you help me out on pointing me on how I need to do it ( not code it for me )  but really the structure of what I have to do..  Currently I have manage to add the form under the METADATA section that list the websites with the checkbox.. I have edited the file in : \templates\templateName\html\com_content\article\form.php   -- Maybe this is not even the good way to go?
Anyhow, this is why I am asking for some help.
Thanks
LVL 1
DaDManAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Member_5340450Commented:
Start here:
http://www.google.com/search?q=joomla+multisite&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
Specifically here:
http://extensions.joomla.org/extensions/core-enhancements/multiple-sites/5550

The Joomla multi site component has evolved so much since the last time I looked at it that I can't say absolutely where it stands in relation to your issue. It seems really close.

Component: becomes the content for a page, populates the page body where would otherwise expect to see article content, such as a calendar or a photo gallery
Module: occupies a specific template position to execute its behavior, such as a login form or a menu
Plugin: operates silently upon the content before rendering, such as a button that gets added to a wysiwyg editor or a filter that searches for email addresses and encrypts them from spam bots.
0
Member_5340450Commented:
Forgot this link: all items in category multi site:
http://extensions.joomla.org/extensions/core-enhancements/multiple-sites
0
DaDManAuthor Commented:
hum.. this is interresting. Did'nt know about that. -- but this would involve that I install Joomla multisite , which I dont know the work involved.. ( dont wanna get in more trouble than I am now! :D )

Would'nt it be easier for me to simply trap the checkbox that was checkmarked on the edition article page ( of the front end site, because the user wont use the backend.. too complex for them... ) and then save all the related data into the checkmarked database? That was my first thought..  The only problem is that I dont know what file to edit...
0
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Member_5340450Commented:
OK without research I don't know either (sorry I'm jammed today) but my thought is that you have to follow the MVC Joomla coding procedures or you will end up wishing you had bought some code to solve the problem. It's a learning curve either way.
0
DaDManAuthor Commented:
Ok well here's what joomla_php ( and thanks alot for your help ).

The solutions found will be this ( alot easier ). I will do a custom page that I will integrate in the front page. This page will have a select list that will contains all the articles name ( need to know how to populate this or is there a plugins, component that allows me to do that ? ) and wlil list the 16 websites with checkboxe's beside. User will select an article and checkmark the website that he wants to publish the article to. hit save and thats all.

So, is there any plugins that allows me to create my page and populate the list box with the db fields? As far as for the bulk insert in the multiple database I could manage to do it with some sql queries upon the save.

Thanks for your help and for pointing me out in the good direction.

0
Member_5340450Commented:
You could model your solution from this one which allows any type of html POST
http://extensions.joomla.org/extensions/contacts-and-feedback/contact-forms/7901

or these contact forms
http://extensions.joomla.org/extensions/contacts-and-feedback/forms

This should allow you to write any code you like in a textarea and publish it to any page
http://extensions.joomla.org/extensions/edition/custom-code-in-content

This might be a cool way to solve it, use a database app
http://extensions.joomla.org/extensions/hosting-a-servers/database-management/10330
http://extensions.joomla.org/extensions/hosting-a-servers/database-management

Hope this isn't too general.

I don't know how to populate a select list (select and options, right) but I will bet you will find that in the first link I posted.




0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DaDManAuthor Commented:
Hi there. Yep I've got something started now and your help was appreciated.
Thanks heaps.

Have a nice evening

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Joomla

From novice to tech pro — start learning today.