MySQL acting strange with PHP
Posted: Mon Feb 19, 2007 7:57 pm
feyd | Please use
I went into the MySQL bin folder and copied libmySQL.dll over into the PHP directory, and it's still not working. The problem is really weird, this is the sample script I set up to test it:
What I find weird is that the script halts execution after the mysql_connect() function. It prints "test" but does not print "test1" or anything after that. I even added:
And still nothing is showing up. Has anyone had this problem before?
Cheers,
- Josh
P.S I'm using MySQL 5 and PHP 5.2.1
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Well I just recently got PHP working with IIS 7.0 on Vista but now MySQL is not working. I have the extension enabled in php.ini, it looks like:Code: Select all
;extension=php_bz2.dll
extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_msql.dll
;extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
;extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.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_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll
extension=php_zip.dllCode: Select all
<?php
echo "test";
mysql_connect("localhost", "root", "****");
echo "test1";
mysql_select_db("testms");
$sql = "SELECT * FROM `test`";
$result = mysql_query($sql);
$arr = mysql_fetch_assoc($result);
echo $arr['name'];
echo "test";
?>Code: Select all
error_reporting(E_ALL);Cheers,
- Josh
P.S I'm using MySQL 5 and PHP 5.2.1
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]