Letting other website access my database?

Reply

Join Date: Sep 2007
Posts: 32
Reputation: upstream is an unknown quantity at this point 
Solved Threads: 1
upstream's Avatar
upstream upstream is offline Offline
Light Poster

Letting other website access my database?

 
0
  #1
Apr 14th, 2008
hi all,

i'm almost done with the program im doing. one last thing i must do is to implement a search box dropdown on the other website with a dynamic content coming from our database. prob is, of course i dunno how to do that? xD

is
  1. require_once("http://www.mywebsite.com/include/db_connect.php")
will do? i'll be experimenting later, but i need some idea so it wont take long..

im also concern with security...

any help?

im using cPanel bdw..
Programming = new Art
---
I <3 BoA Kwon
Reply With Quote Quick reply to this message  
Join Date: Aug 2005
Posts: 150
Reputation: sDJh is an unknown quantity at this point 
Solved Threads: 13
sDJh sDJh is offline Offline
Junior Poster

Re: Letting other website access my database?

 
0
  #2
Apr 19th, 2008
first: you could try to access your databse directly (eg. mysql_connect("http://www.blah.com"); ). But that's in most cases restricted.

so you better do it this way:
write a simple php-routine and put it on the server where your database is running. Select all data you want to display on the other one and just echo them so that you get a plain text.
On the other server you can get these data with pfsockopen (http://de3.php.net/manual/en/function.pfsockopen.php).
For security you can have a simple password that you send via HTTP (a bit unsave though). If it's not enough then crypt it with MD5 or RSA (see wikipedia).

One more thing: pfsockopen is also restricted on some server. So try it out before you do all the fuss with coding.
Last edited by sDJh; Apr 19th, 2008 at 5:25 pm.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the PHP Forum
Thread Tools Search this Thread



Tag cloud for PHP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC