 |  |  |  |  |  |  |  |
show content from another sites's database
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Jan 2007
Posts: 58
Reputation: 
Solved Threads: 2
Junior Poster in Training
Hi,
I am building three websites. The first site has a mysql database with necessary contents for two other sites. The two websites should show the content stored in the first site's database, is it possible without using xml? or is xml the best way or is there any other way to do it?
Regards!
Binod
I am building three websites. The first site has a mysql database with necessary contents for two other sites. The two websites should show the content stored in the first site's database, is it possible without using xml? or is xml the best way or is there any other way to do it?
Regards!
Binod
•
•
Join Date: Oct 2006
Posts: 232
Reputation:
Solved Threads: 24
Posting Whiz in Training
•
•
•
•
Originally Posted by crazynp 
Hi,
I am building three websites. The first site has a mysql database with necessary contents for two other sites. The two websites should show the content stored in the first site's database, is it possible without using xml? or is xml the best way or is there any other way to do it?
Regards!
Binod
If the 3 websites are not stored on the same server, then the server where the mysql database is should allow connections from the internet, not only localhost requests.
If the sites are hosted on a public webserver, I doubt that the server would allow access from the internet, as it is potentially unsafe.
Still, if you can perform grants, you can configure a read-only access to the database for a user, explicitly allowing access from the IP of the website that needs to acces the database. It seems confusing, so I will explain like this:
1. website 1 holds the database.
2. website 2 needs access to the database of website 1 from ip 1.2.3.4 .
Create a user named e.g. web2 with pass web2 in the database server.
Grant to user web2 SELECT on DATABASE.* from host with ip 1.2.3.4.
open port in firewall at website1 server for access to the database server normally on port 3306 for mysql.
it should work this way.
If you need any info check resources available on mysql.com or check the hosting server help and faq manuals and sections on how to allow access, grant permissions, etc.
•
•
Join Date: Jul 2005
Posts: 78
Reputation:
Solved Threads: 3
Junior Poster in Training
Would the first site's database get updated frequently.
If not you can achieve good performance if you run a cron script to transfer content from the first site's database to your other server periodically.
If not you can achieve good performance if you run a cron script to transfer content from the first site's database to your other server periodically.
Chris, Director, Chrisranjana.com
Web developers and software programmers.
Web developers and software programmers.
•
•
Join Date: Jan 2007
Posts: 58
Reputation:
Solved Threads: 2
Junior Poster in Training
•
•
•
•
Originally Posted by Rhyan
Are the 3 websites hosted on the same server?
If the 3 websites are not stored on the same server, then the server where the mysql database is should allow connections from the internet, not only localhost requests.
If the sites are hosted on a public webserver, I doubt that the server would allow access from the internet, as it is potentially unsafe.
Still, if you can perform grants, you can configure a read-only access to the database for a user, explicitly allowing access from the IP of the website that needs to acces the database. It seems confusing, so I will explain like this:
1. website 1 holds the database.
2. website 2 needs access to the database of website 1 from ip 1.2.3.4 .
Create a user named e.g. web2 with pass web2 in the database server.
Grant to user web2 SELECT on DATABASE.* from host with ip 1.2.3.4.
open port in firewall at website1 server for access to the database server normally on port 3306 for mysql.
it should work this way.
If you need any info check resources available on mysql.com or check the hosting server help and faq manuals and sections on how to allow access, grant permissions, etc.
Again a little question
Can I do this if I have got only access to the cpanel of the website or do I need access to the WHM or where Can I configure that and if I can do that with cpanel how to do that?
Last edited by crazynp; Feb 12th, 2007 at 12:18 pm.
•
•
Join Date: Oct 2006
Posts: 232
Reputation:
Solved Threads: 24
Posting Whiz in Training
Well, it is not 1 but three questions 
.
Ok, now, I do not know how many and what opitons do you have on your control panel. But, if you are familiar with MySQL, you maybe will be able to do it on your own, if you answer the following questions:
1. Are you allowed to create database schemas on your server?
2. Are you able to create new tables on your server?
3. Are you allowed to create mysql database users, or you have been given a limit of only 1 user per database?
4. Are you able to grant permissions on your database and tables on your server? Especially check if you can grant permissions to mysql users to access from other locations than localhost!
5. Check if you can connect to your mysql database server from your home computer using the root password you have been supplied by the hosting provider.
E.g. your website name is www.myweb.com
run mysql console and type
You will be prompted for a password, and if everything is ok, you will receive a message like," welcome, blabla for help type /h for exit type /q"
If this test passes, then you will be able to access your mysql DB from the remote website.
If not, then we may be able to figure it out another way maybe.
Goodluck
. Ok, now, I do not know how many and what opitons do you have on your control panel. But, if you are familiar with MySQL, you maybe will be able to do it on your own, if you answer the following questions:
1. Are you allowed to create database schemas on your server?
2. Are you able to create new tables on your server?
3. Are you allowed to create mysql database users, or you have been given a limit of only 1 user per database?
4. Are you able to grant permissions on your database and tables on your server? Especially check if you can grant permissions to mysql users to access from other locations than localhost!
5. Check if you can connect to your mysql database server from your home computer using the root password you have been supplied by the hosting provider.
E.g. your website name is www.myweb.com
run mysql console and type
PHP Syntax (Toggle Plain Text)
If this test passes, then you will be able to access your mysql DB from the remote website.
If not, then we may be able to figure it out another way maybe.
Goodluck
•
•
Join Date: Jan 2007
Posts: 58
Reputation:
Solved Threads: 2
Junior Poster in Training
Thanks Rhyan!
I can create users but how to connect the database from another site other than local host? Can you give me a small example like query
Thanks in advance
I can create users but how to connect the database from another site other than local host? Can you give me a small example like query
Thanks in advance
•
•
Join Date: Oct 2006
Posts: 232
Reputation:
Solved Threads: 24
Posting Whiz in Training
As I have told you earlier, all your code should be the same as it is for website 1(where the database is), however, on website 2 instead of localhost in your mysql_connect statement you should insert website 1.
[php]
// from website 2 make the following
$connect = mysql_connect('website1.com:3306', 'website2_user', 'website2_password');
[/php]
The rest is the same...
If you have any difficulties, read the php and mysql dox more thoroughly.
[php]
// from website 2 make the following
$connect = mysql_connect('website1.com:3306', 'website2_user', 'website2_password');
[/php]
The rest is the same...
If you have any difficulties, read the php and mysql dox more thoroughly.
I don't know if you have thought of this, and whilst it's not directly answering your question you might be interested.
If you have 3 websites on the same IP range, make sure you don't link to the 3 sites, as the search engines could penalise you for this.
If you have 3 websites on the same IP range, make sure you don't link to the 3 sites, as the search engines could penalise you for this.
•
•
Join Date: Jan 2007
Posts: 58
Reputation:
Solved Threads: 2
Junior Poster in Training
•
•
•
•
Originally Posted by DarrenC
I don't know if you have thought of this, and whilst it's not directly answering your question you might be interested.
If you have 3 websites on the same IP range, make sure you don't link to the 3 sites, as the search engines could penalise you for this.
 |
Other Threads in the PHP Forum
- Previous Thread: Opening Header in a new window?
- Next Thread: simple url variable
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
5.2.10 action apache api array beginner beneath binary broken cakephp checkbox class classes cms code cron curl database date destroy display dynamic echo echo$_get[x]changingitintovariable... email encode error fcc file files folder form forms function functions google header howtowriteathesis href htaccess html image images include insert ip javascript joomla limit link local login mail memberships menu mlm mod_rewrite multiple multipletables mysql mysqlquery neutrality oop open passwords paypal pdf php provider query radio random record remote rss script search server sessions sockets source space sql strip_tags syntax system table template thesishelp tutorial update upload url validator variable video voteup web window.onbeforeunload=closeme; youtube
