localhost database issue

[billteale]

Hi all,

I am trying to work with the program called OutSite-In to transform an online php based html site onto standalone offline version that can be installed from CD. I am having trouble getting a couple of things to work, and I wondered if anybody could shed some light?

I designed the original game (http://pressakey.net/snakes/) in Dreamweaver, and the code in the connections/SNAKES.php folder is...

<?php

FileName="Connection_php_mysql.htm"

Type="MYSQL"

HTTP="true"

$hostname_SNAKES = "localhost";
$database_SNAKES = "jdixon_signature";
$username_SNAKES = "jdixon_all";
$password_SNAKES = "XXXXXXXXX";
$SNAKES = mysql_pconnect($hostname_SNAKES, $username_SNAKES, $password_SNAKES) or trigger_error(mysql_error(),E_USER_ERROR);
?>

(I XXXXX'd out the password, but it is correctly entered in the file.)

But when this is called from the page, I get the following error...

Fatal error: Call to undefined function mysql_pconnect() in C:\Program Files\OutSite-In_Standard\OpenedProject\source\files\Connections\SNAKES.php on line 9

I trried asking the OutSite-In support team, but they are not willing to get involved in php coding. I was wondering if anybody had any ideas as to what I am doing wrong?

Also, the game involves the php file writing text files on the fly, that control the audio. Online I ust changed the CHMOD of that particular directory to 777, how can I do that offline during installation?

Many mnay thanks!

Bill.

[bpat1434]

Sounds like the mysql extension doesn't allow persistent connections.... or php isn't running in module mode.

Do a quick check on your server and generate a phpinfo() script to see if MySQL is in fact installed and working, and whether or not pconnect is allowed.

[bradgrafelman]

You might instead look into using the [man]MySQLi[/man] or, better yet, the [man]PDO[/man] extension to query the database.

Also note that in most cases, using the _pconnect() command is dangerous/fatal.

[billteale]

Thanks guys,

Your replies are way over my head, grins! The offline mysql and php should be controlled by the program right?

I got the darn pages to work online, and this OutSite-In program is supposed to change everything that works online to work offline. It doesn't, and support is unhelpful to say the least.

I'm ditching it, and starting again. Any ideas on how I can get this game on CD would be greatly appreciated, before my hair is completely gone!

Bill

[bpat1434]

You can run your own server to host PHP, MySQL and Apache on a CD.... you just can't update or modify anything once it's burned. Look into PortableWebApps, or XAMPP to allow you to run them from a CD or USB drive. Then it's a matter of writing a quick auto-start file for windows PCs to read and start the server(s) and maybe open the index.php file 😉