English 中文(简体)
从有不同数据库的其他子域获取数据的最佳方式是什么?
原标题:What is the best way to get data from other subdomain with different database?

I have a mainwebsite and a subdomain. They both have different databases, config files, ... The file getinfo.php in my subdomain gets the numbers of active topics. What is the best way to display this on my homepage? How can I execute the getinfo.php, get that data and display it on my homepage? Or is there another possibility to do that?

我认为,连接第二个数据库不是一个好的想法。

最佳回答

I don t know why you re opposed to connecting to multiple databases simultaneously. But, if you re so flatly against it then I m sure you have a good reason to be. A hacky solution would be to write a page on the subdomain to provide the data from the database you don t want to connect to via some easily-parsable method, like serialized string, JSON, or XML. Then, use cURL on your other page to fetch this data. There are obvious security concerns that you ll have to account for, such as how you ll ensure the other page isn t accessed by anything but your script.

问题回答

If you have 2 databases you can t do other than connect to the 2 databases. And if they are on the same server you won t get that much overhead

Send a cURL request from your homepage to a PHP file on your subdomain that takes that cURL request and outputs the HTML for your top posts. Then just echo the $output of the cURL.





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签