Forum Moderators: coopster

Message Too Old, No Replies

php5 and mysql4

         

ag_47

5:12 am on May 1, 2008 (gmt 0)

10+ Year Member



I have installed an apache server on my pc, for testing purposes.
The server is set up and running, everything seems fine.
I also installed PHP (the latest one, 5.2.5) and configured it with the server. phpinfo(); seems to be working nicely.
Next I installed Mysql (essentials, v4.1.22) and installed that. It seems to be configured fine, I can manage dbs using the cmd.
BUT, now when I try to enable mysql extensions to php, i seem to hit a wall :(

Everywhere it says to look for [extension=php_mysql.dll] and uncomment it. But when I start the server I get [Unable to load module C:/ .. ext/php_mysql.dll], but the module is there! (along with a whole bunch of other ones... )

I need some help.. the dll is there, i can't seem to get it detected..

edit: It seems to load fine now, but mysql functions are still undefined

coopster

8:56 pm on May 1, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Does the extension_dir configuration directive in your php.ini match the path to the "ext" directory of your PHP installation? Example:
extension_dir = "c:\php\ext"

ag_47

9:53 pm on May 1, 2008 (gmt 0)

10+ Year Member



Hi, after more digging, I got it working, I had to move some dll's around as someone somewhere advised. Its all good now.

Anyway, just another quick question, I'm having trouble storing emails into a mysql table, it doesn't like the @ sign.
If I type the command in myself, using the MySQL CMD everythings fine/
But when php tries it, or I copy-paste from the browser the '@' sign coughs up. The command:

INSERT INTO tbl_name VALUES (
dat1, data2, data3, email@site.com);

Probably has to do with character encoding..

ag_47

11:38 pm on May 1, 2008 (gmt 0)

10+ Year Member



errm, fixed that, but now I'm having trouble sending emails from php :(
Is there an easy way to set up a mail server on xp? Like outlook, or cmd prompt? I don't want to install more software..

jatar_k

11:43 pm on May 1, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



you'd have to install something to be the mail server but you can set it up like any mail client and put an smtp server right into the php.ini

ag_47

12:20 am on May 2, 2008 (gmt 0)

10+ Year Member



Yep, thanks. I used my ISPs SMTP server (address).