MySQL Forums
Forum List  »  PHP

php mysql script not writing to localhost database
Posted by: Ron McCain
Date: March 09, 2009 11:11PM

Hi all,
We have a php mysql engineering application running on a live site hosted on a shared server and all is well. We need to maintain and modifiy the application periodically so we setup a localhost development server at our office to code and debug before going back to the live site with the modifications. We use Zend php IDE studio 5.5 to do our coding so we also used the ZendCore package to set up our dev. server (apache,mysql,php), we also licenced and installed ZendPlatform for fully integrated debugging from any of our client systems to the localhost server where we have our application and Zendcore setup. Our intention was to setup the localhost to mirror the live site so that we could test the new code and then depend on new code being reliable when moved to the live site for our customers access and use.

We got everything setup and working except that with the exception of one table where we store one of the many query results from user input and combinations of user input and database record, none of the other MySql queries will write to the database on the localserver. We can connect to the database on the localhost server and do manual queries and database looks and our php mysql script reads and returns all queries while running the script. We get no database errors from the debugger and the program runs to completionn on all pages tested. Also,All of the applications we are testing during our setup of the localhost development platform are working now on the live site.

Our question is , with the same code, the same database and basically the same server support why cant we write the database on our localhost. As far as we can tell the only difference(s) we can indentify is that....

1. the live site is linux and the localhost is Windows Xp Pro.(apache, mysql,php)
2. php5 is on the localhost server instead of php4 which is on the live hosted server.
3. the site and development url address(s) are different of course.

4.One other address related issue is that we have to call our localhost server by its //IP:port/ intead of just localhost because this was required to get our integrated Zend debugging platform working as advertised.

All of our people are stumped and we are trying to maintain this app ourselves to hold down costs so if you guys can help we would be grateful. Any additional information anyone might need to render assistance will be gladly provided
Thanks

Ron



Edited 1 time(s). Last edit at 03/09/2009 11:13PM by Ron McCain.

Options: ReplyQuote


Subject
Written By
Posted
php mysql script not writing to localhost database
March 09, 2009 11:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.