Jump to content

Connecting php to mysql v 5


Recommended Posts

I need to connect mysql to php, both are version 5s. I changed the extensions_dir in php.ini to correct path, i uncommented the extension=php_mysql.dll, but php still gives me:
Fatal error: Call to undefined function mysql_connect() in C:\Apache\Apache2\htdocs\test.php on line 8
I think i forgot to move a dll from or to mysql direction, does anyone know what dll i am suppoused to move?
Link to comment
Share on other sites

Hello ReVeR,

When setting up my server I had similar problem, and I resolved it by adding

extension=php_mysqli.dll instead of extension=php_mysql.dll as php5 and MySQL5 use this instead, as mysqli i believe this to mean MySQL Improved and only works for later versions of PHP and MySQL.

You will also have to edit the MySQLi section of your php.ini file instead of the MySQL section:

See Example:


; Maximum number of links. -1 means no limit.
mysqli.max_links = -1

; Default port number for mysqli_connect(). If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
mysqli.default_port = 3306

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host = localhost

; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user = root

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off

; Allow or prevent persistent links.
msql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
msql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
msql.max_links = -1

I hope this helps and solves your problem
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.