Where is mysql_connect() ?

[brett]

I'm running PHP5 on Windows Vista with mysql 5.2. I have a simple php
file with

<?
$dbc = mysql_connect ();
?>

When I run the file, I get this error:
Fatal error: Call to undefined function mysql_connect() in E:\www
\mysite\connect test.php on line 2

PHP seems to be installed correctly. What could I be doing wrong?

[Simon Stienen]

Am 4 Mar 2007 11:21:30 -0800 schrieb brett:

PHP seems to be installed correctly. What could I be doing wrong?

Is it *configured* correctly? Especially: Did you load the mysql extension?

[brett]

On Mar 4, 11:23 am, Simon Stienen <[e-mail] hlife.orgwrote:

Am 4 Mar 2007 11:21:30 -0800 schrieb brett:

PHP seems to be installed correctly. What could I be doing wrong?

Is it *configured* correctly? Especially: Did you load the mysql extension?

I only installed mysql and created a database. There are a few
problems. I'd like to move the database but don't know how and am not
sure how to tell mysql where it is to allow connections.

There isn't a mysql odbc in the odbc administrator tools.

I just downloaded the extension listed here: http://dev.mysql.com/downloads/connector/php/.
They talk about modifying a php.ini file. However, I don't have that
file. The closest files I have are:

- php.ini-dist
- php.ini-recommended

Does all of that sound correct? Thanks.

[Simon Stienen]

Am 4 Mar 2007 12:45:12 -0800 schrieb brett:

The closest files I have are:

- php.ini-dist
- php.ini-recommended

Does all of that sound correct? Thanks.

Those two are actually php.ini templates.

HTH,

simon Stienen

(I just noticed that I've got to configure my quote lines to be English
again... I hate reinstalling software.)

[PDannyD]

brett wrote:

I'm running PHP5 on Windows Vista with mysql 5.2. I have a simple php
file with

<?
$dbc = mysql_connect ();
?>

When I run the file, I get this error:
Fatal error: Call to undefined function mysql_connect() in E:\www
\mysite\connect test.php on line 2

PHP seems to be installed correctly. What could I be doing wrong?

What does phpinfo() bring up? If you can't see MySQL in there then it needs
to be installed/configured.

[=?ISO-8859-15?Q?Iv=E1n_S=E1nchez_Ortega?=]

brett wrote:

I'm running PHP5 on Windows Vista with mysql 5.2. I have a simple php
file with

RTFM. Mysql support was dropped by default in the upgrade from PHP4 to PHP5.
Get the php_mysql.dll library, put it in the appropiate place, and check
that it is loaded (see php.ini).

--
----------------------------------
Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-

Todo conocimiento comienza por los sentimientos.- Leonardo da Vinci.

[brett]

On Mar 4, 12:43 pm, PDannyD <dan1...@scenic place.freeserve .co.uk>
wrote:

brett wrote:

I'm running PHP5 on Windows Vista with mysql 5.2. I have a simple php
file with

<?
$dbc = mysql_connect ();
?>

When I run the file, I get this error:
Fatal error: Call to undefined function mysql_connect() in E:\www
\mysite\connect test.php on line 2

PHP seems to be installed correctly. What could I be doing wrong?

What does phpinfo() bring up? If you can't see MySQL in there then it needs
to be installed/configured.

I've installed the extensions and configured php.ini. I renamed php-
recommended to php.ini since one didn't exist. I set the
externsion_dir to my "ext" path but phpinfo() keeps showing it as c:
\PHP5, which doesn't exist. Any idea why that is happening?

Thanks.

[Hendri Kurniawan]

brett wrote:

I'm running PHP5 on Windows Vista with mysql 5.2. I have a simple php
file with

<?
$dbc = mysql_connect ();
?>

When I run the file, I get this error:
Fatal error: Call to undefined function mysql_connect() in E:\www
\mysite\connect test.php on line 2

PHP seems to be installed correctly. What could I be doing wrong?

Brett,

Your MySQL extension is not configured correctly.
Form what I gather from the replies on this thread, you managed to
download the extension and modify php.ini file (to load and mysql
extension). So I assume those steps are complete.

If you are running IIS, PHP is configured to search for php.ini in (as I
recall, CMIIW) your windows directory and your php installation dir.
Again, from what I gather your current installation uses php.ini from
c:\PHP5 dir. You should modify that file instead. Restart your IIS

If you are running apache however, you need to add
PHPIniDir "C:\php5"
to your apache config file (where c:\php5 is where you put your php.ini)
Restart Apache.

If you don't see any result (ie. mysql still not loaded), then your php
is still not configured correctly.

Hope that helps,

Hendri Kurniawan

[Simon Stienen]

On 2007-03-04 23-50-08, Hendri Kurniawan wrote:

If you are running apache however, you need to add
PHPIniDir "C:\php5"
to your apache config file (where c:\php5 is where you put your php.ini)
Restart Apache.

You don't _need_ to add this line. It's still possuble to put the ini file
into one of the classic locations:
a) c:\windows
b) apaches base directory (the one /bin, /conf, /log, ... are located in)
c) the directory the sapi dll is located in (iirc, not absolutely positive
on this one)

Regards,

Simon Stienen

[brett]

On Mar 4, 3:28 pm, Simon Stienen <[e-mail] hlife.orgwrote:

On 2007-03-04 23-50-08, Hendri Kurniawan wrote:

If you are running apache however, you need to add
PHPIniDir "C:\php5"
to your apache config file (where c:\php5 is where you put your php.ini)
Restart Apache.

You don't _need_ to add this line. It's still possuble to put the ini file
into one of the classic locations:
a) c:\windows
b) apaches base directory (the one /bin, /conf, /log, ... are located in)
c) the directory the sapi dll is located in (iirc, not absolutely positive
on this one)

Regards,

Simon Stienen

As mentioned earlier, I don't have a "c:\php5" folder on this machine
and I'm running Windows Vista. Placing the php.ini folder in the
windows folder doesn't help. After restarting IIS, I get a blank
white page. So I put the file back in my php folder, restart IIS and
it works again but PHP is still pointing to the wrong extension_dir
and the mysqlconnect() isn't recognized.

Thanks.