runs on local server but not remote server - help please!

**R1chard_Lew1s** · Nov 12, 2009 06:45

Hi,

My php gallery site talks to MySQL database on my Xampp testing server but I've not managed to successfully run it when uploaded to my remote server.

I've set up the remote database using phpMyAdmin and I've managed to successfully connect to it within Dreamweaver. It's created a /Connections directory and planted a file with the $hostname, $database, $username and $password variables correctly set.

It also created a command:
$mysite = mysql_pconnect($hostname_mysite, $username_mysite, $password_mysite);

So I added the other commands that I needed to get my database info which were

mysqli_set_charset($mysite, 'utf8')
mysqli_select_db($mysite, $database)
$result = mysqli_query($mysite, 'SELECT filename, orientation, rating FROM mytable');

and expected everything to work, but it just returns the http500 error.

In my local server I was using the command: mysqli_connect(etc.
What's the difference? Is that the problem?

Do I need to set up user priveledges on the remote database? If so, why can I see the database already in Dreamweaver?

Thanks
Richard.

**Zarin Denatrose** · Nov 12, 2009 13:46

Are you sure the remote server supports mysqli? It may only support standard mysql.

**R1chard_Lew1s** · Nov 12, 2009 13:51

I ran the info() command and it showed both mysql and mysqli. Does that mean it does support both? How can I check for sure?

"Are you sure the remote server supports mysqli? It may only support standard mysql"

**sparek** · Nov 12, 2009 13:54

What type of server are you using?

What are the permissions on the PHP file on the server?

An Internal Server Error would likely mean that something is preventing the script from running in the first place.