working with database on local system

ferazzo777

Hi Guys, im pretty new at PHP.
I have this website done in php by the developer and im trying to do the same website..,

I have downloaded all the contents and database but having trouble on working on my local system. Basically I know how to insert data from forms but having trouble accessing the database.

Here are the codes to access the database:

$path_check = '';

if ( file_exists(dirname(FILE).'/LIVE') ){
$path_check = 'live';
}elseif ( file_exists(dirname(FILE).'/STAGE') ){
$path_check = 'stage';
}

switch ( $path_check ){
case 'live':
define('SERVER_MODE', 'LIVE' );
define('HOST' , 'http://some.url/' );
define('DB_HOST','');
define('DB_USER','');
define('DB_PASS','');
define('DB_NAME','' );
define('MAIL_HOST', '');
define('MAIL_USER', '');
define('MAIL_PASS', '');
define('MAIL_PORT', 25 );
define('MAIL_AUTH', true);
define("MAIN_SITE_URL", 'http://some.url/');
$campaign_startdate = '2009-05-01';
$campaign_enddate = '2009-06-15';
break;
case 'stage':
define('SERVER_MODE', 'STAGE' );
define('HOST' , '' );
define('DB_HOST','');
define('DB_USER','');
define('DB_PASS','');
define('DB_NAME','' );
define('MAIL_HOST', '');
define('MAIL_USER', '');
define('MAIL_PASS', '');
define('MAIL_PORT', 25 );
define('MAIL_AUTH', true);
define("MAIN_SITE_URL", '');
$campaign_startdate = '2009-05-01';
$campaign_enddate = '2009-06-15';
break;
default:
error_reporting(E_ALL);
define('SERVER_MODE', 'LIVE' );
define('DB_HOST','mysql55-45.wc1.dfw1.stabletransit.com');
define('DB_USER','username');
define('DB_PASS','password');
define('DB_NAME','some database' );
define('HOST' , '' );
define('MAIL_HOST', '');
define('MAIL_USER', ');
define('MAIL_PASS', '');
define('MAIL_PORT', );
define('MAIL_AUTH', true);
define("MAIN_SITE_URL", 'http://www.someurl.com/');

for the 'default' I have tried to change SERVER MODE = STAGE, DB_HOST = localhost, DB_USER=root, DB_PASS= root, DB_NAME = thedatabasename.

but I got no luck, someone please let me know the right code for this, as I have manage to work on it online but not on my local system.

Any feedback will be much appreciated

Cheers

BuzzPHP

1) You must have MySQL installed.
2) You must have MySQL extentions installed with you PHP installation (This isn't always the case)
3) Host is localhost. yep
4) Username is most likely "root"
5) Password is "root"? Are you sure? Did you set it as root when you installed MySQL
6) Database is "thedatabasename"? Are you sure? Did you login to the mysql console and create a database called "thedatabasename"?

I would code up a little PHP script that trys to connect to your mysql database using standard mysql function calls. Check for errors and print out the errors to the screen.

Then at least you know the connection between PHP and MySQL is working.

Behond that, you might have all kinds of problems, like, how are the tables created? Do you need to run a script to create the database tables, as is the case for most database systems.

Always "check your assumptions".

Check what you assume to be correct. Eventually you will find what is incorrect and bingo, you have a solution.

ferazzo777

First of all thx for the reply.

MySQL is installed - yes
Im pretty sure the password is 'root' because I have set up a small php file test and have gained access to the database. (create , retrieve etc)

the database name is not 'thedatabasename' it just a dummy name. I know what the real database name is.

As I mentioned, I can work on the script and the database online but not on my local system.

Im guessing it just the matter of wrong configuration like the host name or DB_HOST name or the SERVER MODE... im NOT sure ...

thx again..

BuzzPHP

mmm, bugger.

Ok, so you have a valid working system. Now assuming the syntax of your PHP is correct

(BTW, I use Delphi 4 PHP's IDE because it checks my syntax for me, and formats my PHP because im somewhat lazy.... and computers do syntax checking better than humans)

Anyway, then another option is try setting your SERVER_MODE to LIVE, as that setting might be used somewhere that is required for a working system. Also, MAIN_SITE_URL might need to be set to something like "http://localhost/mysite"

The fact is, if you cant make simple changes like this, then you need to run a trace. Again, Delphi 4 PHP has a nice trace tool.

But, you can just run though the code a write "Verbose" style functions to output status/error messages.

Another idea is, some live MySQL databases accept remote IP addresses from which they will accept a connection.

ie: My live database allows me to enter my IP and then I can connect from my local server. But, if you dont have a static IP, then you will need to update this each time you connect.

Other than that, Do you have all the tables created on your local machine?

I have worked on some systems where ALL the tables where created by hand. So, I needed to export the database tables as SQL and then run the SQL script on my local machine.

And just to top things off. I had one system that required a single record to be created by hand before it actually worked! As all records added were linked to this "root" record.

Then you may have issues runing linux based PHP on a Windows server.

Sorry, I cant give a clean answer. I wish I could just say..... "theres ya problem!"

Hope you all the best.

rincewind456

You don't actually say if you have a web server installed on your local machine!

Do you?

If your not sure open a browser and put 127.0.0.1 in the address bar, what does it say?

Weedpacket

You also don't actually say what exactly is happening when you try it on your local system. It's hard to make a diagnosis when you don't know any of the symptoms.

ferazzo777

Hi,

I do have a web server on my local system of course, its MAMP on my Mac.

Basically Im trying to get information from 'forms' and save it into database. The script all working well when I work online and able to save it into database but when I am getting no luck on working on my local system, when I click submit it stays on that page instead of going to a page that says "thank you for entering" and its not saving to the database

Im sure it must be the configuration
"default:
error_reporting(E_ALL);
define('SERVER_MODE', 'LIVE' );
define('DB_HOST','mysql55-45.wc1.dfw1.stabletransit.com');
define('DB_USER','username');
define('DB_PASS','password');
define('DB_NAME','some database' );
define('HOST' , '' );
"

Pretty sure thats the configuration to work online, can someone tell me the right configuration to work on my local system?

I tried: db_host - localhost, db_user - root, db_pass - root, db_name - thedatabasename ..

but no luckk..
HELP?

cheers