what am i doing wrong

rockroka

:mad: Operating system: Windows 2003 Server
PHP version: 5.0.
Problem Type: MySQL/PHP related

mysql_connect dont work on PHP5 + MYSQL5 + IIS6 + WIN 2003 SERVER

Description:

When calling mysql_connect(), running Windows 2003 Server + IIS6 + PHP5 +
MYSQL5, the function is not found.

Reproduce code:

Calling :
<? $connector = mysql_connect("localhost"); ?>

Returns :
Fatal error: Call to undefined function mysql_connect()

Expected result:

$connector should become an mysql-connection instance and not return any
errors.

i dont get it i have everything running! but cant seem to connect to the sql server to install my forum...

i have already added c:\php into my system path,
dropped off mysqli.dll and libmysql.dll into the system folder,
i even went one further and added the ext folder to the system path to no avail...
i understand i need to use --with-mysql[=DIR] somewhere but i dont know where to put it i have read all the manuals but they all omit the mysql/php/iis6 conduit issue.
there seems to be an issue with php5/mysql5 having to be compiled could someone explain how to do this im up for the task it has taken me a month to get this together and i cant quit now... please help!

cornercuttinjoe

<?php

define('DB_USER', 'my_user_name');
define('DB_PASSWORD', 'my_password');
define('DB_HOST', 'localhost');
define('DB_NAME', 'my_database');

$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Error');
@mysql_select_db(DB_NAME) or die ('Another error');

?>

Try something like that. You need to tell the database who you are and where you want to go.

nmphpwebdev

I am having the same connection trouble.

My PHP scripts work okay, but I cannot connect to my database.

Any other hint?
I have checked the system variables, I have moved my php5isapi.dll, pht5ts.dll, libmysql.dll. Nothing is working.

The database is there and working because I can connect to SugarCRM that I have installed on the same machine.

Installer

Here's what I would do:

Delete all instances of "libmysql.dll" except the one in the version distribution files. Make sure that one is in your PHP directory ("c:\php"). Add "c:\php" to your path. Make sure the distribution's copy of "php_mysql.dll" is in your extensions directory ("c:\php\ext"). In "php.ini", set extension_dir = "c:\php\ext", and uncomment (or add) the line extension=php_mysql.dll. Restart your server.

nmphpwebdev

No good.
There is something funky going on with this install.

I can use PHP / MySQL in sugar, but not in another app that I am writing.

Houdini

MySQL expects certain values to connect, namely the host (usually localhost) a user and a password if any for the user.

A default MySQL server right after install has one main user root and root has not password, so to connect to this brand new server with no permissions altered or changed yet you would connect like this

$host ="localhost"; //will work on a new MySQL
$user ="root";      //so will this
$pass = "";         // and this too
$connection = mysql_connect($host,$user,$pass)
  or die("Could not connect to server") //You should not see this error

Normally you would have another page that has the configuration parameters (host, user and password) and use it as an include on those pages of your site that need to connect to the data base, so if you did that instead of writing the above and if you ever changed the parameters of the configuration to connect yu wouod just change them in that one file.

include("config.php");
$connect=mysql_connect($host, $user, $pass)
    or die("Could not sonnect with database server!");

Depending on how your server and your PHP is set up you need to make sure that the php.ini is as below

;extension=php_msql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll

If it is commented then get rid of the comment ";" and try it again.