Please Help!

MitchEvans

I'm new to PHP and have designed a MySQL database with all the data and MySQL statements such as SELECT. The MySQL is fine. My problem is when setting up the php software, how do I know what goes in the "SMTP server" box and "from address for mail purposes" box. I tried localhost as I don't have my own web space yet, but still couldn't get it to work. I have downloaded PHP 5 and 4, because apparently PHP4 talks to MySQL better. If anyone can help, please!!!!! 😕

Houdini

The SMTP would bee the samme as what you use with Outlook or Outlook Express or Thunderbird, etcetera like mail.yourisp.com and the from address would be your own email you@yourisp.com in the php.ini file.

MitchEvans

Cheers for replying so soon, so how do I configure apache to use it, as the process still won't complete due to apache not being able to read something, it's a nightmare! :mad:

thorpe

the process still won't complete due to apache not being able to read something, it's a nightmare!

That sort of infomation doesn't help us at all. You need to be much more specific.

start by telling us what operating system your using and weather or not you have access to a mail server?

MitchEvans

I'm using Windows and yes I havew access to have a mail server. When testing apache it says it cannot find apache2

thorpe

What says it cannot find apache2 ?

Houdini

Download the XAMPP or WAMP then run the install, after about five minutes after you start the install you will have Apache, MySQL and PHP, possibly Perl if you get XAMPP and it will be ready to use. Just follow the default install procedure accepting the defaults. It is simple and will save you all the headache of trying to set it all up yourself.

MitchEvans

Thats excellent Houdini!!!

Ive been doing PHP all morning now, its set up as local host and is working fine. Just trying to get data from my MySQL database now. Any tips? Thanks again!

MitchEvans

This is the message given to me:

Not connected : Can't connect to MySQL server on 'localhost' (10061)

Houdini

The default username is root and the default password is (NOTHING) it does not have one so your connection will be like this:

$connect = mysql_connect"(localhost","root", "")
  or die("Could not sonnect to database server. MySQL said: ".mysql_error());
//or you could use
$connect = mysql_connect"(localhost","root")
  or die("Could not sonnect to database server. MySQL said: ".mysql_error());

MitchEvans

This is the error it then gives me, any idea??

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in C:\Program Files\xampp\htdocs\ecs.php on line 41
Could not sonnect to database server. MySQL said: Access denied for user 'root'@'localhost' (using password: NO)