1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Call to undefined function mysql_connect()

Discussion in 'Site & Server Administration' started by Yoneh, May 13, 2005.

  1. #1
    I get the following error while trying to use mysql_connect():

    Fatal error: Call to undefined function mysql_connect() in C:\Apache2\htdocs\songs\checkdb.inc.php on line 3

    I use Windows, Apache, PHP, mysql:
    Windows XP Professional (and 750MHz, 512MB, 160GB)
    Apache/2.0.54 (Apr 16 2005 14:25:31)
    PHP 5.0.4 (cli) (built: Mar 31 2005 02:45:48)
    mysql Ver 14.7 Distrib 4.1.11, for Win32 (ia32)

    I have this at the end of httpd.conf:
    LoadModule php5_module "c:/php/php5apache2.dll"
    AddType application/x-httpd-php .php .wml
    PHPIniDir "C:/php"
    LoadModule php5_module "c:/php/ext/php_mysql.dll"
    SEMrush
    The Apache server and PHP starts and works normally with that and Apache does not give any error message, but MySQL gets not loaded. When I type 'php -m' on the command line to list all modules loaded, it shows yes 'mysql' among other modules, but the mysql_connect() can't still be used.

    What's the wrong? What could I try? Is MySQL compatible with PHP5? How can I repair the problem?
     
    Yoneh, May 13, 2005 IP
    SEMrush
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,297
    Likes Received:
    2,602
    Best Answers:
    461
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    You may want to use get_defined_functions() to see if any of the mysql functions are available. Maybe mysqli is installed instead or something?
     
    digitalpoint, May 13, 2005 IP
  3. kalius

    kalius Peon

    Messages:
    599
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I had a similar problem this might help.

    Basically php5 don't support mysql by default you have enable it.(at least on windows + apache2 + php5 situation)

    I think this is the solution, if not try searching for php5 + mysql
    http://www.dbforums.com/t1044828.html
     
    kalius, May 13, 2005 IP
  4. Yoneh

    Yoneh Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I solved the problem!

    I had a copy of my old php.ini at the root of C:, and PHP used it instead of one in c:\windows.

    I solved the problem when I noticed that allthought I write something wrong into c:\windows\php.ini, for example 'foo foo foo', i did not get any warning from Apache. Then I remembered that I had my old php.ini at the root of C, and so removed it.

    Now it works! And thanks you very much for help!
     
    Yoneh, May 13, 2005 IP