Php And Mysql Extension Installation

[magiccode91405241511 0]

/**
* $Author: pgeric $
* $Revision: 8 $
* $Date: 2008-06-30 19:40:52 +0800 (Mon, 30 Jun 2008) $
* $Id: php_mysql_install.txt 8 2008-06-30 11:40:52Z pgeric $
*/

Installing newer version of php and enable mysql connection.
(As of this writing will be targeted at php 5.2.5 and above)

Because of a change on newer version of php. Some files have been moved around
within the default folder structure of php package. The result was when try
working with mysql. It surprise you a lot.
(The dicussion on this was based-on zip package. Use it becasue it is easy to
install and without too much unknown data have been installed on local machine.
This is especially important for server computer.)

Before going with the steps. There are some common terms as following
/* change the wording a bit to friendly describe it */

php installation folder = c:\php
Use {PHP_DIR}
( Please don't use space within folder, it might cause issues )

php extension folder = c:\php\ext
Use {PHP_EXT_DIR}

php.ini settings = c:\php\php.ini
Use {PHP_INI_FILE}

Are you ready ? Let's go !

1.) Download a copy of php from http://php.net/ and extract all files to {PHP_DIR}

2.) Move file libmysql.dll to {PHP_DIR}\{PHP_EXT_DIR} from {PHP_DIR}

3.) Adding {PHP_DIR} to system search path.
Open System Applet by pressing Winkey + Break, click on the Advanced tab, then
Environment button.

4.) Check the PHPIniDir directive on httpd.conf
Open the httpd.conf file in your apache\conf folder check to see if it is
pointed to the {PHP_DIR}.

5.) Configure extension folder location and loading mysql extension on php.ini
If the directory location of extension_dir on php.ini was not configured to
the {PHP_DIR}\{PHP_EXT_DIR}. You will need to change it.

Go to extension_dir by a search and scroll up or down and look for an entry
called php_mysql.dll. Remove the leading `;` character and save the change.

6.) Create a file called phpinfo.php and put the text and save it to webroot,

<?php	phpinfo();?>

Test it by locate your browser to web server's webroot folder.

If everything works fine.
Confrag, you have a working php now


Eric,

Comments are welcome and could co from
http(s)://opensvn.csie.org/freescript

[iGuest 3]

Question Re: Php And Mysql Extension InstallationPhp And Mysql Extension Installation

hey, I just found this page http://forums.xisto.com/no_longer_exists/,; browsing threw the internet, it is very hard to find help on installing php extensions. Your instructions seem knowledgeable, although my question is aimed towards, a shared server. I am using IXwebhosting,  PHP, MYSQL, all the goodies are installed. My hosting service is Linux based.

I wish to install a custom php extension, I cannot access the PHP_DIR or PHP_EXT_DIR, all I can access is the php.Ini,a few other files, and my ftp site.

I have tried using the php.Ini to change the PHP_EXT_DIR, and placing my extension there. Then I used the dl(my.Dll); to load my extension, and got errors.

My extension is a .Dll  file.  Does my extension have to be a .So file type for a Linux based server? I'm hoping you can help me learn to install and implement this extension. 

Thanks

[iGuest 3]

If Linux based, it should be .so extension.If Windows, it should be .dll extension.Cheers,MC