Hi everyone, im new to PHP and have found the code that i needed in this book. however i am having problems running the code and the mysql statements on my local machine and the remote server. can anyone help me out please?

Many thanks in advance.

It is typically good form to specify what code you are using, what you have attempted to do to run said code, and what errors you are getting. You have not provided any information that would be pertinent to solving your problem.

hth
-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

Basically I was looking for user registration code and have found it in this book. However because I am totallt new to PHP/Mysql I do not knwo how to upload the completed code along with the sql table that has been provided. I do have a local installation of apache, Mysql, PHP (WAMP) but when i try to run the code locally it says 'cannot connect to database' error. could you please suggest the steps I need to make it run successfully.

Many thanks again for your reply previously it is very much appreciated.

Just so you know I am not a PHP guy so I won't be able to provide you much in the way of code, luckily you aren't asking a language specific question ;]

What is the exact error? 'Can't connect to database' seems overly generic and there are only about 123459820 things that can cause this type of error. What does your connection string look like?

-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

Thanks for the quick reply, the code for connecting to the database looks like this:
<?php
// database connection and schema constants
define('DB_HOST', 'localhost');
define('DB_USER', 'username');
define('DB_PASSWORD', 'password');
define('DB_SCHEMA', 'WROX_DATABASE');
define('DB_TBL_PREFIX', 'WROX_');

// establish a connection to the database server
if (!$GLOBALS['DB'] = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD))
{
die('Error: Unable to connect to database server.');
}
if (!mysql_select_db(DB_SCHEMA, $GLOBALS['DB']))
{
mysql_close($GLOBALS['DB']);
die('Error: Unable to select database schema.');
}
?>

Alright, first off can you connect to MySQL, either through the command prompt shell or any of the gui tools, using localhost as the server name, and username and password as the username and password? If the answer is no then you need to either A) modify the PHP code so that it has a valid username and PW or B) Log in and create a Username and Password for your application to use. (I don't recommened using Username and Password either! ;])

Secondly, based upon the error you are getting, this line of code is being executed:
die('Error: Unable to connect to database server.');

So do this instead:


This *should* print out a more detailed error message.

hth.
-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

yes I can connect to the msql database via the command line. I have changed the connection code as you suggested, and the error that I get is:

Error: Unable to connect to database server. MySQL Error is: Access denied for user 'username'@'localhost' (using password: YES)

Do i have to create a database for the table that has been supplied with the code? What i did is basically load the code into the wamp folder for it to run and i have not created anything in mysql. does there need to be a corresponding database table in mysql for the pre-written scripts to access?

The error you are getting either means the password is incorrect, the user doesn't exist, or the user is not allowed to access the server.

I am not sure how the code download is structured for this book but it would stand to reason that somewhere in there is a .SQL file that you could execute that will build all of the necessary tables, sprocs, and so on. So, to answer your question, yes you must setup MySQL with the proper database (Schema), tables, and so forth otherwise all of this is for not.

hth.
-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

There is a SQL called tables, how can i execute this file for it to build all the necessary tables, sprocs etc?

Once again many thanks for your assistance