| | |
Letting other website access my database?
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
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
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..
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
PHP Syntax (Toggle Plain Text)
require_once("http://www.mywebsite.com/include/db_connect.php")
im also concern with security...
any help?
im using cPanel bdw..
•
•
Join Date: Aug 2005
Posts: 150
Reputation:
Solved Threads: 13
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.
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.
![]() |
Other Threads in the PHP Forum
- Previous Thread: ooccurence of a string in a file
- Next Thread: favicon.ico was not found
| Thread Tools | Search this Thread |
ajax apache api array back basic beginner binary broken cakephp checkbox class cms code computing confirm cron curl database date delete display dynamic echo email error file files filter folder form forms function functions gc_maxlifetime google host href htaccess html iframe image include insert integration ip java javascript joomla limit link login loop mail malfunction memmory memory menu mlm multiple mysql navigation oop parsing paypal pdf php problem query radio random recursion regex remote script search server sessions sms snippet soap source space sql syntax system table thesishelp trouble tutorial update upload url validation validator variable video web xml youtube





