MySQL Functions

TimC

Hi All,

I am using AMP (Apache, MySQL and PHP) to develop a website, they're all installed correctly, and - as far as I know - working together correctly.

I'm trying to connect to the MySQL database I've sent with this code:

$connection = mysql_connect("localhost", "****", "*******");

but I'm getting this error:

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\project\signupsubmit.php on line 10

Which makes me think maybe they aren't all working together... any ideas?

devinemke

you need to enable the mySQL extension. read the Installation and Configuration section of the manual for installing extensions.

TimC

I'm running PHP 5...

I found on php.net that you need to enable the extension in php.ini, I did that, I also added php to my windows path, then I found a thread in this forum about making PHP 5 work with MySQL, followed its instructions, and its still not working 🙁

superwormy

Check the output of the phpinfo() function to see if MySQL is listed as an extension there, and double check that you have the module and have it enabled. You may have to restart Apache as well.

TimC

I've done all that but its still not working 😢

superwormy

Is MySQL listed as an extension in the output of phpinfo()...? Are you sure you're typing the name correctly?

TimC

I've done PHPInfo and searched the page for MySQL, but it can't find it on that page....

But in my php.ini file, its definitely enabled:

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

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

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

; Default port number for mysql_connect().  If unset, mysql_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.
mysql.default_port = 3306

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

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

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

; Default password for mysql_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("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off