Ad:

PHP Discussion Thread
Marked Solved
Views: 4436

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Feb 11th, 2007

show content from another sites's database

Expand Post »

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

crazynp

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

58 posts
since Jan 2007

Permalink

Feb 12th, 2007

Re: show content from another sites's database

Click to Expand / Collapse Quote 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

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.

Rhyan

Reputation Points: 21

Solved Threads: 26

Posting Whiz in Training

Offline

240 posts
since Oct 2006

Permalink

Feb 12th, 2007

Re: show content from another sites's database

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.

chrisranjana

Reputation Points: 11

Solved Threads: 3

Junior Poster in Training

Offline

82 posts
since Jul 2005

Permalink

Feb 12th, 2007

Re: show content from another sites's database

Click to Expand / Collapse Quote 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.

Thanks Rhyan,

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.

crazynp

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

58 posts
since Jan 2007

Permalink

Feb 12th, 2007

Re: show content from another sites's database

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

PHP Syntax (Toggle Plain Text)

 mysql -h www.myweb.com:3306 -u root -p

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

Rhyan

Reputation Points: 21

Solved Threads: 26

Posting Whiz in Training

Offline

240 posts
since Oct 2006

Permalink

Feb 13th, 2007

Re: show content from another sites's database

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

crazynp

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

58 posts
since Jan 2007

Permalink

Feb 13th, 2007

Re: show content from another sites's database

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.

Rhyan

Reputation Points: 21

Solved Threads: 26

Posting Whiz in Training

Offline

240 posts
since Oct 2006

Permalink

Feb 14th, 2007

Re: show content from another sites's database

Thanks Rhyan.

crazynp

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

58 posts
since Jan 2007

Permalink

Feb 14th, 2007

Re: show content from another sites's database

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.

DarrenC

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

5 posts
since May 2006

Permalink

Feb 15th, 2007

Re: show content from another sites's database

Click to Expand / Collapse Quote 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.

The IP address are of different range. Is creating RSS feed is better than this?

crazynp

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

58 posts
since Jan 2007

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Opening Header in a new window?

Next Thread in PHP Forum Timeline: simple url variable

DaniWeb Message

Cancel Changes

User Name
Password