Multiple domain and it's content management from single admin in PHP/MYSQL

At this point Iam trying to merge two different databases of two different sites into one. Next step is to build 1 admin panel to manage more than 1 domain, and its content .. all in same server. is it possible in php/mysql. .. Please let me know.. So far when i googled , its showing WP plugins. But i need this to be built with core php. What is the level of complexity here ..Any framework is recommended ?
Please help !!
codeoxygenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

arnoldCommented:
not clear what you want.

You can host multiple domains on the same IP using host headers to differentiate among the many.
You could by the structure in the DB differentiate among the many.

One option is to pass info that will differentiate among them.

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
Vimal DMSenior Software EngineerCommented:
Hi,

It is based on the FRAMEWORK or CMS that your planning to choose

1) In core php you can have two different connection string to manage the records in the same admin panel & even in end user side

2) Based on the framework or cms that you choose will have plugins or extensions, that will merge the databse

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
Dave BaldwinFixer of ProblemsCommented:
It's doable and the complexity is up to you and what you want to do.  I would put the database on one host along with phpMyAdmin to administer the database.  Just make sure the database is accessible from the other domain.
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Ray PaseurCommented:
People do this all the time (think every advertising platform since about 2004) and it's very easy if you understand how the parts work together and follow the general designs that have evolved to handle these applications.

First, you create the canonical data source.  It is your "merged database" and it is hosted on a server that contains all of the content that you want to present on any of the public-facing web sites.  But its URL only responds to requests from certain authenticated clients.  You call it via an API.
http://www.experts-exchange.com/articles/12239/Introduction-to-Application-Programming-Interfaces.html

Now that your data source (the Model) is in place, you can build the public-facing web sites.  These sites contain the presentation layer (Controller and View) for the data.  When a web page is requested from one of these public sites, it calls the API to get the data and inserts the data into the document used in the response to the request.

In this design you have a client (human) that uses a browser to make a request to a server (your public sites).  Then your public site becomes a client (machine) that makes a request to a server (your API).  The data flows back up from the API server to the web site server, and then to the client browser.  It's important to understand the Client/Server relationship!
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/A_11271-Understanding-Client-Server-Protocols-and-Web-Applications.html

You will probably want to use JSON to transport response data between servers and clients.
Julian HansenCommented:
Not a big fan of drupal but it apparently does support this
https://www.drupal.org/documentation/install/multi-site
Ray PaseurCommented:
If you're experienced with web APIs and frameworks, a modern solution set might be Laravel and AngularJS.  Google them and you will find many useful online learning resources.  They can be integrated into RESTful MVC applications.

If you're not familiar and experienced in these technologies, you might be better off building your own for a "starter system" to see how the parts work together and to learn the debugging tools you will need!  From observation and personal experience, I can assure you that your first effort will be a throw-away, but you will learn a lot from the time you commit to the project.
codeoxygenAuthor Commented:
Well said Ray Paseur ... Iam honestly interested in building applications. But unfortunately a beginner .. How should i approach.. Should i hire an expert for a some weeks to work closely on the project and learn the best or what should i do?.. I prefer to learn things practically than books.. Please help !!
Ray PaseurCommented:
You could hire an expert, or use something like CodeMentor (full disclosure - I have never tried CodeMentor, but it sounds like a good idea).  Or you could just work your way through the learning and examples in this article.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html

I believe that we all learn better from examples, and any of the books and online resources listed there have many great examples.  You can copy them, modify them, install them and run them to see the effects.  When I started with PHP in the 1990's I began by building a teaching library that was nothing but examples of solutions to everyday problems.

One of the learning principles for complex technical activities like programing is "fail fast."  This means that you want to create a work environment in which testing and data visualization are the easiest things in the world.  A "one-touch build" is important.  The ability to see logs and visualize errors is important.  Take care of those things first - the things that reveal errors - and you will never waste time wondering if your code worked.  Always be able to see that.  And best of luck with your project!
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
PHP

From novice to tech pro — start learning today.