[danielair]

Okay, I had tried to use Apache but I couldn't figure it out on Windows 7 so I'm using IIS with PHP and MySQL installed. For some reason when I try to use PHP to access MySQL I get this and I don't know why

PHP Fatal error:  Call to undefined function mysql_connect() in D:\www\index.php on line 33

I have everything installed and my php.ini file is setup for MySQL to work. If you got any input that'd be great!

Another thing, how can I configure SQL Server to work with PHP too?

Thanks,
Daniel

[macosxnerd101]

Could you post your code as well? Perhaps you aren't passing the correct or enough parameters?

[danielair]

Yeah sure, heres my code or the MySQL connection part anyway

	$link = mysql_connect('localhost', 'root', 'password');
	if(!$link) {
		die('Failed to connect to server: ' . mysql_error());
	}
	
	//Select database
	$db = mysql_select_db('localhost');
	if(!$db) {
		die("Unable to select database");
	}

[JackOfAllTrades]

Your php.ini configuration is wrong. It's not loading the mysql DLL.

[Dormilich]

check in the phpinfo(), what db drivers are available (mysqli, PDO, etc.)

[ludo237]

danielair, on 07 September 2010 - 05:01 PM, said:

Yeah sure, heres my code or the MySQL connection part anyway

	$link = mysql_connect('localhost', 'root', 'password');
	if(!$link) {
		die('Failed to connect to server: ' . mysql_error());
	}
	
	//Select database
	$db = mysql_select_db('localhost');
	if(!$db) {
		die("Unable to select database");
	}

are you sure that root & password are the correct username and password?

[Valek]

ludo237, on 08 September 2010 - 06:54 AM, said:

are you sure that root & password are the correct username and password?

Incorrect credentials wouldn't cause PHP to see the function as undefined. Undefined functions result from the extension (or file, if it's user-defined) containing the function definition(s) not being loaded.

[danielair]

I'm sure the credentials are correct though. And here is what the extension section looks like:

;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_exif.dll
;extension=php_fileinfo.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_intl.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_ming.dll
;extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll      ; Use with Oracle 10gR2 Instant Client
;extension=php_oci8_11g.dll  ; Use with Oracle 11g Instant Client
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_phar.dll
;extension=php_pspell.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_soap.dll
;extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sqlite3.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll
;extension=php_zip.dll

Daniel

[JackOfAllTrades]

Are you sure the INI file you've printed is the one in use by PHP? I don't know much about PHP and IIS (this site might be helpful), but perhaps you need to stop/restart IIS?

[danielair]

Ok I fixed one problem, the extension wasn't set correctly but thats fixed now. But Now theres a new problem that I still don't understand, when I run my script I get this

PHP Warning:  mysql_connect(): [2002] A connection attempt failed because the connected party did not  (trying to connect via tcp://localhost:3306) in D:\www\index.php on line 33
PHP Warning:  mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 in D:\www\index.php on line 33
PHP Fatal error:  Maximum execution time of 30 seconds exceeded in D:\www\index.php on line 33

Daniel

[Valek]

Check to see whether MySQL is reachable from GUI tools or via the command line. If you can connect there, change localhost to 127.0.0.1. Some IIS users have reported that as a common problem when dealing with PHP connecting to MySQL.

[danielair]

Valek, on 09 September 2010 - 02:40 PM, said:

Check to see whether MySQL is reachable from GUI tools or via the command line. If you can connect there, change localhost to 127.0.0.1. Some IIS users have reported that as a common problem when dealing with PHP connecting to MySQL.

Ok I can access it from the command line, but when I try to run it with phpMyAdmin I get a 500 error. Do you mean change the url in the browser from "localhost" to "127.0.0.1" (that had no affect) or in the MySQL settings. If you mean the MySQL setting could you explain how to do this?

Thanks,
Daniel

[danielair]

Ok I figured out what you meant. I changed my phpMyAdmin configuration to connect with 127.0.0.1 instead of localhost, but how can I make it so that I can connect on localhost so I wouldn't have to change all my scripts?

Thanks,
Daniel

[JackOfAllTrades]

Google Windows 7 localhost

[Atli]

Try adding 127.0.0.1 localhost to your hosts file. (It's hidden under C:\Windows\System32\drivers\etc\)

I ran across this same problem in the Win7 beta, but not since then. The problem was that Win7 didn't associate "localhost" with the IPv4 loopback (127.0.0.1) but only the IPv6 loopback (::1). Adding it manually fixed it back then.