Begining PHP

emerald558

Hi all,
Well, I am a newbie thrust into learning PHP. I have a couple of basic questions and I apologize in advance if they have already been answered here.
1. How do I get PHP to connect to mysql? I have mysql running successfully, php4 is running but when ever I use the mysql_connect function, it never succeeds and issues a fatal error of an unknown function. I have looked at the php.ini and httpd.conf files, but I don't see what I am missing. Any help would be apreciated. This is a RedHat 7.3 box btw.

And a 2nd question:
On a windows 2k box with php running w/ IIS, how do I make php parse .html files (on a specified directory in the web root)?

Thanks!
- A Newbie

rIkLuNd

This is how I connect to MySQL:

<?php

$link = mysql_connect("localhost","MyUser","MyPass");
if(!$link)
die(mysql_error());

$select = mysql_select_db("MyDB");
if(!$select)
die(mysql_error());

?>

emerald558

Hi rIkLuNd,
Thanks for your reply. I am using the same function mysql_connect however PHP throws a fatal error when it hits this function. It says that it's not defined. Things like phpinfo() and includes work fine, but when I try to connect to mysql it's hosed. Thanks for the help.

rIkLuNd

Are you sure that you've installed MySQL properly?

Jiggy

It also could be possible that your provider uses another connect type... I use lycos as a domain controller and if i put it online it wants me to use the Function $db=mysql_connect
so maybe it something wrong in that. I am a newbee too but just trying to help,

Greetz,

JiGgY

emerald558

rIkLuNd,
Well, I'm not exactly sure that I installed it correctly, but it seems to be working fine - so is PHP for that matter. I really think that I didn't do something right with PHP more so than mysql, as when I do a phpinfo() I don't see the support for mysql listed. I have read somewhere about compiling php for mysql support, do I need to reinstall php or something? Both seem to work ok independant of each other but when I try to get them to "talk" it doesn't work. Also, I am not using an ISP for this, these are my boxes - not an ISP's server. In fact, I am using the same code that works on a properly configured linux box.

Also, any comments on the windows PHP install and getting .html files to be processed by PHP? Thanks again!

rIkLuNd

You could download this program:

http://zimbowl.simgateway.com/triad.exe ( 11 MB )

This will install Apache, PHP v.4.0.5 (I recommend you to download and install the newest version! so did I...), MySQL, Perl support, and everything is really simple. You just run the installer, and everything is installed and configured!

emerald558

I don't think an .exe will work for linux, will it? Besides, I would like to know how to do this without the help of an installer. I am really starting to think I need to reinstall php with support for mysql or something like that. Thanks again.

emerald558

Well, I managed to get it working! I downloaded the latest version of php and installed it. Here are the commands in case it helps anyone else:
$ gunzip -c php-4.x.y.tar.gz | tar xf -
$ cd php-4.x.y
$ ./configure --with-mysql --with-apxs
$ make
$ make install

If you get an error telling you that the apxs script could not be found,
look for it on your system and if you find it, provide the full path to it
as: --with-apxs=/path/to/apxs

Next you must copy php.ini-dist to the appropriate place (normally
/usr/local/lib/php.ini) and edit it as necessary to set PHP options.

The only thing left to do is to edit your httpd.conf file and make sure the
PHP 4 mime type is there and uncommented.

If anyone knows about how to get php to parse .html files w/ IIS on win 2k, I would love to hear about it. Thanks!

emerald558

Ok, got php to execute .html files on the specific directory too! Here's how incase anyone else needs to do this:
Go to the IIS snap in. Right click on the folder you want to do it to and select properties. On the Directory tab, give the application a name then click on configuration. On the configuration app mappings tab click Add. Set the executable to php usually C:\PHP\php.exe and give the extension as .html or whatever you want it to be, click ok and apply, and that's it! Hope it helps someone else. Thanks!