SQL Data not being pulled in

andrade1379

Hey guys,

I'm having a problem. Is there any way around having my table on one server and having my PHP script and database in another?



Thanks!

Matt

andrade1379

Due to the amount of characters in a post I had to remove some syntax...

andrade1379

Anyone have any insight?? i'm really stuck and confused as to why this is not working.

allan

Hi andrade1379,

Basically the problem is Cross Site Scripting (XSS) security used by all modern web-browsers. You cannot load Ajax data from a different domain from the location of the page. The reason for this is that XSS is a rather nasty (and very effective) way of hijacking user information. As such, you need to have your PHP script in the same domain as your web page. So ways around this:

1. use a proxy script to grab the information
2. just put your PHP script on the same server as your web page and add a SQL user with read access to the database
3. Flash remoting can be used to get around this...

Regards,
Allan