Jump to content


Photo

Connecting php to mysql v 5


  • Please log in to reply
3 replies to this topic

#1 ReVeR

ReVeR
  • Members
  • PipPipPip
  • Advanced Member
  • 42 posts

Posted 26 May 2006 - 01:04 PM

Hello.
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?
Thx

#2 CHLee

CHLee
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 26 May 2006 - 01:15 PM

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:

[MySQLi]

; 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
; at MYSQL_PORT.
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

[mSQL]
; 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
My pain will be the pain my computer feels when it's a door stop....

#3 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 26 May 2006 - 02:59 PM

Please read my thread [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=87276\" target=\"_blank\"]here[/a]

#4 ReVeR

ReVeR
  • Members
  • PipPipPip
  • Advanced Member
  • 42 posts

Posted 26 May 2006 - 03:49 PM

thx alot,. thats the file i forgot to move. sry that i didn;t find that thread b4 posting.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users